Yahoo EOD historical data importation into MT4 | Forex Factory

Options

Permalinks
Print Thread

Similar Threads

A fixed script for importing data from Yahoo finance to MT4 45 replies

How to import old historical data into MT4 (M1 TF) 2 replies

MT4 EOD Data export to Metastock 0 replies

Transfer Yahoo Finance chart data into MT4 - Possible? 3 replies

The meaning of EOD? 3 replies

Attachments: Yahoo EOD historical data importation into MT4
Exit Attachments

Yahoo EOD historical data importation into MT4

  • #1
  • First Post: Nov 24, 2013 7:03am Nov 24, 2013 7:03am
hi everyone !

i use the following link to download yahoo EOD historical data for an indian stock and in order to import the csv into mt4's history center i got to format two rows :-

http://ichart.finance.yahoo.com/tabl...04&ignore=.csv

A) i have attached two csv's so that you understand the before & expected outcomes (csv)
B) i have attached a scipt which could simplify some things & it can download individual stock's historical data (.hst) but may need modification according to following :-

1) i have to always delete the horizontal row on top which has tags like

Date
Open
High
Low
Close
Volume
Adj Close


2) insert an additional row after date for time of close or last traded stock time i.e mostly ' 15 :30 '


15 :30
15 :30
15 :30
15 :30

kindly help me find a way to shorten the tiresome process to keep downloading csv's with incorrect format or keep manually editing csv's to import into Mt4.

Thanks & Regards.
Attached File(s)
File Type: csv table_BEFORE.csv   92 KB | 621 downloads
File Type: csv table_EXPECTED.csv   96 KB | 663 downloads
File Type: mq4 LoadStockData (1).mq4   13 KB | 714 downloads
  • #2
  • Nov 25, 2013 12:05pm Nov 25, 2013 12:05pm
any one ?
  • #3
  • Nov 26, 2013 2:00am Nov 26, 2013 2:00am
Quoting .Hawk.
hi everyone ! i use the following link to download yahoo EOD historical data for an indian stock and in order to import the csv into mt4's history center i got to format two rows :- http://ichart.finance.yahoo.com/tabl...04&ignore=.csv A) i have attached two csv's so that you understand the before & expected outcomes (csv) B) i have attached a scipt which could simplify some things & it...
have you actually tried the script?

because it already appears to have a line of code that ignores the header labels

and it writes the history file as: Time,Open,Low,High,Close,Volume ie: not as per your Expected.csv

you cannot write time separate to the date or the adjusted volume to MT history
  • #4
  • Nov 26, 2013 8:19am Nov 26, 2013 8:19am
hi max doom

first of all thanks for taking out your valuable time to assist me.

once i drag the script to a chart, the chart does not gets back filled with required data. maybe i am unable to understand how the .hst can be used to view chart. after dragging script history file is not getting up to date.

i found an alternate script(attached) but unable to understand how it works ! attached it as well. the script is apparently not backfilling either but atleast shows settings including time which previous didn't.
previous one does not shows time of 15:30 along with date, but this one could show as it appears on settings box.


purpose is to import indian stock scripts data into mt4 and view their EOD historical chart.

regards


Quoting MaxDoom
{quote} have you actually tried the script? because it already appears to have a line of code that ignores the header labels and it writes the history file as: Time,Open,Low,High,Close,Volume ie: not as per your Expected.csv you cannot write time separate to the date or the adjusted volume to MT history
Attached File(s)
File Type: ex4 Yahoo Update ALL Charts cot V3.ex4   24 KB | 589 downloads
  • #5
  • Nov 26, 2013 9:05am Nov 26, 2013 9:05am
Quoting .Hawk.
hi max doom first of all thanks for taking out your valuable time to assist me. once i drag the script to a chart, the chart does not gets back filled with required data. maybe i am unable to understand how the .hst can be used to view chart. after dragging script history file is not getting up to date. i found an alternate script(attached) but unable to understand how it works ! attached it as well. the script is apparently not backfilling either but atleast shows settings including time which previous didn't. previous one does not shows time of...
well that first script you provided, create a specific symbol and updates only the daily data, so I assume you are using that particular chart?

beyond that you are going to need to research it more, there is plenty of articles about importing data into MT4

regards
  • #6
  • Last Post: Edited 12:14pm Nov 26, 2013 9:22am | Edited 12:14pm
i trade only daily timeframe of indian stocks, so nothing wrong with the script.
downloading daily historical quotes is fine & g = d denotes daily data only.

http://ichart.finance.yahoo.com/table.csv?s=VOLTAS.NS&d=10&e=30&f=2020&g=d&a=7&b=19&c=2004&ignore=.csv

issue is, the format in which yahoo finance downloads data, does NOT match the mt4 .hst format and charts are not getting backfilled.

i have 2 excellent scripts to download data from google.com but the closing price is different for indian scrips, because of which i prefer yahoo finance, where every high low open close is perfect.

try out these google scripts , they re beautiful to download EOD from google. they backfill perfectly.

Quoting MaxDoom
{quote} well that first script you provided, create a specific symbol and updates only the daily data, so I assume you are using that particular chart? beyond that you are going to need to research it more, there is plenty of articles about importing data into MT4 regards
Attached File(s)
File Type: ex4 Google Update ALL Charts cot V3.ex4   23 KB | 762 downloads
File Type: ex4 Google Update Single Chart cot V3.ex4   22 KB | 691 downloads
0 traders viewing now