Gruss Forum • View topic - API-ERROR ON LAYSP in EXCEL

by **4legs** » Fri May 27, 2011 3:50 am

I am trying to lay a number of runners in the same race using LAYSP - the trigger comes up ok but I get the API_ERROR
Details:
LAYSP is in col Q
Odds: 100 in col R
Stake: $30 in col S (this is betfair SP min in Oz)

Version is: 1.1.0.65z6. I get the same error on Windows 7 machine and also on the Laptop Vista.

Normal BACK Trigger Works

Is there some other thing I have to set - or any ideas what could be causing it.

Thanks ... Fred

by **GaryRussell** » Fri May 27, 2011 7:17 am

I cannot replicate this. API_ERROR is usually a problem at Betfair's end. Try again today and let me know if it's still happening then I will investigate further.

by **4legs** » Sat May 28, 2011 9:10 am

Error still persists.

Contacted Betfair, but they did not want to know about the problem and said to contact the software developer - it would be their problem!
Further Information:

It is the same error on both machines:
Laptop is running Visa with Avast internet security
Desktop running Windows 7 with AVG internet secturity

Both Machines connect directly to the modem via cable (ADSL2). I would say a very reliable internet connection.

No problems with any other program.

I am at a complete loss with one as I am finding it difficut to find what will cause an API-ERROR and also if there is a setting that I have missed; but reading all the forums and User guide it all seems so straight forward.

Any suggestions would be greatly appreciated. Thanks ... Fred

by **GaryRussell** » Sat May 28, 2011 9:31 am

If you send a copy of the spreadsheet to admin@gruss-software.co.uk after this error has occurred I can see if I can replicate it. It is likely that there is something wrong in your spreadsheet, but without seeing it myself it is sometimes very difficult to diagnose.

It's irrelevant that you don't have problems with other programs because this is a very specific issue. It's also absolutely nothing to do with your internet connection. It's pointless contacting Betfair. If anyone is going to solve this problem it will be us. It is our software. When I said the problem could have been at Betfair's end I did not mean that you should contact Betfair, I was not passing the buck.

by **Shaun** » Sun May 29, 2011 2:05 am

Hey 4legs, have some issues do you mate i am sure these guys will sort it.

by **GaryRussell** » Sun May 29, 2011 9:31 am

I'm still looking into this and I received your second spreadsheet thank you.

by **4legs** » Sun May 29, 2011 10:45 am

Thanks Gary; Thanks Shaun - another Aussie I see - although 4,500 Klms away ( I am in Brissie).

This is truely a weird one; but hopefully we will sort it out. I love the idea of the excel interface - great concept ... Fred

by **4legs** » Sun May 29, 2011 10:44 pm

Shaun was kind enough to send me a lay spreadsheet last night, which was virtually the same as mine except 2 fields appeared on his which were not on mine. There were:

Code: Select all: Cell Heading Shauns Value My Value J3 Blank 66 Blank L3 IR Delay 1 0

Is this relevant and where/how would I change mine to the above.

Many thanks ... Fred

by **GaryRussell** » Mon May 30, 2011 8:32 am

I don't think it's relevant. I have released version 1.1.0.65z7 today. This will log exactly what is being sent to Betfair's API. The next time you get API_ERROR please send the file named BA_Diagnostic.txt in "c:\temp\Betting Assistant Logs" to admin@gruss-software.co.uk
The log will show me the exact contents of the request sent to Betfair's API. If I cannot see anything wrong in this request I will then report it to Betfair. I think this will probably be the case.

by **4legs** » Mon May 30, 2011 10:52 am

Thanks Gary. I have upgraded to this version so I will use it tomorrow and send you the results .. Fred

by **GaryRussell** » Tue May 31, 2011 5:40 pm

I have received confirmation from Betfair that it is an API bug so we will have to wait for Betfair to fix it unfortunately.

by **4legs** » Tue May 31, 2011 10:09 pm

Thanks Garry - I appreciate your speedy action - Fred

by **GaryRussell** » Thu Jun 02, 2011 4:30 pm

Betfair have confirmed the fix is scheduled for release 6th June. They will let me know if this is delayed.

by **GaryRussell** » Mon Jun 06, 2011 1:11 pm

Betfair have confirmed that the fix has been deployed. Please let me know if it happens again.

by **4legs** » Tue Jun 07, 2011 7:49 am

Today I layed (SP) every Aus race - (23 in total) without a problem - I would say my problem is fixed. Thanks Gary.

API-ERROR ON LAYSP in EXCEL

API-ERROR ON LAYSP in EXCEL

Who is online

Sports betting software from Gruss Software