How do I trigger when market moves "In-Play" ?

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
PistolC
Posts: 2
Joined: Sat Apr 18, 2009 2:17 pm

Hi,

Still finding my feet with this automated help from Excel. Im attempting to write a code for a strategy I employ in the tennis. Im in desperate need to find out how to get my trigger to recognise when the market goes "In-Play". I cant rely on the countdown as tennis matches regulary start later than advertised for lots of reasons, Rain delay's, previous match taking longer to complete & so on. I cant see a CELL that indicates then market has gone "In-Play".

Can anyone help??
Thanks in advance
PeterLe
Posts: 3726
Joined: Wed Apr 15, 2009 3:19 pm

In-play is displayed in Cell G1
PistolC
Posts: 2
Joined: Sat Apr 18, 2009 2:17 pm

Many thanks Peter!!

have you any new videos on this as iv watched most & couldnt find anything that stated "In-Play". I have noticed in your video "Creating your own Betfair trading bot" in Cell "H1" shows "SUSPENDED", but nothing in G1.
PeterLe
Posts: 3726
Joined: Wed Apr 15, 2009 3:19 pm

Hi
Yes H1 displays suspended and G1 displays In-play..Link it up to a market and try it...
Regards
Peter
martins1116
Posts: 17
Joined: Mon Sep 27, 2010 5:53 pm

Hi - dont know if this is of any help, but I use the function =IF(ISTEXTG1) to trigger betting in-play.
Works fine for me.
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”