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.

NSE stock data download
Adding NSE stock, Equity TCS in Zerodha Pi software

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.
intraday stock data nse
Choose time period for the stock data in Zerodha Pi

Download NSE stock data:

Now we will export the TCS stock data to excel.

export nse stock data zerodha
Export NSE 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:

  • DateTime
  • Open
  • High
  • Low
  • Close
  • Tick volume
  • Volume
  • Spread

So in our CSV file, we need to setup TCS data in that way.
Zerodha data comes in the following format:

  • Datetime
  • Open
  • High
  • Low
  • Close
  • Volume

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.

data format change for metatrader import csv
Changing datetime format to custom format in Excel

For MetaTrader we need to use following DateTime format:


Excel Format:

yyy.mm.dd hh:mm:ss

excel custom date format
Excel custom date and time 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:

csv excel data final
Final CSV excel data


NOTE:

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”.

create metatrader 5 custom symbol
Metatrader 5 create custom symbol

Here you need to add custom symbol details. Just edit only the following fields.

  • Symbol
  • Description
  • Group path
  • Base currency, profit currency, margin currency to INR
  • The calculation to exchange stocks
Add custom symbol details metatrader
Metatrader 5: Add custom symbol details

You can edit, add, delete any custom symbol, just right click on the symbol to open the menu.

add remove edit metatrader custom symbol
Metatrader 5: Add, remove, edit custom symbol description

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”.

import custom data in metatrader
Import custom data into custom symbol with default settings

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.

show custom symbol chart metatrader
Display chart window for custom symbol

Now you can add custom indicators on this chart for your trade analysis.

Conclusion

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.

Metatrader Linux

Metatrader Linux Ubuntu Forex Trading

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) […]

metatrader optimization select option

5 minutes guide to backtest MetaTrader strategies visually

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 […]

Latest posts

Check all recently updated & newly posted forex articles, forex trade analysis, MetaTrader indicator manual update.

Contact IntraQuotes

Contact IntraQuotes

Last updated on March 24, 2020

Referral Program – Forex Rebate

Referral Program – Forex Rebate

Last updated on March 21, 2020

FAQ  – Forex Rebates | Products

FAQ – Forex Rebates | Products

Last updated on March 8, 2020

Leave a Reply

avatar
  Subscribe  
Notify of