diff options
Diffstat (limited to 'python')
| -rw-r--r-- | python/bondallocation_email.py | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/python/bondallocation_email.py b/python/bondallocation_email.py index cd425928..1e805988 100644 --- a/python/bondallocation_email.py +++ b/python/bondallocation_email.py @@ -32,14 +32,16 @@ if __name__ == "__main__": with dawndb.cursor() as d: for row in df.itertuples(): d.execute( - f"SELECT tradeid, notional, fund FROM bond_allocation LEFT JOIN accounts a USING (code) WHERE account_type='Cash' AND active AND tradeid=%s;", + "SELECT tradeid, notional, fund FROM bond_allocation " + "LEFT JOIN accounts a USING (code) WHERE account_type='Cash' " + "AND active AND tradeid=%s;", (row.tradeid,), ) em = ExchangeMessage() subject = ( f"LMCG - Trade Allocations - TD {row.trade_date} - {row.counterparty}" ) - cc_recipients = ("fyu@lmcg.com", "NYOps@lmcg.com") + cc_recipients = ("NYOps@lmcg.com",) allocations = [ "<li>" + f" {row.notional:,.0f} to {alert[row.fund]}" + "</li>" for row in d |