diff options
Diffstat (limited to 'python/load_indicative.py')
| -rw-r--r-- | python/load_indicative.py | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/python/load_indicative.py b/python/load_indicative.py index c8b1ac91..8fd75b6e 100644 --- a/python/load_indicative.py +++ b/python/load_indicative.py @@ -57,7 +57,11 @@ def upload_cusip_data(conn, filename): line['Curr Attachment Point'] = line['Curr Attachment Point (def at MV)'] line['Curr Detachment Point'] = line['Curr Detachment Point (def at MV)'] if "Curr Moody" not in line: - line['Curr Moody'] = line['Orig Moody'] + if 'Orig Moody' in line: + line['Curr Moody'] = line['Orig Moody'] + else: + line['Curr Moody'] = None + line['Orig Moody'] = None sqlstring = "INSERT INTO cusip_universe(Cusip, ISIN, \"Bloomberg Ticker\", dealname, tranche, " \ "Coupon, Orig_Balance, Curr_Balance, Factor, Orig_Moody, Curr_Moody, " \ "Orig_Attach, Orig_Detach, Curr_Attach, Curr_Detach, Floater_Index, " \ |