diff options
Diffstat (limited to 'python')
| -rw-r--r-- | python/upload_bbh_trades.py | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/python/upload_bbh_trades.py b/python/upload_bbh_trades.py index 8124dae0..d827e3ee 100644 --- a/python/upload_bbh_trades.py +++ b/python/upload_bbh_trades.py @@ -13,7 +13,7 @@ if __name__ == "__main__": with conn.cursor() as c: c.execute("SELECT headers from csv_templates where template_name='bbh_bonds'") (headers,) = c.fetchone() - sql_query = "SELECT bond_trades.*, counterparties.dtc_number FROM bond_trades LEFT JOIN counterparties ON cp_code=code WHERE cash_counterparty AND trade_date >= '2022-04-05' AND fund='BRINKER' and faceamount is not null;" + sql_query = "SELECT bond_trades.*, counterparties.dtc_number FROM bond_trades LEFT JOIN counterparties ON cp_code=code WHERE cash_counterparty AND trade_date >= '2022-04-05' AND fund='BRINKER' and faceamount is not null and faceamount >0;" c.execute( sql_query, (datetime.date(2022, 4, 5),) ) # We don't want to upload trades before this date |