diff options
Diffstat (limited to 'python/baml_fcm_fx.py')
| -rw-r--r-- | python/baml_fcm_fx.py | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/python/baml_fcm_fx.py b/python/baml_fcm_fx.py index 4c0d327e..1c7984bb 100644 --- a/python/baml_fcm_fx.py +++ b/python/baml_fcm_fx.py @@ -22,7 +22,7 @@ def email_fcm(em, d, fund): </style> </head> <body> - Hello,<br><br>Please see below details for an FX Spot Trade we did with the desk today for account {fcm_account} Please let me know if you need more information.<br><br>{to_tabulate(d)} + Hello,<br><br>Please see below details for an FX Spot Trade we did with the desk today for account {fcm_account}. Please let me know if you need more information.<br><br>{to_tabulate(d)} </body> </html>""" ), @@ -71,7 +71,9 @@ def to_tabulate(d): def main(trade_date, conn, fund, em): with conn.cursor() as c: c.execute( - "SELECT spots.cash_account, buy_currency, sell_currency, buy_amount, sell_amount, spot_rate, settle_date, trade_date FROM spots LEFT JOIN accounts2 USING (cash_account) WHERE account_type='Fcm' AND spots.cp_code='BAMSNY' AND spots.trade_date =%s AND spots.fund=%s", + "SELECT spots.cash_account, buy_currency, sell_currency, buy_amount, sell_amount, spot_rate, settle_date, trade_date FROM spots " + "LEFT JOIN accounts2 USING (cash_account) " + "WHERE account_type='Fcm' AND spots.cp_code='BAMSNY' AND spots.trade_date =%s AND spots.fund=%s", (trade_date, fund), ) for rec in c: |