Gruss Forum • View topic

by **excelhasey** » Fri Jun 11, 2010 11:44 am

Checking the My Bets Tab yesterday I noticed there was a discrepancy between the number of bets recorded by BA (matched i.e. not including "cancelled") and the number of settled bets on Betfair. There where 2 extra bets recorded and matched on Betfair as against the BA Excel My Bet tab - Any ideas why ?? - I noticed I lost on one of the "extra bets", which makes me wonder has Betfair added this bet themselves !!!

Is there any way of Betfair telling the difference between a manual bet placed on the Betfair site and an automatic bet placed via BA ??

by **GaryRussell** » Fri Jun 11, 2010 11:55 am

It's unusual that you've no idea where that bet came from. MyBets includes every bet placed on the market regardless of whether it was placed through Excel, manually in Betting Assistant, via the website or another API program and I am pretty sure there isn't a bug causing it to miss out any bets. Betfair can tell you if the bet was placed via BA if you send an email to bdp@betfair.com.

by **GaryRussell** » Fri Jun 11, 2010 11:57 am

Another thing. What market was this on? MyBets does not show settled bets. Once the market is settled they disappear from MyBets.

by **excelhasey** » Fri Jun 11, 2010 12:22 pm

Horse Racing

Below is a typical My Bet row, it was matched and I won, so I call them settled bets

11196457029 Three Ships L 10.07 27 RESULT_WON

by **GaryRussell** » Fri Jun 11, 2010 12:38 pm

That's not the MyBets sheet, it's the bet results sheet. The bet results sheet only includes bets triggered from Excel. If you you used the tick offset trigger (eg. BACK-T1) it does not log the offset bet refs in the results sheet, only the original back bet. Could this be your issue?

by **excelhasey** » Fri Jun 11, 2010 10:00 pm

Ah I thought my results were going into the MyBets tab, sorry I have added a Results tab now so I will check that tomorrow

On the offset trigger issue, instead of me having a trigger that says simply Back or Lay (when my conditions are met) I can simply have it write Back-T1 or Lay+T1 etc and that will work directly in Excel and try and place / match a bet will it but at the next tick value ??

by **GaryRussell** » Sat Jun 12, 2010 8:33 am

No, BACK-T1 is not for adjusting the odds of the back bet. It's for placing a lay bet at 1 tick lower than the matched back odds when the back bet is matched. There isn't a trigger for adjusting the odds of the back bet. You can make column R equal to the best back odds plus or minus any number of ticks with a custom function I created. See http://www.gruss-software.co.uk/forum/v ... php?t=2399

My Bets Tab

My Bets Tab

Who is online

Sports betting software from Gruss Software