PDA

View Full Version : Adjusting Prices


Shaun
27th May 2006, 01:09 PM
I need information on adjusting prices after scratchings, if you were using the pre-post paper market how would you adjust the price if the fav was removed before the race

jfc
27th May 2006, 01:43 PM
If your actual odds are in Column A

Then the "normalised to 100%" odds can be shown in Column B as

=A1/COUNT(A:A)*HARMEAN(A:A)

(replicating for all runners)


Simply delete any scratchings at any time and the thing will still work.

Shaun
27th May 2006, 02:51 PM
Can i set that to any % market i i need it to replicate the Tab or Bookie market

jfc
27th May 2006, 03:15 PM
Can i set that to any % market i i need it to replicate the Tab or Bookie market


simply multiply/divide that expression appropriately:

eg: divide it by 1.20 if you want to frame to a 120% market.

Shaun
27th May 2006, 03:35 PM
Thanks mate works a treat

Bhagwan
29th May 2006, 07:36 AM
Go to
Ozracetools

There is a free market reframer program there which can be set to any percentage.
Plus some other punting tools.

Cheers.