History Syntax

Download Sample Spreadsheet

 

Besides using the Excel Plug-in to generate Historical RTD links, you can create RTD links by directly entering the RTD formula.

 

=RTD("ESRTD",,"*H", <Symbol>,<Field>,<Agg>,<Start>, <Index>)

 

*H - Denotes History Function

 

Symbol - Symbol

 

Field - Field Name

 

Possible Field Names:

 

 

Agg - Data Interval/Aggregation

 

 

Start - Starting Date (Optional). Default is current day

 

Index - Offset from Current Day. Default is Zero. Number of Bars prior to Start Date/Current Day

 

* Start and Index are mutually exclusive.