Additional Condition to sample excel

[bmchunu]

Using http://www.gruss-software.co.uk/Excel/E ... etting.htm how can I restrict the bets to only when % lay book is greater then say 95%?

[Captain Sensible]

In colum AM5 copy and paste

=IF(OR(H5="",H5=0),"",100/H5)


then drag the edge to copy it down to AM50 so the cells show as

=IF(OR(H6="",H6=0),"",100/H6) etc copy further than AM50 if you do markets over 40 + runners


doing =sum($AM$5:$AM$50) will then give you the lay book % so you can include it in your trigger

[bmchunu]

thanks man ... and for the fast response too.

I want to try out some US racing tonight. I have the figure in AM56 and matches betfair ... now how can I restrict the selections to only be placed if % book is greater then XX%

[bmchunu]

Think I have found it in Q.

[bmchunu]

Think I have found it in Q.

But I am not sure of the snytax when I have to add on top of soooo many if's already.

[Captain Sensible]

Just amend the bit in the the trigger in Q5 where it shows

AND(E$2="Not In Play",F$2<>"Suspended")

to

AND($AM$56 > 95,E$2="Not In Play",F$2<>"Suspended")

then drag the cell down the column to copy them with the correct relative references

[bmchunu]

Thanks a lot Captain ... worked like a charm ... got 3 spreadsheet running different centres.

Now the real hard part begins .. winning a few pennies!!