VBA Excel Code to Add Cumulativel Based on Date

[nicho1978]

Could someone point me in the right directions of how to get the desired results as shown in column E for an indefinite amount of rows. I am pretty much trying to figure out how to buy a stock on Date A (column A) and Sell the stock on Day B (column B) and make a profit of C % (column C) and then i want to take the profit + my initial investmentment and reinvest it the next row. Assume i will always be investing and extra 2 k in each row plus what was sold previously. Its tricky because the time period invested is not always constant. Thanks a bunch.

COL/ROW A B C D E
1 1/11 1/12 1 2000 d2*(c2+(1/100)=2020
2 1/14 1/25 0.5 2000 (e2+d3)*(c3+(1/100)=4040
3 1/16 1/18 1.2 2000 (d4)*(c4+(1/100)=2024
1 1/27 1/28 2 2000 (d4+e3+e5)*(c5+(1/100)=8225

 

[SkipVought]

hi,

Why are you posting an Excel question in an MS Access formum?

forum68.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}