Hi everybody, I have made a simple strategy on excel and I want BA (VPS version) to run it automatically in all the races. I prepared an excel with multiple spreadsheets and unsed autobind function to populate them. Everything ok so far.
Then I selected "restrict refresh" function to start refreshing 2 minutes before the event, leaving autobind flagged. I though in this way Guardian would automatically play the right spreadsheet on the workbook starting 2 minutes before the event start. But it doesn't!
For every event, it always plays the first spreadsheet, and the problem is that it doesn not deleted the status cell when changing the event! So the status is always on Suspended or Placed, and no bets are fired in the following event!
What do I do wrong? How can I tell Guardian to play Event 1 in spreadsheet 1, event 2 in spreadsheet 2 and so on? I have tried to disable the autobind function and manually select the spreadsheet in the drop-down menu in each event, but it seems that I can do that only if we are already in the restrict refresh time frame, otherwise my selection is not kept by Guardian!
Or, in alternative, how can I tell it to delete the status cell on the spreadsheet when changing the event?
Thank you very much!!
SP
Problem with autobinding / status cell
-
- Posts: 7
- Joined: Mon Oct 03, 2011 2:14 pm
Oh ok, looking better.. I found out that I should disable the "autoclear bindings" option, shouldn't I? In this way Guardian will switch to spreadsheet 2 for event 2, spreadsheet 3 for event 3, etc. That's what I want!
But.. just a question: if the autoclear option does not delete the status cell in the spreadsheet, how can it be used for automatic trading?
But.. just a question: if the autoclear option does not delete the status cell in the spreadsheet, how can it be used for automatic trading?