diff options
Diffstat (limited to 'sql')
| -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 7eb1413d..54d5fd93 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -3598,7 +3598,7 @@ AS SELECT tranche_risk.date, citco_stax.period_end_date, 0 AS admin_accrued, sum(base_market_value) AS admin_clean_nav, - sum(quantity) AS admin_notional + sum(-quantity) AS admin_notional FROM citco_stax WHERE close_trade_date IS NULL GROUP BY citco_stax.fix_id, citco_stax.period_end_date) a ON NULLIF("substring"(a.fix_id, 'SCCDS(\d*)'::text), ''::text)::integer = tranche_risk.tranche_id AND a.period_end_date = tranche_risk.date LEFT JOIN index_version ON cds.security_id::text = index_version.redindexcode |