Re-priceing

[Shaun]

Say i was using the newspaper for my prices and there were some scratchings....how could i re-price the field to get an accurate price....for example say in the first three lines of betting you had
Fav $3
2nd fav $5
3rd Fav $6.50

and then the fav was scratched the second fav would not stay at $5 how would i know what price it should be as well as the changes to the other runners.

Shaun

[KennyVictor]

What I would do is turn the prices for the full field into percentages in the time honoured way (I'm pretty sure you know how to do that - same way VFG adds the percentages up at the bottom of each race).
Remove the horses that are scratched and redistribute the percentages proportionately between those left. For e.g. if you start with three horses at 50%, 25% and 25% and one of the 25 percenters is scratched you have two left at 50% and 25% which now share the 100% between them so they become 66% and 33%.
Then turn those percents back into the new odds (in the reverse time honoured way).

Apologies for a non detailed work through but short of time and I know you with your level of expertise will cope with this.

KV

[Shaun]

I think that works like this...correct me if i am wrong
a) 33%
b) 25%
c) 25%
d) 15%
e) 10%
f) 10%
= 118% tab prices

A) is scratched so we add up the remaining percentages and get
a) scr
b) 25%
c) 25%
d) 15%
e) 10%
f) 10%
= 85% tab prices

then divide the above percentages in to 85% to get the final percentages
b) 29.4%
c) 29.4%
d) 17.6%
e) 11.7%
f) 11.7%

when converting these back to prices should i use the 85% or 100% this is part i am not sure of.

Shaun

[KennyVictor]

I think that works like this...correct me if i am wrong
a) 33%
b) 25%
c) 25%
d) 15%
e) 10%
f) 10%
= 118% tab prices

A) is scratched so we add up the remaining percentages and get
a) scr
b) 25%
c) 25%
d) 15%
e) 10%
f) 10%
= 85% tab prices

Shaun

I would then multiply each original price by 118 / 85 to give a market of 118% again (might as well end up with a market framed to the same percentage as you started with). This would give:

b) 35%
c) 35%
d) 21%
e) 14%
f) 14%

Then convert back to prices.

[Bhagwan]

What you need is a market reframer & here it is , free.

http://www.ozracetools.com/index.php

[Heavyweight]

Amazing what you can find if you know where to look. Wish I'd known, so I wouldn't have had to knock up something for myself. It's attached if you're interested. I entered the pre-post prices from my local catbox-liner for yesterday's Winter Challenge Final. 155%! Deleting the original prices for the scratchings gives the revised prices for the remainder. The desired market percentage is manually entered (F1). For the purposes of this, I entered the original 155% from C27.

Cheers,

H.

[partypooper]

HV, famous last words "please explain"?

[Shaun]

Thoses are great programs thanks....but can i have the formula i would prefer to make my own

[Zlotti]

<TABLE style="WIDTH: 548pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=728 border=0 x:str><COLGROUP><COL style="WIDTH: 26pt; mso-width-source: userset; mso-width-alt: 621" width=34><COL style="WIDTH: 20pt; mso-width-source: userset; mso-width-alt: 475" width=26><COL style="WIDTH: 35pt; mso-width-source: userset; mso-width-alt: 841" width=46><COL style="WIDTH: 96pt; mso-width-source: userset; mso-width-alt: 2340" width=128><COL style="WIDTH: 174pt; mso-width-source: userset; mso-width-alt: 4242" width=232><COL style="WIDTH: 197pt; mso-width-source: userset; mso-width-alt: 4790" width=262><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 26pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=34 height=17>A</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 20pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=26>B</TD><TD class=xl29 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 35pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=46>C </TD><TD class=xl30 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 96pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=128>D</TD><TD class=xl29 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 174pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=232>E</TD><TD class=xl30 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 197pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=262>F</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl27 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17 x:num>1</TD><TD class=xl25 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent">a</TD><TD class=xl28 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:num>4</TD><TD class=xl24 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:num="0.25" x:fmla='=IF(C2>0,1/C2,"")'>=IF(C1>0,1/C1,"")</TD><TD class=xl24 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:num="0.24999969314020565">=IF(C1>0,D1*($F$1/(100*$D$27)),"")</TD><TD class=xl26 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:str="$4.00" x:fmla='=IF((C2>0),"$"&(FIXED((1/E2),1)&"0"),"")'>=IF((C1>0),"$"&(FIXED((1/E1),1)&"0"),"")</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl27 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17 x:num>2</TD><TD class=xl25 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent">b</TD><TD class=xl28 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:num>6.5</TD><TD class=xl24 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:num="0.15384615384615385" x:fmla='=IF(C3>0,1/C3,"")'>=IF(C2>0,1/C2,"")</TD><TD class=xl24 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:num="0.15384596500935732">=IF(C2>0,D2*($F$1/(100*$D$27)),"")</TD><TD class=xl26 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:str="$6.50" x:fmla='=IF((C3>0),"$"&(FIXED((1/E3),1)&"0"),"")'>=IF((C2>0),"$"&(FIXED((1/E2),1)&"0"),"")</TD></TR></TBODY></TABLE>

<TABLE style="WIDTH: 548pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=728 border=0 x:str><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-LEFT-COLOR: #d4d0c8; BORDER-BOTTOM-COLOR: #d4d0c8; WIDTH: 26pt; BORDER-TOP-COLOR: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #d4d0c8" width=34 height=17></TD><TD style="BORDER-LEFT-COLOR: #d4d0c8; BORDER-BOTTOM-COLOR: #d4d0c8; WIDTH: 20pt; BORDER-TOP-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #d4d0c8" width=26></TD><TD class=xl29 style="BORDER-LEFT-COLOR: #d4d0c8; BORDER-BOTTOM-COLOR: #d4d0c8; WIDTH: 35pt; BORDER-TOP-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #d4d0c8" width=46>C </TD><TD class=xl30 style="BORDER-LEFT-COLOR: #d4d0c8; BORDER-BOTTOM-COLOR: #d4d0c8; WIDTH: 96pt; BORDER-TOP-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #d4d0c8" width=128>D</TD><TD class=xl29 style="BORDER-LEFT-COLOR: #d4d0c8; BORDER-BOTTOM-COLOR: #d4d0c8; WIDTH: 174pt; BORDER-TOP-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #d4d0c8" width=232></TD><TD class=xl30 style="BORDER-LEFT-COLOR: #d4d0c8; BORDER-BOTTOM-COLOR: #d4d0c8; WIDTH: 197pt; BORDER-TOP-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #d4d0c8" width=262></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl27 style="BORDER-LEFT-COLOR: #d4d0c8; BORDER-BOTTOM-COLOR: #d4d0c8; BORDER-TOP-COLOR: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #d4d0c8" height=17 x:num>27</TD><TD class=xl25 style="BORDER-LEFT-COLOR: #d4d0c8; BORDER-BOTTOM-COLOR: #d4d0c8; BORDER-TOP-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #d4d0c8"></TD><TD class=xl28 style="BORDER-LEFT-COLOR: #d4d0c8; BORDER-BOTTOM-COLOR: #d4d0c8; BORDER-TOP-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #d4d0c8" x:num>=SUM(D1:26)</TD><TD class=xl24 style="BORDER-LEFT-COLOR: #d4d0c8; BORDER-BOTTOM-COLOR: #d4d0c8; BORDER-TOP-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #d4d0c8" x:num="0.25" x:fmla='=IF(C2>0,1/C2,"")'>=SUM(D1:26)</TD></TR></TBODY></TABLE>

[Shaun]

KV sorry mate you were 100% correct in your calculations....i ran the prices i had listed with that program Bhagwan listed and it came out the same as yours....thanks for all your help guys..