aboutsummaryrefslogtreecommitdiffstats
path: root/python
diff options
context:
space:
mode:
Diffstat (limited to 'python')
-rw-r--r--python/baml.py6
1 files changed, 1 insertions, 5 deletions
diff --git a/python/baml.py b/python/baml.py
index e6ee117f..688ca3a1 100644
--- a/python/baml.py
+++ b/python/baml.py
@@ -1,12 +1,8 @@
-from collateral.baml_isda import download_from_secure_id
-from bs4 import BeautifulSoup
import logging
import pandas as pd
from serenitas.utils.env import DAILY_DIR
-from urllib.parse import urlsplit, parse_qs, urlunsplit
from serenitas.utils.db import dawn_engine
import datetime
-from serenitas.analytics.dates import prev_business_day
from collateral.baml_isda import read_secure_message
logger = logging.getLogger(__name__)
@@ -43,6 +39,7 @@ def load_cash_report(workdate: datetime.date):
"Portfolio ID",
"Information As Of",
],
+ parse_dates=["Information As Of"],
)
df = (
df[df["Asset Class"] == "CASH AND EQUIVALENTS"]
@@ -61,7 +58,6 @@ def load_cash_report(workdate: datetime.date):
},
axis=1,
)
- df["date"] = pd.to_datetime(df["date"])
df["fund"] = "SERCGMAST"
df.to_sql("cash_balances", dawn_engine, if_exists="append", index=False)