Price history after a stock split
Parador
Member ✭✭
I’m about 60% through a 2007 to Premier 2019 Mac transfer of a number of accounts. This particular issue is a brokerage account and with a security with a 10:1 stock split that happened several months ago. The account is not linked to an online account. Everything ever entered was done by hand or as part of a security price update over many years. After the data was automatically converted (open the 2007 file with 2019) the plot of account value looked like a saw tooth. Prior to the stock split quicken updated the historical prices to be the post split equivalent value (i.e. 1/10th of what was there before) for every possible date it had previously had a stock price except for those that had been entered manually. For the manually entered transactions the calculated value (price x number of shares) was correct. For all other pre-split dates the value computed and displayed was off by a factor of 10. I did a stock price rebuild and allowed it to change any price entry it wanted to. The saw-tooth look is gone but now there is a step change in displayed value at the date of the stick split that isn’t really what happened. Anyone else seen this sort of behavior? Quicken should know how to provide historical value not just historical price. If it is expected to match what is displayed in an online brokerage account history or be able to compare to a statement it needs to know the difference between current day historical prices that may have been altered by a split and the prices actually paid throughout an investments history.
0
Comments
-
0
-
0
-
0
-
0
-
Just so it is clear. The rebuild of the price history is how I got from the Before to the After chart. I allowed it to change the manually entered prices during the rebuild. If all stock splits in Quicken now work this way than the program has serious programming logic problems and is useless for investment tracking. Can anyone assure me that it does work correctly for all other (or at least most, some) stock split situations?0
-
Same problem (FMAGX); just converted from Q2016 for Mac to Q2019 (didn't want to, but the new owners of Quicken left me no choice). The same thing appears to have happened with the other securities as to which I've had stock splits.
Quicken for Windows (don't ask: running VMWare was worse than Q2016, although the Quicken product was much better) always got splits right: it went back and adjusted prices and volumes from first purchase. Always got the cost basis right, too. I simply cannot believe that the database architecture on the Mac (which is Quicken's excuse for everything they do under Windows that they don't do on Mac) is SO different that they can't do this simple, basic operation.
My strong guess, based on the comments above and the way my transaction register looks, is that there is no workaround that preserves cost basis (which is what really matters). When Quicken fixes the bug, I know the answer will be to delete the stock split transaction, then rebuild the price history, then reinsert the stock split transaction. But right now, it's a bug.0
This discussion has been closed.