Backing if a horse hits a certain low price in-running

[Hill16]

Hi folks,
Not sure if this is easy to do or not so it may be in the wrong part of the forum. But I just thought I'd ask...
Anyone know if there is a way to set up a spreadsheet to back horses - but only if they hit a certain low price in running? Not saying this is profitable by the way, but I just want to get some data on something.

For example, let's say you wanted to back a horse but only if it dropped below 1.5. Is this possible? I know there's a risk of the price running away from you so ideally, I'd like the bet fired in at 1.4 and hopefully get matched somewhere in between 1.4 and 1.5. Is this possible? The prices are just examples and I presume they are not profitable but I just want to test a few things. There are a few other things to consider but overall, I suppose I'm looking to:

* Back a horse if it hits X price in-running (e.g. 1.5).
* Fire in the bet a few ticks lower at X price to help get matched (e.g. 1.4).
* Ignore the market if there is a horse priced 1.5 or lower pre-race.
* Bets on multiple horses per race should be allowed (so backing a 2nd or 3rd horse if it hits 1.5 in running is fine).
* But no more than one bet per horse (so I don't want the same selection backed multiple times if it hits 1.5 a few times).

Any idea if this is simple or not? ! Thanks,

Wayne

[jc0r]

Hi

Below is a link for a simple Excel sheet i have created for you that should do as you wish

https://drive.google.com/file/d/0B_1J8B9mLp7Jd2FIRVJfTEZRSWM/view?usp=sharing

There are some things to note in order for this to work. When you log to Excel, you will want the SP tick box checked in the additional colums bit on the right. This should put Betfair SP in column Y in Excel. You will also need "Enabled Trigger Betting" ticked, along with "Clear Bet refs" down the bottom section. Basically, make it look like the picture below.

I have created you a trigger price in cell S1. This is the price you are looking for a selection to go below before backing. Cell U1 is the price at which you would like to back a horse at if the horse goes below your trigger and cell W1 is the stake you wish to use.

I haven't got a race i can test this on but it should work as you wish.

Disclaimer: Im hungover, hopefully there arent any errors, but i will not be held responsible if things don't go ya way!

[Hill16]

jc0r, I'm highly impressed that you would take time out to come up with this and help out a fellow trader. That's fantastic, I'll try it out tomorrow. Really appreciate your help. Kind regards,

Wayne