Excel Calculating Trailing Returns as New Data Populates
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 Last edited by James02; Yesterday at 09:15 AM.
This question generated 13 answers. To proceed to the answers, click here.