I need help setting up a financial formulain in Excell

O

ozarkfellow

Example:
Date closed Gain + or - % + or -
12/30/70 838.92
12/31/71 890.20 +51.28 + 6.11%
12/29/72 1020.02 +129.82 +14.58%
12/31/73 850.86 -169.82 -16.58%

I would ike to keep a running total as I add the date and closed data for as
long as I can, say 30 years or more.


Thanks,
Ed
 
G

Gary L Brown

If your example is from A1:D5, then...
E1: 'Total Gain or Loss'
F1: 'Total & Gain or Loss'
E3: =B3-$B$2
F3: =E3/$B$2

Copy E3 and F3 down 30 years.
Format Column F to be %

HTH,
 
Top