If you experience problems with retrieving data in Microsoft Excel, you will find tips about recommended settings in Microsoft Excel below to solve some of the most common problems.
Microsoft Excel only refreshes RTD data periodically, based on a system-wide throttle interval named Excel.Application.RTD.ThrottleInterval. This interval is automatically set to 100 milliseconds on installation of TeleTrader WorkStation RTD in the registry (exception: If the throttle interval has already been set by another application to a value lower than 100, it is left unchanged). You can configure the throttle interval (in milliseconds) by using either Visual Basic/VBA or the registry:
▫ With Visual Basic / VBA, you can set Application.RTD.ThrottleInterval in immediate mode or in a startup handler.
▫ In the registry, you can change the registry value: HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Excel\Options\RTDThrottleInterval (for Excel 2002) HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options\RTDThrottleInterval (for Excel 2003) HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Options\RTDThrottleInterval (for Excel 2007).
For more information, please refer to the following Microsoft FAQ item from MSDN:
If you want to copy the content of calculated watch list columns like Total P/L or P/L Perc to Excel, you have to change the formula options in the Excel Options dialog to use a different reference style. Click Formulas, and under Working with formulas select the option R1C1 reference style.
In some cases, the calculated values of watch lists are not rounded correctly, resulting in displayed numbers like for example 1.78E-15. In this case, you have to highlight the affected cells in Excel. Then, right-click on the selection and click Format Cells. Choose Number and the amount of decimal places that you want to show. The calculated values should then be rounded according to your settings.
Microsoft Excel 2007 has very tight security settings. Sometimes, when you open a saved spreadsheet with RTD links, the data is not being updated even though TeleTrader WorkStation RTD is running and visible in the system tray.
If this is the case, you can try to change the security settings in the Excel Options dialog. Click Trust Center, and then click the button Trust Center Settings. Change the settings under External Content to your needs. The macro security settings need to be set to "low" or "medium".