aboutsummaryrefslogtreecommitdiffstats
path: root/python
diff options
context:
space:
mode:
Diffstat (limited to 'python')
-rw-r--r--python/baml_fcm_fx.py2
-rw-r--r--python/report_ops/fcm.py86
-rw-r--r--python/report_ops/utils.py80
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()