diff options
Diffstat (limited to 'python/email_ctm.py')
| -rw-r--r-- | python/email_ctm.py | 19 |
1 files changed, 14 insertions, 5 deletions
diff --git a/python/email_ctm.py b/python/email_ctm.py index 2be8c2e2..d7a07d2a 100644 --- a/python/email_ctm.py +++ b/python/email_ctm.py @@ -2,20 +2,29 @@ from serenitas.utils.db import dbconn from serenitas.utils.exchange import ExchangeMessage conn = dbconn("dawndb") -email_text = """Our firm LMCG Investments is currently working with DTCC to implement DTCC Central Trade Manager – DTCC’s global solution for central matching and confirmation. As part of the implementation effort, your firm has been identified as a key broker partner. +email_text = """Hi All, -Our firm will begin using Omgeo CTM to create electronic trade confirmations for fixed income trades. LMCG Investments BIC is LMCGUS31. Does your firm currently use CTM? If so can you please provide your CTM BIC code +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 -Thank you """ -sql_query = "SELECT name, allocation_contacts FROM counterparties c WHERE cash_counterparty AND allocation_contacts IS NOT null AND code NOT IN ('SCOTIA', );" +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"*Response Requested* CTM Setup {row.name} - LMCG Investments", + 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() |