Manually triggered bet from excel

[Rinconpaul]

I have an excel sheet with an xml feed. By manually triggering the sheet it takes AUS tote prices, applies criteria and applies a conditional coloured format to the selections in the desired race. Timing is of the utmost importance with this method, as being as close to the jump as possible ensures the prices are as close to tote SP as possible. The whole system is built around tote SP.

Once the selections are identified, the time to select the names on Betfair and enter liability, then place SP bet, kills the method as they've jumped by then. Can Gruss identify the formatted selections on excel and immediately place SP bets on the exchange for a pre determined liability, as they're all Lay bets?

[Captain Sensible]

If you've managed to code a sheet to apply conditional formatting to cells I'm not sure why you haven't coded it to just simply apply a LAY trigger instead.

Gruss links fine to excel and can do all the SP bets to a liability simply enough, I think you're only sticking point maybe ensuring the tote and betfair names match but even that's usually no problem with a bit of parsing the data. Have a look at the sheets in the excel examples section as there's a few that show how to use vlookup which is basically all you'd be doing instead of formatting a cell

[doncht]

Hi Rinconpaul, just curios if you were able to apply a LAY trigger already. Can you show also on how you did it?

[Rinconpaul]

Hi Rinconpaul, just curios if you were able to apply a LAY trigger already. Can you show also on how you did it?

There are a few issues, namely the tote I take the xml feed from displays horses names in saddlecloth numbers down the page and any scratchings remain. Betfair remove those and put them at the bottom of the list. Also a horse called "Sunday's Paper" is displayed as "Sundays Paper" on Betfair, no apostrophes. Then you have Late scratchings to deal with.

I'm advised, that it can be done, for a price! I found that the problem was the methodology. You can capture tote prices a couple of seconds out from the Close and act upon them, but AT the CLOSE prices still change, markedly at times, often turning a selection into a non selection or vice versa. An instance was a horse at $101 on the tote 2 secs out from the close, dropped to $51 after the Close and went on to win. How can you beat that?

[Captain Sensible]

The saddlecloth numbers can be exported to excel along with horses names so if the xml feed also contains those it should be easy to match the two and that would clear your problems with apostrophes also. Otherwise just use a little vba to find and replace them.

As for the methodology and late scratches the problems is if things only turn a profit when things are going to plan they'll rarely turn a profit on Betfair when botting them for real But plenty of time things will level out in the long run with missed selections losing or selections that shouldn't be sneaking in to win.