I have a moving date range (changes daily) that I would like to compute a YTD return for. How should I lock my reference point as the first day of the year so that as the dates push down the spreadsheet the YTD return is still truly YTD?
<tbody>
</tbody>
I hope this clearly explains what I'm trying to do.
Thanks
Time/Date | Yield | CHG |
=Now | 0.375 | -0.002 |
Trading day before | 0.377 | 0.01 |
Trading day before.... | 0.367 | 0.02 |
..... | 0.346 | 0.002 |
..... | 0.344 | -0.001 |
..... | 0.345 | 0.004 |
.... | 0.341 | 0.004 |
....and so on, until... | 0.337 | .... |
First day of year | 0.382 |
<tbody>
</tbody>
I hope this clearly explains what I'm trying to do.
Thanks