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.
Forex rebate service

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, BSE, MCX Equity data from Yahoo Finance for FREE.
https://in.finance.yahoo.com/

Download NSE stock data:

First, open the yahoo finance India page with the above link. Then in the search bar type the NSE BSE or MCX stock symbol name. It will show all stock exchange date for that selected stock symbol.

With the picture below for CIPLA, CIPLA is listed in many stock exchange including BSE and NSE. So here we will only select the NSE.

Yahoo Finance NSE BSE stock data download
Yahoo Finance NSE BSE stock data download

After opening the TCS.NS page, it will show 3 options to download the CSV data with your preferred choice.

Yahoo finance NSE BSE historical data download csv
Yahoo finance NSE BSE historical data download csv

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 CIPLA data in that way.
Yahoo Finance data comes in the following format:

  • Date
  • Open
  • High
  • Low
  • Close
  • Adjusted Close
  • Volume

Just we will add two extra columns “tick volumes”, “spread” with 0 (zero) value and remove “Adjusted Close”.

Changing DateTime format:

Yahoo Finance shows on date and in different format. But MetaTrader DateTime format is a bit different therefore we need to change it with the excel custom format option.

Select the cell or column then right click on it and from right click menu click on the “Format Cell”
option.

CSV data cell format update date format
CSV data cell format update date format

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:

Final CSV data Stock data for MT5 import
Final CSV data Stock data for MT5 Custom Symbol import


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 only need to add symbol name and keep everything as it is and save.

Create custom symbol metatrader 5 NSE BSE
Creating new custom symbol on Metatrader 5 for NSE

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 Ubuntu Forex Trading

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

5 minutes guide to backtest MetaTrader strategies visually

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.

Forex Market Hours

Forex Market Hours

Last updated on October 10, 2021

Referral Program – Forex Rebate

Referral Program – Forex Rebate

Last updated on August 18, 2021

0 0 votes
Rating
Subscribe
Notify of
guest

This site uses Akismet to reduce spam. Learn how your comment data is processed.

11 Comments
oldest
newest most voted
Inline Feedbacks
View all comments
Quick Chat
11
0
Would love your thoughts, please comment.x
()
x