diff options
| -rw-r--r-- | python/interest_statement.py | 3 | ||||
| -rw-r--r-- | python/monthend_interest_recon.py | 4 |
2 files changed, 5 insertions, 2 deletions
diff --git a/python/interest_statement.py b/python/interest_statement.py index 790cdfd3..aec764c7 100644 --- a/python/interest_statement.py +++ b/python/interest_statement.py @@ -3,6 +3,7 @@ import pandas as pd from pandas.tseries.offsets import BDay conn = dbconn("serenitasdb") +dawndb = dbconn("dawndb") df_rates = pd.read_sql_query( "SELECT date, rate FROM rates where name='FED_FUND'", conn, @@ -11,7 +12,7 @@ df_rates = pd.read_sql_query( ).sort_index() df_balances = pd.read_sql_query( "SELECT * FROM strategy_im WHERE fund='SERCGMAST'", - conn, + dawndb, parse_dates=["date"], index_col=["date"], ).sort_index() diff --git a/python/monthend_interest_recon.py b/python/monthend_interest_recon.py index 066b5f59..d796fb96 100644 --- a/python/monthend_interest_recon.py +++ b/python/monthend_interest_recon.py @@ -104,7 +104,9 @@ def get_MS(path): def get_BAML(g): for e in g: if "Net interest Amount" in e.text: - return -float(next(g).text.replace("(", "-").replace(")", "")) + return -float( + next(g).text.replace("(", "-").replace(")", "").replace(",", "") + ) def get_JPM(g): |