Hi guys
Know very little but enough excel to get by. Trying to get the multiple excel sheets to place a back bet on horses 10 seconds before off..
What function do I need to use to get that done?
Thanks in advance
Mark
Excel Help
Hi Mark,
Not sure if this is what you mean, but...
If you want to control actions entirely inside Excel (no BA automation), then you have three choices. You can change values in the sheets with cell Formulas, use VBA or a combination of both.
The cells you need to change to make a trade are in Column L (the command. e.g. LAY or BACK etc.), Column M (the odds to use) and Column N (the stake).
The slightly more complex task is to work out the criteria that will make an action happen, and also to stop it happening repeatedly (unless that's what you want).
Also, and most importantly for your question, BetAngel doesn't have any concept of '10 seconds before the off'. BetAngel knows what time the race is due to start and how many minutes/seconds there are until that time. But it can have no idea of when the actual race will start. So, what you can do is check cell F4 for when the value is '00:00:10' (or, say, between 00:00:11 and 00:00:09) then do your stuff (BACK, LAY, etc.).
You can have multiple conditions. So, the formula in L9 (for the first horse) might look for the time before the race starts and to see if the odds are in a certain range before putting the word 'BACK' or 'LAY' into the cell.
You can have other formulas in the Odds and Stake columns to change those values according to your own rules/strategy.
What I've described is the equivalent of the CEO of Ford saying to a car designer "I want a car with 4 wheels and an engine". It's a starting point, but there is so much more you need to think about.
Hope that helps - and if you've got more specific questions then ask.
There are also lots of people on here doing clever stuff with Excel and some really great spreadsheets that show just what can be done. Take some time to read through the Excel part of this forum.
BA and Excel can do pretty much anything. If you can come up with an idea, then it can almost certainly be coded.
I think that most systems start with Formulas and then move on to use VBA as well, as the programming language gives more flexibility for complex decision making.
Ian
Not sure if this is what you mean, but...
If you want to control actions entirely inside Excel (no BA automation), then you have three choices. You can change values in the sheets with cell Formulas, use VBA or a combination of both.
The cells you need to change to make a trade are in Column L (the command. e.g. LAY or BACK etc.), Column M (the odds to use) and Column N (the stake).
The slightly more complex task is to work out the criteria that will make an action happen, and also to stop it happening repeatedly (unless that's what you want).
Also, and most importantly for your question, BetAngel doesn't have any concept of '10 seconds before the off'. BetAngel knows what time the race is due to start and how many minutes/seconds there are until that time. But it can have no idea of when the actual race will start. So, what you can do is check cell F4 for when the value is '00:00:10' (or, say, between 00:00:11 and 00:00:09) then do your stuff (BACK, LAY, etc.).
You can have multiple conditions. So, the formula in L9 (for the first horse) might look for the time before the race starts and to see if the odds are in a certain range before putting the word 'BACK' or 'LAY' into the cell.
You can have other formulas in the Odds and Stake columns to change those values according to your own rules/strategy.
What I've described is the equivalent of the CEO of Ford saying to a car designer "I want a car with 4 wheels and an engine". It's a starting point, but there is so much more you need to think about.
Hope that helps - and if you've got more specific questions then ask.
There are also lots of people on here doing clever stuff with Excel and some really great spreadsheets that show just what can be done. Take some time to read through the Excel part of this forum.
BA and Excel can do pretty much anything. If you can come up with an idea, then it can almost certainly be coded.
I think that most systems start with Formulas and then move on to use VBA as well, as the programming language gives more flexibility for complex decision making.
Ian
Hi guys,
I have only started using BetAngel recently and want to do something similar to Mark, using VBA.
I am just starting with VB so bear with me, what I am trying to accomplish first is a simple lay the draw.
I am using the visualisation spreadsheet fron BA and writing up a 'calculations sheet' to try and get the values I want at certain times. So far I can manage to get excel to trigger a lay bet at the current lay price when the countdown timer cell is greater than 0.
What I am trying to do next is wait 10 mins after kick off before placing the bet by using the in play time cell.
I have tried using the in play timer = start timer + 10 but I am not familiar with the time format in excel. How can I format the data to suit?
Also, how long will the bet need to trigger? Is there a condition I can use to trigger the bet when the inplay timer is within a certain range?
Should it be left on until the bet status becomes 'matched'?
When the bet has been matched should I clear status cell straight away? I have seen a lot of posts on the topic but cant seem to find a definitive process for it.
Has anyone any recomendations on best practice for this task?
Any help on any questions appreciated...
I have only started using BetAngel recently and want to do something similar to Mark, using VBA.
I am just starting with VB so bear with me, what I am trying to accomplish first is a simple lay the draw.
I am using the visualisation spreadsheet fron BA and writing up a 'calculations sheet' to try and get the values I want at certain times. So far I can manage to get excel to trigger a lay bet at the current lay price when the countdown timer cell is greater than 0.
What I am trying to do next is wait 10 mins after kick off before placing the bet by using the in play time cell.
I have tried using the in play timer = start timer + 10 but I am not familiar with the time format in excel. How can I format the data to suit?
Also, how long will the bet need to trigger? Is there a condition I can use to trigger the bet when the inplay timer is within a certain range?
Should it be left on until the bet status becomes 'matched'?
When the bet has been matched should I clear status cell straight away? I have seen a lot of posts on the topic but cant seem to find a definitive process for it.
Has anyone any recomendations on best practice for this task?
Any help on any questions appreciated...