For using cell references and wrapper functions, see the Tips and Examples for Retrieving Live Data.

Note For more examples of how to use TeleTrader WorkStation RTD, a sample Excel sheet is included in the installation: Right-click the RTD tray icon and choose Help > Samples to open it. See also Samples for the RTD Component.

Retrieving daily data

Retrieve the volume of the Microsoft stock for 3 days counting backwards from April 5th, 2006 in a daily compression (each formula needs to be entered in a different cell):

=RTD("ProfRTD";;"History";"{829802},Daily,VOLLAST,E=05042006";1)

=RTD("ProfRTD";;"History";"{829802},Daily,VOLLAST,E=05042006";2)

=RTD("ProfRTD";;"History";"{829802},Daily,VOLLAST,E=05042006";3)

Retrieving intraday data

Retrieve the Close price of 1-hour-bars (60 minutes) for the EURUSD currency pair, from March 30th, 2011, 8:00 h to noon. The first cell should contain the following formula it retrieves the Close price of the 12:00 bar:

=RTD("ProfRTD";;"History";"{3212164},Min60,PCLOSE,S=300320110800,E=300320111200";1)

To retrieve the rest of the data (8:00, 9:00, 10:00 and 11:00 bars), the following formulas should be used (notice that the Index count is going up for each cell):

=RTD("ProfRTD";;"History";"{3212164},Min60,PCLOSE,S=300320110800,E=300320111200";2)
=RTD("ProfRTD";;"History";"{3212164},Min60,PCLOSE,S=300320110800,E=300320111200";3)
=RTD("ProfRTD";;"History";"{3212164},Min60,PCLOSE,S=300320110800,E=300320111200";4)

=RTD("ProfRTD";;"History";"{3212164},Min60,PCLOSE,S=300320110800,E=300320111200";5)
=RTD("ProfRTD";;"History";"{3212164},Min60,PCLOSE,S=300320110800,E=300320111200";6)

As there is no more data available for this time region, the last cell (with index 6) will show n/a (not available).

Retrieving tick data

Retrieve the last five ticks of the Dow Jones Industrial Average note that the data will NOT update automatically when new ticks come in (use live RTD links for ticking data):

=RTD("ProfRTD";;"History";"{394917},TICK,LAST,now";1)
=RTD("ProfRTD";;"History";"{394917},TICK,LAST,now";2)

=RTD("ProfRTD";;"History";"{394917},TICK,LAST,now";3)

=RTD("ProfRTD";;"History";"{394917},TICK,LAST,now";4)

=RTD("ProfRTD";;"History";"{394917},TICK,LAST,now";5)