diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/dawn.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index c89402b5..075e1bdb 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -4879,3 +4879,15 @@ HAVING cr.symbol IN ('EUR Cash Balance', 'USD Cash Balance'); +CREATE OR REPLACE VIEW citco_otc_valuations AS SELECT period_end_date, fund, "prime_broker/clearing_broker", + COALESCE(split_part("strategy", '/', 1), 'CASH') AS portfolio, + COALESCE(split_part("strategy", '/', 2), 'CSH_CASH') AS strategy, + sum(issue_market_value) +FROM citco_reports cr +WHERE trade_ccy IN ('USD', 'EUR') + AND "prime_broker/clearing_broker" LIKE '%_IS' +GROUP BY period_end_date, fund, "prime_broker/clearing_broker", + COALESCE (split_part("strategy", '/', 1), 'CASH'), + COALESCE (split_part("strategy", '/', 2), 'CSH_CASH') ORDER BY period_end_date desc; + + |