diff options
Diffstat (limited to 'python/ctm_allocation.py')
| -rw-r--r-- | python/ctm_allocation.py | 7 |
1 files changed, 0 insertions, 7 deletions
diff --git a/python/ctm_allocation.py b/python/ctm_allocation.py index 8a4d6581..9e4eb419 100644 --- a/python/ctm_allocation.py +++ b/python/ctm_allocation.py @@ -19,13 +19,6 @@ if __name__ == "__main__": args = parser.parse_args() dawndb = dbconn("dawndb") - alert = { - "SERCGMAST": "Serenitas Credit Gamma Master Fund", - "BOWDST": "Bowdoin St. (ALERT acronym: LMUNDER, Account: SER003)", - "BRINKER": "Brinker Destinations Multi-Strategy Alternatives - LMCG", - "ISOSEL": "ISO Selene (ALERT acronym: LMUNDER, Account: SER004)", - } - df = pd.read_sql_query( "SELECT ba.id, allocated, emailed FROM bonds LEFT JOIN bond_allocation ba ON bonds.id=ba.tradeid LEFT JOIN counterparties c ON cp_code=c.code WHERE trade_date=%s AND ctm_code IS NOT null;", con=dawn_engine, |