Importing Stocks fails

Sources of data to import to the program
Message
Author
borntosucceed
Posts: 4
Joined: Sun Feb 28, 2016 8:16 pm

Importing Stocks fails

#1 Postby borntosucceed » Sun Feb 28, 2016 10:32 pm

Hi;
I have downloaded EOD history (20 years) for a stock from Yahoo. When I get to the last step of the Import wizard I get the message "Can not import file". Just wondering is there an issue importing EOD data?

Here is part of the export:

20151009,3.83387,3.88711,3.81257,3.86581,10848000,4.11694
20151008,3.99361,4.00426,3.81257,3.83387,11412300,4.08293
20151007,4.07881,4.07881,3.95101,3.96166,10725800,4.21902
20151006,4.1853,4.2066,4.08946,4.11076,10220300,4.37781
20151005,4.11076,4.17465,4.10011,4.14271,5541800,4.41183
20151002,4.04686,4.12141,4.03621,4.06816,6188100,4.33244
20151001,3.99361,4.07881,3.97231,4.06816,9604700,4.33244
20150930,4.00426,4.04153,3.94036,3.96166,13103500,4.21902
20150929,3.98296,3.99361,3.91906,3.95101,12808500,4.20768
20150928,3.91906,4.03621,3.90841,4.03621,5121300,4.29841
20150925,4.04686,4.07881,3.91906,3.92971,13502800,4.18499

columns are Date, Open, High, Low, Close, Volume, average (ignore)

Thanks
Thomas

FX Helper
Posts: 957
Joined: Mon Apr 01, 2013 3:55 am

Re: Importing Stocks fails

#2 Postby FX Helper » Mon Feb 29, 2016 10:31 am

Hello,

Please open this file via excel and sort the data A->Z by a first column.
Earlier data need to be at the top of the file.

Here is and example of how it should be (you can delete the last column too).

20150925,4.04686,4.07881,3.91906,3.92971,13502800
20150928,3.91906,4.03621,3.90841,4.03621,5121300
20150929,3.98296,3.99361,3.91906,3.95101,12808500


Return to “Data sources”

Who is online

Users browsing this forum: No registered users and 1 guest