Six hours and I am going Crazy

[waytogo78247]

I downloaded the Betdaq version today and have spent 6-7 hours trying to do the simplest thing, but cant seem to find a way.

All I want is a rule that I can add to any selected horse once the market overound goes below 103%.

Overound is not in the Excel sheets, so that is out.

I have been messing with Guardian, but when I make a rule for one race lets say 2:15 good which takes a couple of minutes and appears to work.

I want the exact same rule for the next race 2:45 but get a message saying that the rule is linked to my selection in the 2:15 and wont work.

The only way I can see to get this to work is start from scratch and write the whole rule again for each and every race that I want a bet in and delete the whole lot at the end of the day.

That would take hours.

[Dallas]

If using the Betdaq version the only way not to have to edit the rule between each race is to apply to a selection by row index or order of favouritism.
In the Betfair version, you can nominate the selections for each race quickly on the main Guardian page as shown in the image below

Front Run Nom.png

[waytogo78247]

Thanks Dallas. It is unfortunately the Betdaq version so Nominated selections are not an option. I can't believe how difficult it is for this very basic rule.

If I could get the market overround into the spreadsheet that would do the job as I would just have to copy and paste my bet order into each race using the Multiple races sheet.

Is there a way to get that done?

[sentinel]

You can calculate the overround on the spreadsheet

[waytogo78247]

My mind has gone totally numb after all this time.

Anyone know of a quick formula to calculate the overound to place in a single cell like J2?

[ShaunWhite]

My mind has gone totally numb after all this time.

Anyone know of a quick formula to calculate the overound to place in a single cell like J2?

= (100/Price 1) + (100/Price 2) + (100/Price 3)... + (100/Price n)
Replace "Price 1" etc with the appropriate cell references.

But to cater for prices which are zero that would need to be slightly changed to be ...

=IfError(100/Price 1,0) + IfError(100/Price 2,0) + IfError(100/Price 3,0) ... + IfError(100/Price n,0)
This overrides any invalid '100/0' evaluation with zero.

But the easiest way is probably to add a BackBook% column populated from each of the prices individually so you can check they're as you expect, and then make your cell J2 contain the sum those values. Once you have that working you can very easily copy that to also give you a LayBook% value.

[waytogo78247]

Thanks Shaun,

That got my mind working again straight away and did in no time at all.