diff options
| -rw-r--r-- | python/strat_cash_realloc.py | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/python/strat_cash_realloc.py b/python/strat_cash_realloc.py index 89147b75..f639b654 100644 --- a/python/strat_cash_realloc.py +++ b/python/strat_cash_realloc.py @@ -48,6 +48,8 @@ CASH_STRATEGY_MAPPING = { "MBSCDSCSH": [ "HEDGE_MBS", "MBSCDS", + ], + "M_CSH_CASH": [ "CRT_LD", "CRT_LD_JNR", "CRT_SD", @@ -68,7 +70,7 @@ dawndb = dbconn("dawndb") with dawndb.cursor() as c, dawndb.cursor() as d: date = datetime.date(2022, 5, 18) c.execute( - "SELECT endqty, port, strat, custacctname, invid, custodian, cp_code FROM valuation_reports vr LEFT JOIN accounts2 ON custacctname=cash_account WHERE periodenddate =%s AND vr.fund='BOWDST' AND invid IN ('USD','EUR') AND port NOT IN ('CASH', 'GFS_HELPER_BUSINESS_UNIT') and endqty >0;", + "SELECT endqty, port, strat, custacctname, invid, custodian, cp_code FROM valuation_reports vr LEFT JOIN accounts2 ON custacctname=cash_account WHERE periodenddate =%s AND vr.fund='BOWDST' AND invid IN ('USD','EUR') AND port NOT IN ('CASH', 'GFS_HELPER_BUSINESS_UNIT') and endqty !=0;", (date,), ) trades = [] @@ -95,7 +97,6 @@ with dawndb.cursor() as c, dawndb.cursor() as d: "custacctname": "Cash Account", "custodian": "Custodian", "cp_code": "Counterparty", - "port": "Portfolio", "strat": "Folder", }, ) |