How to correct bad price history data?

RobertPila

Every once in a while, Quicken has bad history data for a symbol. For example, the price history for the symbol PG is wrong for the 2023-12-04. The actual close price is 152.06 according to TD Ameritrade, but Quicken has 146.76, which is the close price for 2023-12-05. And there is entry for 2023-12-03, which is a Sunday, so there shouldn't be one. The price eventually corrects itself, but it throws off the gain/loss in the portfolio for that day. Included is a screen shot of the price history for PG. I've seen this happen for other symbols as well, both company stocks and ETFs. How can this be corrected without manually fixing it? I have tried running Update History but that did not fix the prices.

jacobs

Quicken downloads prices from a third-party data supplier, and as you note, those prices are occasionally off. Sometime, they get corrected by the data supplier, and those corrections flow into Quicken. So if the data downloaded into Quicken is incorrect, you simply make a manual correction of the price.

You asked "How can this be corrected without manually fixing it?" Well, if it isn't automatically fixed by the data supplier, then manually fixing it is the alternative; I'm not sure what third option you think there might be. 😉

Fixing a price on a specific date is fast and easy. You posted this under Quicken Mac, but your screenshot shows you are using Quicken Windows, so I don't want to state how to do it. A price can be edited in the security's price history screen, like the one you have shown, by selecting a date and either editing the price value (you can ignore High, Low and Volume) — or deleting the price for a day if it's an inconsequential day (e.g. not a month-end, or date of a transaction). (In Quicken Mac, one can also edit a price on a specific day in the Portfolio view.)

If there are long string of days with incorrect prices — which is rare — you can look for another source of price data for the security (such as finance.yahoo.com), download the date range as a .csv file, and import the data into Quicken.