diff options
Diffstat (limited to 'python/intex/load_indicative.py')
| -rw-r--r-- | python/intex/load_indicative.py | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/python/intex/load_indicative.py b/python/intex/load_indicative.py index 322c45ad..67bb94e9 100644 --- a/python/intex/load_indicative.py +++ b/python/intex/load_indicative.py @@ -133,7 +133,7 @@ def upload_deal_data(conn, filename): pdb.set_trace() if line["Pay Day"]: line["Pay Day"] = line["Pay Day"].day - for key in ["Collection Account Principal Balance", "Collection Account Interest Balance", + for key in ["Principal Collection Account", "Interest Collection Account", "Curr Deal Bal", "Tranche Curr Bal", "CDOpercent", "defaultedbal"]: if line[key]: line[key] = sanitize_float(line[key]) @@ -164,8 +164,8 @@ def upload_deal_data(conn, filename): sqlstring = \ "INSERT INTO clo_universe " \ "VALUES (%(Deal/Tranche ID)s, %(Curr Deal Bal)s, %(Tranche Curr Bal)s, " \ - "%(Tranche Factor)s, %(Collection Account Principal Balance)s, " \ - "%(Collection Account Interest Balance)s, %(CDOpercent)s, %(defaultedbal)s, " \ + "%(Tranche Factor)s, %(Principal Collection Account)s, " \ + "%(Interest Collection Account)s, %(CDOpercent)s, %(defaultedbal)s, " \ "%(Coupon)s, %(Latest Update)s)" try: with conn.cursor() as c: |