Gruss Forum • View topic - help

by **gravitywgy** » Wed May 24, 2006 3:20 pm

I am trying to automatically lay using the spreadsheet. Everything seems fine but the bets do not get laid they just go to PENDING. If I then CLEAR and copy the trigger code from another cell the bet then lays ... any ideas please.

John

by **The Gambling Monkey** » Wed May 24, 2006 3:59 pm

From time to time I also get "PENDING" and no bet being placed.

I'm fairly sure it's got something to do with the fact I normally have a seperate tab for each horse race, each refreshing every 10 seconds.

In my case the attempt to submit the bet might be being swamped by the refresh requests, hence PENDING and no bet placed.

I don't know if this helps or not.

by **gravitywgy** » Wed May 24, 2006 4:16 pm

I wonder if there is an application issue, as I have just noticed that I cannot copy and paste within my spreadsheets when BA is running.

by **The Gambling Monkey** » Wed May 24, 2006 4:26 pm

I'm not that advanced when it comes to VBA (so I might be wrong) but if you're running a macro you won't be able to cut & paste.

by **GeorgeUK** » Wed May 24, 2006 4:55 pm

you should be able to copy & paste as long as you have application.screenupdating = false
Then after you cut and paste turn it to true so that the updates continue.

by **BlueBoy** » Wed May 24, 2006 7:00 pm

Can I add myself to the list members who suffer from the PENDING problem and request help from any experts out there?

by AP » Wed May 24, 2006 7:03 pm

If you have the refresh rate set @ 10 seconds I think BA only checks the spreadsheet for bets on those 10 second updates. This may be wrong, but thats how it works when set @ 1 second.

by **gravitywgy** » Thu May 25, 2006 7:29 am

My refresh rate is set at 1 second. I have tried both longer and short refresh rates but still get the problem.

The automatic lay did work one day, but generally does not. I am on Windows XP Pro SP2 and excel 2003.

John

by **The Gambling Monkey** » Thu May 25, 2006 9:42 am

How many market tabs do you have open at once?

by **gravitywgy** » Thu May 25, 2006 7:38 pm

just the one market tab

by **Castillo** » Thu May 25, 2006 10:09 pm

I nearly always include the following in all my trigger betting formula, basically if PENDING is in the Bet Ref column for more than 5 seconds and the matched stake is = to zero the bet is cleared, hence another trigger bet BACK or LAY can be made depending on the formula etc...
Sometimes it can quite often get stuck, especially if your stake is below £2, or there is a delay in the IN PLAY market.

IF(AND(Q5="PENDING",T5=0,(R5+"00:00:05")<C2),"CLEAR"

by **The Gambling Monkey** » Thu May 25, 2006 10:13 pm

Cheers for that Castillo.

I was going to look at doing something simliar.

by **gravitywgy** » Thu May 25, 2006 11:21 pm

Thanks Castillo, slowly getting there, but I am now cancelling the bet oafter it has been layed at refresh rate 1 second.

Changed refreshed rate to 3 seconds and started to lay hundreds of bets.

My trigger is now as follows

=IF(AND(Q7="PENDING",T7=0,(R7+"00:00:05")<C4),"CLEAR",IF(AND(MINUTE($D$2)<10,O7>0),"LAY",""))
.

Cheers

John

by **gravitywgy** » Thu May 25, 2006 11:36 pm

Whoops ... needed a couple of $s in there ... now seems to work but will try properly at the weekend when I can sit at the PC.

=IF(AND(Q8="PENDING",T8=0,(R8+"00:00:05")<$C$2),"CLEAR",IF(AND(MINUTE($D$2)<10,O8>0),"LAY",""))

by **gravitywgy** » Fri May 26, 2006 7:16 pm

Seems to work ok on US racing but still stays pending on UK racing. Any more ideas folks?

John

help - automatic lays always go to PENDING

help - automatic lays always go to PENDING

Who is online

Sports betting software from Gruss Software