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 4e1149c8..a94b3fc3 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -1590,7 +1590,7 @@ LEFT JOIN index_maturity USING (INDEX, series, maturity) LEFT JOIN ( SELECT ticker_bbg AS bbg_id, -sum(position) AS position, sum("end_mkt_value_[n]"+"bond_accrual_[n]") AS dirty_nav, sum(bond_accrual) FROM isosel_accrued WHERE instr_type=''Credit Default Swap'' -AND ticker_bbg IS NOT NULL %s GROUP BY period_end_date, ticker_bbg HAVING period_end_date=$1 ) b USING (bbg_id)', and_clause); +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; RETURN QUERY EXECUTE sqlquery USING p_date, strat, p_fund; END; |