diff options
| -rw-r--r-- | sql/dawn.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index 422a59cd..249ca3f4 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -813,7 +813,7 @@ ON a.security_id=b.identifier LEFT JOIN factors_history(p_date) c ON a.security_id=c.identifier LEFT JOIN securities d ON a.security_id=d.identifier) SELECT temp.security_id, temp.cusip, temp.security_desc, temp.maturity, temp.notional, temp.factor, -temp.fixed_rate, temp.notional*temp.factor*(temp.price-100)/100, +temp.fixed_rate, temp.notional*temp.factor*(100.-temp.price)/100, -yearfrac(temp.start_accrued_date, p_date+1, 'ACT/360')*temp.fixed_rate/100*temp.notional*temp.factor FROM temp; END |