how often does charting collect figures ?
When using the excel charting with BA, how often does the macro collect the data, I calculated it as every 3.3 seconds, is this right ? Is there a way to collect the data more often, just looking for a way to collect the back and lay prices more frequently, thanks
Are you referring to the charting spreadsheet supplied? The original author of this sheet is currently unavailable. However, from memory it uses a 1 second VBA pause loop (not sure why you are seeing a longer period) which cannot be altered. You may want to have a go at creating your own and use a different timing method to loop. This might make it more controllable. Maybe someone can suggest a better method?
Also - fyi - we provided the forum for user chat. We try to get involved where we can but if you want a specific answer to a product related question within a timeframe then drop a note to support. The forum is not monitored for support issues and there is no guarantee of a response within a week let alone 24 hrs. However, support will respond within 24 hrs normally.
Also - fyi - we provided the forum for user chat. We try to get involved where we can but if you want a specific answer to a product related question within a timeframe then drop a note to support. The forum is not monitored for support issues and there is no guarantee of a response within a week let alone 24 hrs. However, support will respond within 24 hrs normally.