NSE Stock Data Import on Metatrader
In this article, you will earn how to use NSE stock data on Metatrader, draw charts analyze with custom indicators, even backtest your strategy.
Metatrader has a custom symbol option which allows you to add custom datasets into MetaTrader 5 trading software.
Download MetaTrader 5:
First download MetaTrader 5 software from the MetaTrader official site. Then install it on your computer.
You can download NSE intraday stock data or equity data from Zerodha. Not just NSE you can have all exchanges stock data including MCX, BSE, options data.
For that, you need to have a real stock trading account with Zerodha. Open Zerodha account with the link below:
They have both offline and online simple process. Zerodha representative will guide you best, once you will register. Even collect your KYC documents from your home for free.
Not to mention you can trade stock, options, futures contract with Zerodha with lowest brokerage charges. Equity trading has zero brokerage.
Install Zerodha Pi:
After you have an active trading account, download Zerodha pi, an advance stock trading platform and install it on your computer.
Then log in to Zerodha pi with your username, password and pin.
Zerodha Pi dashboard:
The default tab in the software is termed as “Default MW”. In this tab, you can add your favorite stocks. In the example below, we have added TCS from NSE.
Next right on the equity and click on “chart”. This will the chart window. Here you can get any type of chart you want, with the example below we have selected the 1-hour chart for 60 days. You can even open the minute chart. The chart will open in a new tab.
Download NSE stock data:
Now we will export the TCS stock data to excel.
Right-click on the chart, then from “save chart” to “save the chart data to excel”. Click on it. It will save the chart data in excel .csv format to the below location:
This PC > Local disk (C:) > Zerodha > Pi > Exported
If you install Zerodha to any other location, then open the installation folder from there Pi > Exported
Edit CSV Data for Metatrader import:
Metatrader has a different setup for importing custom data into the trading platform. So we need to edit the data or rearrange it with MetaTrader bar data importing format.
Metatrader has the following format:
- Tick volume
So in our CSV file, we need to setup TCS data in that way.
Zerodha data comes in the following format:
Just we will add two extra columns “tick volumes” and “spread” with 0 (zero) value.
Changing DateTime format:
Zerodha data time and MetaTrader DateTime format is a bit different which we need to change with excel custom format option.
Select the DateTime field then from data format option, click on the “more number formats” it will open the custom format option.
For MetaTrader we need to use following DateTime format:
Now select the rest of the data in that column and repeat the above set. Insert two columns for “tick volume” and “spread” as shown below:
You need to sort the data with “Z to A” because by default Zerodha export stock into .csv file last to first. So you need to make the last date first then the current date last. Just reverse.
Save the file. Now our CSV file is completely ready to import into the MetaTrader custom symbol.
Import NSE stock data into MetaTrader:
Open MetaTrader 5 and press “Control + U” to open the symbols window. You can also open by right-clicking on the symbol from the market watch window.
There click on “Create custom symbol”.
Here you need to add custom symbol details. Just edit only the following fields.
- Group path
- Base currency, profit currency, margin currency to INR
- The calculation to exchange stocks
You can edit, add, delete any custom symbol, just right click on the symbol to open the menu.
Import data into a custom symbol:
Now only need to import data into that custom symbol, which you have created before.
Select the symbol then click on the bar from the symbol window (Control + U). Now click on “Import Bars”.
From the import bar window, browse and select your .csv file then with the default setting click “Ok”. Check data if required.
Display chart window
Show the chart!
Your newly added custom symbol will be showing on the “Market Watch” section. From there right-click on it and from the right-click menu on “Chart window”. This will open the offline chart of the stock, in this case, TCS.
Now you can add custom indicators on this chart for your trade analysis.
In the beginning, it might feel like a complex process. But once you will do it. It will get easier. No such big deal plus its FREE. No monthly rental for using MetaTrader. You can use any custom or paid forex indicator on your favorite Indian stock. Also can do backtesting of your strategy with MetaTrader strategy tester.
Shares of different metatrader trading strategies
Learn MetaTrader tips & tricks to improve your day trading. Handpicked articles on MetaTrader trading software.
Are you an Ubuntu Linux lover? Looking for metatrader linux alternative. Then here is the guide to run MetaTrader 4 on Ubuntu Linux platform. In this demonstration, we are using Ubuntu 16.04 the latest one. Installation Below is the step by step guide for installing Metatrader on Ubuntu linux operating system Step 1 (Downloading Wine) […]
It is always worthful to backtest a trading strategy before implementing it, on your real trading account. With the MetaTrader backtesting feature, a trader can understand better how a system works on historical data or past charts visually. If you are new to this, then worry not! As you are going to be a backtesting […]
Check all recently updated & newly posted forex articles, forex trade analysis, MetaTrader indicator manual update.
Last updated on March 24, 2020
Last updated on March 24, 2020
Last updated on March 21, 2020
Last updated on March 8, 2020