For example, say the selection on row 9 is the favourite horse in a race called, "Peter". Then say I want to send in an opening back bet at the current odds, a profit point 2 ticks away and a stop loss 2 ticks the other way. Is there a way to send all three bets into the market within the same refresh of the worksheet?
Running something like this:
Code: Select all
Cells(9,12) = "BACK"
Cells(9,13) = Cells(9,7)
Cells(9,14) = Stake
Cells(9,15) = ""
Cells(9,12) = "BACK"
Cells(9,13) = Cells(9,9)
Cells(9,14) = Stake
Cells(9,15) = ""
Cells(9,12) = "LAY"
Cells(9,13) = Cells(9,5)
Cells(9,14) = Stake
Cells(9,15) = ""
If not, how does Automation get arounds this? I assume it can be done within a single refresh with Automation?