Over the past year, I have been using an excel spreadsheet (that I adapted from this forum) to record horse racing data - LTP price, WOM etc. I used guardian to move from one race to the next every 5 mins before the off time. This works fine for racing because apart from the odd occasion the first five minutes before a start race don't tend to clash with another.
Now, I've started to take an interest in tennis trading, I'd like to record data from each match. But if you followed the US Open the last few days, you'll see that you can have 10+ matches at the same time.
My question is whether anybody knows if its possible (in theory) to record data from multiple markets at the same time?
Recording data from multiple markets
Yep, just use guardian and create a few more 'Bet Angel' worksheets in the excel workbook you are using. You then just add the new matches to the data sheet, this will take a bit of simple excel coding. But because there is only 2 'runners' you can fit loads on.
This is assuming you are using this spreadsheet..
viewtopic.php?f=31&t=2385&hilit=record
This is assuming you are using this spreadsheet..
viewtopic.php?f=31&t=2385&hilit=record
Yes, that's the one. I modified to just grab the first three horses and include the WOM.
I just had a quick play with two tennis markets & its giving me stack errors. But, I'll try and strip it back tonight as your right I don't need a huge amount of data, just LTP really.
I just had a quick play with two tennis markets & its giving me stack errors. But, I'll try and strip it back tonight as your right I don't need a huge amount of data, just LTP really.
when I just make few copies of Bet Angel sheet and connect them to multiple markets,excel workbook implodes and gives me Out of stack space error (Error 28).LinusP wrote:Yep, just use guardian and create a few more 'Bet Angel' worksheets in the excel workbook you are using. You then just add the new matches to the data sheet, this will take a bit of simple excel coding. But because there is only 2 'runners' you can fit loads on.
This is assuming you are using this spreadsheet..
viewtopic.php?f=31&t=2385&hilit=record
When I only copy Bet angel sheets, workbook is ok but without data sheet it is recording only one market obviously.
So I think stack space error is there because copies of data sheets are using data from first market in Bet angel sheet and not from respective copies.
Any advice on how to change this data sheet so it works properly?
Thanks
From Microsoft support
"This error message appears when one procedure in your module calls another procedure, and that procedure calls another procedure, and so on. The error message occurs in this case because when you call one sub procedure from another procedure, the first procedure is not unloaded from memory until the procedure that it called is finished. Because of this behavior, if you continue to call a procedure from another procedure, you may run out of stack space, or memory allotted for the macro, before the last procedure is called"
If you intend to record multiple markets with Guardian, it would be better to use the 'worksheet change' event and use the 'last updated' cell on the BetAngel sheets, so the macros only run once every ## seconds.
"This error message appears when one procedure in your module calls another procedure, and that procedure calls another procedure, and so on. The error message occurs in this case because when you call one sub procedure from another procedure, the first procedure is not unloaded from memory until the procedure that it called is finished. Because of this behavior, if you continue to call a procedure from another procedure, you may run out of stack space, or memory allotted for the macro, before the last procedure is called"
If you intend to record multiple markets with Guardian, it would be better to use the 'worksheet change' event and use the 'last updated' cell on the BetAngel sheets, so the macros only run once every ## seconds.
Hey nigelk so where is the sheet from this thread?
viewtopic.php?f=31&t=4172
I'm trying to get my head around VBA, it's shame on me I didn't do it earlier!
So I would like to capture data from multiple matches going at once. Which spreadsheet is better to start with and reworking for this purpose? BetAngel_multiple or BetAngel_record_data? Or using Capture Plus you posted?
And one more:BetAngel_multiple is properly updating only one market which is currently open in BetAngel.
Thanks, all the best!
viewtopic.php?f=31&t=4172
I'm trying to get my head around VBA, it's shame on me I didn't do it earlier!
So I would like to capture data from multiple matches going at once. Which spreadsheet is better to start with and reworking for this purpose? BetAngel_multiple or BetAngel_record_data? Or using Capture Plus you posted?
And one more:BetAngel_multiple is properly updating only one market which is currently open in BetAngel.
Thanks, all the best!