Calculating return for multiple separate time periods
Pete,
I have the start and end date columns figured out. but i cant figure out
how to write a formula to calculate the return between the a given start and
end date.
trey
"Pete_UK" wrote:
It might be easier if you have a start date (eg in E1) and an end date
(in F1) to define a continuous range, and then a formula in G1 to
provide the returns within that period. Where you have discontinuous
ranges, you can put these in the rows below (eg Jun-06 in both E2 and
F2, and Aug-06 in E3 and Feb-07 in F3), and copy the formula from G1
into G2:Gn as appropriate, and then add these up.
Hope this helps.
Pete
On Dec 11, 3:39 pm, trey1982
wrote:
How can I go about creating a formula that calculates the returns for strings
of positive returns? Sample data is below i.e. return for Jan-06 to Mar-06,
Jun-06, and Aug-06 to Feb-07. (everytime column D0)
thanks...trey
Motnh
Jan-06 1.37% 1
Feb-06 0.99% 2
Mar-06 0.12% 3 3
Apr-06 -0.45% 0
May-06 -0.18% 0
Jun-06 0.30% 1 1
Jul-06 -0.21% 0
Aug-06 0.38% 1
Sep-06 0.74% 2
Oct-06 0.37% 3
Nov-06 1.50% 4
Dec-06 1.40% 5
Jan-07 0.39% 6
Feb-07 1.44% 7 7
Mar-07 -0.09% 0
Apr-07 -0.74% 0 - Hide quoted text -
- Show quoted text -
|