It is nice but I don't like that it seems to require the central server for the core data. Fine that it's free and around, but are you only planning to track investments this year? I'm wondering and worried about 5-20 years down the road!
Central server is only to pull stock quotes, but yes your concern is valid.
i would love to try, i use google sheets and finance and can get some excellent basic information (it leaves out dividend yields as an example of where it fails, though you can do a workaround)
Portfolio Slicer does not work with MAC because MAC version of Excel does not support PowerPivot - engine that is used for all calculations. So it is really out of my hands - but I do hope that Microsoft will include PowerPivot support in next version of Excel for Mac.
Hi Larry,vidm, i didnt know you posted on this forum
Could you explain how a "Norbert Gambit" transaction should be handled with Portfolio Slicer ? I have a hard time figuring how to enter the pair of transactions without breaking everything !
Hi Kaitlyn,
Thanks! Just wondering, what IF these are omitted - what exactly doesn't get tracked/reported properly?
If you would not use these special transaction types and would not add cash deposits/withdrawals you would see incorrect "Cash Value" and "Total Value" for Portfolios and for Total reports. So lets say you buy MSFT for 100,000$. Your Cash Value for that portfolio would be -100,000$ and your total value for that Portfolio would be 0: (CashValue + StockValue) = (-100,000 + 100,000) =0. Of course you can add all your "Buy" transactions and Portfolio Slicer will calculate that Cash Value is -x$. Then you just go back and enter source deposit transaction for x$, then your CashValue and Stock value will be OK, but Portfolio Rate of return could be affected (deposited Jan 1st x amount, bought first stock on Jan 2nd, then second stock in Nov 2nd, so PS will assume that cash was sitting in account and not earning much).
Webber22,Quicken usually has hundreds of fixes with every new release and it has thousands of users. I can't imagine how fixes this product will have, considering so few are using it now --- I won't be the guinea pig here
Not sure i understand, i have both a US and a Canadian account, isnt something that should be configured in Portfolio Slicer ? Can you do an example of Norbert Gambit with the an interlisted stock (Ex: TD) ? Just want to avoid any confusion
I've used Quicken for years. I've always felt it leaves much to be desired when it comes to investments. It tracks them well, but it doesn't give you much of a complete picture. I had to use a lot of custom reports to get what I needed.Quicken usually has hundreds of fixes with every new release and it has thousands of users. I can't imagine how fixes this product will have, considering so few are using it now --- I won't be the guinea pig here
Larry - You are right, I assumed that you are looking to do Norbert Gambit in the same account. But of course there could be different usage when you buy in one account and sell in another. I just updated same FAQ entry and added another example what you should do when you are buying in one and selling in another account. Please visit same page: http://portfolioslicer.com/Support/FAQ#norbertNot sure i understand, i have both a US and a Canadian account, isnt something that should be configured in Portfolio Slicer ? Can you do an example of Norbert Gambit with the an interlisted stock (Ex: TD) ? Just want to avoid any confusion
Q1: Normally when you enter transactions in normal circumstances you enter positive values. So for buy and for sell when you enter qty or price - you enter them as positive values. If bank charges you lets say 50$ for account, you would enter positive 50$ for charge and for refund you would enter transaction with type BankFee but with negative TransPrice as -50.I am entering all my transactions as well, so far its very nice
Question #1
For maximum consistency sake, how should a fee refund be entered ?
Method 1 - Deposit
Method 2 - Positive BankFee
Question #2 -
Is there a way to enter a dividend transaction without having to specify how many shares I held at the time the cash was distributed to shareholders ? From what i understand, DivTA could be used with a shares value of 1 ?
