Step-by-step RTD linking
- Open a "Market" window/"Watchlist". Right-click on the column headings and choose "Select Columns". From the "Select Columns" window, you can add and delete column headings. These will be the fields you wish to export to Excel.
- There are two ways to export to Excel using RTD links. The first step for both methods is to select the cells you want to be exported to Excel by holding down left click on the mouse and dragging the mouse across all of the data you want to export.
When you have highlighted your selection, you can export the selection to Excel following the below directions: Open as Excel sheet.
Click the Excel icon which appears to the top of the window. (The Excel Add-in needs to be installed for this button to appear.)
This will automatically open an Excel sheet with your selection. Alternatively, use the keyboard shortcut <CTRL>+<SHIFT>+<E> when you make the selection.
If you click on one of the cells, you can see the RTD function used to get the data in the formula bar.
As you can see from the below, the formula uses cell referencing and is therefore dynamic and more flexible.
=RTD("ontrade.quotes","",$C6,"",E$5)Element Description ontrade.quotes
Infront Professional Terminal's application name for the quotes module.
C6
The cell which contains the market feed code and ticker symbol.
E5
The cell that contains the name of the field data to display.
Alternatively, you can copy the RTD link.
Right-click the selection and select "Edit" > "Copy RTD Link". Alternatively use the keyboard shortcut <Ctrl>+<R>. Paste into Excel and the highlighted selection will populate the Excel worksheet.
If you click one of the cells, you can see the RTD function used to get the data in the formula bar.
Differing from the cell referencing method used in the 3.1 example, this method is hard coded and references specific feed codes and ticker symbols in the formula.
=RTD("ontrade.quotes","","LSE:AAL","","last")
Element | Description |
---|---|
ontrade.quotes | Infront Professional Terminal's application name for the quotes module. |
"LSE:AAL" | The market feed code and the ticker symbol. |
"last" | The name of the field data to display. |