I'm trying to create a column, then a graph, of the % returns over the last 30 days, which would automatically update daily- since I'd like today() to be the starting point.
Can anyone help, at least with the formula for the column. Ideally, every other cell in the column would be blank, apart from today.
average percentage returns of last 30 days, variable amount invested, varied returns. Hope thats clear (ish)
value contributed returns to date
£1,585,000 1600,000 -0.91%
£1,585,000 1600,000 -0.89%
£1,597,000 1600,000 -0.18%
£1,648,000 1650,000 -0.13%
£1,648,000 1650,000 -0.13%
£1,645,000 1650,000 -0.30%
£1,667,000 1650,000 1.05%
£1,680,000 1650,000 1.82%
£1,678,000 1650,000 1.69%
£1,665,000 1650,000 0.90%
£1,665,000 1650,000 0.90%
£1,665,000 1650,000 0.90%
Thanks so much
Bookmarks