diff options
Diffstat (limited to 'python')
| -rw-r--r-- | python/email_ctm.py | 30 |
1 files changed, 0 insertions, 30 deletions
diff --git a/python/email_ctm.py b/python/email_ctm.py deleted file mode 100644 index d7a07d2a..00000000 --- a/python/email_ctm.py +++ /dev/null @@ -1,30 +0,0 @@ -from serenitas.utils.db import dbconn -from serenitas.utils.exchange import ExchangeMessage - -conn = dbconn("dawndb") -email_text = """Hi All, - -Our firm LMCG Investments recently reached out about moving over to Omgeo CTM. - -Our firm will begin using Omgeo CTM to create electronic trade confirmations for fixed income trades on Monday October 10th, 2022. On that date please forward trade information to Omgeo CTM via our firm’s CTM BIC -LMCGUS31. - -Our firm would like to thank you in advance for your cooperation. Should you have any questions or would like additional information, please do not hesitate to contact us or DTCC’s Client Support Center at the numbers listed below: - -Americas: 877.664.3625 -Asia-Pacific: 65.6323.1238 -EMEA: 44.20.7369.7090 - -""" -sql_query = "SELECT name, allocation_contacts FROM counterparties c WHERE cash_counterparty AND allocation_contacts IS NOT null AND code NOT IN ('SCOTIA', ) and ctm_code is not null;" -with conn.cursor() as c: - c.execute(sql_query) - em = ExchangeMessage() - for row in c: - em.send_email( - f"*CTM Go Live Date October 10, 2022 {row.name} - LMCG Investments*", - email_text, - to_recipients=row.allocation_contacts, - cc_recipients=("fyu@lmcg.com", "jreha@lmcg.com"), - ) - breakpoint() |