diff options
| -rw-r--r-- | R/new_index_series.R | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/R/new_index_series.R b/R/new_index_series.R index c979e3b9..9c5a3d20 100644 --- a/R/new_index_series.R +++ b/R/new_index_series.R @@ -45,7 +45,7 @@ all.companyids <- dbGetQuery(dbCon, "SELECT company_id from cds_issuers") curves <- curves[!prep.data$company_id %in% all.companyids$company_id,] prep.data <- prep.data[!prep.data$company_id %in% all.companyids$company_id,] prep.data[prep.data$doc_clause=="Modified-Modified Restructurin","doc_clause"] <- "Modified Modified Restructurin" -sqlstr <- "INSERT INTO CDS_Issuers VALUES('%s', %s, '%s', '%s', '%s', '%s', '%s')" +sqlstr <- "INSERT INTO bbg_issuers VALUES('%s', %s, '%s', '%s', '%s', '%s', '%s')" with(prep.data, for(i in 1:nrow(curves)){ stmt <- sprintf(sqlstr, gsub("'","''", Name[i]), company_id[i], ticker[i], currency[i], |