Hi all,
I am trying to work out how to automate a simple process but I am finding it very hard.
All I want to do is lay the fav if it hits £5 more than its SP in play.
Can this be done in automation?
If so could someone please explain how to do it.
Its doing my head in as I want to automate my trading but am wasting day after day trying to get it right to no avail...
Thanks in advance.
Lay fav £5 above SP
-
JollyGreen
- Posts: 2047
- Joined: Sat Mar 21, 2009 10:06 am
Hi
I am slightly confused by what you mean "lay favourite at £5 above SP", is this profit?
If you tell me what you're trying to do I can try to help.
JG
I am slightly confused by what you mean "lay favourite at £5 above SP", is this profit?
If you tell me what you're trying to do I can try to help.
JG
-
NeilSpence
- Posts: 78
- Joined: Sun Nov 17, 2013 11:58 am
Jolly,
Just the man I need....
If a fav is trading at say 3.00 at the off, I want to lay it when it hits 8.00 in play. If it is 2.00, then it would be 7.00. I appreciate it is drifting and the price could be rising fast so would like the market entry price to be 10.00 so it gets matched a high proportion of the time.
The exact numbers are not as important as the automation process as I can adjust the numbers on different races etc. I can't use the "tick" option as it would be always different depending which band it is in. i.e 2.00/4.00
Does that make sense?
All the videos I have seen using the drifter/steamer bot lay/back it before the off and green up in play.
I want my bets to occur in play only.
I have used racing traders software before and they have a simple stop entry tool which allows me to be the exact thing but its al manually done and I cant get rid of my gremlins so automation it needs to be.
Hope you can help.
Just the man I need....
If a fav is trading at say 3.00 at the off, I want to lay it when it hits 8.00 in play. If it is 2.00, then it would be 7.00. I appreciate it is drifting and the price could be rising fast so would like the market entry price to be 10.00 so it gets matched a high proportion of the time.
The exact numbers are not as important as the automation process as I can adjust the numbers on different races etc. I can't use the "tick" option as it would be always different depending which band it is in. i.e 2.00/4.00
Does that make sense?
All the videos I have seen using the drifter/steamer bot lay/back it before the off and green up in play.
I want my bets to occur in play only.
I have used racing traders software before and they have a simple stop entry tool which allows me to be the exact thing but its al manually done and I cant get rid of my gremlins so automation it needs to be.
Hope you can help.
-
NeilSpence
- Posts: 78
- Joined: Sun Nov 17, 2013 11:58 am
It might be easy for some... but I don't know the first thing about how to do that. Would you have a spreadsheet I could pinch which has the process on it?
-
Dublin_Flyer
- Posts: 842
- Joined: Sat Feb 11, 2012 10:39 am
If you settle for the price at the off instead of the exact SP, you can automate it fairly easily.
I made a quick attempt using pretty broad ranges, if the price at off time is between 2-2.98 it will lay at 7 so you will be 4.02-5 points higher, if price at off is 3-3.95 it lays at 8 so 4.05-5 points higher etc.
If you want to be exact, you could set up a rule for each increment, but there's 200 price increments from 1.01 up to 8, so put the kettle on, it might take a while! Alternatively you could reduce the ranges like 3-3.30 at off, lay at 8.2, 3.35-3.60 at off, lay at 8.4, 3.65-3.95 at off, lay at 8.6, so you find a happy medium very close to your 5 points distance target.
If you're not familiar with the automation on BF then pay particular attention to the other conditions rules, I included a Matched bets on selection = 0 condition so hopefully only 1 bet will trigger. I've had experience before of accidentally using overlapping price bands where 2+ bets triggered and it doesn't take long to ruin your day!
Looking at numbers, 33.7% of BF favs have won since 2010, so you can expect 66.3% of bets to go in your favour as the losing fav hits your price, and hope only a fraction of the winning favs are come from behind Wichita Lineman types!
Have a fiddle around and see what you think, all going well you could expand on it to include safety options. A 60 tick offset with greening on your bet or something like that. So if your horse is battling it out for 2nd but 20 lengths behind the leader who falls at the last, then you're covered if your horse comes out as winner because after laying it at 7, you backed at 70. Winnings are slightly reduced but in the races where your horse comes out of nowhere to win, your losses are vastly reduced.
EDIT: If anyone spots faults, please make them known. Constructive criticism is better than been known as that c*nt who lost me a packet!
I made a quick attempt using pretty broad ranges, if the price at off time is between 2-2.98 it will lay at 7 so you will be 4.02-5 points higher, if price at off is 3-3.95 it lays at 8 so 4.05-5 points higher etc.
If you want to be exact, you could set up a rule for each increment, but there's 200 price increments from 1.01 up to 8, so put the kettle on, it might take a while! Alternatively you could reduce the ranges like 3-3.30 at off, lay at 8.2, 3.35-3.60 at off, lay at 8.4, 3.65-3.95 at off, lay at 8.6, so you find a happy medium very close to your 5 points distance target.
If you're not familiar with the automation on BF then pay particular attention to the other conditions rules, I included a Matched bets on selection = 0 condition so hopefully only 1 bet will trigger. I've had experience before of accidentally using overlapping price bands where 2+ bets triggered and it doesn't take long to ruin your day!
Looking at numbers, 33.7% of BF favs have won since 2010, so you can expect 66.3% of bets to go in your favour as the losing fav hits your price, and hope only a fraction of the winning favs are come from behind Wichita Lineman types!
Have a fiddle around and see what you think, all going well you could expand on it to include safety options. A 60 tick offset with greening on your bet or something like that. So if your horse is battling it out for 2nd but 20 lengths behind the leader who falls at the last, then you're covered if your horse comes out as winner because after laying it at 7, you backed at 70. Winnings are slightly reduced but in the races where your horse comes out of nowhere to win, your losses are vastly reduced.
EDIT: If anyone spots faults, please make them known. Constructive criticism is better than been known as that c*nt who lost me a packet!
You do not have the required permissions to view the files attached to this post.
I wanna do something similar however I want to know the price which is a set% +/- the current price.
For example,
-15% increase on 2.00 fav = 1.54
-15% decrease on 2.0 fav = 2.86
i have a table with all tick sizes and prices in sheet.
any help would be appreciated
For example,
-15% increase on 2.00 fav = 1.54
-15% decrease on 2.0 fav = 2.86
i have a table with all tick sizes and prices in sheet.
any help would be appreciated
You do not have the required permissions to view the files attached to this post.
-
NeilSpence
- Posts: 78
- Joined: Sun Nov 17, 2013 11:58 am
Dublin Flayer,
That should be close to what I am looking for and increment prices should be close enough to work out whether its close to working, over time I can alter it. Will have a good look a bit later .
Thanks very much
That should be close to what I am looking for and increment prices should be close enough to work out whether its close to working, over time I can alter it. Will have a good look a bit later .
Thanks very much
I could knock one up if you were happy to wait a couple of days. Have you used spreadsheets at all with Bet Angel?NeilSpence wrote:It might be easy for some... but I don't know the first thing about how to do that. Would you have a spreadsheet I could pinch which has the process on it?
Neil,
If you're going to be doing this seriously, you need to learn how to use Excel.
A lot of traders would be able to knock that up in ten mins, but imo that's not really helping you.
They say necessity os the mother of all invention and the same is true here.
I just about knew how to add two cells together when I started on here but very proficient now.
I would recommend doing some training on it (try Udemy.com) for an excel course. Its a fantastic site and the training is superb. (I'm learning C# at the moment via Udemy with a view to creating my own direct access to the API).
The other reason I say learn it yourself is because it can be extremely powerful (and potentially dangerous) and will not hesitate to submit hundreds of bets if that is what it is told to do. You should be able to see what the excel sheet is doing and be in total control of it.
Regards
Peter
If you're going to be doing this seriously, you need to learn how to use Excel.
A lot of traders would be able to knock that up in ten mins, but imo that's not really helping you.
They say necessity os the mother of all invention and the same is true here.
I just about knew how to add two cells together when I started on here but very proficient now.
I would recommend doing some training on it (try Udemy.com) for an excel course. Its a fantastic site and the training is superb. (I'm learning C# at the moment via Udemy with a view to creating my own direct access to the API).
The other reason I say learn it yourself is because it can be extremely powerful (and potentially dangerous) and will not hesitate to submit hundreds of bets if that is what it is told to do. You should be able to see what the excel sheet is doing and be in total control of it.
Regards
Peter
-
NeilSpence
- Posts: 78
- Joined: Sun Nov 17, 2013 11:58 am
Peter,
I know how basic formulas in spreadsheets work but not how they link in with Betangel.
I suppose the teach a man to fish method needs to come into play. I will read up more on the excel side of things. If you say it is easy then I need to learn the things to make it easy.
On the basis I understand how spreadsheets work, what do you suggest I read/learn how to incorporate what I need into Betangel?
I know how basic formulas in spreadsheets work but not how they link in with Betangel.
I suppose the teach a man to fish method needs to come into play. I will read up more on the excel side of things. If you say it is easy then I need to learn the things to make it easy.
On the basis I understand how spreadsheets work, what do you suggest I read/learn how to incorporate what I need into Betangel?
Neil,
Take a look at the Betangel user guide; there is a whole section on Excel integration. Strong advice would be to use the Practice mode first (ie log into Betangel in Practice mode) then connect your sheets as normal.
There are two ways to connect your excel sheet; either via guardian (ie multiple sheets) and the way I tend to use them is connecting via the main Excel Tab located on the One click screen.
Regards
Peter
Take a look at the Betangel user guide; there is a whole section on Excel integration. Strong advice would be to use the Practice mode first (ie log into Betangel in Practice mode) then connect your sheets as normal.
There are two ways to connect your excel sheet; either via guardian (ie multiple sheets) and the way I tend to use them is connecting via the main Excel Tab located on the One click screen.
Regards
Peter