Can anyone help me to write a formula to record SP and make bets if the SP suitable?
This is what I want to do, for each horse in a race that is in-running...
If SP is more than 10 and Back price is less than 3, Back the horse to win.
It sounds simple but I can't figure out how to do it. I think the SP will have to be worked out from the Proj.SP at the off, but I'm not sure.
Help with formula to record SP
You could have a routine that,as soon as the rece shows as suspended, records the back price, which should be somewhere close to the sp. You could do that in two ways, either record the back price at suspend, or record the back price, and stop recording at suspend. I would suggest,if you do it this way, watch the data fro a while and see how close your recorded data comes to sp.
Nic
Nic
Thanks Nic. Do the prices stay visible during market suspension? There are often market suspensions well before the start of the race. How could I be sure to record the Race Start Suspension Back Price?
What does this routine look like? What would I need to type into the Bet Rules cell?
What does this routine look like? What would I need to type into the Bet Rules cell?
I was thinking of it as a VBA routine, possibly in a specific excel sheet for recording sp. You could write it to watch the start countdown, and not take a suspension prior to that. But as I said watch your data for a while before you bet on it, otherwise it can cost you lots of money.
Hi,
I have just done a quick and dirty version of the excel spreadsheet. I have not been able to test it, because I have a version up and running doing my betting. At the very least this should give you some ideas of how to write some of the code. I have put a second sheet in to pull the data from the betangel sheet. I have put the runners in column A, the back prices in column B, and it should be copying B to column C until the race is suspended at the start. As I said I have not been able to test it, I only just wrote it a few minutes ago. Connect it to your Betangel and see how it goes. I have not written anything to do any betting in this, but you should be able to see if your idea would work, or might work.
If you want you can message me privately and we can carry this on from there. You will probably have to learn a fair bit about Excel and VBA to make these things work, it depends whether you want to learn that programming stuff.
Nic
I have just done a quick and dirty version of the excel spreadsheet. I have not been able to test it, because I have a version up and running doing my betting. At the very least this should give you some ideas of how to write some of the code. I have put a second sheet in to pull the data from the betangel sheet. I have put the runners in column A, the back prices in column B, and it should be copying B to column C until the race is suspended at the start. As I said I have not been able to test it, I only just wrote it a few minutes ago. Connect it to your Betangel and see how it goes. I have not written anything to do any betting in this, but you should be able to see if your idea would work, or might work.
If you want you can message me privately and we can carry this on from there. You will probably have to learn a fair bit about Excel and VBA to make these things work, it depends whether you want to learn that programming stuff.
Nic
You do not have the required permissions to view the files attached to this post.
I had a quick look at it this morning and it does still have commands in the bet cells on the betangel sheet from the thing it was before, but as they refer to now non existing sheets it should not cause a problem. It is also an older version of the spreadsheet so you might want to transfer the code etc to a newer version of the spreadsheet. The new ones have more data, things like backs and lays over to the right, I just grabbed an old sheet and cleared out the sheets not needed for this.
Nic
Nic