diff options
Diffstat (limited to 'python')
| -rw-r--r-- | python/analytics/__init__.py | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/python/analytics/__init__.py b/python/analytics/__init__.py index 83fab3eb..62933b5b 100644 --- a/python/analytics/__init__.py +++ b/python/analytics/__init__.py @@ -23,8 +23,13 @@ import datetime def on_the_run(index, value_date=datetime.date.today()): + if index == "HY": + interval = "+ INTERVAL '7 days'" + else: + interval = "" r = serenitas_engine.execute( - "SELECT max(series) FROM index_maturity WHERE index=%s " "and issue_date <= %s", + "SELECT max(series) FROM index_maturity WHERE index=%s " + f"AND issue_date {interval}<= %s", (index, value_date), ) series, = r.fetchone() |