Command cells being hardcoded when market switches
-
- Posts: 2
- Joined: Mon Jan 03, 2011 12:19 am
On the standard Bet Angel excel template I've linked multiple markets to an individual excel tab so it cycles through at the chosen refresh rate, but as soon as the market switches for the first time it hardcodes whatever is in the green command cells (i.e. L9:N9, L11:N11 etc), so I'm unable to link these cells to another part of the sheet. I know the 'Status' cells will populate with hardcoded values but it shouldn't be doing this for the others should it? Any idea?
Are you using the Excel binding from Guardian or the Excel page from the main Trading screen?
I wouldn't recommend binding multiple markets to the same Excel sheet from Guardian - it's designed so that each market is given its own worksheet (as per the BetAngel_Multiple.xls template). Binding multiple markets to the same worksheet could have expected behaviour.
I wouldn't recommend binding multiple markets to the same Excel sheet from Guardian - it's designed so that each market is given its own worksheet (as per the BetAngel_Multiple.xls template). Binding multiple markets to the same worksheet could have expected behaviour.
-
- Posts: 2
- Joined: Mon Jan 03, 2011 12:19 am
Yes I'm binding from guardian. I appreciate that binding multiple markets to one tab isn't ideal, but it's just to avoid having many different tabs, which in practice would limit the number of markets that could be simultaneously looked at. Is there a better way to do this than binding multiple markets to the same tab?
-
- Posts: 35
- Joined: Sat Apr 09, 2016 11:50 am
I was getting this even when doing it on the single market template.