• Hot Topics

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.

This thread is current as of April 7, 2015.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel