Bet Angel wrote: ↑Fri May 12, 2017 2:41 pm
Nero Tulip wrote: ↑Fri May 12, 2017 2:04 pm
Any chance for that group worksheet select feature in guardian that might just save my life in 1.49 ? grumble grumble hint hint... I'm dying here selecting 1000 drop down menus a day for different markets on different sheets!
For clarity, highlight all the markets in guardian to send to a particular sheet, highlight next batch of markets for different sheet and so on.. unless I've missed some feature that will already do this for me? I need related markets running on different sheets, eg football match odds, o/us and so on..
So are you assigning multiple markets to the same sheet in Excel, potentially switching markets for a single sheet every second or so? It was never intended to work that way.... it was intended that a single market would be assigned to a single sheet (and you just copy as many sheets as required). Although even so, I doubt that'd scale into the 1000s!
Or have I misunderstood, are you waiting for one market to finish before reusing the sheet?
Do you have macros running to trigger bets and clear when the market changes in the sheet?
No, I'm putting markets onto different sheets, switching markets on same sheet would cause my calculations to go mad and waste computation time on a massive scale I'd imagine.
Here is an example of the sort of thing I might do for a day...
Say I want to trade dogs win markets and place markets at the same time for the whole day, starting 3 minutes before the off for each race. I have my win markets assigned to sheet "Bet Angel Win" and the places to "Bet Angel Place". In the morning I load up all the markets in guardian, restrict refresh to 180 seconds before start and a bit after too. I now have to go through the excel sheet column and physically drop down a menu for every single market, assigning it to the right sheet. Now imagine any number of sports with loads of races, and loads of derivative markets, add in multiple strategies on different Bet Angel iterations and it can very quickly get to be well over 1000 drop down menus a day.
(I will, at this point, be the happiest person if you point out the foolishness of my ways and suggest there's been a simple solution to this all along...please!
)
I don't want to copy as many sheets as required, as the file would get massive, there's a lot of calculations on each sheet that are quite taxing on the cpu, as well as macros / code running too, I've spent a lot of time optimising to the best of my ability (admittedly, not great, but ok), recommend fast excel 3.0 for that.
I just want to be able to highlight batches of markets in the guardian window, and assign them to a particular sheet, then highlight the next batch, and choose a sheet for those, and so on.