Post
Topic
Board Economics
Re: Monthly average USD/bitcoin price & trend
by
Diabolicus
on 22/11/2017, 15:33:13 UTC
using today's values based on OP's formula the bit coin price should be:


10^(-2.869800 + 0.003012 * ((number of days since 2009 Jan 03)/days)) =

$26,439

The coefficients -2.8698 and 0.003012 are dynamic and recalculated daily from past price data.

So it's more like $5,000 now - which still IS somewhat higher than the actual price  Cheesy

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.