diff options
Diffstat (limited to 'python/analytics/index.py')
| -rw-r--r-- | python/analytics/index.py | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/python/analytics/index.py b/python/analytics/index.py index ac3c435b..73d7c9bb 100644 --- a/python/analytics/index.py +++ b/python/analytics/index.py @@ -105,7 +105,9 @@ class CreditIndex(CreditDefaultSwap): @classmethod def from_tradeid(cls, trade_id): r = dawn_engine.execute(""" - SELECT * FROM cds + SELECT index, series, tenor, trade_date, notional, security_desc, + protection, upfront + FROM cds LEFT JOIN index_desc ON security_id = redindexcode AND cds.maturity = index_desc.maturity WHERE id=%s""", (trade_id,)) |