by jokerjoe » Wed Aug 25, 2010 1:54 pm
Any problem you need break down into steps, just think what you do manually.
1. Check if current odds in range.
2. Check if full stake matched yet (might have to use the bets sheet if betting multiple selections).
3. Place bet - stake as a proportion of the money currently available, odds at back/lay/in between depending how aggressive you want to be.
4. Periodically check if at favourable position (ie at back/lay, not further behind). If not cancel bets and repeat.
I'd use VBA to check condition and clear bets. Could also use kill or fill orders, though not if at limit of odds range. Might be doable purely in Excel but never done it that way myself.