Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Aug 2005
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formula needed for comparing change in bond prices (Excel)

    <img src=/S/confused3.gif border=0 alt=confused3 width=45 height=45>

    Hi,

    I can't believe the sheer quality of help I continue to get from this site, thanks to all those assisting me with formulas thus far, it is greatly appreciated!!!

    My current quest for a formula should answer the following question: How can I tell if a price increased/decreased 40% or more in a two day increment??
    An example of this data set is enclosed to give you an idea of what I'm working with....

    Thanks for your help-
    Lori

    (fyi: this is not a double posting)--I posted a similar question for a different type data, but cannot seem to transfer the logistics for this scenario...)

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Formula needed for comparing change in bond prices (Excel)

    You could enter the following formula in B4 and fill down to the end of the data:

    =OR(A4/A2>1.4,A4/A2<0.6)

    Alternatively, you could use this formula in Conditional Formatting.

  3. #3
    New Lounger
    Join Date
    Aug 2005
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula needed for comparing change in bond prices (Excel)

    Thanks for the formula Hans!

    What if I have to use this same process, but working the formula horizontally?? Example attached...

    Lori

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Formula needed for comparing change in bond prices (Excel)

    Exactly the same idea: for example, to compare A2 and C2:

    =OR(C2/A2>1.4,C2/A2<0.6)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •