diff options
| -rw-r--r-- | python/globeop_reports.py | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/python/globeop_reports.py b/python/globeop_reports.py index 030d27ca..4175a501 100644 --- a/python/globeop_reports.py +++ b/python/globeop_reports.py @@ -10,10 +10,10 @@ import numpy as np import datetime -def get_monthly_pnl(group_by=["identifier"]): - sql_string = "SELECT * FROM pnl_reports" +def get_monthly_pnl(group_by=["identifier"], fund="SERCGMAST"): + sql_string = "SELECT * FROM pnl_reports where fund = %s" df_pnl = pd.read_sql_query( - sql_string, dawn_engine, parse_dates=["date"], index_col=["date"] + sql_string, dawn_engine, parse_dates=["date"], index_col=["date"], params=[fund] ) df_pnl["identifier"] = df_pnl.invid.str.replace("_A$", "", regex=True) pnl_cols = [ |