RTD Excel Formula
RTD, which stands for Real-Time Data, is used to view Market Data in Excel. The Formula used for bringing in the data is:
=RTD("ESRTD",," ",<"Field">)
"ESRTD" - Name of RTD Component
" - Symbol that is Linked
" " – Field that is linked
Note: There are 2 Comma’s between ESRTD and Symbol as noted above.
Additionally, the Field and Symbol can be taken from a Cell reference. For examples of various cell referencing view our Example Spreadsheet.
In order to use RTD, you must first have installed the Interactive Data RTD Service. View the Installation KB for more info.