Price History has additional entries
Comments
-
Price history entries come from transactions or can be downloaded from your financial institution. Why do you think the entries are a problem?
Quicken user since Q1999. Currently using QW2017.
Questions? Check out the Quicken Windows FAQ list0 -
Because the price vacillates between $11 $60 . So the $60 security price is not correct and I don't know where that data came from as there is no ticker symbol even on that item0
-
Price history data comes first from transactions. Do you have a transaction on the date of the $60 price?RogerSnook said:Because the price vacillates between $11 $60 . So the $60 security price is not correct and I don't know where that data came from as there is no ticker symbol even on that item
Quicken user since Q1999. Currently using QW2017.
Questions? Check out the Quicken Windows FAQ list0 -
If you have the account set up to download transactions from your mutual fund company, then as they download transactions, they also (typically) download prices for the holdings for that date.RogerSnook said:Because the price vacillates between $11 $60 . So the $60 security price is not correct and I don't know where that data came from as there is no ticker symbol even on that item
So as best I recall, prices can come from:
Downloads from Quicken's servers (requires tickers which you have excluded)
Downloads from the financial institution
Your manual entry as a direct price on a specific date
Through transaction entry (like buys, sells, reinvestments, etc.)
Your import of data as a csv file
Your import of data as a QIF file
Some other obscure way I've forgotten.
All offered FWIW.0 -
And if the price data came from the FI during transaction downloading, I would be very hesitant to delete that data as it may be impossible to recreate without a lot of pain.RogerSnook said:Because the price vacillates between $11 $60 . So the $60 security price is not correct and I don't know where that data came from as there is no ticker symbol even on that item
Quicken user since Q1999. Currently using QW2017.
Questions? Check out the Quicken Windows FAQ list0 -
In one case, on March 28th, I have 3 transactions that are all priced $44, but the price history shows $28 on that day. WEIRD.RogerSnook said:Because the price vacillates between $11 $60 . So the $60 security price is not correct and I don't know where that data came from as there is no ticker symbol even on that item
0 -
Roger, is that $28/$44 day recent? If so, it might be worth the effort to take a look at your OFX log to see what the fund company is sending.RogerSnook said:Because the price vacillates between $11 $60 . So the $60 security price is not correct and I don't know where that data came from as there is no ticker symbol even on that item
HELP, Log Files, OFX Log. Save it to your desktop, and then open it with NotePad or WordPad (NOT MS Word).
Then do a search for 44.00 and see what shows up. If nothing, search for 28.00. Note the absence of dollar signs in both searchs.Q user since February, 1990. DOS Version 4
Now running Quicken Windows Subscription, Business & Personal
Retired "Certified Information Systems Auditor" & Bank Audit VP0 -
More info on this - this appears to be limited to dates before June 2016. All more recent data seems good.RogerSnook said:Because the price vacillates between $11 $60 . So the $60 security price is not correct and I don't know where that data came from as there is no ticker symbol even on that item
0 -
If the funds don't have tickers in Quicken and are not matched to an online security, then I think it is most likely that the bogus price history comes from erroneous transactions you entered manually. For example you might have transposed two digits in the dividend amount when entering a dividend reinvestment.
Look for transactions on dates with wrong values in the price history and see if anything is amiss. Hopefully correcting any bad transactions will also correct the price history, but if not at least you will know what the value should be and you can correct it manually.
When entering dividend reinvestments manually, I always check that the computed price per share is reasonable before clicking OK. I have caught many typos this way.QWin Premier subscription0 -
You are right that if you have securities like unit investment trusts that are not publicly traded in different accounts they may have very different values. For example I once had something called "Capital Guardian International" with a value of about 55 in one account and 8 in another.
The only work-around here is to give then different names in Quicken so it will treat them separately.
As you have observed, when you are entering transactions you may encounter round-off errors that lead to slight differences between the share prices in Quicken's price history and your statements. It is certainly important to get the date right.
It is almost always best to make sure you get the investment amount and number of shares purchased correct, and accept Quicken's calculation of the share price. If you use the method you describe above where you try to force a particular share price, you will either end up with the wrong number of shares or the wrong amount invested.QWin Premier subscription0
