I have an excel sheet set up to place a Back bet at a certain point in play of a football match (e.g. at 60mins back Team 1 for $100).
When the odds drop, I need to place a lay on Team 1 for $100.
I'm struggling to set up a back and lay bet on the same team.
As the boxes for Team 1 are filled, the only option is for the global function to green_all.
Is there any way to do this without me programming some VBA to clear the placed intial bet?
Back and then Lay The Draw
-
beepbeep20
- Posts: 27
- Joined: Wed Feb 09, 2011 10:05 pm
If you don't want to use the "BACK Offset:5 FILL_KILL: etc. etc." when you initially place your bet then you'd have to clear the 'PLACED' text either manually or by VBA.
A small VBA macro to clear the 'PLACED' text could be triggered by time (eg. 20 minutes after you placed your back bet) or by price (when the price has dropped to 2.02 or whatever) or by how much greening you could have.
The danger with doing it that way is if your internet connection dropped or your PC froze no 2nd bet would be fired.
A small VBA macro to clear the 'PLACED' text could be triggered by time (eg. 20 minutes after you placed your back bet) or by price (when the price has dropped to 2.02 or whatever) or by how much greening you could have.
The danger with doing it that way is if your internet connection dropped or your PC froze no 2nd bet would be fired.