diff options
Diffstat (limited to 'python/position.py')
| -rw-r--r-- | python/position.py | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/python/position.py b/python/position.py index 3bb6b67b..83bff28f 100644 --- a/python/position.py +++ b/python/position.py @@ -18,7 +18,7 @@ def get_list( ): if workdate: positions = pd.read_sql_query( - "SELECT identifier, bbg_type FROM list_positions(%s, %s, %s, %s)", + "SELECT identifier, figi, bbg_type FROM list_positions(%s, %s, %s, %s)", engine, params=(workdate, asset_class, include_unsettled, fund), ) @@ -299,7 +299,7 @@ def populate_cashflow_history(engine, session, workdate=None, funds=("SERCGMAST" secs = get_list(engine, workdate, fund=fund) for sec in secs.itertuples(): if sec.Index not in securities: - securities[sec.Index] = sec.identifier + securities[sec.Index] = sec.figi data = retrieve_data( session, securities, |