Days Total Gain (%) - no pivot table

[domgilberto]

In column "D" I have Dates ( DD/MM/ YYYY ) all in chronological order. Oldest > Newest (top > down).

Column AO has "Cumulative Gain (%)".

0.27%
0.42%
0.60%
0.80%
...
...

Each Cumulative Gain corresponds to a date in Column "D".

I want to know - without using a pivot table - what the end of day cumulative gain was from the previous day (not simply sum total gain%)

You can see a spread-sheet example attached.