Excel in running - asking for current price regardless

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
foxwood
Posts: 432
Joined: Mon Jul 23, 2012 2:54 pm

Using Excel in running for horse racing, the latest odds inserted into the spreadsheet by BA will often be vastly different to the real available odds once a bet hits the exchange. This is particularly dramatic in the final run-in.

If I want to back at the current price regardless of how it has changed, can I just ask for odds of 1.01 and the exchange will automatically fill that with the best odds available ? If so would a similar approach work for laying by asking for odds of 1000 ?

Alternatively, can this be achieved by leaving the odds cell blank when constructing the back/lay cells prior to clearing the status ?

The reason for thinking that this may work is that you can do something similar in the ladder by clicking out of the odds to place a bet at the latest price.

I've found nothing in the manual or forums on this and the Betdaq version (which is all I have at the moment) does not have a practice mode to test with. Don't want to risk laying a 999:1 winner by testing live !

Any help appreciated.
PeterLe
Posts: 3727
Joined: Wed Apr 15, 2009 3:19 pm

Hi
You always need to have something in the Odds cells or the bet wont fire.
If you back at 1.01 or lay at 1000 it will always fill at the best odds available
Regards
Peter
foxwood
Posts: 432
Joined: Mon Jul 23, 2012 2:54 pm

Many thanks Peter :)
User avatar
Euler
Posts: 26443
Joined: Wed Nov 10, 2010 1:39 pm

Be careful if you do this as you could end up with some wacky prices. Be sure to thoroughly test what you are doing first.
PeterLe
Posts: 3727
Joined: Wed Apr 15, 2009 3:19 pm

Hi
Just to add to what Peter said..
Its recommended to test it (on as many races as possible) in Practice mode..before going live
Yo might also want to build in safeguards..for example, in the lay statement you may want to say something such as "only lay if H9<10"
(H9 is the first available lay price for the first horse)..
Also check your liability settings in BA and only leave a small amount in your betfair UK wallet, move the bulk into your Aus wallet
Regards
Peter
foxwood
Posts: 432
Joined: Mon Jul 23, 2012 2:54 pm

I have seen some of the wacky prices come up in testing on the back side. Don't think I dare go near the lay side with an open "give me your price" offer - could easily get caught and wiped out :/

Just to be certain, presume I'm right in also assuming that will never get matched with a worse price than asked for eg if ask to back at 3.0 then will only get matched at 3.0 or greater ? Conversly a lay at 3.0 would only get matched at 3.0 or less ?
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”