diff options
Diffstat (limited to 'python/populate_tranche_cashflows.py')
| -rw-r--r-- | python/populate_tranche_cashflows.py | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/python/populate_tranche_cashflows.py b/python/populate_tranche_cashflows.py index 2b1355a1..971b3043 100644 --- a/python/populate_tranche_cashflows.py +++ b/python/populate_tranche_cashflows.py @@ -62,8 +62,8 @@ def insert_tranche_accrued(d: datetime.date, dawndb, funds=("SERCGMAST",)): for t in portf: c.execute( "INSERT INTO tranche_cashflows(date, tranche_id, accrued, currency) " - "ON CONFLICT (date, tranche_id) DO NOTHING" - "VALUES(%s, %s, %s, %s)", + "VALUES(%s, %s, %s, %s) " + "ON CONFLICT (date, tranche_id) DO NOTHING ", ( t.cs["payment_dates"][0], t.trade_id, @@ -102,4 +102,4 @@ if __name__ == "__main__": serenitas.analytics._include_todays_cashflows = True funds = ("SERCGMAST", "BOWDST", "BRINKER", "ISOSEL") - insert_tranche_accrued(datetime.date(2022, 12, 16), dawndb, funds) + insert_tranche_accrued(datetime.date(2023, 3, 15), dawndb, funds) |