Hi Ian,
To begin, Excel itself is not very fast when it comes to updating and processing data in the cells. MF Pro will have to wait for Excel to finish whatever it is working on before it can send a new portion of data to the worksheet. That's why we discourage you and other MF Pro users from setting the refresh rate to anything above 2 sec. Using higher rates (i.e. once per 1 sec, once per 0.5 sec) will simply render the connection useless and inoperable, because it will be freezing all the time.
Next, the OLE connection over which MF Pro communicates with Excel can be tricky: it won't work if you are actively doing something inside the worksheet, such as editing a cell or saving file/creating sheets, etc. So that could additionally stall MF Pro's data exchange with Excel.
The matter aggravates as you add more markets that are refreshed simultaneously. I don't know how many you have, but anything more than 5 will start causing problems.
I don't have any quick solution for you I'm afraid. The use of Excel was necessary in the old times when the triggers could not operate in a different way (all conditions used to be in an Excel file). But nowadays you can probably avoid using Excel altogether if you need to run MF Pro for a continuous period of time, as it is such a slow-thinking application. Use a
"write to file" trigger to export to a CSV file, then open it in Excel. Or use
import selections for auto-trading to import a list of values from a formatted text file.
