diff options
| -rw-r--r-- | python/csv_headers/globeop_upload.py | 26 | ||||
| -rw-r--r-- | python/reallocate_cash.py | 38 |
2 files changed, 26 insertions, 38 deletions
diff --git a/python/csv_headers/globeop_upload.py b/python/csv_headers/globeop_upload.py index 98e82755..f58b25ed 100644 --- a/python/csv_headers/globeop_upload.py +++ b/python/csv_headers/globeop_upload.py @@ -402,7 +402,6 @@ HEADERS = { ], "trs": HEADERS_PRE + [ - "TradeDate", "Reserved", "Reserved", "ReceiveLegRateType", @@ -511,7 +510,6 @@ HEADERS = { "TradeDateFX", ], "irs": [ - "TradeDate", "Reserved3", "Reserved4", "RecLegType", @@ -645,6 +643,30 @@ HEADERS = { "ReceiveCashFlowStubType", "PayCashFlowStubType", ], + "iam": HEADERS_PRE + + [ + "SettlementDate", + "Reserved", + "InstrumentType", + "ExpirationDate", + "CallNoticeIndicator", + "TransactionIndicator", + "StartMoney", + "Currency", + "Rate", + "Commission", + "DealFunction", + "FromAccount", + "ClientReference", + "Basis", + "MarginType", + "ClearingFacility" "CcpTradeRef", + "BlockId", + "BlockAmount", + "ExecutionDateTimeStamp", + "Collateralized", + "TradeDateFX", + ], "termination": [ "DealType", "DealId", diff --git a/python/reallocate_cash.py b/python/reallocate_cash.py index f04360d3..22252a72 100644 --- a/python/reallocate_cash.py +++ b/python/reallocate_cash.py @@ -8,44 +8,10 @@ from serenitas.utils.env import DAILY_DIR from serenitas.utils.remote import SftpClient from psycopg2.errors import UniqueViolation from serenitas.analytics.dates import bus_day +from csv_headers.globeop_upload import HEADERS -columns = [ - "DealType", - "DealId", - "Action", - "Client", - "Fund", - "Portfolio/Business Unit", - "Strategy", - "Custodian", - "CashAccount", - "Counterparty", - "Comments", - "State", - "TradeDate", - "SettlementDate", - "Reserved", - "InstrumentType", - "ExpirationDate", - "CallNoticeIndicator", - "TransactionIndicator", - "StartMoney", - "Currency", - "Rate", - "Commission", - "DealFunction", - "FromAccount", - "ClientReference", - "Basis", - "MarginType", - "ClearingFacility" "CcpTradeRef", - "BlockId", - "BlockAmount", - "ExecutionDateTimeStamp", - "Collateralized", - "TradeDateFX", -] +columns = HEADERS["iam"] _brokers = { "BAML_ISDA": "BOANNY", "CS": "CSITLN", |