How to automatically record markets and then move to the nex

[cjones198]

Hi all
I have made a recording sheet which just simply logs price changes of a market and saves.

How do I select the horse races for the day and set it so that it records and saves the data then when that current market goes inplay, it moves on to the next scheduled race and records that one. Etc etc.
My coding is pretty basic.

[Captain Sensible]

Not at my pc right now but either F2 or E2 has the in play status so switching to the new market isn't much more than sticking -1 in Q2 when the cell value changes to "In Play" and running the save code you already have.

Not sure what you mean by how do you select markets. You can choose what market load on startup by using the default quick pick menu and that can be refreshed to load new markets.

Might be easier to stick up the code you currently use do people can add any code you might need.

[cjones198]

Thanks for the reply, I will do when I'm at a computer mate.
So I just want to select markets for the day, say for example
Ling 13.40 record until inplay, save move to next
Haydock 14.00 record until inplay, save move to next
Ascot 14.15 record until inplay, save move to next
Basically I'm just working a worksheet event change to do it, logging each time the price changes

[Captain Sensible]

You can set BA to load the day's UK and ire races into the quick pick menu by default and it'll just load them in time order. You can even have it load each market venue into a separate tab if you want to avoid thing like races going off at the same time. So shouldn't be too much trouble to amend your existing code as lots of us record and save data.

[cjones198]

Thanks for the info!
I just want a set and forget thing whilst I'm out during the day.
So I'd probably pick races with at least 15 minutes in between each one to try and avoid clashes

[Captain Sensible]

You can select markets manually and drag them to the quick pick list of that is what you wanted or load the lot and delete the ones you don't want

[cjones198]

Yeah I will need to have a play with quick list etc, I'm fairly new to gruss and VBA.
I'd just want to basically automatically go through the markets recording and saving. I'm only able to record 4 or 5 a day at present.
Ideally would leave a computer running at home recording

[Captain Sensible]

Many of us leave PC's running round the clock with Gruss as it can be programmed to reload markets whenever you want, so say every morning etc.

As long as you have a rough grasp of VBA it's shouldn't be too hard to acheive what you need as most is simply copy cells from one place to another nothing complicated. As you're already using worksheet change events it shouldn't be any more than sticking a few sub routines into a module. The most complicated thing is just thinking ahead to ensure you cover all scenarios, like what to do when you reach the end of your quick pick list, closed markets etc

[cjones198]

Thanks Captain!!!!! I will let you know how i get on!

[cjones198]

Sorry to bother you Captain

How do I load up the quick pick list onto a spreadsheet? ive noticed Q2 -1 mentioned a lot where is best to start at attempting this?

[Captain Sensible]

Probably best place to start is the manual online here http://www.gruss-software.co.uk/Betting ... e/help.htm

Click on the betting assistant features folder then go to the Excel Triggered betting and Log current prices. That will get your spreadsheet connected to Betting assistant. Any open market in the tab will then get sent to excel.

When betting assistant (BA) is connected to excel you can move thru the quick pick list with various triggers that you put into cell Q2 , there's no need to send the quick pick list to excel but obviously you can if needed. Putting -1 in Q2 moves to the next market in the quick pick list, -3 reloads the quick pick list, here's a list of the triggers for Q2 http://www.gruss-software.co.uk/Betting ... _other.htm.

[cjones198]

Thanks for that it's much appreciated!!!!

[cjones198]

Hi Captain thanks for the help,

I can navigate that now mate! I will just make some code that puts a -1 in Q2 when market turns InPlay, pretty simple. the only issue is i created a sheet labelled Sheet1_QuickPickList and ticked the option to export quick pick list to excel but nothing gets exported its a blank page

[Captain Sensible]

Hi Captain thanks for the help,

I can navigate that now mate! I will just make some code that puts a -1 in Q2 when market turns InPlay, pretty simple. the only issue is i created a sheet labelled Sheet1_QuickPickList and ticked the option to export quick pick list to excel but nothing gets exported its a blank page

It get'sexported when the sheet is linked or quickpick reloaded , was the sheet named and created before you connected the sheet to excel? Also some functions only seem to work if you have "Enable Triggered Betting" tiked when you connect the sheet to excel. Here's the help page for linkng http://www.gruss-software.co.uk/Betting ... k_list.htm

Always works fine for me but to be honest I've never found any use for it other than very complicated sheets where I'm looping thru markets as certai times before the off. Unless you have a specific need/use for it I wouldn't bother about it too much.

[cjones198]

Thanks. Sorted it now. I hadn't put Market_QuickPickList as the sheet name.