Stugots as you are the VBA Guru, I wanted to ask for your help. I want to open the Betfair data files and then extract the odds of the horses in each race, identify the winner in red font and sort (in ascending order) in rows.eg:
1.6 3.3 19 46 200 250
1.86 3.65 9.8 13 55
3.5 3.8 5.5 9.4 10 25 34
At present I have to manually mark the winner in red then Copy & Paste every race, then sort. The aim of the excercise is to look down columns of 1st Fav, 2nd Fav... and identify no. of consecutive losses and wins. Also Strike Rate, Average Div etc
The reasoning behind identifying no's of consecutive losses/wins is because they are the arch enemy of recovery staking plans. Most plans if staked right can handle two or three consecutive losses but any more and then followed shortly after by another loss and you've just been "shaken out of the tree". I was considering setting up multiple instances, using the same selection system, whereby instead of betting consecutive races each instance is programed to randomly miss a race or two or three in unison with each other so there's no double ups. Hopefully this will break up any clusters of losses. I'm not a mathematician and maybe this will have no affect?
Thanks in advance,
RP