diff options
Diffstat (limited to 'python/collateral/baml_fcm.py')
| -rw-r--r-- | python/collateral/baml_fcm.py | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/python/collateral/baml_fcm.py b/python/collateral/baml_fcm.py index 1d986941..f89bbc8f 100644 --- a/python/collateral/baml_fcm.py +++ b/python/collateral/baml_fcm.py @@ -95,10 +95,16 @@ def collateral(d, positions, *, engine, fund="Serenitas", positions_irs, **kwarg "NOTIONAL", "EFFDATE", "MATDATE", + "LEG1ROLLCONV", ], - index_col=["CLEAREDTRADEID"], parse_dates=["MATDATE", "EFFDATE"], ) + df_rates.loc[df_rates["DIRECTION"] == "Rec", "NOTIONAL"] *= -1 + df_rates["FIXEDRATE"] = df_rates["FIXEDRATE"].round(4) + df_rates = df_rates.groupby(by=["MATDATE", "FIXEDRATE", "LEG1ROLLCONV"]).agg( + {"NOTIONAL": "sum", "NPV": "sum"} + ) + df_rates.index.names = ["maturity_date", "fixed_rate", "roll_day"] compare_notionals_rates(df_rates, positions_irs, "BAML") positions_irs["Amount"] = df_rates.reindex(positions_irs.index)["NPV"] positions_irs.folder.replace(STRATEGY_CASH_MAPPING, inplace=True) |