Save a String as a Csv

19 Ansichten (letzte 30 Tage)
Joshua
Joshua am 4 Jan. 2016
Kommentiert: Walter Roberson am 5 Jan. 2016
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.

Antworten (1)

Walter Roberson
Walter Roberson am 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 Kommentare
Joshua
Joshua am 4 Jan. 2016
Sorry about that, I copied and pasted the wrong URL. That has been corrected.
Walter Roberson
Walter Roberson am 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.

Melden Sie sich an, um zu kommentieren.

Kategorien

Mehr zu Workspace Variables and MAT Files finden Sie in Help Center und File Exchange

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by