diff options
| -rw-r--r-- | python/globeop_monitor.py (renamed from python/gfs_monitor.py) | 0 | ||||
| -rw-r--r-- | python/innocap.py (renamed from python/innocap_file_transfer.py) | 0 | ||||
| -rw-r--r-- | python/innocap_bond_setts.py | 40 | ||||
| -rw-r--r-- | scripts/globeop_monitor.timer (renamed from scripts/gfs_monitor.timer) | 4 | ||||
| -rw-r--r-- | scripts/innocap.timer | 10 | ||||
| -rw-r--r-- | scripts/innocap_citco_files.timer | 10 |
6 files changed, 12 insertions, 52 deletions
diff --git a/python/gfs_monitor.py b/python/globeop_monitor.py index 0c3ff512..0c3ff512 100644 --- a/python/gfs_monitor.py +++ b/python/globeop_monitor.py diff --git a/python/innocap_file_transfer.py b/python/innocap.py index 191901f1..191901f1 100644 --- a/python/innocap_file_transfer.py +++ b/python/innocap.py diff --git a/python/innocap_bond_setts.py b/python/innocap_bond_setts.py deleted file mode 100644 index 6a5b6281..00000000 --- a/python/innocap_bond_setts.py +++ /dev/null @@ -1,40 +0,0 @@ -import datetime -from serenitas.utils.db import dbconn -from report_ops.utils import PaymentSettlement, next_business_days -from serenitas.analytics.dates import prev_business_day - - -def get_cash_balance(account_number, date, conn): - with conn.cursor() as c: - sql_str = "SELECT balance, currency_code from cash_balances WHERE account_number=%s AND date=%s" - c.execute(sql_str, (account_number, date)) - return {row.currency_code: row.balance for row in c} - - -if __name__ == "__main__": - import argparse - - parser = argparse.ArgumentParser() - parser.add_argument( - "date", - nargs="?", - type=datetime.date.fromisoformat, - default=datetime.date.today(), - help="working date", - ) - args = parser.parse_args() - conn = dbconn("dawndb") - 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",): - for date in ( - args.date, - next_business_days(args.date, 1), - next_business_days(args.date, 2), - ): - for currency in ("USD", "EUR"): - params = (fund, args.date, date, currency) - c.execute(sql_str, params) - PaymentSettlement.stage_payment(c, date) - PaymentSettlement.email_innocap(args.date, cash_balances) diff --git a/scripts/gfs_monitor.timer b/scripts/globeop_monitor.timer index e962afc0..85bedfff 100644 --- a/scripts/gfs_monitor.timer +++ b/scripts/globeop_monitor.timer @@ -1,9 +1,9 @@ [Unit] -Description=Monitor GFS Helper Strategy +Description=Monitor globeop reports [Timer] OnCalendar=Mon..Fri 10:00 -Unit=simple@gfs_monitor.service +Unit=simple@globeop_monitor.service RandomizedDelaySec=1m [Install] diff --git a/scripts/innocap.timer b/scripts/innocap.timer new file mode 100644 index 00000000..6b0db007 --- /dev/null +++ b/scripts/innocap.timer @@ -0,0 +1,10 @@ +[Unit] +Description=Handle daily operations for innocap + +[Timer] +OnCalendar=Mon..Fri 10:00 +Unit=simple@innocap.service +RandomizedDelaySec=1m + +[Install] +WantedBy=timers.target diff --git a/scripts/innocap_citco_files.timer b/scripts/innocap_citco_files.timer deleted file mode 100644 index f9cec7a5..00000000 --- a/scripts/innocap_citco_files.timer +++ /dev/null @@ -1,10 +0,0 @@ -[Unit] -Description=Upload Citco Positions and Trades from previous business day to Innocap for reconcilliation - -[Timer] -OnCalendar=Mon..Fri 10:00 -Unit=simple@innocap_file_transfer.service -RandomizedDelaySec=1m - -[Install] -WantedBy=timers.target |