by negapo » Wed May 13, 2009 12:20 pm
The default refresh rate in your excel sheet is going to be the same defined in B.A. Options - Preferences but you can change it in excel by putting a value (between 0.1 and infinite) in cell "Q2". This way you can have 10 markets logged to 10 different worksheets each of them having it's own refresh rate. You can also put conditions to your refresh rate with some functions like for example:
putting in cell "Q2" this formula if(E2="In Play";0.1;10)
In this way, if you have a strategy that is only active when the market is in-play you can save resources until then.