1 Reply Latest reply on Oct 14, 2018 5:56 PM by Don Wise

    How to calculate the percent growth rate of the trend-line

    Stephen Hellyar

      Need a little help.

       

      The attached workbook tracks the daily [Price] of aluminum since the start of 2016.

       

      I need the percent growth of the trend-line from the first day to the last day so that I can extrapolate the price out a year or more into the future.  How can I generate this?

       

      I tried the quick table calculations Compound Growth Rate and Percentage Difference.  But, these only provide a relative growth rate or percentage difference relative from a date in time to the first date (12/31/2015).  The forecast function is not helpful in this example. 

       

      Thank you.