Price Change Formula For AFL Dreamteam

[TalkingFootball]

Can somebody please confirm the formula

[ALI-G]

Originally Posted by TalkingFootball

Can somebody please confirm the formula

I can't confirm it completely due to possible changes but going by last year here are 4 examples.

Barry Hall: average = 50.5, price = 356,600

Formula = (average - (Price / 3160) x 1000
= (50.5 - (356,600 / 3160) x 1000
= (50.5 - 112.84) x 1000
= -62.34 x 1000
= -62,340

Barry Hall will therefore lose $62,340 in value and will be $294,260 if his 3 game average matches his 2 game average.

If Barry Hall comes out and scores 150 this week his total rises to 251 giving him a 3 game average of 83.66.

= (83.66 - (356,600 / 3160) x 1000
= (83.66 - 112.84) x 1000
= -29.18 x 1000
= -29,180

So even with a massive 150 Hall will lose nearly 30K this week.

Dean Solomon: average = 57.5, price = 192,200
= (57.5 - (192,200 / 3160) x 1000
= (57.5 - 60.82) x 1000
= -3.32 x 1000
= -3320

If Dean Solomon scores his average of 57.5 pts again this week he will drop $3,320


Now lets say Solomon comes out and scores 100. His average jumps to 71.66

= (71.66 - (192,200 / 3160) x 1000
= (71.66 - 60.82) x 1000
= 10.84 x 1000
= 10,840

So if Solly scores 100 he raises $10,840 in price.

[m8rix]

I think the magic number is different this year...

Seems to be about 3680 I don't know for sure, but that figure gave me some "close" results, well close enough anyway especially when it is only used for making predictions.

[peterfitz]

Originally Posted by m8rix

I think the magic number is different this year...

Seems to be about 3680 I don't know for sure, but that figure gave me some "close" results, well close enough anyway especially when it is only used for making predictions.

Loos about right.
I set up a spreadsheet with a 3700 magic number (it was just a guess) before last week and it was just out.

[LoveThemLions]

peterfitz, mate I have spent way to much time on a big spreadsheet and graphs and all kinda stuff for me and a mate who is in Fiji. I update it as the round goes and it gives me some cool info re: efficiency forecasted scores etc, also graphs recent weeks results, captains scores, high scorers, etc. End result is a pretty sweet, professional looking 8 or so page report. Currently I have a efficiency formula in there for cost price and current price based on a 3200 point per dollar average, ie if a player cost 320000 he needs to score 100 for a 100% efficiency. I would much prefer to use the accurate dt price valueing system to do this although it would only be on a weekly basis I could keep tabs on it over the weeks. Do you reckon if I sent you the file you could put the formula in??? If you have a personal rivalry going with someone it is Gold and I am happy for you to use the whole report as is but I cannot work out the formula. Considering I prolly put 40 or 50 hours into developing it I would think it p[retty cool for others to enjoy it too. Or if anyone can tell me how to put screenshots up I will show you some of it and anyone who wants it can pm me there email.