diff options
| -rw-r--r-- | python/interest_statement.py | 3 | ||||
| -rw-r--r-- | python/monthend_interest_recon.py | 10 |
2 files changed, 4 insertions, 9 deletions
diff --git a/python/interest_statement.py b/python/interest_statement.py index f108a51e..790cdfd3 100644 --- a/python/interest_statement.py +++ b/python/interest_statement.py @@ -2,8 +2,7 @@ from serenitas.utils.db import dbconn import pandas as pd from pandas.tseries.offsets import BDay -conn = dbconn("dawndb") - +conn = dbconn("serenitasdb") df_rates = pd.read_sql_query( "SELECT date, rate FROM rates where name='FED_FUND'", conn, diff --git a/python/monthend_interest_recon.py b/python/monthend_interest_recon.py index 59859bde..066b5f59 100644 --- a/python/monthend_interest_recon.py +++ b/python/monthend_interest_recon.py @@ -26,10 +26,6 @@ def get_fpath(counterparty, save=False): return ( DAILY_DIR / "Serenitas" / "MonthlyInterest" / f"{counterparty}_reports" ) - case ("CITI", True): - return DAILY_DIR / f"{counterparty}_reports" / "Interest Statements" - case ("BAML", True): - return DAILY_DIR / "Serenitas" / f"BoA_reports" / "Interest Statements" case _: return ( DAILY_DIR @@ -192,14 +188,14 @@ if __name__ == "__main__": ) df["difference"] = df["amount"] - df["monthly_statement"] if args.accept: - df = export_data(start, end) + ssnc_df = export_data(start, end) for k, v in df["difference"].items(): - df.loc[k].loc["CSH_CASH"] -= v + ssnc_df.loc[k].loc["CSH_CASH"] -= v from io import StringIO from serenitas.utils.exchange import ExchangeMessage, FileAttachment buf = StringIO() - df.to_csv(buf) + ssnc_df.to_csv(buf) attach = [ FileAttachment( name=f"{start:%b}.csv", |