diff options
Diffstat (limited to 'python/external_deriv_marks.py')
| -rw-r--r-- | python/external_deriv_marks.py | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/python/external_deriv_marks.py b/python/external_deriv_marks.py index 5cee017e..670ac115 100644 --- a/python/external_deriv_marks.py +++ b/python/external_deriv_marks.py @@ -229,6 +229,8 @@ def cs_navs(date: datetime.date = None, fund: str = "Serenitas"): df = pd.read_excel(fname, header=5, skipfooter=29) except ValueError: continue + if df.empty: + raise ValueError(f"empty position statement for {d}") df.columns = [c.replace("\n", " ").strip() for c in df.columns] df = df[1:] df = df.set_index("Structure ID") @@ -358,7 +360,11 @@ if __name__ == "__main__": for cp in ("MS", "CITI", "GS", "BAML", "BNP", "CS", "JPM"): for fund in ("Serenitas", "Brinker", "BowdSt"): logger.info(f"{cp} at {fund}") - df = globals()[f"{cp.lower()}_navs"](date, fund=fund) + try: + df = globals()[f"{cp.lower()}_navs"](date, fund=fund) + except ValueError as e: + logger.error(e) + continue if df.empty and cp == "CS": df = globals()[f"{cp.lower()}_navs_old"](date, fund=fund) logger.debug(df) |