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