Scalping with Excel
Making use of the CLEAR trigger for Simple Scalping In Excel
You can use this spreadsheet download to place a back bet at the current best back odds and when matched place a lay bet for the same stake at the current best lay odds. You must select to log My Bets when linking to the spreadsheet for it to function as intended.
It uses SUMIFS to calculate the total matched back and lay stakes. When they are the same it means another back can be triggered as the previous trade is closed. It only checks up to row 100 on My Bets, so if the number of bets exceeds 99 it will not work correctly.
Download it here
"A joy to use and easily customised to my own requirements."