Hi,
I have no idea if I linked this correctly or not. But I'm trying!
C:\Users\jkaelin\Dropbox\2015-04-07 Trailing Cumulative Returns.xlsx
QUESTION:
I'm trying to automate the trailing returns. As new data gets populated, I'm trying find a formula that will provide me the most recently 1-mo, 6-mo, 1-yr, 2-yr trailing returns. Note: The highlighted yellow cells starting in column E125 is what I'm referring to.
Right now, i adjust the formula each month. Any ideas?
Thank you!
James
I have no idea if I linked this correctly or not. But I'm trying!
C:\Users\jkaelin\Dropbox\2015-04-07 Trailing Cumulative Returns.xlsx
QUESTION:
I'm trying to automate the trailing returns. As new data gets populated, I'm trying find a formula that will provide me the most recently 1-mo, 6-mo, 1-yr, 2-yr trailing returns. Note: The highlighted yellow cells starting in column E125 is what I'm referring to.
Right now, i adjust the formula each month. Any ideas?
Thank you!
James
Last edited: