Displaying 1 result from an estimated 1 matches for "tradebit".
2005 Jun 08
1
RODBC question: problem importing series with blank cells
...I have an excel file that I load through RODBC. Some of my columns are
blank. They are equity time series and the stocks did not exist at the
earlier dates. My problem is that the whole column becomes <NA> even though
there are numbers at later dates.
Here's my excel file
http://www.tradebit.com/download.php/35699
<http://www.tradebit.com/download.php/35699>
And here's the code I use:
library(RODBC)
chan <- odbcConnectExcel("C:/book54.xls") #load data
ts<- sqlFetch(chan, "Sheet1")
close(chan)
ts<-ts[-1,]
str(ts)
head(ts)
tail(ts)
Regards,...