Registered User
Joined: 4/10/2007
Posts: 38
|
((C12/31/2010 - C'12/31/09') / C'12/31/09') * 100
or in elegant algebraics which merely rearrange and
eliminate a parenthetic:
100 * (C'12/31/2010' - C'12/31/09') / C'12/31/09'
or this simplicity masterpiece of TC2007
arithmetic elegance:
100 * (C'12/31/2010' / C'12/31/09' - 1)
All three return the same mathematical
result:
PPG ... price percent gain
Example: SPY CY2010
100.00 * (125.75 / 110.86 - 1)
The PCF returns: 13.4314 representing 13.43%
YTD CY2011, as it unfolds, will be:
((C - C'12/31/10') / C'12/31/10') * 100
or
100 * ( C / C'12/31/10' - 1)
Note that 12/31/2010 and 12/31/2009 were both
market open trading days, not weekends or holidays.
May the force
be with us.
|