diff options
Diffstat (limited to 'python')
| -rw-r--r-- | python/baml_fcm_fx.py | 2 | ||||
| -rw-r--r-- | python/report_ops/fcm.py | 86 | ||||
| -rw-r--r-- | python/report_ops/utils.py | 80 |
3 files changed, 87 insertions, 81 deletions
diff --git a/python/baml_fcm_fx.py b/python/baml_fcm_fx.py index 927f8b02..45c57fb0 100644 --- a/python/baml_fcm_fx.py +++ b/python/baml_fcm_fx.py @@ -1,5 +1,5 @@ import datetime -from report_ops.utils import BamlFcmNotify +from report_ops.fcm import BamlFcmNotify from serenitas.utils.db2 import dbconn from tabulate import tabulate diff --git a/python/report_ops/fcm.py b/python/report_ops/fcm.py new file mode 100644 index 00000000..6bff38ff --- /dev/null +++ b/python/report_ops/fcm.py @@ -0,0 +1,86 @@ +from .misc import _recipients +import datetime +from serenitas.utils.exchange import ExchangeMessage +from tabulate import tabulate +from exchangelib import HTMLBody +from dataclasses import dataclass + + +@dataclass +class BamlFcmNotify: + account: str + curr: str + totbal: float + homecurrency: str + fxrate: float + convtotbal: float + buysell: bool + valuedate: datetime.date + + @classmethod + def from_dict(cls, d): + _fcm_alias = {"V0NSCLMSPT": "6MZ20049"} + if d["sell_currency"] == "USD": + key1, key2 = "buy", "sell" + else: + key1, key2 = "sell", "buy" + return cls( + account=_fcm_alias.get(d["cash_account"], d["cash_account"]), + curr=d[f"{key1}_currency"], + totbal=d[f"{key1}_amount"], + homecurrency=d[f"{key2}_currency"], + fxrate=d["spot_rate"], + convtotbal=d[f"{key2}_amount"], + buysell="Buy" if d["sell_currency"] == "USD" else "Sell", + valuedate=d["settle_date"], + ) + + def to_list(self): + return list(self.__dict__.values()) + + def to_tabulate(self): + line = self.to_list() + num_format = [("{0:,.2f}", 2), ("{0:.5f}", 4), ("{0:,.2f}", 5)] + for f, i in num_format: + line[i] = f.format(line[i]) + return tabulate( + [line], + headers=[ + "account", + "curr", + "TotBal", + "HomeCurrency", + "fxRate", + "convTotBal", + "BuySell", + "Value Date", + ], + tablefmt="unsafehtml", + ) + + def email_fcm(self, trade_date): + em = ExchangeMessage() + em.send_email( + f"FX Details: {self.account} Trade Date: {trade_date}", + HTMLBody( + f""" +<html> + <head> + <style> + table, th, td {{ border: 1px solid black; border-collapse: collapse;}} + th, td {{ padding: 5px; }} + </style> + </head> + <body> + Hello,<br><br>Please see below details for an FX Spot Trade we did with the desk today for account {self.account} Please let me know if you need more information.<br><br>{self.to_tabulate()} + </body> +</html>""" + ), + to_recipients=_recipients["BAML_FCM"], + cc_recipients=_recipients["NYOPS"], + ) + + @classmethod + def process(cls, trade_date, d): + trade = cls.from_dict(d) + trade.email_fcm(trade_date) diff --git a/python/report_ops/utils.py b/python/report_ops/utils.py index 463e5112..b624b1f8 100644 --- a/python/report_ops/utils.py +++ b/python/report_ops/utils.py @@ -276,86 +276,6 @@ class GFSMonitor(Payment): @dataclass -class BamlFcmNotify: - account: str - curr: str - totbal: float - homecurrency: str - fxrate: float - convtotbal: float - buysell: bool - valuedate: datetime.date - - @classmethod - def from_dict(cls, d): - _fcm_alias = {"V0NSCLMSPT": "6MZ20049"} - if d["sell_currency"] == "USD": - key1, key2 = "buy", "sell" - else: - key1, key2 = "sell", "buy" - return cls( - account=_fcm_alias.get(d["cash_account"], d["cash_account"]), - curr=d[f"{key1}_currency"], - totbal=d[f"{key1}_amount"], - homecurrency=d[f"{key2}_currency"], - fxrate=d["spot_rate"], - convtotbal=d[f"{key2}_amount"], - buysell="Buy" if d["sell_currency"] == "USD" else "Sell", - valuedate=d["settle_date"], - ) - - def to_list(self): - return list(self.__dict__.values()) - - def to_tabulate(self): - line = self.to_list() - num_format = [("{0:,.2f}", 2), ("{0:.5f}", 4), ("{0:,.2f}", 5)] - for f, i in num_format: - line[i] = f.format(line[i]) - return tabulate( - [line], - headers=[ - "account", - "curr", - "TotBal", - "HomeCurrency", - "fxRate", - "convTotBal", - "BuySell", - "Value Date", - ], - tablefmt="unsafehtml", - ) - - def email_fcm(self, trade_date): - em = ExchangeMessage() - em.send_email( - f"FX Details: {self.account} Trade Date: {trade_date}", - HTMLBody( - f""" -<html> - <head> - <style> - table, th, td {{ border: 1px solid black; border-collapse: collapse;}} - th, td {{ padding: 5px; }} - </style> - </head> - <body> - Hello,<br><br>Please see below details for an FX Spot Trade we did with the desk today for account {self.account} Please let me know if you need more information.<br><br>{self.to_tabulate()} - </body> -</html>""" - ), - to_recipients=_recipients["BAML_FCM"], - cc_recipients=_recipients["NYOPS"], - ) - - @classmethod - def process(cls, trade_date, d): - trade = cls.from_dict(d) - trade.email_fcm(trade_date) - - -@dataclass class EmailOps: _em = ExchangeMessage() |
