diff options
| -rw-r--r-- | python/notify_novations.py | 21 |
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)) |