Importing Yahoo Finance data
10 replies
Popopipi
10 years ago #114931
Hi there !
I´m using a trial version of SQ.
I´m trying to import stock´s data from Yahoo Finance.What I do is just convert the Yahoo xls format into csv,so SQ can read it.But I´m having trouble with the import…some kind of error parsing on row 1.
Attach a screenshot.
Thanks in advance !
0
Tomas Matejka
10 years ago #136048
Hello,
error message says you pre-set date format to yyyy.mm.dd while in you CSV you have yyyy-mm-dd
Fix this and it should work
0
Popopipi
10 years ago #136059
Hi Thomas !
Thanks for your answer.
Changed yyyy.mm.dd –> yyyy-mm-dd but still not working.
Any idea?
Thanks in advance again 😉
0
geektrader
10 years ago #136060
Additional set:
“Skip 1 rows 0″ since the file doesn´t start with prices but with declaration of words as you see (Date, open, high, low, close, volume, adj close”. The error message also clearly says exactly that. So if you skip row 1, all will be fine.
0
Popopipi
10 years ago #136061
Thx Geektrader ,followed your indications to no avail.I keep getting an error message !!
I wonder if quotation marks might be causing the problem.
0
Popopipi
10 years ago #136071
Anybody know where can I buy stock data to try SQ?
Yahoo Finance Data doesnt seem to work.
Thx
0
geektrader
10 years ago #136072
Open the CSV file or whatever it is in a text editor and remove all quotation marks. Then it will hopefully work.
0
Popopipi
10 years ago #136077
Thx Geektrader…finally made it!
Some kind of problem converting xls into cvs
Gonna try SQ
0
Angel Talavera
8 years ago #202921
hello I have the same problem I import the data but they do not appear in the drop-down, if you read them and load them. I am trying to take the data from yahoo finance of the sp500 in diary since 1950 but they do not appear I remove the first row with date, open, high, low, close, volume, adjust close (unused).
I appreciate your help, thank you.
https://angeltalavera.com
0
Tomas Matejka
8 years ago #202960
DId
hello I have the same problem I import the data but they do not appear in the drop-down, if you read them and load them. I am trying to take the data from yahoo finance of the sp500 in diary since 1950 but they do not appear I remove the first row with date, open, high, low, close, volume, adjust close (unused). I appreciate your help, thank you.
Have you set skip 2 rows?
0
Manish Mistry
4 years ago #278563
Hello. I am getting an error message when trying to download historical data from Yahoo? See image below.
Any advise?
1
Viewing 10 replies - 1 through 10 (of 10 total)