2

I'm struggeling to read a local CSV file with quantmod's getSymbols. The format of the file (wkn_541779.csv) I'm trying to read is like this:

Date;Open;High;Low;Close;Volume;Ajdusted
2012-09-06;104,62;105,95;104,62;105,95;1248065,00;105,95
2012-09-05;104,78;104,78;104,45;104,48;1176371,00;104,48
2012-09-04;104,73;104,73;104,26;104,26;13090,00;104,26

> getSymbols("wkn_541779", src="csv", header = TRUE, sep=";", dec=",")

Gives me an error message: "more columns than column names" though.

> count.fields("wkn_541779.csv", sep = ";", skip = 0, blank.lines.skip = TRUE)

Results in "7" for each line (including the header!), which is exactly the number of columns in the header.

Can anybody please help me tracking down the problem here?

Joshua Ulrich
  • 173,410
  • 32
  • 338
  • 418
user1653205
  • 145
  • 1
  • 8

1 Answers1

1

getSymbols.csv calls read.csv with its defaults. i.e. sep=","

GSee
  • 48,880
  • 13
  • 125
  • 145