Time triggers

[andyh]

Hi all, newbie to this forum and very impressed so far. A quick question is it possible to trigger a bet using the time cell D2 so I can match odds 5 mins before the off. I have googled time formats etc in Excel but became a little unstuck as I am unsure of the 'live' nature of the time in D2. Can I treat it as a particular format when an an IF function for example?

Cheers

Andy

[andyh]

Apologies, I think I've just found the answer in another post!

Cheers

Andy

[andyh]

Hi, I did find my answer to the above but am now a little stuck at triggering a bet 5 mins before the off within set odds, eg between 2 and 12. I thought I may have cracked it with the line below but this doesn't seem to work. Anybody any ideas? I'm off to but and Excel book this afternoon!

=IF(AND(TEXT(NOW(),"hh:mm:ss")="11:03:00",2<H5<=12),"LAY","waiting")

Cheers

Andy

[Castillo]

Hi, I did find my answer to the above but am now a little stuck at triggering a bet 5 mins before the off within set odds, eg between 2 and 12. I thought I may have cracked it with the line below but this doesn't seem to work. Anybody any ideas? I'm off to but and Excel book this afternoon!

=IF(AND(TEXT(NOW(),"hh:mm:ss")="11:03:00",2<H5<=12),"LAY","waiting")

Cheers

Andy

Andy

I convert the time to a decimal, and then trigger to bet below the decimal figure, see below.

If you enter =(D2-INT(D2))*24 in Cell Y2 for example then in your trigger cell Q5 add

=IF(AND(F5>=2,F5<=12,Y2<0.0833),"BACK","WAIT")

5 mins is equal to 0.0833, so if the odds in cell F5 are equal to or between 2 and 12 and the time is less than
5 mins to the off a bet will be made.

Other people might do it differently, but I hope this helps.

Cheers
Castillo

[andyh]

Hi Castillo, thanks for the swift reply. Am I right in thinking that the line you provided me would place multiple bets for all the times below 0.0833? Could I change the change it to read Y2=0.0833 to trigger the single bet?

Thanks again

Andy



=IF(AND(F5>=2,F5<=12,Y2<0.0833),"BACK","WAIT")

[Castillo]

Hi Castillo, thanks for the swift reply. Am I right in thinking that the line you provided me would place multiple bets for all the times below 0.0833? Could I change the change it to read Y2=0.0833 to trigger the single bet?

Andy

This will only place 1 bet, the Bet Ref would need to be cleared using the CLEAR command for another bet to take place.
To be absolute certain only one bet gets placed you can add W5=0,T5=0,U5=0 to the formula which means the Bet Ref, Bet Time & Matched Stake field must all be clear before a bet is placed. Once a bet is placed the trigger will return to the WAIT command because there will be entries in W5,T5 & U5, see below.

=IF(AND(F5>=2,F5<=12,Y2<0.0833,W5=0,T5=0,U5=0),"BACK","WAIT")

Cheers
Castillo

[andyh]

Thanks Castillo, you've been a great help.

Andy

[knot]

having tried the formulas on this thread all i can make happen is #VALUE appear in Y2 when the bet is to be placed. where am i going wrong? please help.

[Castillo]

having tried the formulas on this thread all i can make happen is #VALUE appear in Y2 when the bet is to be placed. where am i going wrong? please help.

Hi Knot

After the race time expires it does change to #VALUE!
From your other post I see that you want to back a selection if the odds are between 2 and 10 at 2 mins before the off.
(2 mins = 0.0333) so the formula would be something like this

=IF(AND(F5>=2,F5<=10,Y2<0.0333),"BACK","WAIT")

This should trigger a bet when the clock is below 2 mins before the off, and the selection is between or equal to odds of 2 & 10.
By using =(D2-INT(D2))*24 in cell Y2 as the clock is counting down, is it showing a decimal figure?

Hope this helps
Cheers
Castillo

[andyh]

I have successfully used the lines suggested above for a few days but then came unstuck yesterday when a non runner was removed and my lay bet was placed on the next horse who duly won! I have searched the other topics and read about the use of a secondary sheet to validate the name of the horse to ensure this doesn't happen but I was wondering if anybody has used a line similar to those mentioned above but with the manual insertion of the horse name ( no lookup to a secondary sheet) in the trigger line.

I appreciate all the help from those whose knowledge far outwieighs my own!

Andy

[knot]

im trying to back all horses at certain odds using these formulas having set BA to auto start of 2 mins each race. sometimes the bets trigger sometimes they dont and sometime half the bets trigger could anybody please tell me why this is. thank you

[GaryRussell]

im trying to back all horses at certain odds using these formulas having set BA to auto start of 2 mins each race. sometimes the bets trigger sometimes they dont and sometime half the bets trigger could anybody please tell me why this is. thank you

I am revising the code that places triggered bets at the moment. I will improve the error reporting which should enable you to see why the bets weren't placed.

[knot]

Hi Gary do you think it could of been due to refresh rate being to high? it was set at 1.0, now i have set it to 3.0 and it seems better do you recommend a refresh rate for excel? Also is it somehow possible to pick only certain races for auto start?

[knot]

ok it has nothing to do with the refesh rate as the same situation has happened today hit and miss if the bet is placed. i would be very grateful if anybody could advise me on this thanks i missed out on some good winners today, does anybody eles have problems triggering multiple bets at the same time?

[knot]

think ive sorted it just needed to stagger the trigger times a little