diff options
Diffstat (limited to 'python')
| -rw-r--r-- | python/analytics/index_data.py | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/python/analytics/index_data.py b/python/analytics/index_data.py index 682c5981..94a45eff 100644 --- a/python/analytics/index_data.py +++ b/python/analytics/index_data.py @@ -19,8 +19,8 @@ def insert_quotes(): We can also do it in sql as follows: - INSERT INTO index_quotes(date, index, series, version, tenor, closeprice) - SELECT date, index, series, version+1, tenor, (factor1*closeprice-100*0.355)/factor2 + INSERT INTO index_quotes_pre(date, index, series, version, tenor, close_price, source) + SELECT date, index, series, version+1, tenor, (factor1*closeprice-100*0.355)/factor2, 'MKIT' FROM index_quotes WHERE index='HY' and series=23 and date='2017-02-02' |