Hello all,
I am trying to use Excel again as I had abandoned it.
First of all I'd like to just have a list of horses to lay a certain amount of time before the race at the odds available.
From what I've seen the only thing that comes to my mind to do this simple task is to fire up the Multiple spreadsheet with the markets I want and place in each selection the necessary if statements to place the bets.
Two concerns arise:
- If a horse is removed prior to the race, don't rows rearrange. I say this because if I put the code to lay on i.e. row 7 and later horse on row 3 is withdrawn, doesn't my horse on row 7 go up to row 6?
- Isn't there an easier way to just have a list of horses and lay them automatically a certain time before the race?
Thanks for all!
Lay a list of horses
-
JacoboPolavieja
- Posts: 91
- Joined: Thu Sep 10, 2009 6:00 pm
Thanks a lot for helping!Euler wrote:Why not put the race time and horse name in a list with a price. Get Guardian to auto switch markets and do a VLOOKUP on the runner name and trigger a bet that way?
About the VLOOKUP function... my knowledge of Excel is very basic so didn't know about it. I've had a look at it and seems exactly part of what I'm looking for.
About switching the markets automatically, the idea is that I can still use BetAngel for normal trading while the automatic ones are done by Excel "without me knowing". That's why I think I have to have several sheets loaded that monitor those conditions whleI manually trade on other markets. Am I on the right path or is there a simpler way of doing this?
Thanks a lot for all, it's been very helpful.
It should be possible:
http://www.youtube.com/user/betangeltv# ... n2NdKgPtuc
Also, in reply to your earlier question, you could also use the "Match" function, which will return the row number of the horse you are interested in, and will always update itself if any preceding rows are deleted.
Nigel.
http://www.youtube.com/user/betangeltv# ... n2NdKgPtuc
Also, in reply to your earlier question, you could also use the "Match" function, which will return the row number of the horse you are interested in, and will always update itself if any preceding rows are deleted.
Nigel.
-
JacoboPolavieja
- Posts: 91
- Joined: Thu Sep 10, 2009 6:00 pm
Hello both and thanks for helping!
I'm sorry Euler but I don't get what role do various accounts would play here. I'm just binding markets to spreadsheets.
I have the bot already running. What I've finally done is get the BetAngel_Multiple spreadsheet and add a first sheet called "Selections" where I put the horses I want to lay. Then, on each row of each spreadsheet I do a VLOOKUP to see if the horse on that row coincides with any of the "Selections" sheet, in which an depending on other factors I have accounted, it lays it.
It's been running well all evening, but I had to go out for an hour and when I came back there had been two selections that weren't layed (others were in the same time). I don't know exactly what might have happened as it's been only two selections of them all. At first I thought about a naming issue, but re-checking I thnk it was all spelled correctly. As I had to close and restart BetAngel some times I don't know if it may have been that it didn't clear the corresponding cells for placing the bets correctly or what...
I hate this, why do these things always fail when you're not looking at them! I'll try to stay tomorrow till the end and see where the bug might be, although it seems to be one of the hard ones...
Thanks a lot for all the help!
I'm sorry Euler but I don't get what role do various accounts would play here. I'm just binding markets to spreadsheets.
I have the bot already running. What I've finally done is get the BetAngel_Multiple spreadsheet and add a first sheet called "Selections" where I put the horses I want to lay. Then, on each row of each spreadsheet I do a VLOOKUP to see if the horse on that row coincides with any of the "Selections" sheet, in which an depending on other factors I have accounted, it lays it.
It's been running well all evening, but I had to go out for an hour and when I came back there had been two selections that weren't layed (others were in the same time). I don't know exactly what might have happened as it's been only two selections of them all. At first I thought about a naming issue, but re-checking I thnk it was all spelled correctly. As I had to close and restart BetAngel some times I don't know if it may have been that it didn't clear the corresponding cells for placing the bets correctly or what...
I hate this, why do these things always fail when you're not looking at them! I'll try to stay tomorrow till the end and see where the bug might be, although it seems to be one of the hard ones...
Thanks a lot for all the help!
The attached might help a bit.
On the "Summary" sheet, you'll see two buttons, press the "Get Summary" and a list of all Meetings, sheet names, horses and associated rows will be listed.
Find your horses, and in column E, put either Lay or Back and then press the "Place Bet" button.
If you then go to the appropriate sheet, you'll see that your lay bet has been placed.
However, please be aware that it doesn't do fill_kill, offset or other instructions ( but it could be incorported), and it WON'T clear any bets, so if you want to cancel then you'll have to do it manually.
Anyway, hope you find it useful.
Nigel
On the "Summary" sheet, you'll see two buttons, press the "Get Summary" and a list of all Meetings, sheet names, horses and associated rows will be listed.
Find your horses, and in column E, put either Lay or Back and then press the "Place Bet" button.
If you then go to the appropriate sheet, you'll see that your lay bet has been placed.
However, please be aware that it doesn't do fill_kill, offset or other instructions ( but it could be incorported), and it WON'T clear any bets, so if you want to cancel then you'll have to do it manually.
Anyway, hope you find it useful.
Nigel
You do not have the required permissions to view the files attached to this post.
-
JacoboPolavieja
- Posts: 91
- Joined: Thu Sep 10, 2009 6:00 pm
That is amazing nigelk, thanks a lot!
The problem I see with it is that it only displays the names & races of the loaded sheets (obviously). As I somedays have between 20-30 selections (this is a system with lots of action, hence the need for automation) I think I'd only have the option of copying up to 40 sheets in order to have all my possible selections loaded, and that I think would be very CPU consuming also.
Nice sheet anyway, I think I'll find a use for it in the future for some other things I'm trying
.
Thank you very much!
The problem I see with it is that it only displays the names & races of the loaded sheets (obviously). As I somedays have between 20-30 selections (this is a system with lots of action, hence the need for automation) I think I'd only have the option of copying up to 40 sheets in order to have all my possible selections loaded, and that I think would be very CPU consuming also.
Nice sheet anyway, I think I'll find a use for it in the future for some other things I'm trying
.Thank you very much!
-
JacoboPolavieja
- Posts: 91
- Joined: Thu Sep 10, 2009 6:00 pm
Ok... first races of the day and I see what may have happened yesterday.
Some of today's races the bot didn't place the bet because I had set it to put it 30seconds before the off. There have been some races thathad started earlier than expected and hence th 30 second mark wasn't met. Even more so, I synchronized my computer's clock manually to one of Windows Internet services and it has forwarded my clock 1 minute ahead... so that adds to my delay and hence it may have happened that due to this two things several bets weren't placed.
I'll continue monitoring... it was just in case anyone with a similar problem reached this.
Cheers!
P.S: I don't know if it's because I manually have to put some bets but, doesn't BetAngel clear the status cells when it reassigns an existing sheet to a new market?
Some of today's races the bot didn't place the bet because I had set it to put it 30seconds before the off. There have been some races thathad started earlier than expected and hence th 30 second mark wasn't met. Even more so, I synchronized my computer's clock manually to one of Windows Internet services and it has forwarded my clock 1 minute ahead... so that adds to my delay and hence it may have happened that due to this two things several bets weren't placed.
I'll continue monitoring... it was just in case anyone with a similar problem reached this
.Cheers!
P.S: I don't know if it's because I manually have to put some bets but, doesn't BetAngel clear the status cells when it reassigns an existing sheet to a new market?