To create a RTD Historic Table:
1. Click from the RTD Excel Toolbar.
OR
2. From the Menu bar, select Interactive Data RTD, then Historic Table.
Result: Insert Historic Table window opens.
The Insert Historic Table window from the Excel Toolbar contains the following options:
Symbols |
Enter Symbols separated by comma |
Show Header |
Display Symbol Header in Table. Symbol Header will be Bold. |
Use Reference |
Use Symbol Header as Cell Reference. You may change the Symbol in the Reference Cell and the corresponding Fields will change to the newly changed Symbol. |
Interval |
Select Daily, Weekly, Monthly, or Intraday. Input mins for Intraday |
Show Header |
Display Interval Header in Table. |
Use Reference |
Use Interval Header as Cell Reference. You may change the Interval in the Reference Cell and the Table will update the Interval. D - Daily , W - Weekly , M - Monthly , Inn where nn is minutes I5 for example. |
Time Range |
Only available for Intraday Intervals. Define a start and end point for bars, similar to Time Templates |
Fields |
Use Arrow to Add, Remove, and Arrange Fields |
Show Header |
Display Fields Header in Table. |
Use Reference |
Use Field Headers as Cell Reference. You may change the Field in the Reference Cell and the corresponding Symbol cells will update with the newly changed Field. |
Series |
|
Count |
Number of bars to create back from current time. Bars will update as time passes |
Dates |
Select Dates from which to retrieve History. Cannot be used with Intraday Intervals |
Show Header |
Display the Series Header in Table. |
Use Reference |
Use Series Headers as Cell Reference. You may change the Date in the Reference Cell and the corresponding cells will update with the new Date |
Options |
|
Vertical (Symbols in Columns) |
Create Table with Symbols in Columns and Fields in Rows |
Reversed (Oldest Bars First) |
Oldest Bars are at Top of Series Count Tables |
Use Short RTD Form |
Shortened RTD Syntax |
Forward and Back buttons |
Navigate Back and Forth through previously created Quote Table Settings |
Publisher |
Advanced Settings used when multiple Interactive Data products are installed on the system. |