Hi guys,
I'm fairly new to all this automation but really need it set up to make my life easier.
I have an excel spreadsheet with my data/values etc and I have 2 columns next to each other, one is for the price of the football game market and the other is then telling me if the trade is yes/no based on my formulas.
So what I need to is to pull the betfair prices into my first column at a certain time before kick off, the formula will then tell me automatically if its a trade or not, so the next step is I need the sheet to automatically place the bet on betfair, if it does qualify, is this possible?
Hope it makes sense as I've explained it
Betfair prices into excel and place bet
-
CallumPerry
- Posts: 575
- Joined: Wed Apr 19, 2017 5:12 pm
Hi CunningStunts (Great username),
Yes it should all be possible, firstly may I ask what your experience of excel is? How advanced would you say you are, have you created any sort of bot using workbooks before and are you familiar/savvy with VBA?
The way I see it, you would have a Boolean column so each runner has a True/False trigger. So you just need this trigger, a time trigger, perhaps a total volume trigger to make sure you entering liquid markets and are you letting bets run?
A little more detail would help. I'm assuming this would be an automatic, multi-market use workbook so you'd need a way fo reloading each market for one. Are you making a single bet for each runner in each market or a single trade (1x Back followed by 1x Lay or vice versa), are you greening and any other info you think would be useful.
There is a way you can send values in Excel to automation too apparently so if you're more familiar with the automation rules, you could just learn how to send these values from Excel and do the rest with what you're already comfortable with. That's just me assuming more people come from automation to Excel.
Yes it should all be possible, firstly may I ask what your experience of excel is? How advanced would you say you are, have you created any sort of bot using workbooks before and are you familiar/savvy with VBA?
The way I see it, you would have a Boolean column so each runner has a True/False trigger. So you just need this trigger, a time trigger, perhaps a total volume trigger to make sure you entering liquid markets and are you letting bets run?
A little more detail would help. I'm assuming this would be an automatic, multi-market use workbook so you'd need a way fo reloading each market for one. Are you making a single bet for each runner in each market or a single trade (1x Back followed by 1x Lay or vice versa), are you greening and any other info you think would be useful.
There is a way you can send values in Excel to automation too apparently so if you're more familiar with the automation rules, you could just learn how to send these values from Excel and do the rest with what you're already comfortable with. That's just me assuming more people come from automation to Excel.
-
CunningStunts
- Posts: 16
- Joined: Fri Dec 27, 2019 8:11 pm
Haha thanks and thanks for the reply too.
Ok, so my experience with excel isn't fantastic, I know how to create macro's but that's about as advanced as I would say I am. I got help from a friend in building my value formulas.
I just wanted to clarify, all my trading is in football markets, not horse racing as you mentioned runners. Guessing that shouldn't change anything? It's still possible?
I will try and give as much detail as possible for you. First, I have attached one of excel sheets from Tuesday evening for the Championship. If you open it up, you will see that column BR has the prices of the first half goal market for each match, I put these prices in manually but I'm looking for a way to extract them automatically and populate them into the same cell exactly 5 minutes before kickoff, that part would be important, for example, if the clock was 14:54:59, then as it soon ticks over to 14:55:00, is price I would need. This price is also the back price for Over 0.5 goals in the first half goal market, so that would be the first step.
Second would be related to column BR, my formula either comes up blank which means it is a trade or it says no trade which is obvious
so, I'm then looking for a way to automatically place the bet on betfair for all columns that show up as blank on the sheet and the bet would be to Lay the Under 0.5 goals in the first half goal market and to ignore the no trade columns.
Hope this helps to clear up what I need and where to hopefully start this process.
Thanks for taking the time
Ok, so my experience with excel isn't fantastic, I know how to create macro's but that's about as advanced as I would say I am. I got help from a friend in building my value formulas.
I just wanted to clarify, all my trading is in football markets, not horse racing as you mentioned runners. Guessing that shouldn't change anything? It's still possible?
I will try and give as much detail as possible for you. First, I have attached one of excel sheets from Tuesday evening for the Championship. If you open it up, you will see that column BR has the prices of the first half goal market for each match, I put these prices in manually but I'm looking for a way to extract them automatically and populate them into the same cell exactly 5 minutes before kickoff, that part would be important, for example, if the clock was 14:54:59, then as it soon ticks over to 14:55:00, is price I would need. This price is also the back price for Over 0.5 goals in the first half goal market, so that would be the first step.
Second would be related to column BR, my formula either comes up blank which means it is a trade or it says no trade which is obvious
so, I'm then looking for a way to automatically place the bet on betfair for all columns that show up as blank on the sheet and the bet would be to Lay the Under 0.5 goals in the first half goal market and to ignore the no trade columns. Hope this helps to clear up what I need and where to hopefully start this process.
Thanks for taking the time
You do not have the required permissions to view the files attached to this post.
-
CallumPerry
- Posts: 575
- Joined: Wed Apr 19, 2017 5:12 pm
Ok, I have just opened this up - looks like there's quite a bit going on here. I'll be able to have a proper look at it tomorrow - 3 other people have downloaded it too so perhaps they'll beat me - but basically column BR contains trigger cells and it should trigger 5 minutes before?
To make things easier before I get chance to have a look tomorrow, maybe download the template workbook from Bet Angel's main website, there's a download tab I think (been ages since I last went there) and it's there for free. Download it, see how far you can get yourself and familiarise yourself with it as that'll help you out loads!
To make things easier before I get chance to have a look tomorrow, maybe download the template workbook from Bet Angel's main website, there's a download tab I think (been ages since I last went there) and it's there for free. Download it, see how far you can get yourself and familiarise yourself with it as that'll help you out loads!
-
CunningStunts
- Posts: 16
- Joined: Fri Dec 27, 2019 8:11 pm
Sorry for the late reply, busy weekend manually trading which is why I need this automation set up
I took your advice and had a look at the template workbook, gonna take me a while to get my head around it to fit my sheets, any chance yourself or anybody else that downloaded my sheet knows how to help me out please?
I took your advice and had a look at the template workbook, gonna take me a while to get my head around it to fit my sheets, any chance yourself or anybody else that downloaded my sheet knows how to help me out please?
-
CunningStunts
- Posts: 16
- Joined: Fri Dec 27, 2019 8:11 pm
Bump
Maybe we can break this down into steps first, so first off, can anybody please tell me how to extract betfair prices into excel?
My formula sheet is above if anybody needs to take a look, I'm looking to extract the betfair prices of the first half goal market (back over 0.5 goals) into column BR on my sheet.
Many thanks to anybody that can help me with this
Maybe we can break this down into steps first, so first off, can anybody please tell me how to extract betfair prices into excel?
My formula sheet is above if anybody needs to take a look, I'm looking to extract the betfair prices of the first half goal market (back over 0.5 goals) into column BR on my sheet.
Many thanks to anybody that can help me with this
-
CallumPerry
- Posts: 575
- Joined: Wed Apr 19, 2017 5:12 pm
Had a busy few days, just seen this thread is still in my 'New Posts' area so thought I'd ask, have you figured out how to get the prices into the sheet yet and started piecing your system together?
-
CunningStunts
- Posts: 16
- Joined: Fri Dec 27, 2019 8:11 pm
Apologies on my late reply, been crazy busy. I'm still struggling to be honestCallumPerry wrote: ↑Thu Feb 06, 2020 9:26 amHad a busy few days, just seen this thread is still in my 'New Posts' area so thought I'd ask, have you figured out how to get the prices into the sheet yet and started piecing your system together?
I really can't figure it out, how to get the betfair prices pasted into cell BR, any advice?
-
CallumPerry
- Posts: 575
- Joined: Wed Apr 19, 2017 5:12 pm
Create a three-dimensional array and then read the values from here, that's one of the first things I would research if you're not at that stage with macros. How to define, write to and read from a three-dimensional array.
Until then, your code would be a bit messy but just reference each important cell individually and say what it is i.e. Cell L9 = CommandR1 then later you can say CommandR1 = "BACK". Surround this in an if statement and your system quickly gets a but more sophisticated.
If you're just using formulae on the sheet however, I would just make some cell in column BR = whatever value you need it to be and then start building your formulae from this single area here. I think what you need to do first is get some pen and paper out and really detail your logic to make this happen.
Until then, your code would be a bit messy but just reference each important cell individually and say what it is i.e. Cell L9 = CommandR1 then later you can say CommandR1 = "BACK". Surround this in an if statement and your system quickly gets a but more sophisticated.
If you're just using formulae on the sheet however, I would just make some cell in column BR = whatever value you need it to be and then start building your formulae from this single area here. I think what you need to do first is get some pen and paper out and really detail your logic to make this happen.