diff options
Diffstat (limited to 'python/load_indicative.py')
| -rw-r--r-- | python/load_indicative.py | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/python/load_indicative.py b/python/load_indicative.py index 864d609e..8ee2d222 100644 --- a/python/load_indicative.py +++ b/python/load_indicative.py @@ -113,12 +113,13 @@ def upload_deal_data(conn, filename): line["Paid Down"] = re.sub("Paid Down: ","", line["Latest Update"]) line["Latest Update"] = line["Paid Down"] for field in ["Deal Issue Date", "Deal Termination Date", \ - "Deal Next Pay Date", "Reinv End Date", "Latest Update"]: + "Deal Next Pay Date", "Reinv End Date", "Latest Update", "Pay Day"]: if line[field]: try: line[field] = datetime.datetime.strptime(line[field], '%b %d, %Y').date() except ValueError: pdb.set_trace() + for key in ["Collection Account Principal Balance", "Collection Account Interest Balance", "Orig Deal Bal", "Curr Deal Bal", "Tranche Curr Bal", "Tranche Orig Bal", "CDO Pct of Assets that are Structured Finance Obligations", @@ -137,8 +138,8 @@ def upload_deal_data(conn, filename): "%(Collection Account Principal Balance)s," \ "%(Collection Account Interest Balance)s, %(CDOpercent)s, %(defaultedbal)s, " \ "%(Coupon)s, %(Deal Issue Date)s," \ - "%(Deal Termination Date)s, %(Deal Next Pay Date)s," \ - "%(Reinv End Date)s, %(Latest Update)s, %(Deal CUSIP List)s, %(Paid Down)s)" + "%(Deal Termination Date)s, %(Deal Next Pay Date)s, %(Reinv End Date)s, " \ + "%(Latest Update)s, %(Deal CUSIP List)s, %(Paid Down)s, %(Pay Day)s)" try: with conn.cursor() as c: c.execute(sqlstring, line) |