Home                           

 Try Investor/RT             

 Investor/RT Tour           

 Getting Started              

 What's New                  

 Testimonials                 

  Q&A - Broken down by Topic . . .      Complete List of Questions - All Topics
     Charts and Technical Indicators      TPO Charts
     RTL: Scans, Signals, and Custom Indicators      Importing and Exporting
     Trading Systems and Backtesting      Schedules
     Quotepages, Portfolios and Custom Columns      Alarms / Alerts
     Data: Historical Data, the Database, and Data Services      User Variables (T# and V#)
     Custom Instruments: Spreads and Pairs      General / Miscellaneous
     Controls, Windows, and the Button Indicator      Autotrading
     Slide Shows      Product Line

 
Q&A Home

Investor/RT Answer
Answers to Common Questions

   

Question

Is there any way to export technical indicator data/values to a text file?
   

Answer

Yes.   Just right click on any technical indicator in any chart and choose "Export Data".  You'll be asked to supply a file name.  A descriptive name like "MSFT_MA.txt" will be supplied by default (when exporting Moving Average data from a chart of MSFT).  The resulting text file will have the following tab delimited format:

MSFT_MA 10/31/2001 27.84
MSFT_MA 11/01/2001 27.97
MSFT_MA 11/02/2001 28.21
MSFT_MA 11/05/2001 28.39
MSFT_MA 11/06/2001 28.57
MSFT_MA 11/07/2001 28.78
MSFT_MA 11/08/2001 29.02
MSFT_MA 11/09/2001 29.26
MSFT_MA 11/12/2001 29.49
MSFT_MA 11/13/2001 29.75
MSFT_MA 11/14/2001 30.01
MSFT_MA 11/15/2001 30.16
MSFT_MA 11/16/2001 30.33

The file contains the time series of values for the selected technical indicator. The text file will contain a ticker, date/time stamp, and a numeric value of the indicator at that date/time. The ticker symbol in the export file will be in the form XXXX_YYYY where XXXX is the ticker of the underlying instrument and YYYY is a token representing the indicator exported. For example if you have a five minute chart of IBM with a moving average indicator, select the indicator by clicking on the moving average line, then right-click in the chart to access the popup menu and choose “Export Indicator”. The exported text file will show the five minute values of the moving average. The exported ticker in each line of the exported file will be IBM_MA, in this example. You can export any technical indicator value series this way, including custom indicators. The data can be imported into IRT (using File: Import) for further study using other indicators. You must define the ticker IBM_MA to Investor/RT before importing. We suggest you use “Cash” as the security type of the imported instrument so that Investor/RT will not request data from your data service on such instruments. The export file can, of course, be opened directly by Excel for further analysis also.