MARKET_SUSPENDED - Placing bets directly after the start

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
buyshirts
Posts: 490
Joined: Sat Apr 18, 2009 12:37 pm

The sheet is set up to place bets in running straight away but i get the MARKET_SUSPENDED if i clear this the bet will then get fired in. So i know it is not the formula im using any help would be much appreicated.
Top
User avatar
Euler
Posts: 26434
Joined: Wed Nov 10, 2010 1:39 pm

You should use the countdown timer to only put bets in a few seconds after the start of the race and / or use the "inplay" string to ensure it is definately inplay.
Top
buyshirts
Posts: 490
Joined: Sat Apr 18, 2009 12:37 pm

I am using the "In-Play" i would have thought that would have worked on its own. Im not totally sure how the countdown will help because race virtually always go off late and i dont want to put the best in say 30 seconds into a race.
Top
User avatar
Euler
Posts: 26434
Joined: Wed Nov 10, 2010 1:39 pm

I always wait a second or two so I don't get crazy prices just after the off so I've never seen this. I guess there is a slight timing difference between suspended and inplay and the spreadsheet is picking that up.
Top
buyshirts
Posts: 490
Joined: Sat Apr 18, 2009 12:37 pm

When you say you "wait a couple of seconds" Is this when firing the bets in via Excel or just when placing bets manually?
Top
buyshirts
Posts: 490
Joined: Sat Apr 18, 2009 12:37 pm

Does anybody else have any ideas?
Top
Talkbet
Posts: 67
Joined: Tue Apr 26, 2011 6:35 am

Just so you're clear. Just because a market is 'In-Play' it doesnt mean it cant be in a 'Suspended' state.
You need to check for the in play flag to become true and then either wait a few seconds or keep checking the suspended flag (with say a 1 second pause between each loop) until suspended is no longer true.
Top
buyshirts
Posts: 490
Joined: Sat Apr 18, 2009 12:37 pm

Ok thanks for that. The formula im using is

=IF(AND(C4>4,G1="in-play",K2>2),"BACK","")
So C4 is amount of runners
G1 obviously In-play
K2 is just a Min price/
Can you advise where i have gone wrong here? as im unsure how to pause this process for a few seconds. Also
i only want the bets to go in once is there any need for a loop?
Thanks in advance for any help
Top
Talkbet
Posts: 67
Joined: Tue Apr 26, 2011 6:35 am

I was looking at it from a coding point of view as opposed to the spreadsheet (something I've never used or tried). Is there not an option to check Suspended ? So your formula will only fire once 'in play' is true and 'suspended' is false ?
Top
buyshirts
Posts: 490
Joined: Sat Apr 18, 2009 12:37 pm

Yes there is a suspended cell and that now works.
Once again thanks for taking the time to help.
Cheers!
Top
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”