I tried to import the following test .csv file in Schwab format:
Date,Action,Symbol,Description,Quantity,Price,Fees & Comm,Amount
06/26/2025,Buy,AAPL,PROSHARES SHORT QQQ ETF,29,34.215,-992.24
06/26/2025,Sell,AAPL,PROSHARES SHORT QQQ ETF,29,34.19,991.51
After the load TradeTally shows the position as a short ‘open’ even though the trade is closed (1 buy and 1 sell).
After a bit of trial and error I discovered that removing the word ‘SHORT’ from the stock description field on the first trade record fixed the problem. Very strange.
Anyone else seen this?