Today we discover how to export data from TradeStation to use it in Excel. It’s straightforward; you only need our free indicator.

This project is open, and we’ll add many functions in the future.

Extract data from TradeStation is essential when you need to perform statistical analysis on data series. TradeStation is perfect for BackTest, but Excel is the most potent tool to analyze data.

If you are searching price pattern or seasonality, you can do that with our Data Extractor Indicator and Excel.

EXPORT DATA FROM TRADESTATION

First of all, we have to create a heading.

The code in EasyLanguage:

FileAppend(“c:\TS_TO_EXCEL\”+NameFile1+”.txt”,
“DATE;TIME;OPEN;HIGH;LOW;CLOSE;VOLUME;BODY;RANGE;RSI;ATR” + NewLine);

With this part of code we created the first part of our spreadsheet:

Export data from TradeStation to Excel

Now we have to get all the data from our chart.

We use this simple trick to grab data from every candle in the chart:

If Close[1] <> Close[2] then begin

_Open = Open[0];
_High = High[0];
_Low = Low[0];
_Close = Close[0];
_Volume = Volume[0];
_Body = Abs(Close[0]-Open[0]);
_Range = High[0] – Low[0];
_RSI = Rsi(Close, Rsi_Period);
_ATR = AvgTrueRange(ATR_Period);

End;

In this way, at the end of the bar, the system will write on each variable.

Now we only have to transfer this data in our file.txt with this code:

FileAppend for Excel export code easylanguage tradestation indicator

When you attach the Data Extractor Indicator to a chart, TradeStation creates a text file in the folder “TS_TO_EXCEL”.

file data excel tradestation extractor indicator

IMPORT TRADESTATION DATA INTO EXCEL

Open Excel and in the Menu “Data” click on “Get Data: From Text/CSV”

Excel Import stock data from file CSV

Now you can load the data in excel:

Load Data to Excel from Tradestation indicator

Our spreadsheet:

Spreadsheet data tradestation excel

Now you are free to organize and utilize this data or you can create a chart.

Excel Chart Stock with Tradestation Data Export

 

 

Register or Login and Download the indicator for free!!

DOWNLOAD LINK:   DataExtractor Indicator for TradeStation

 

 

Editors’ Recommendations:

 

 

 

You can learn how to create a chart in Excel here:

Excel Guide

 

 

 

 

Leave a Reply