diff options
Diffstat (limited to 'python')
| -rw-r--r-- | python/reallocate_cash.py | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/python/reallocate_cash.py b/python/reallocate_cash.py index ffe4f514..aceebf2a 100644 --- a/python/reallocate_cash.py +++ b/python/reallocate_cash.py @@ -104,7 +104,7 @@ def insert_iam_sql(conn, trade_date): strategy_allocation = ( "SELECT broker, amount, currency, strategy FROM (SELECT *, rank() " "OVER(PARTITION BY broker,fund ORDER BY date desc) FROM strategy_im si " - "WHERE fund = 'BOWDST' AND date<=%s ORDER BY date DESC) test WHERE RANK=1;" + "WHERE fund = 'BOWDST' AND date<=%s ORDER BY date DESC) test WHERE RANK=1 and abs(amount) >= .01;" ) c.execute(strategy_allocation, (trade_date,)) for row in c: |