diff options
Diffstat (limited to 'python/bondallocation_email.py')
| -rw-r--r-- | python/bondallocation_email.py | 9 |
1 files changed, 7 insertions, 2 deletions
diff --git a/python/bondallocation_email.py b/python/bondallocation_email.py index ba1b9bd8..180f8bf3 100644 --- a/python/bondallocation_email.py +++ b/python/bondallocation_email.py @@ -5,14 +5,19 @@ import pandas as pd from io import StringIO import datetime import argparse +from pandas.tseries.offsets import BDay + if __name__ == "__main__": parser = argparse.ArgumentParser() parser.add_argument( - "--trade_date", type=datetime.date.fromisoformat, default=datetime.date.today() + "--trade_date", + type=datetime.date.fromisoformat, + default=(datetime.date.today() - BDay(1)).date(), ) args = parser.parse_args() dawndb = dbconn("dawndb") + breakpoint() alert = { "SERCGMAST": "Serenitas Credit Gamma Master Fund", @@ -21,7 +26,7 @@ if __name__ == "__main__": } df = pd.read_sql_query( - "SELECT bonds.id as tradeid, trade_date, settle_date, CASE WHEN buysell THEN 'Buy' ELSE 'Sell' end as buysell, identifier, description , faceamount AS notional, price, accrued, principal_payment + accrued_payment as net_amount, name as counterparty, allocation_contacts FROM bonds LEFT JOIN counterparties on cp_code=code WHERE trade_date = %s and not EMAILED and allocated;", + "SELECT bonds.id as tradeid, trade_date, settle_date, CASE WHEN buysell THEN 'Buy' ELSE 'Sell' end as buysell, identifier, description , faceamount AS notional, price, accrued, principal_payment + accrued_payment as net_amount, name as counterparty, allocation_contacts FROM bonds LEFT JOIN counterparties on cp_code=code WHERE trade_date >= %s and not EMAILED and allocated;", con=dawndb, params=(args.trade_date,), ) |