For some examples of how to use TeleTrader WorkStation RTD, a sample Excel sheet is included in the installation. It contains samples for retrieving live data, historical data, market depth data, VWAPs, studies and a complete field reference. You can easily copy the reusable samples to your own Excel tables and tweak them there.

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

▪       Choose Help > Samples.

Samples with fixed symbols contain the symbol ID as a fixed value in the RTD formula. If you copy the formula, you must replace the sample symbol ID with the one that you want to use:

▪       Copy the formula from the sample document, for example:

▪       Insert the formula in the target document and replace the highlighted part with the new symbol ID, for example:

Samples with variable symbols take advantage of Excel's cell references: The RTD formula contains the symbol ID as a cell reference. You can enter a new symbol ID in the highlighted Symbol ID cell in the sample, and all formulas will automatically be calculated for this new symbol ID. If you copy the formulas, you can either include the cell that holds the symbol ID if you want to keep the flexibility, or you can replace the cell references in each RTD formula with the fixed symbol ID (using search & replace):

▪       Copy the data from the sample document and insert it in the target document

▪       Search for the cell reference in all formulas, for example:

▪       Replace with the symbol ID (in quotes), for example:

For maximum flexibility, some samples use the Lookup command to determine the symbol ID used in the RTD formulas. These samples can be used if you don't know your security's symbol ID. Use the search form (LOOKUP) to find out the correct symbol ID; the found symbol ID is then used automatically (by using cell references) in all RTD formulas of the sample. When you want to copy the formulas, make sure that you convert the cell reference in the highlighted Symbol ID field to the actual symbol ID before copying the formulas:

▪       Click into the formula bar of the field that holds the symbol ID, e.g. =C14

▪       Press the F9 key to convert the cell reference to a fixed value, e.g. {458757}

▪       Copy the data from the sample document and insert it in the target document.

▪       If you did not include the Symbol ID cell while copying, you must now search & replace the cell references in the RTD formulas of the target document (see above).