diff options
Diffstat (limited to 'python/bondallocation_email.py')
| -rw-r--r-- | python/bondallocation_email.py | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/python/bondallocation_email.py b/python/bondallocation_email.py index 8d150db3..6e80a3a9 100644 --- a/python/bondallocation_email.py +++ b/python/bondallocation_email.py @@ -26,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 AND ctm_code;", + "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 AND ctm_code is NULL;", con=dawn_engine, params=(args.trade_date,), ) |