aboutsummaryrefslogtreecommitdiffstats
path: root/R
diff options
context:
space:
mode:
Diffstat (limited to 'R')
-rw-r--r--R/build_portfolios.R2
1 files changed, 1 insertions, 1 deletions
diff --git a/R/build_portfolios.R b/R/build_portfolios.R
index ca1651ef..cb21140c 100644
--- a/R/build_portfolios.R
+++ b/R/build_portfolios.R
@@ -74,7 +74,7 @@ for(i in seq_along(dealnames)){
if(deal.name %in% currdealnames$dealname){
sqlstring <- paste0("UPDATE et_deal_model_numbers SET dealspread5y = $1,",
"dealspread = $2, cdopercentage = $3, stalepercentage= $4, ",
- "marketvalue = $5",
+ "marketvalue = $5 ",
"WHERE dealname= $6 and updatedate = $7")
r <- dbSendQuery(etdb, sqlstring,params = list(deal.spread5y,
deal.spreadatmaturity,