diff options
| -rw-r--r-- | python/Dawn/models.py | 2 | ||||
| -rw-r--r-- | python/position.py | 4 | ||||
| -rw-r--r-- | sql/dawn.sql | 2 |
3 files changed, 4 insertions, 4 deletions
diff --git a/python/Dawn/models.py b/python/Dawn/models.py index 61129921..248a6dc7 100644 --- a/python/Dawn/models.py +++ b/python/Dawn/models.py @@ -50,7 +50,7 @@ class Accounts(db.Model): counterparty = db.Column(db.String(12), db.ForeignKey("counterparties.code")) -FUND = ENUM("SERCGMAST", "BRINKER", name="fund") +FUND = ENUM("SERCGMAST", "BRINKER", "BOWDST", name="fund") PORTFOLIO = ENUM( "OPTIONS", diff --git a/python/position.py b/python/position.py index 873cc9ac..5b3157bf 100644 --- a/python/position.py +++ b/python/position.py @@ -381,8 +381,8 @@ if __name__ == "__main__": workdate = pd.Timestamp.now().normalize() with init_bbg_session(BBG_IP) as session: update_securities(dawn_engine, session, workdate) - populate_cashflow_history(dawn_engine, session, workdate, "SERCGMAST") - populate_cashflow_history(dawn_engine, session, workdate, "BRINKER") + for fund in ("SERCGMAST", "BRINKER", "BOWDST"): + populate_cashflow_history(dawn_engine, session, workdate, fund) update_fx(dawn_conn, session, ["EURUSD", "CADUSD"]) update_swap_rates(serenitas_conn, session) update_cash_rates(serenitas_conn, session) diff --git a/sql/dawn.sql b/sql/dawn.sql index b407dad1..cadd077d 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -1534,7 +1534,7 @@ CREATE TYPE portfolio AS ENUM('CASH', 'CLO', 'CURVE', 'GFS_HELPER_BUSINESS_UNIT' 'SERCGLLC__SERCGLLC', 'SERCGLTD__SERCGLTD', 'SER_TEST__SER_TEST', 'STRUCTURED', 'IR', 'TRANCHE'); -CREATE TYPE fund AS ENUM('SERCGLLC', 'SERCGLTD', 'SERCGMAST', 'SER_TEST') +CREATE TYPE fund AS ENUM('SERCGLLC', 'SERCGLTD', 'SERCGMAST', 'SER_TEST', 'BRINKER', 'BOWDST') CREATE TYPE strategy AS ENUM( -- CLO portfolio |