Excel VBA program for Bet Angel

First of all this task involves a gambling site, just be aware of that.

You will need a Betfair account and copy of BetAngel (can be run in practice mode) - Ill supply the daily codes for use.

Bet angel produce a spreadsheet that they require you to use when using excel or VBA, I can supply this, on this spread sheet it supplies you with all of figures/prices required for the task, it has been populated with the commands you can use at the top. I can guide you when attaching the spreadsheet to the main betangel program.

With betangel you can use a bookmakers feature, all Lay bets will be placed on the Back side and will consequently not be taken immediately, when the price moves out (against you) I need this program to;

Eg current lay bet is 10 at £5

Cancel the current bet (Bet angel have a command for that) green cells in column 'O' need to be cleared
recaluate the new bet, price go up by 5% (10.5) then the bet offer is reduce by 5% £4.75, green cells in column 'O' need to be cleared.
New Lay bet is offered at the new price, 10.5 @ £4.75, green cells in column 'O' need to be cleared.

Now the bet is made, betangel spreadsheet has a weird habit of marking in a column O with 'OK' or other report this needs to be removed as betangel will not accept any further bets on that horse and snarl up the entire process.

The VBA program needs to loop around the spreadsheet monitoring the entire field again and again until the all the bets have been filled.

Betangel have excellent online support, instruction manual and numerous Youtube videos and ive attached a copy of the spreadsheet I mentioned