diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/dawn.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index 3c27806a..c14be071 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -3232,7 +3232,7 @@ SELECT eo.id, eo.dealid, t.termination_date AS trade_date, t.fee_payment_date AS settle_date, - t.termination_amount AS notional, + t.termination_amount AS quantity, eo.bbg_ticker, eo.figi, CASE WHEN t.termination_cp=eo.cp_code THEN @@ -3258,7 +3258,7 @@ SELECT eo.id, eo.dealid, eo.trade_date, eo.settle_date, - eo.notional, + eo.quantity, eo.bbg_ticker, eo.figi, 'New' AS trade_type, @@ -3271,7 +3271,7 @@ SELECT eo.id, eo.expiration_date, eo.strike, eo.buysell, - eo.notional * price * (2* buysell::integer -1.) + eo.quantity * price * (2* buysell::integer -1.) FROM equityoptions eo JOIN counterparties cps ON cp_code = code) ORDER BY trade_date DESC; CREATE TABLE bond_tickets ( |