diff options
Diffstat (limited to 'python/load_intex_collateral.py')
| -rw-r--r-- | python/load_intex_collateral.py | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/python/load_intex_collateral.py b/python/load_intex_collateral.py index a568c48e..0ccaa1da 100644 --- a/python/load_intex_collateral.py +++ b/python/load_intex_collateral.py @@ -10,7 +10,7 @@ if os.name=='nt': elif os.name=='posix': root = "/home/share/CorpCDOs/" -fields = ['Asset Name', 'Issuer', 'Current Balance', 'Maturity Date', 'Asset Subtype', \ +fields = ['Asset Name', 'Issuer', 'Contributed Balance', 'Maturity Date', 'Asset Subtype', \ 'Asset Type', 'Gross Coupon', 'Spread', 'Frequency', 'Next Paydate', 'Second Lien', \ 'LoanX ID', 'CUSIP', 'Market Price', 'Market Price Source', 'Price Date', 'Fixed or Float', \ 'Defaulted Flag', 'Security Sub-Category', 'Structured Finance Security'] @@ -59,8 +59,8 @@ for dealname in os.listdir(os.path.join(root, "Collaterals_" + workdate)): line[field] = - float(prog.match(line[field]).group(1)) if line['Market Price'] != '' and isinstance(line['Market Price'], str): line['Market Price'] = float(line['Market Price'].replace(',','')) - if isinstance(line['Current Balance'], str): - line['Current Balance'] = float(line['Current Balance'].replace(',','')) + if isinstance(line['Contributed Balance'], str): + line['Contributed Balance'] = float(line['Contributed Balance'].replace(',','')) try: r = [convertToNone(line[field]) for field in fields] except KeyError as detail: |