GREEN_ALL function

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
Wyndon
Posts: 237
Joined: Sun Nov 13, 2011 10:14 am

Doe anyone know whether the GREEN_ALL global command in Excel functions in the same manner as trading out by ticking the Green box in One-Click Betting? I ask because the latter seems to work consistently in-play in that it always seems to stop things happening and realises a fairly even profit or loss, whereas the GREEN_ALL function in Excel seems much more haphazard in closing trades and can send some really large bets winging in that remain unmatched. I know part of the problem is attempting to green up during in-play (because of one second delay in horse-racing); but as I say this doesn't seem to be a problem in the One-Click screen. I hasten to add that I'm in practice mode when experimenting in this area.
doncht
Posts: 74
Joined: Mon May 05, 2014 3:57 pm

Hi Wyndon, bumping this up. Were you able to find any updates to this already?
Wyndon
Posts: 237
Joined: Sun Nov 13, 2011 10:14 am

No response so far. I'm guessing that the problem may be that whereas the manual green-up is a single action, it is difficult to replicate this on a spreadsheet where greening-up for example after a certain time would keep firing the command in.
Bet Angel
Bet Angel
Bet Angel
Posts: 4031
Joined: Tue Apr 14, 2009 3:47 pm

The GREEN_ALL function in Excel runs exactly the same process as clicking one of the greening buttons on the one-click screen when the 'Green' check box is ticked. All open positions (based on net stake) are closed and any profits from those positions are hedged into the market to spread the profit/loss across the book.
Wyndon
Posts: 237
Joined: Sun Nov 13, 2011 10:14 am

Thanks for the clarification. I suspect it may be another aspect of my spreadsheet that is causing the problem.
Wyndon
Posts: 237
Joined: Sun Nov 13, 2011 10:14 am

Hello again. I still have a problem. My spreadsheet is designed to Green_All if the P&L exceeds a certain amount after x seconds into the race. It keeps on firing once the condition is met - whereas this is not a problem if you green up manually. Any advice welcome.
Wyndon
Posts: 237
Joined: Sun Nov 13, 2011 10:14 am

My fault! I discovered a Worksheet Calculate event that I'd forgotten about which was clearing the Status cell.
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”