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)