Quote from: Diabolicus on November 22, 2017, 03:33:13 PM

Hi, I'm struggling to reproduce / update these coefficients based on current data - can you please point me to an example / excel spreadsheet with formulas? Or is it an iterative approach?
Thanks.

Put the values into a spreadsheet as Date,Price

You're going to want to normalize your dates per rpietila's convention, where date is number of days since 2009-01-03. In Excel you can accomplish this by taking your column of dates, subtracting the function date(2009,01,03), and showing as numbers.

You're going to want to add a column that is the log base 10 of price. ( =log10() )

Do a least squares on [log base 10 of price] as a function of [number of days since 2009-01-03]. This is a built-in function in the Excel graphing features (there is an option to show you the exact function in y=mx+b form overlaid on the chart itself).

That linear function will now output the log of price.

You can calculate the linear model price by adding a column that's =10^(your least squares function). You could literally create a column where you start "=10^(" and paste in your least squares function, and replace the variable with a cell reference.