In light of another post this afternoon whereby £200 was traded at 790 (on a winning Greyhound)..I thought Id open a post for newbies as a way to prevent such losses using automation...I would hate to think that was someone from our forum.
A couple of ways I use excel is to put in a simple command in say cell K6 (=C6-Balance)...So if you had £100 in your betfair account the cell would contain : =C6-100
In your main qualification cells (ie the cells that determine whether you fire in a bet or not)..you could put a condition in there that checks that this cell is greater than -£20 (for example). This will work OK until you hit your stop loss.
The above works OK for back bets (assuming you are using small stakes) but not so for the first lay bet.
Here you may want to have a cell that checks your intended lay stake against the odds and not fire the bet in unless the Liability is less than X or greater than Y
Another simple one is to simply check the value of cell C9, C11 etc..(ie dont place another bet if this cell is less than X already)
Other ways is to check the net stakes (eg AA10-AD10) and/or the matched/Unmatched bet info
These are all very basic commands (and in a respectful way, if you can't do these simple commands you should still be in practice mode)..
Anyway a few pointers, please add other suggestions for newbies
Regards
Peter
