diff options
Diffstat (limited to 'python/external_deriv_marks.py')
| -rw-r--r-- | python/external_deriv_marks.py | 9 |
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"] ) |
