Market Building - Excel Help

[Oaksnaf]

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?

 

[dr nick]

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]

Dr.Nick it didn't take long, but I found an answer. Download a spreadsheet from someone who knows.

 

[Oaksnaf]

Take this situation:

$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:

$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.