Command cells being hardcoded when market switches

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
luketmcmanus
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?
Bet Angel
Bet Angel
Bet Angel
Posts: 4031
Joined: Tue Apr 14, 2009 3:47 pm

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.
luketmcmanus
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?
amberleith
Posts: 35
Joined: Sat Apr 09, 2016 11:50 am

I was getting this even when doing it on the single market template.
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”