Hey guys
Just looking for assistance if there is a way to place lay bets on a certain selection at different prices all at the same time (i.e. Laying a selection at 1.2, 1.3, 1.4 at the same time) in the excel spreadsheet. Which type of vba code should I be using?
Cheers
Placing Lay bets at different odds on same selection
One way would be to get a list of all the Betfair prices and put them in your spreadsheet.
You can then use the 'match' function to get the row number of your initial price. Say for example 1.04 was on row 130, your subsequent bet placements would be 1.05 ( match 1.04 -1), then 1.06 (match 1.04 -2) and so on.
You'd also need to clear the status cell so each new bet would be accepted.
You can then use the 'match' function to get the row number of your initial price. Say for example 1.04 was on row 130, your subsequent bet placements would be 1.05 ( match 1.04 -1), then 1.06 (match 1.04 -2) and so on.
You'd also need to clear the status cell so each new bet would be accepted.