Calculating yearly returns from daily performance data - product function

[VBAhelp33]

Hi all,

I have a column of daily dates & in the next column I have the corresponding values (daily stock returns) for those dates. For the EOM dates, the return is for the whole month, not just the day like the daiy returns are.

I would like to find the 1 year return, which means I need to find the product of the last 12 EOMs monthly stock returns. Is there a formula that can do that? If it was just monthly data it would be quite easier, but its got me stumped with the daily data..

Example of my data:

A1

29/03/2021	0.07%
30/03/2021	0.30%
31/03/2021	0.02%
01/04/2021	0.02%

Etc

 

[offthelip]

The way I would do it is create helper column where you add 1 to the return. to get 1.0007 for the first value, then use geometric mean times the count to find total annual return ( subtract 1 from the result)

=GEOMEAN(A2:A360)* COUNT(A2:A360)-1