diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/dawn.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index 2a35bfc8..4da7a9f0 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -4775,3 +4775,5 @@ FULL OUTER JOIN ( GROUP BY periodenddate, fund, port ) c USING (periodenddate, fund, port); + +CREATE VIEW eur_fx_excess AS SELECT fund, periodenddate, sum(COALESCE (forward_valuations,0) + COALESCE (otc_valuations,0) + COALESCE (cash_valuations,0)) AS eur_excess FROM eur_fx_valuations GROUP BY fund, periodenddate ORDER BY periodenddate DESC;
\ No newline at end of file |