aboutsummaryrefslogtreecommitdiffstats
path: root/python/external_deriv_marks.py
diff options
context:
space:
mode:
Diffstat (limited to 'python/external_deriv_marks.py')
-rw-r--r--python/external_deriv_marks.py9
1 files changed, 5 insertions, 4 deletions
diff --git a/python/external_deriv_marks.py b/python/external_deriv_marks.py
index e9c38dc9..5df6979c 100644
--- a/python/external_deriv_marks.py
+++ b/python/external_deriv_marks.py
@@ -81,11 +81,12 @@ def ms_navs(date: datetime.date = None, fund: str = "Serenitas"):
return df
-def citi_navs(date: datetime.date = None, **kwargs):
- date = next_business_day(date)
+def citi_navs(date: datetime.date | None = None, **kwargs):
dfs = []
- glob_str = f"{date:%Y%m%d}*" if date else "*"
- for fname in (DAILY_DIR / "CITI_reports").glob(f"262966_Portfolio_{glob_str}.xlsx"):
+ glob_str = f"{next_business_day(date):%Y%m%d}*" if date else "*"
+ for fname in (DAILY_DIR / fund / "CITI_reports").glob(
+ f"262966_Portfolio_{glob_str}.xlsx"
+ ):
df = pd.read_excel(
fname, skiprows=6, skipfooter=2, parse_dates=["Trade Date", "Value Date"]
)