Placing Lay bets at different odds on same selection

Example spreadsheets and comments on example spreadsheets.
Post Reply
tedcarapook
Posts: 6
Joined: Fri Jul 28, 2017 1:37 pm

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
nigelk
Posts: 469
Joined: Wed Apr 15, 2009 11:00 pm

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.
Post Reply

Return to “Bet Angel - Example spreadsheets”