diff options
Diffstat (limited to 'python/monthend_recon_bowdst.py')
| -rw-r--r-- | python/monthend_recon_bowdst.py | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/python/monthend_recon_bowdst.py b/python/monthend_recon_bowdst.py index 7bc89a9d..346a3e50 100644 --- a/python/monthend_recon_bowdst.py +++ b/python/monthend_recon_bowdst.py @@ -130,13 +130,13 @@ def recon(date, conn): conn, params=(date, asset), ) - bond_trades = bowd_bond_trades.merge( db_bond_trades, left_on="mellon_security_id", - right_on="identifier", + right_on="cusip", how="right", - )[ + ) + bond_trades = bond_trades[ [ "description", "identifier", @@ -145,6 +145,7 @@ def recon(date, conn): "current_notional", "base_market_value", "usd_market_value", + "cusip_y", ] ] bond_trades["db_notional"] = bond_trades["notional"] * bond_trades["factor"] |