diff options
Diffstat (limited to 'python')
| -rw-r--r-- | python/citco_ops/utils.py | 1 | ||||
| -rw-r--r-- | python/innocap_bond_setts.py | 2 |
2 files changed, 1 insertions, 2 deletions
diff --git a/python/citco_ops/utils.py b/python/citco_ops/utils.py index f3611198..f27cae93 100644 --- a/python/citco_ops/utils.py +++ b/python/citco_ops/utils.py @@ -265,7 +265,6 @@ class PaymentSettlement(Payment): @classmethod def subtract_cash_balance(cls, account_balance): - overdraft = [] for settlement in cls._insert_queue: settlement.amount = Decimal(account_balance[settlement.currency]) - ( -settlement.amount diff --git a/python/innocap_bond_setts.py b/python/innocap_bond_setts.py index 8fd10db2..9e9ec570 100644 --- a/python/innocap_bond_setts.py +++ b/python/innocap_bond_setts.py @@ -24,7 +24,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 settle_date BETWEEN %s AND %s AND currency=%s group by settle_date, currency;" + sql_str = "SELECT currency, sum(payment_amount) as payment_amount FROM payment_settlements ps2 WHERE fund=%s AND asset_class in ('bond', 'spot') AND settle_date BETWEEN %s AND %s AND currency=%s group by currency;" cash_balances = get_cash_balance("ISOS01", prev_business_day(args.date), conn) with conn.cursor() as c: for fund in ("ISOSEL",): |