In another subforum I have referred to this (excellent) thread recently, so maybe it's time to refresh it a bit!
First I'd like to ask @virginorange: do you still think the original formula holds? I repeat it here:
e^[ 5,8323 * ln(Date - 03.Jan.2009) - 39,296 ]
For those who want a quick & dirty command line script, in the Spanish subforum I've published a little
script to calculate the value for each day, in Python:
import sys
import datetime
import math
rawdate = sys.argv[1]
# fórmula @virginorange: e^[ 5,8323 * ln(Date - 03.Jan.2009) - 39,296 ]
genesis = datetime.date.fromisoformat("2009-01-03")
date = datetime.date.fromisoformat(rawdate)
delta_since_genesis = date - genesis
days_since_genesis = delta_since_genesis.days
price = math.e ** (5.8323 * math.log(days_since_genesis) - 39.296)
print(price)
I personally consider it a tiny bit too optimistic, because I believe that the price in early 2024 may have been an "overshoot". I have experimented a bit with the formula and got that the following values would be currently quite close:
e^[ 5,82 * ln(Date - 03.Jan.2009) - 39,4 ]I'm however not good at math, so it's not completely clear for me how I'd adjust it to get lower values in the future preserving the approximate curve until now (or if this is even possible with that formula).
