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.
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)
table_BEFORE.csv
92 KB
|
463 downloads
table_EXPECTED.csv
96 KB
|
498 downloads
LoadStockData (1).mq4
13 KB
|
527 downloads