diff options
Diffstat (limited to 'python/cusip_universe.py')
| -rw-r--r-- | python/cusip_universe.py | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/python/cusip_universe.py b/python/cusip_universe.py index f90523b9..eceb3325 100644 --- a/python/cusip_universe.py +++ b/python/cusip_universe.py @@ -21,7 +21,7 @@ conn = psycopg2.connect(database="ET", cursor = conn.cursor() # cursor.execute("delete from cusip_universe") -workdate = '2013-01-15' +workdate = '2013-01-17' count = 0 def sanitize_float(intex_float): @@ -61,6 +61,8 @@ for cusip_universe_file in os.listdir(os.path.join(root, "data", "Trinfo_" + wor if line[key]: line[key] = sanitize_float(line[key]) line[key] = convertToNone(line[key]) + if "Curr Moody" not in line: + line['Curr Moody'] = line['Orig Moody'] sqlstring = "INSERT INTO cusip_universe(cusip, ISIN, dealname, tranche," \ "coupon, Orig_Balance, Curr_Balance, Factor, Orig_moody, Curr_moody, " \ "Orig_attach, Orig_detach, Curr_attach, Curr_detach, Floater_Index," \ @@ -76,3 +78,4 @@ for cusip_universe_file in os.listdir(os.path.join(root, "data", "Trinfo_" + wor cursor.close() conn.close() +print "done" |