Hi Everyone,
I have a betting idea that I would like to somehow automate from an excel sheet if at all possible. I have a list of horses in a given race, let’s say 4 horses and the minimum price I am prepared to take for each horse to bet on it, I would like to BA to compare the price of each horse 1 min before off and if it’s greater than my price in excel then a back bet should be fired into the market for that particular horse. Hopefully that makes sense!
Is this at all possible to do and if so Can anyone suggest where I might find some ideas about how to set this up?
Thanks Nick
Help needed
-
CallumPerry
- Posts: 575
- Joined: Wed Apr 19, 2017 5:12 pm
Hi Nick.
Yes absolutely possible! Would you have a list of horse names (and prices) for the whole day ready each morning before you opened and connected this future spreadsheet? How many races are you planning on betting in per day, approximately? Are you flat staking with a fixed amount on each horse?
Cal
Yes absolutely possible! Would you have a list of horse names (and prices) for the whole day ready each morning before you opened and connected this future spreadsheet? How many races are you planning on betting in per day, approximately? Are you flat staking with a fixed amount on each horse?
Cal
Hi Cal,
Thanks for replying so quick!
Yes I would have a spreadsheet with all the days UK races in it with all the runners listed and the prices I’m looking for. Regarding the number of races all except maidens, novice etc and yes it would be a fixed stake on each horse to begin with in the testing phase.
As mentioned I’m looking at backing the horse when the BFSP is greater than my tissue price.
Thanks again for your reply!
Thanks for replying so quick!
Yes I would have a spreadsheet with all the days UK races in it with all the runners listed and the prices I’m looking for. Regarding the number of races all except maidens, novice etc and yes it would be a fixed stake on each horse to begin with in the testing phase.
As mentioned I’m looking at backing the horse when the BFSP is greater than my tissue price.
Thanks again for your reply!
-
CallumPerry
- Posts: 575
- Joined: Wed Apr 19, 2017 5:12 pm
Ok so version 1 of your workbook I imagine would be a variation of the multiple market template BA supplies with approx 30 sheets and 1 input sheet.
This one input sheet should have three columns: Market Start Time, Horse Name and Price.
Then you would just need some formulae that looks at the input sheet to see if the current market is one with the same start time as on your input sheet. Then it would lookup the horses' name and then an 'if' statement to check the price is within your range and if all of these conditions are met, it would make a fixed stake bet in the market.
Have a go at starting a workbook and when you get stuck, post it on here (or PM me), for testing you can just make up some random horse names and price values for your input sheet.
This one input sheet should have three columns: Market Start Time, Horse Name and Price.
Then you would just need some formulae that looks at the input sheet to see if the current market is one with the same start time as on your input sheet. Then it would lookup the horses' name and then an 'if' statement to check the price is within your range and if all of these conditions are met, it would make a fixed stake bet in the market.
Have a go at starting a workbook and when you get stuck, post it on here (or PM me), for testing you can just make up some random horse names and price values for your input sheet.
Hi Cal,
So I have my workbook loaded up with the markets via Guardian and also on a separate sheet within the workbook, the listing of race time, horse name and tissue price.
What I want excel to do is cross reference my list of minimum BSP prices with the market price at the off and if the price is available then a bet should be placed. What may present difficulty’s is that I only want excel to look at the top 5 horses in my list.
I’m an excel novice so I really have no clue about how to set this up, but I’ve being watching some you tube videos and I think I need to maybe start off with the VLOOKUP command to cross reference lists, or is an IF command I would have to use? Maybe this project is a bit to much for a novice like me but maybe you or someone else can point me in the right direction to get things going?
Thanks again for any suggestions on offer!
So I have my workbook loaded up with the markets via Guardian and also on a separate sheet within the workbook, the listing of race time, horse name and tissue price.
What I want excel to do is cross reference my list of minimum BSP prices with the market price at the off and if the price is available then a bet should be placed. What may present difficulty’s is that I only want excel to look at the top 5 horses in my list.
I’m an excel novice so I really have no clue about how to set this up, but I’ve being watching some you tube videos and I think I need to maybe start off with the VLOOKUP command to cross reference lists, or is an IF command I would have to use? Maybe this project is a bit to much for a novice like me but maybe you or someone else can point me in the right direction to get things going?
Thanks again for any suggestions on offer!
-
CallumPerry
- Posts: 575
- Joined: Wed Apr 19, 2017 5:12 pm
Should be able to do it with simple IFs I'd have thought.
IF ([lookup horse name and offset to the back price cell] > [Price I'm willing to take from separate sheet], "BACK","Standby")
You may (will) need to add layers of complexity on top of this, for example, a time trigger. Because you're using BSP, I assume you're going to want this to trigger pretty much as instant as you can once the BSP cells on the worksheet fill and then let this go in-play?
Some more things to think about:
When a bet gets triggered do you let it run as a standard bet or are you looking to trade out, if so when? What's your ideal exit point and what's your 'Shit, I need to get out' exit point?
What about when your first bet only gets partially matched?
When you say the top 5 runners do you mean the top 5 as they appear on the sheet or top 5 in rank order so favourite first followed by the runner with the second lowest odds and then the third...?
IF ([lookup horse name and offset to the back price cell] > [Price I'm willing to take from separate sheet], "BACK","Standby")
You may (will) need to add layers of complexity on top of this, for example, a time trigger. Because you're using BSP, I assume you're going to want this to trigger pretty much as instant as you can once the BSP cells on the worksheet fill and then let this go in-play?
Some more things to think about:
When a bet gets triggered do you let it run as a standard bet or are you looking to trade out, if so when? What's your ideal exit point and what's your 'Shit, I need to get out' exit point?
What about when your first bet only gets partially matched?
When you say the top 5 runners do you mean the top 5 as they appear on the sheet or top 5 in rank order so favourite first followed by the runner with the second lowest odds and then the third...?
-
karltrades
- Posts: 13
- Joined: Wed Jan 01, 2020 9:55 pm
I'm glad I happened upon this thread, because I'm also looking to do something similar here. Initially, I was thinking I'd have to copy and paste in each horse's tissue price and then write an IF statement to back if the BSP was => than the tissue, on EVERY market. So am I to understand that I can have a list of horses and tissue prices on a separate sheet within the Workbook, and a standard rule on the BetAngel market sheet that cross-references current price against my tissue, and fires in a bet? If so and anyone could help me to write one, I would be very grateful! I would be looking to:
Have a list of horses and min BSP that I will bet on.
Bet on any selection that is greater than my tissue price, but less than a set amount.
Back to a fixed stake.
Back at BSP, or as close to it as I can get, attempting to get a bet matched up to ten seconds after market suspension.
No trade outs - I want to let them run.
Many thanks!
Have a list of horses and min BSP that I will bet on.
Bet on any selection that is greater than my tissue price, but less than a set amount.
Back to a fixed stake.
Back at BSP, or as close to it as I can get, attempting to get a bet matched up to ten seconds after market suspension.
No trade outs - I want to let them run.
Many thanks!