Problem in Excel Laying under minimum stake

Please post any questions regarding the program here.

Moderator: 2020vision

Problem in Excel Laying under minimum stake

Postby the_mathman » Mon Nov 09, 2009 5:14 pm

Hi,
i have some problem with the Excel triggers:

I realized an excel trigger to Lay under the minimum stake (about 1€) if are true some conditions.
The problem is that the lay result sended and not matched in the excel sheet, but if I control (in BA or in the betfair site), I can see the bet blocked at the first step of the "under minimum stake" process (i see 2€ layed @1,01); if i wait for minutes, the bet rest blocked at 2€ layed@1,01) and the only solution for this problem is delete the pending bet and resend the lay from BA interface.

some other info:
- my excel sheet is just opened, clear and no bet are placed before this;
- the lay under the minimum stake is the only bet placed from the sheet;
- I wait for the lay for minutes, but it is not placed;
- During the lay proces, on BA don't appear the classic message "waiting 20 second for betfair dalay..."
- I'm using BA 1.1.0.63t

can you help me?
sorry for my bad english!
the_mathman
 
Posts: 18
Joined: Fri Oct 23, 2009 1:46 pm

Re: Problem in Excel Laying under minimum stake

Postby the_mathman » Mon Nov 09, 2009 5:19 pm

the_mathman wrote:Hi,
i have some problem with the Excel triggers:

I realized an excel trigger to Lay under the minimum stake (about 1€) if are true some conditions.
The problem is that the lay result sended and not matched in the excel sheet, but if I control (in BA or in the betfair site), I can see the bet blocked at the first step of the "under minimum stake" process (i see 2€ layed @1,01); if i wait for minutes, the bet rest blocked at 2€ layed@1,01) and the only solution for this problem is delete the pending bet and resend the lay from BA interface.

some other info:
- my excel sheet is just opened, clear and no bet are placed before this;
- the lay under the minimum stake is the only bet placed from the sheet;
- I wait for the lay for minutes, but it is not placed;
- During the lay proces, on BA don't appear the classic message "waiting 20 second for betfair dalay..."
- I'm using BA 1.1.0.63t

can you help me?
sorry for my bad english!

another info:

the lay is an "In play" bet.

p.s. where is the "modify" button here in the forum?
the_mathman
 
Posts: 18
Joined: Fri Oct 23, 2009 1:46 pm

Postby GaryRussell » Mon Nov 09, 2009 5:52 pm

Does this problem occur every time or intermittently?

What type of market does this problem occur on, ie. horse racing, soccer?

The latest version is 1.1.0.63v. Can you install this version and tell me if the problem still occurs? Download link can be found here http://gruss-software.co.uk/forum/viewtopic.php?t=3922
User avatar
GaryRussell
Site Admin
 
Posts: 9872
Joined: Fri Nov 18, 2005 8:09 pm
Location: Birmingham, UK

Postby Captain Sensible » Mon Nov 09, 2009 7:26 pm

I think you'll find the problems due to the API limits on the UpdateBets calls, at a guess you're placing more than 15 undersize bets in one pass and it's getting rejected by the API.
User avatar
Captain Sensible
 
Posts: 2923
Joined: Sat Nov 19, 2005 2:29 pm

Postby Captain Sensible » Mon Nov 09, 2009 7:28 pm

Ooops missed the


- the lay under the minimum stake is the only bet placed from the sheet;
bit :oops:
User avatar
Captain Sensible
 
Posts: 2923
Joined: Sat Nov 19, 2005 2:29 pm

Postby the_mathman » Mon Nov 09, 2009 11:44 pm

GaryRussell wrote:Does this problem occur every time or intermittently?

What type of market does this problem occur on, ie. horse racing, soccer?

The latest version is 1.1.0.63v. Can you install this version and tell me if the problem still occurs? Download link can be found here http://gruss-software.co.uk/forum/viewtopic.php?t=3922


this problem occur every time.

My test are in soccer, in the match odds market.
Now, I will test the 1.1.0.63v version!
the_mathman
 
Posts: 18
Joined: Fri Oct 23, 2009 1:46 pm

Postby the_mathman » Mon Nov 09, 2009 11:57 pm

GaryRussell wrote:Does this problem occur every time or intermittently?

What type of market does this problem occur on, ie. horse racing, soccer?

The latest version is 1.1.0.63v. Can you install this version and tell me if the problem still occurs? Download link can be found here http://gruss-software.co.uk/forum/viewtopic.php?t=3922


At a first test the system appear to don't work (using the 1.1.0.63v version too).
But after more detailed test i have discovered that the problem was in same cell data format; indeed if I use odds and stake writen manually, the LAY command works correctly.
The problem was about the odds and the stake calculated from another cells.
the origin cells was an FIXED(XX;1) function; this referenced cell don't work (probally the 1 decimal number was interpreted as string, not as number); now the cell is =FIXED(XX;1)+"0" and it work !!!
the_mathman
 
Posts: 18
Joined: Fri Oct 23, 2009 1:46 pm


Return to Help

Who is online

Users browsing this forum: Bing [Bot] and 50 guests

Sports betting software from Gruss Software


The strength of Gruss Software is that it’s been designed by one of you, a frustrated sports punter, and then developed by listening to dozens of like-minded enthusiasts.

Gruss is owned and run by brothers Gary and Mark Russell. Gary discovered Betfair in 2004 and soon realised that using bespoke software to place bets was much more efficient than merely placing them through the website.

Gary built his own software and then enhanced its features after trialling it through other Betfair users and reacting to their improvement ideas, something that still happens today.

He started making a small monthly charge so he could work on it full-time and then recruited Mark to help develop the products and Gruss Software was born.

We think it’s the best of its kind and so do a lot of our customers. But you can never stand still in this game and we’ll continue to improve the software if any more great ideas emerge.