How to import data in MT4
Download MT4 and install
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.
After opening the TCS.NS page, it will show 3 options to download the CSV data with your preferred choice.
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.
For MetaTrader we need to use following DateTime format:
Excel Format:
yyy.mm.dd hh:mm:ss
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:
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”.
Here you only need to add symbol name and keep everything as it is and save.
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.
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.
MotiveWave 6.6.7
motivewave |
Instructions:
Install setup file.
Run files crack.exe and crack.bat (in Administrator mode)
(crack.bat will write 2 lines to the host file)
37.59.176.46 motivewave.com
37.59.176.46 www.motivewave.com
You may want to to check if the 2 lines are written to the host file properly
as sometimes the .bat files could not do so.
Copy AA.jar file into motivewave\lib folder
This AA.jar should be dated 4/25/2022 and is good for up to version 6.6.7
(In No way, I am associated to this file, I got this link from a friend and simply shared here, I personally never used Motivewave)