diff options
Diffstat (limited to 'python/innocap.py')
| -rw-r--r-- | python/innocap.py | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/python/innocap.py b/python/innocap.py index cdd84213..dd2337d6 100644 --- a/python/innocap.py +++ b/python/innocap.py @@ -10,7 +10,7 @@ from serenitas.analytics.dates import prev_business_day, next_business_day from report_ops.sma import build_position_file from report_ops.utils import SettlementMonitor -settlement_sum_query = "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 account NOT IN ('Bank of America FCM Selene') group by currency;" +settlement_sum_query = "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 account NOT IN ('BoA FCM Selene') group by currency;" _account_fund = {"ISOS01": "ISOSEL"} |