Hi 6th Sense,
Don't know if you are still seeing this thread. After a day of testing unfortunately your recommendation does not work and here is why :
If you remember i am laying all at x with offset and greening. When 1st bet is matched i want to cancel all remaining lays and keep the offset back bet. The automation function does not allow this as it also cancels the back bet.
You suggested ( and kindly sent me a rule file ) to not offset but cancel first THEN green. This does not work for this reason :
At the price i am laying at initially the market is extremely volatile and jumps up and down very rapidly so in your rule file the lay bet is activated , all remaining lays are cancelled and the back bet DOES NOT get fired inot the market until the required green level is achieved at which point it then fires which takes a second or two. This is no good as the market moves too quick and often it gets to my price then moves away before the back bet hits the market. With offset the opposing back bet is already in the market waiting to be filled and does get filled as soon as the market hits that price INSTEAD of firing when it gets to that price which takes a second or two which is too long.
I hope that makes sense. Anyway , i have investigated spreadsheets and see that an available command is cancel_all_lay. This seems to be the exact command that will give me what i want. Unfortunately , although i am very familiar with excel , strings of formula is not my forte and i'm really struggling with the IF ,AND , OR bits , i'm just either to stupid or not experienced enough to write the required formula to get it working.
Is there anyway you can help ?
To remind this is basically what i need :
lay all @ "x" with offset and greening
Cancel all lay when green value of any runner is less than or greater zero ( ie after one bet has been matched )
Leave the offset back bet in place which should happen if only all remaining lay bets are cancelled.
Any help you can provide would be hugely appreciated
Lay All - Horses
There is a delay in running. There is no getting around this. So if the process of triggering a green is not working then perhaps another method is required. I can probably spend another couple of hours trying to figure out how to do this but it would be preferable if you could do this yourself. But I would look at placing a back bet against each selection as soon as the unmatched LAY bets have been cancelled. Or maybe use offsetting again with a long fill/kill since the bets are being placed in the in-play phase anyway.
RegL - Welcome to the forum. The greening does not fire off at 'Random'. And there is no glitch in Bet Angel. It is set to trigger when the overall position is profitable. If it never reaches a profitable position then it will not fire. Also, as TheNuts has pointed out, the markets are volatile so even if a greening bet IS triggered, it is likely the market will move again before the bet is matched.
Please go through the automation file and try to understand what it is doing and how it works. Use practice mode so you do not risk money. Tweak it and adjust it. Start over again if necessary. Try it out. Test it. Then test it again.
Have a go at creating your own and I'm sure you'll get there.
RegL - Welcome to the forum. The greening does not fire off at 'Random'. And there is no glitch in Bet Angel. It is set to trigger when the overall position is profitable. If it never reaches a profitable position then it will not fire. Also, as TheNuts has pointed out, the markets are volatile so even if a greening bet IS triggered, it is likely the market will move again before the bet is matched.
Please go through the automation file and try to understand what it is doing and how it works. Use practice mode so you do not risk money. Tweak it and adjust it. Start over again if necessary. Try it out. Test it. Then test it again.
Have a go at creating your own and I'm sure you'll get there.
Thanks for the reply 6th Sense. I don't think i am able to get across via written text what my point is.
Maybe this is ridiculous , but would i be able to buy an hour of your time ?
It would probably take me 10 mins to explain and then 15 mins to write the query in the spreadsheet and i also need some face to face training on the spreadsheet side of things as well.
I'm guessing you are an expert on this side of things so do you offer any kind of face to face training ( chargeable of course ) ?
If not do you know anyone that does ?
Maybe this is ridiculous , but would i be able to buy an hour of your time ?
It would probably take me 10 mins to explain and then 15 mins to write the query in the spreadsheet and i also need some face to face training on the spreadsheet side of things as well.
I'm guessing you are an expert on this side of things so do you offer any kind of face to face training ( chargeable of course ) ?
If not do you know anyone that does ?
i'm not as stupid as i thought i was. I managed to get it to work in a spreadsheet. The formula is :
=IF(OR(D14>0,D14<0),"CANCEL_ALL_LAY","")
D = The green value cell
So with one click i stick a lay all bet into the market with offset and greening. This formula then ensures that as soon as one bet is matched the offset back bet goes in and instantly all the remaining lay bets are cancelled without my offset back bet being cancelled.
I know im talking to myself
but i don't care.
Thanks for the push in the right direction 6th Sense.
I would be interested to know ( re my previous post ) if you do offer any kind of face to face training.
=IF(OR(D14>0,D14<0),"CANCEL_ALL_LAY","")
D = The green value cell
So with one click i stick a lay all bet into the market with offset and greening. This formula then ensures that as soon as one bet is matched the offset back bet goes in and instantly all the remaining lay bets are cancelled without my offset back bet being cancelled.
I know im talking to myself
but i don't care. Thanks for the push in the right direction 6th Sense.
I would be interested to know ( re my previous post ) if you do offer any kind of face to face training.
Very long story short - after more than 1500 races i had a 0.2% edge at low stakes ( cumulative profit as % of cumulative staked ).
I could not be sure of getting matched at high stakes so stopped at that point as it did not seem viable.
However it has been a very important learning curve and opened up other thought provoking ideas.
If it was easy everyone would do it
I'm still here and still trying !
I could not be sure of getting matched at high stakes so stopped at that point as it did not seem viable.
However it has been a very important learning curve and opened up other thought provoking ideas.
If it was easy everyone would do it
I'm still here and still trying !