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.
Hi Stephen,
Not sure if this is what you're looking for? This is the result of a primary quick table calculation using the running total (average), then a secondary quick table calculation is further applied which reflects percent difference from the first mark in the view, to the end mark getting a 26.38% percent difference from 12/31/2015 to 10/11/2018:
Hope it helps! Thx, Don