diff options
Diffstat (limited to 'sql/dawn.sql')
| -rw-r--r-- | sql/dawn.sql | 8 |
1 files changed, 5 insertions, 3 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index 59581919..3179bb1e 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -3858,8 +3858,9 @@ SELECT trs.id, True END AS buysell, termination_fee AS upfront, - terminations.traded_level as price - maturity_date + terminations.traded_level as price, + maturity_date, + settle_date FROM terminations RIGHT JOIN trs USING (dealid) LEFT JOIN counterparties on termination_cp=code WHERE termination_date is NOT NULL @@ -3879,5 +3880,6 @@ SELECT id, buysell, accrued as upfront, price, - maturity_date + maturity_date, + settle_date FROM trs JOIN counterparties ON cp_code = code) ORDER BY trade_date DESC, folder;
\ No newline at end of file |