Save a String as a Csv
6 views (last 30 days)
Show older comments
I'm trying to save and stockdata from yahoo finance.
% code
Quotes = urlread('http://real-chart.finance.yahoo.com/table.csv?s=HMSY&a=00&b=1&c=2015&d=00&e=4&f=2099&g=d&ignore=.csv');
"Quotes" will end up being a string in csv form. How can I save "Quotes" as a .csv file?
Edit: I posted the wrong string in urlread by accident.
0 Comments
Answers (1)
Walter Roberson
on 4 Jan 2016
No it will not. Given that URL, Quotes will end up being a string full of HTML that does not contain the data at all, and instead contains references to javascript functions that presumably read in the data.
2 Comments
Walter Roberson
on 5 Jan 2016
To store that as a csv file:
fid = fopen('YourFile.csv', 'wt');
fwrite(fid, Quotes);
fclose(fid);
If you had wanted it as an xls* file then there would have been more work, but since it is already in csv line structure just write the string to a file.
See Also
Categories
Find more on String Parsing in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!