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

This question generated 13 answers. To proceed to the answers, click here.

This thread is current as of April 07, 2015.

For more resources for Microsoft Excel