Price history for stocks does not adjust for stock splits
I created a new file specifically to track securities in a brokerage account. I downloaded all transactions (last 90 days) and then added transactions to cover all of 2024 using the brokerage statements. I used the start-of-year cash balance, and the cash is balanced to current. I also manually entered all stock purchases (date, cost and number of shares) for the current portfolio of stocks, and these positions now balance to the account.
I didn't expect an accurate net worth report for 5 years previous to now when using the "Rebuild stock price History" because there were other stocks that were bought and sold during those years along with dividends, cash additions and withdrawals, etc. However, I hoped to get a general idea of the worth of the current portfolio with appreciation and additions to stock positions.
However, I did not expect the net worth to wildly jump to values much higher than the current values when the actual portfolio is near its high currently. I quickly discovered that the imported stock prices are NOT adjusted for stock splits. For example NVDA stock price closed at $1,208.88 on 6/7/2024 and $121.79 on 6/10/2024 after the 10:1 split. So the imported prices are inaccurate for current positions entered from a current statement which has the original purchases adjusted for the split.
Can stock prices be imported into Quicken Mac with prices adjusted for splits (i.e: the 6/7/2024 price would be $120.89)? If not using Quicken Mac "Rebuild History," is there another source for a CVS stock quotes file that does adjust stock prices to splits that could be imported using the Mac "Import History from CVS File"?
Answers
-
I don't know of any way to change the data source Quicken uses for stock prices, or to cause them to be adjusted for splits in the way you desire. IMO you should correctly enter your historical purchases - enter the number of shares you actually bought on that day, not the number of shares they turned into after the split - and then enter stock split transactions on the days that splits occurred so that the number of shares will be adjusted correctly at the same time the price changes.
Most online stock price listings are adjusted for stock splits so if you can find one that will let you export pricing data you could import it using the import function. When you click on the import button a dialog box will pop up telling you how the file needs to be formatted to correctly import.
0 -
Thanks Jon,
Your suggestion is probably the best (enter actual shares, adjusted with stock splits). I'll look at the number of transactions that would entail versus trying to import prices adjusted for splits. Hopefully, there aren't many stocks with splits over the period of history that the current portfolio covers.
0