diff options
| -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 7ee90ccc..bc5482df 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -1678,7 +1678,7 @@ SELECT l.*, b.dirty_nav, b.position FROM list_cds_marks_pre($1, $2, $3) l LEFT JOIN index_version ON security_id=redindexcode LEFT JOIN index_maturity USING (INDEX, series, maturity) LEFT JOIN ( -SELECT ticker_bbg AS bbg_id, -sum(position) AS position, sum(end_mkt_value+total_acc_int) AS dirty_nav +SELECT ticker_bbg AS bbg_id, -sum(position*end_princ_factor) AS position, sum(end_mkt_value+total_acc_int) AS dirty_nav FROM isosel_accrued WHERE instr_type=''Credit Default Swap'' AND ticker_bbg IS NOT NULL AND status in (''Open'', ''P'') %s GROUP BY period_end_date, ticker_bbg HAVING period_end_date=$1 ) b USING (bbg_id)', and_clause); END IF; |