diff options
Diffstat (limited to 'python')
| -rw-r--r-- | python/innocap_bond_setts.py | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/python/innocap_bond_setts.py b/python/innocap_bond_setts.py index 7734d366..91c60ce2 100644 --- a/python/innocap_bond_setts.py +++ b/python/innocap_bond_setts.py @@ -15,7 +15,7 @@ if __name__ == "__main__": ) args = parser.parse_args() conn = dbconn("dawndb") - sql_str = "SELECT settle_date, currency, sum(payment_amount) as payment_amount FROM payment_settlements ps2 WHERE fund=%s AND asset_class in ('bond', 'spot') AND %s < (settle_date + INTERVAL '5' DAY) group by settle_date, currency;" + sql_str = "SELECT settle_date, currency, sum(payment_amount) as payment_amount FROM payment_settlements ps2 WHERE fund=%s AND asset_class in ('bond', 'spot') AND settle_date >= %s group by settle_date, currency;" with conn.cursor() as c: for fund in ("ISOSEL",): c.execute(sql_str, (fund, args.date)) |