diff options
Diffstat (limited to 'python/intex/load_indicative.py')
| -rw-r--r-- | python/intex/load_indicative.py | 9 |
1 files changed, 6 insertions, 3 deletions
diff --git a/python/intex/load_indicative.py b/python/intex/load_indicative.py index 3686aa85..84b7f653 100644 --- a/python/intex/load_indicative.py +++ b/python/intex/load_indicative.py @@ -1,25 +1,27 @@ import psycopg2 import os import datetime -from datetime import date -import csv, sys, re +import csv import pdb from common import sanitize_float from db import dbconn from contextlib import closing import logging +import re +import sys logger = logging.getLogger(__name__) def convertToNone(s): return None if s in ["", "-", "NR"] else s + def insert_new_cusip(conn, line): if line['Pari-Passu Tranches']: line['Pari-Passu Tranches'] = line['Pari-Passu Tranches'].split(",") to_insert = (line['CUSIP'], line['ISIN'], line['Bloomberg Ticker'], line['dealname'], line['tranche'], line['Pari-Passu Tranches']) - for key in ['Orig Balance', 'Orig Attachment Point','Orig Detachment Point', + for key in ['Orig Balance', 'Orig Attachment Point', 'Orig Detachment Point', 'Floater Spread/Margin']: if line[key]: line[key] = sanitize_float(line[key]) @@ -35,6 +37,7 @@ def insert_new_cusip(conn, line): logger.error(e) conn.commit() + def upload_cusip_data(conn, filename): dealupdate = {} with open( filename, "r") as fh: |