by Milchcow Tue Jan 21, 2020 4:18 pm
StormTrooper96 wrote:Trying to add a price predictor into my spreadsheet. What is the best formula to use?
For example I will have - Current Price, Predicted Score, Predicted Price
What formula should be used to calculate the predicted price by formulating the current score, the predicted score and the MN (14500). Not sure where to start.
Price change formula is
New Price = 0.75 * old price + 0.25 * Weighted average * MN
Weighted average = (5*G1 + 4*G2 + 3*G3 + 2*G4 + G5) ÷ 15
G1 = most recent game
G2 = game before that
G3 = game before that
Etc
Before a player has played 4 games, they are assumed to have scored their priced average for the missing games from the weighted average
Note that given they have changed the initial pricing it's possible they may have changed the formula for price changes too, although I assume it will work basically the same.