Skip to Content

How to read data from a csv table in R?

I have a csv file, and I want to extract the each column a as string so I can use it with getSymbols function from quantmod package.

The csv file looks like this:

AEGR,Aegerion Pharmaceuticals Inc
AKS,AK Steel Holding Corp
ALXA‎,Alexza Pharmaceuticals Inc
CCL‎,Carnival Corporation
CECO‎,Career Education Corp
CDXS‎,Codexis Inc

And I use this code to read the file:


I get this error:

Error in download.file(paste(yahoo.URL, "s=",, "&a=", from.m,  : cannot open URL '‎&a=0&b=01&c=2007&d=5&e=16&f=2012&g=d&q=q&y=0&z=ALXA‎&x=.csv'
In addition: Warning message:
In download.file(paste(yahoo.URL, "s=",, "&a=", from.m,  : cannot open: HTTP status was '404 Not Found'

When I enter the symbols one by one it works fine. I've also noticed that when I go to the end of the last line, the margins seem to corrupt. In the image you can see that values of 'symbols', the end of the line is a few more spaces to the right than it should be (you can see that because of the color of the initial parenthesis).