How to trigger a bet just before the off.

[ocean]

Hi everyone,

I`m a newbie here and have only just discovered this great piece of software. Firstly I`d like to thank Gary for making this program freely available, a lot of personal effort must have gone in to it.

What I am trying to do is trigger my bets at my value prices about 30 seconds before the race is off but I can`t seem to come up with a formula to do this. I`m not very knowledgeable when it comes to Excel and the formula I`ve been trying to use obviously doesn`t work. In the trigger box I`ve typed =if(d2="00:00:30",BACK)

Does anyone know if what I am trying is possible and if so can anyone please tell me where I`m going wrong or maybe even post the correct formula.

Any help would be grately appreciated.

Ray.

[Captain Sensible]

Probably best to use < less than rather than equals as lag etc may mean you'll miss the exact time. BF wont retrigger hen a bet ref is tere so it won't keep kicking off bets unless you've some clear loop.

I've used time functions before and they work think I used the minute function but not too sure as I'm not on my main pc at the moment. Look thru the time functions in help and use less than and you should be ok.

[ocean]

Hi Captain,

Thanks for your reply. I have just tried =IF(D2<"00:00:30","BACK","WAIT") but still no joy.

[The Gambling Monkey]

Try

=IF(SECOND(D2)<=30,"BACK","WAIT")

[ocean]

Thanks for the reply Monkey, I`ve just tried that and I don`t think it works. I keep getting ERROR in the bet ref cell.

[Captain Sensible]

Monkey yours would kick off whenever the secounds were below 30 i.e. 00:10:29 , 00:09:29 etc

Probably best use

=IF(D2<=0.000347222,"BACK","WAIT")

as 0.000347222 represents 30 seconds to excel

Ocean have you entered stakes and odds, logged in etc ? there's a few reasons why error would come up

[The Gambling Monkey]

I tested it before I posted, so it works. Is the value in D2 is negative i.e. past the start time?

Does the word BACK appear in your trigger column though when the number of seconds in D2 are less than 31?

One problem I just though of though is that the formula just looks at the seconds.

You may actualy need:

=IF(AND(MINUTE(F2)=0,SECOND(F2)<=30),"BACK","No")

Depending on how far in advance of the event you load the race into excel you may also need to consider hours.

[Horseman]

well i have a problem to

im new so sorry for my questions

my question is !

IS IT POSSIBLE TO PLACE A BET FOR EXAMPLE ONE MINUTE BEFORE THE OFF AUTOMATED BY BETASSISTANT EQUAL WHICH ODDS AT THIS MOMENT ARE ? OR MAYBE ALL THE ODDS LOWER THEN 10 OR AN PREDEFINED ODDSRANGE ??? IM NOT ABLE TO PLACE ALL MY BETS BECAUSE IM WORKING AT THE AFTERNOON WHEN THE RACES STARTS SO I CAN PLACE THIS BEFORE I GO . IM ITALIAN AND MY ENGLISH IS NOT GOOD SO I HOPE YOU UNDERSTAND WHAT I MEAN

[BlueBoy]

I was interested in your post containing the value 0.000347222 as 30 seconds.
This was new to me and could be useful

Do other values correspond i.e does half this (0.000173611) equal 15 seconds.


Thanks

[GeorgeUK]

Horseman - I have a spreadsheet made up that allows the user to lay x minutes before the race starts.

I had been asked to make this by someone else and it seems to work but i am unable to use it as i have a really dodgy isp. The trigger formula is part of the code so this may need changed. Have you used VBA before (writing macros)? If not, i'm still pretty sure i can help. Will try to tweak it to make it a little more user friendly.

PM me if you have any queries.


BlueBoy - format cell A1 as time and put 00:00:30 (30 secs)
for B1 put =A1 and format as general
this will show you the numeric value of the time.
so you can test for 15 secs - and yes it is 0.000173611111111111

George

[BlueBoy]

Thanks very much.

[Mitch]

For anyone who wants to understand why, Excel counts time in days so if you divide however many seconds you want to trigger at by 86400 (seconds in a day ie. 60*60*24) it gives you the number for your formula.

Horseman....
If you wanted to place a bet only if the odds are above or below a pre-defined figure then you would include that as part of your IF formula for the time, using AND.
IF(AND(time is less than x, odds are less than y),"BACK","WAIT")

[Captain Sensible]

horseman if you're looking to place bets a minute before the off have a look at

http://gruss-software.co.uk/forum/viewt ... c&start=15

basically it's the code for a list so you can enter the horses you wish to bsck/lay and odds etc on a separate sheet, set markets to auto select 1 minute before the off and it'll lay/back them for you. Easy to set the sheet to take the available odds if you dont wish to pre define the odds