diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/dawn.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index 69eb2586..02e8805a 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -1735,9 +1735,9 @@ SELECT id, expiration_date, strike, buysell, - notional * price / 100 * (2* buysell::integer -1.) * indexfactor + notional * price / 100 * (2* buysell::integer -1.) * COALESCE(indexfactor / 100, 1.) FROM swaptions JOIN counterparties ON cp_code = code - JOIN index_version ON security_id = redindexcode) ORDER BY trade_date DESC; + LEFT JOIN index_version ON security_id = redindexcode) ORDER BY trade_date DESC; CREATE OR REPLACE VIEW cds_trades AS SELECT id, |