1 files changed, 21 insertions, 0 deletions
diff --git a/python/notify_novations.py b/python/notify_novations.py
new file mode 100644
index 00000000..aee6718b
--- /dev/null
+++ b/python/notify_novations.py
@@ -0,0 +1,21 @@
+import datetime
+from mtm_status import get_latest_file
+
+
+def contact_novation_counterparties(date):
+    df = get_latest_file(date)
+    df = df[
+        (df["SwapType"].isin(["ASGM"]))
+        & (df["ThirdPartyStatus.1"].isin(["Pending Consent"]))
+    ]
+    df = (
+        df.groupby(["ExecutingBroker", "RemainingBroker"])["Novation Consent ID"]
+        .apply(list)
+        .reset_index()
+    )
+    for row in df.itertuples():
+        print(row.ExecutingBroker, row.RemainingBroker, row[3])
+
+
+if __name__ == "__main__":
+    contact_novation_counterparties(datetime.date(2023, 3, 14))