Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Quick Links
TrackCash outputs a huge negative value in the Holdings
Hi all,
I have turned TrackCash to ON and although the Cash value column in the Transactions worksheet works fine, in the pivots the Cash position is hugely negative, distorting all the numbers.
Has this happened to anyone?
Thanks for your help in advance!
Best,
Francisco
I have turned TrackCash to ON and although the Cash value column in the Transactions worksheet works fine, in the pivots the Cash position is hugely negative, distorting all the numbers.
Has this happened to anyone?
Thanks for your help in advance!
Best,
Francisco
Comments
If you enable cash tracking (preferred method of using Portfolio Slicer), then you should make sure that before buying any shares, you have deposited cash - that is there should be explicit "Deposit" transaction. If you believe that data you entered is OK, then you can send me your workbook for review. My email is posted on this page: http://www.portfolioslicer.com/contact.html