I found a question here about tracking a stock portfolio. He would like to automatically create an overview table with a unique stock symbol per row. He also wants the range extended down to include new rows as they become valid.
Symbol Type Shares Price
F Buy 100 12
MSFT Buy 100 25
MSFT Buy 50 28
F Buy 100 16
GOOG Buy 25 550
You can also convert the range in sheet1 to a table and then create a pivot table with data from table. The table includes new rows automatically. Unfortunately the pivot table does not. Right click anywhere on pivot table and click Refresh when new rows are added.
The question is how to subtract sold shares from bought shares in a pivot table?