From 08a6c748f17c8baf2c83d391341c731cb9eeef4f Mon Sep 17 00:00:00 2001 From: Guillaume Horel Date: Mon, 17 Oct 2011 02:57:31 -0400 Subject: Finally finish to debug getBloombergData --- bloomberg-data.R | 10 ++++++++-- 1 file changed, 8 insertions(+), 2 deletions(-) (limited to 'bloomberg-data.R') diff --git a/bloomberg-data.R b/bloomberg-data.R index bf7afad..229254d 100644 --- a/bloomberg-data.R +++ b/bloomberg-data.R @@ -10,9 +10,15 @@ for(i in 1:length(sp500.tickers)){ start.date <- as.Date("2000-01-01") list.sp500 <- list() -for(i in 1:10){ +for(i in 1:500){ ticker <- sp500.tickers[i] - list.sp500[[ticker]] <- getBloombergData(conn,ticker,start.date) + #list.sp500.new[[ticker]] <- getBloombergData(conn,ticker,start.date) + list.sp500[[ticker]] <- bdh(conn,paste(ticker,"Equity"),c("PX_OPEN","PX_HIGH","PX_LOW","PX_LAST","VOLUME"),start.date,dates.as.row.names=F) + cat(paste("ticker", i, ": ",ticker),"\n") +} +test <- c() +for(i in 1:158){ + test <- c(test,sum(abs(as.numeric(list.sp500.new[[i]][1,1:5])-as.numeric(list.sp500[[sp500.tickers[i]]][1,2:6])))) } add <- read.table("sp500 add.csv",sep=",",fill=T,header=T,colClasses="character",quote="") -- cgit v1.2.3-70-g09d2