1 files changed, 25 insertions, 0 deletions
diff --git a/python/fixup.py b/python/fixup.py
new file mode 100644
index 00000000..8b939ff5
--- /dev/null
+++ b/python/fixup.py
@@ -0,0 +1,25 @@
+import csv
+import os.path
+import pdb
+
+if os.name=='nt':
+    root = "//WDSENTINEL/share/CorpCDOs/"
+elif os.name=='posix':
+    root = "/home/share/CorpCDOs/"
+
+root = os.path.join(root, "data")
+fh1 = open(os.path.join(root, "clo_universe_intex_2012-11-20.txt"))
+fh2 = open(os.path.join(root, "clo_universe_intex_2012-11-21.txt"))
+
+dr1 = csv.DictReader(fh1, dialect = 'excel-tab')
+dr2 = csv.DictReader(fh2, dialect = 'excel-tab')
+
+for line1 in dr1:
+    line2 = dr2.next()
+    if line1['Deal,Tr/CUSIP/ISIN'] != line2['Deal,Tr/CUSIP/ISIN']:
+        pdb.set_trace()
+    if line1['Latest Update'] != line2['Latest Update']:
+        print '{0}: {1}   {2}: {3}'.format(line1['Deal,Tr/CUSIP/ISIN'], line1['Latest Update'],
+                                           line2['Deal,Tr/CUSIP/ISIN'], line2['Latest Update'])
+
+