Hey thanks for quick response.

Looking over your spread-sheet I have made an error in my explanation.

Because column AO is a cumulative gain, it is telling us what the gain is in chronological order. Therefore using your spread-sheet if you see row 11, the gain for 04/11/2014 was in-fact +0.60%

For 05/11/2014 it's = 1.29% (last row on 05/11/2014) - 0.60% (row 11 for 04/11/2014) = 0.69% for the 05/11/2014

Sorry I was way off in my explanation