Greening up excel

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
StellaBot
Posts: 818
Joined: Thu Jan 26, 2017 11:52 am

I am trying to work out how to put a green up command in excel. When manually trading one can click any green all when in profit by (+x).
Initially had a formula based on the D10,D12,D14 cells all being above + 0.00(x) ie not red
But sheet fired/greened/red at an instant of red , didnt seem to recognise the minus value of the red.
Any ideas ? or further explanation required
Edit
Also tried (-)x(-) minus times minus = plus, therefore if any 2 reds on excel(screen)etc would show a plus
StellaBot
Posts: 818
Joined: Thu Jan 26, 2017 11:52 am

I did see this post.
https://betangel.com/forum/viewtopic.php?f=19&t=2110
Tried Green_All in global command.
But still cannot find a solution.
StellaBot
Posts: 818
Joined: Thu Jan 26, 2017 11:52 am

Simple solution
Under Global command L6
=IF(AR7=3,"GREEN_ALL","")

AR7 being my cell reference and if value 3 in same cell.


Happy days, excel automation on its way.
All yesterdays races went green but had to manually click.
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”