To retrieve and update the quote data that you include in your spreadsheets, a separate program is needed that communicates between the TeleTrader Market Data Server and Microsoft Excel. This program is called TeleTrader Professional RTD.

You can see if the RTD connection is active in your Windows system tray:

TeleTrader Professional RTD is started automatically when needed, for example when opening an Excel spreadsheet containing RTD links. You can also manually start the RTD connection, if necessary.

The RTD connection stays active even if you close the spreadsheet that contains the RTD links. You can stop the connection manually if you don’t need it anymore.

Note             TeleTrader Professional RTD creates a separate connection to the TeleTrader Market Data Server. Therefore, firewalls have to be set up to allow traffic for TeleTrader Professional RTD (ProfRTD.exe) on either port 80 or 2088 (TCP).

To start the RTD connection manually

▪       Click on the Windows Start button, and then select All Programs > TeleTrader Professional > Professional RTD Server.

▪       You will be asked to log in with your user name and password.

To stop the RTD connection manually

▪       In the Windows system tray, right-click the Professional RTD icon:

▪       Select Exit.

Possible issues in Microsoft Excel

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 Professional 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:

http://msdn.microsoft.com/en-us/library/aa140060%28office.10%29.aspx#odc_xlrtdfaq_howconfigrtdthrottle

Microsoft Excel 2007 security 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 Professional 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".