RTD Excel Formula

ICE Data Services -

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.