diff options
Diffstat (limited to 'python')
| -rw-r--r-- | python/trade_dataclasses.py | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/python/trade_dataclasses.py b/python/trade_dataclasses.py index 880ec00d..2c278672 100644 --- a/python/trade_dataclasses.py +++ b/python/trade_dataclasses.py @@ -361,7 +361,8 @@ class CDSDeal( if line["Coupon"] == "": with cls._conn.cursor() as c: c.execute( - "SELECT coupon, index, series, tenor FROM index_maturity_markit LEFT JOIN index_version USING (redindexcode) WHERE redindexcode=%s AND maturity =%s;", + "SELECT coupon, index, series, tenor FROM index_desc " + "WHERE redindexcode=%s AND maturity =%s", ( line["Red Code"], datetime.datetime.strptime(line["Mat Dt"], "%m/%d/%Y").date(), |