Market Building - Excel Help

Oaksnaf

Club Legend
Joined
Mar 31, 2008
Posts
2,255
Likes
2
Location
Australia
AFL Club
Hawthorn
Thread starter #1
I have a market set to 100%:


#1 GIOVES THUNDER $2.80
#5 FRANQUIN $4.50
#4 GRIP THE STICK $5.50
#8 CAMPASPE JACK $8
#2 JEDDY BOY $12
#7 KELANDY $33

And I change #5 FRANQUIN from $4.50 to $3.90.
How do I factor in this change so that it automatically adjusts the rest of the market?

At the moment I am just adjusting the markets manually. And I don't think that is the correct way at all as there is no accuracy in it.

Can anyone help?
 

(Log in to remove this ad.)

dr nick

Brownlow Medallist
Joined
May 22, 2002
Posts
13,523
Likes
25
Location
Dee Why, NSW
AFL Club
Sydney
#2
well there are a million ways to do it. Do you want the other odds to go up in the same proportion?

#1 GIOVES THUNDER $2.93
#5 FRANQUIN $3.90
#4 GRIP THE STICK $5.75
#8 CAMPASPE JACK $8.37
#2 JEDDY BOY $12.55
#7 KELANDY $34.51
 

Oaksnaf

Club Legend
Joined
Mar 31, 2008
Posts
2,255
Likes
2
Location
Australia
AFL Club
Hawthorn
Thread starter #4
Take this situation:



Code:
$2.40	0
$5.57	8
$6.88	2
$9.43	3
$14.38	4
$24.35	5
$45.82	6
$50.91	1
The BLUE is the margin I think will seperate each selection.

So 2nd selection 8lengths behind 1st.

If I change that to 5:
Code:
$2.92	0
$4.94	5
$6.10	2
$8.37	3
$12.75	4
$21.60	5
$40.64	6
$45.16	1
So yes you are right. I just had to find a way to calculate this into an excel spread sheet without it getting messy.
 
Top Bottom