Q2 Moving Market Excel

[siony1974]

I'm not sure if I'm missing a setting or something somewhere.

I have BA linked to an Excel sheet. The quick pick list is not set to move forward using the 'Auto Select Markets' option.
In Excel when i put -1 in cell Q2 and press enter nothing happens. It just sits there in the cell. The market doesn't move to the next race in the list.
I don't remember Q2 needing any code to force the update.

Any ideas what I've forgotten to click/tick ?

[Captain Sensible]

The -1 should get picked up on the next refresh not when you press enter. Are you logging the market tocell A1? Enable Triggered Betting ticked ?

[siony1974]

Hi Captain,

It's been a while since I've used the Q2 triggers and spotted my mistake this morning. I hadn't enabled triggered betting.
I was testing out a new sheet and didn't want it triggering anything at that point.
I'd set up the -1,-2 triggers as buttons on the sheet with very basic macros attached to them to move the market back and forth.
I was just a little baffled why they weren't working. Enabled triggered betting and they all work fine.
Many thanks for the swift reply, it's much appreciated.