In this TradeStation tutorial, we discover how to use EasyLanguage to export data from TradeStation to 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 and MULTICHARTS

First of all, we have to create a heading.

The code in EasyLanguage export to Excel:

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 - easylanguage export to excel - how to download historical data tradestation

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

But, how to get data from TradeStation and MultiCharts?

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

// EasyLanguage Indicator from CSV 

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 data creates a text file in the folder “TS_TO_EXCEL”.

how to get data from tradestation export trades Excel MultiCharts

IMPORT TRADESTATION DATA INTO EXCEL –

easylanguage export to excel – How to Get data from TradeStation export trades

TradeStation Export Trades

 

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 easylanguage indicator from csv

 

Q&A

How to download historical data TradeStation?

 

Register or Login and Download the indicator for free!!

DOWNLOAD LINK:   DataExtractor Indicator for TradeStation

 

 

Editors’ Recommendations:

 

tradestation review

EasyLanguage Indicator from CSV

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

Excel Guide

 

 

Leave a Reply