Quotes and Investment Headlines Updates
Comments
-
I experimented further with this and found the following. My method was:
- In a test file, set up some securities with "Download quotes" and "Watch list" checked in the Security List. Choose securities that have a blank ticker symbol, a valid 1 letter ticker (I used AT&T, T), a valid multi-letter Ticker, and an invalid multi-letter Ticker.
- Real time quotes is disabled
- Select various combinations of these securities by checking and un-checking the Download Quotes box. Call these the selected securities.
- Go to the Security Detail view for any security and click on Update to refresh the quotes from the quote provider. This is a quick way to update the quotes.
- Go to Tools > One Step Update Summary to view the results
Here is what I found:
- If only valid multi-letter tickers are included, the summary says how many were updated and there is no report link. This is correct.
- If a valid 1-letter ticker is included, it is downloaded with the others but there is a report link that lists it and the report does not include any other securities that have invalid tickers. THIS IS A BUG.
- Any securities with blank tickers are not downloaded and the download count does not include them. They are not included in the report. THIS IS ANOTHER BUG.
- If all the securities have either a valid or invalid multi-letter ticker, there is a report and all the invalid ones are listed. This is correct.
I invite others to confirm this and any combinations I may have missed, and to see what if anything is different if Real Time Quotes are enabled. A while ago I found that if RTQ was enabled and any securities with blank tickers were included, it would fill in the prices for the ones with the blank tickers with the price for the first security in the list alphabetically (often AAPL).
QWin Premier subscription0 -
Hudson Bay Co. is traded on the Toronto exchange. It might be TSX:HBC or HBC.TO in Quicken.
QWin Premier subscription0 -
@Jim_Harman appreciate you digging in further, I will test later in teh week when I get a few work thinsg behind me. That said, clearly this aspect of QWin is extremely buggy and needs work!
0 -
@Jim_Harman , I tried both and neither works (I also tried this for other Canadian stocks such as TSX:GS or GS.TO). What I discovered in my testing is that any security a is not found in the "security search" will not be updated. This is why HBC — an iconic Canadian company — is not being updated.
0 -
There was a lengthy discussion last May on TSE issues that I see you participated in.
Is this a continuation of the same issue?
Reading through that discussion, it seems that turning off Real Time Quotes fixes issues for some users.
QWin Premier subscription0 -
@Jim_Harman good find but no, it is not the same issue. That issue was that no Canadian stocks — not a single now — was being updated. The current situation is that only those stocks that are not listed bu the "security update provider" are not being updated.
Hope this helps.
0 -
To summarize a workaround for the issues with the unsuccessful quotes report in the OSU Summary,
- Go to Tools > Security List and look for any securities that have blank ticker symbols. The quote provider uses the ticker symbol to look up the security, so if it is blank no quotes will be downloaded. If these securities are publicly traded, add the correct tickers. If not, un-check the Download Quotes box.
- If there are any securities that you know are not publicly traded, such as special 401(k) securities, the quote provider will not have prices for them. Make sure the Download Quotes box is un-checked.
- If any securities have valid 1-letter ticker symbols, temporarily un-check the Download Quotes box. Examples are T for AT&T, F for Ford, K for Kellogg, and Z for Zillow. These securities download OK but break the unsuccessful quotes report, hiding any other problems.
- You should also un-check the Download Quotes box for all money market funds (tickers ending in XX) The share price is always $1.00, so updates are not necessary, and I have sometimes seen the price download as 0, which of course causes problems.
- Click on any security name to display the Security Detail view and click on Update to refresh the quotes.
- Go to Tools > One Step Update Summary and click on the See a report link if there is one. You should now see a list of any remaining securities that the quote provider could not locate and thus were not updated. Investigate those to see why not.
- If you had any 1-letter tickers in Step 3, re-check the Download Quotes box.
With Download Quotes un-checked for a security, you will still get quotes along with downloaded transactions from your broker(s), just not from the quote provider.
QWin Premier subscription1 -
@Jim_Harman , excellent and thank you. I wish I had this a few ays ago!
0 -
I got curious and just started experimenting with this today.
I think there may be other types of tickers that break the report. Please let us know if you find any and I will add them to my steps above.
Just so you know, sometimes the ticker is changed for a security and the quote provider finds something different and starts using that, causing wildly incorrect prices to be downloaded. This happened a few years ago when the ETF ITR changed its ticker to SPIB. The shares were exchanged 1:1 but unless you got the word and changed the ticker, Quicken kept using ITR which the quote provider treated as index:ITR with a very different price.
QWin Premier subscription0 -
I got curious and just started experimenting with this today.
I think there may be other types of tickers that break the report. Please let us know if you find any and I will add them to my steps above.
I completely understand both points. I have gotten far more curious focus than I perhaps should on a few items and have spent many hours digging in. Rest assured that I will report anything else that I may find.
Just so you know, sometimes the ticker is changed for a security and the quote provider finds something different and starts using that, causing wildly incorrect prices to be downloaded. This happened a few years ago when the ETF ITR changed its ticker to SPIB. The shares were exchanged 1:1 but Quicken kept using ITR which the quote provider treated as index:ITR with a very different price.
Agreed. There are also time when the symbol changes because company A buys company B, etc. The bottom line, it is important to investigate stocks that do not update because the related repot is useless.
Thank you.
0 -
Following your earlier example, does Hudson Bay show up in the list of failed updates if it is on the Watch List and you have the Download Quotes box checked?
QWin Premier subscription0 -
@Jim_Harman yes, it does, see the below:
0 -
Thanks for confirming. So the report is working for you and the issue is still why quotes for HBC are not working.
At the beginning of all this the report was not working, right? Do you know what you changed that made the report start to work?
And once the report started to work were you able to figure out why most of the securities in the report no longer had quotes available - merged, ticker changed, etc? Is HBC the only one left?
QWin Premier subscription0 -
Thanks for confirming. So the report is working for you and the issue is still why quotes for HBC are not working.
Agreed accept I think the actual question is why stock quote provider does not recognize HBC (i.e., this is why HBCis not working).
At the beginning of all this the report was not working, right? Do you know what you changed that made the report start to work?
At the start the report did not work at all, there is an image of that. I suppose one or more of the "non-updating" stocks as the cause. I can check later on should you want know that I know which stocks to take out.
0 -
I think once it is working, the report is very useful for telling which securities can't be updated, assuming the ones it identifies are are actually merged, delisted, ticker changed, etc.
HBC is still a mystery though. Since that is apparently widely held, I'm surprised no one else has complained about it.
QWin Premier subscription0 -
@Jim_Harman , agreed on all fronts, especially the caveat "once it is working:.
HBC is still a mystery though. Since that is apparently widely held, I'm surprised no one else has complained about it.
I would bet most people have no idea and have not looked.
0 -
@JoelC .
Since you're running Q Canada, please post in the Canada topic area of this forum, rather than having us repeatedly request the mods to move your posts.Q user since February, 1990. DOS Version 4
Now running Quicken Windows Subscription, Business & Personal
Retired "Certified Information Systems Auditor" & Bank Audit VP0 -
The answer is that HBC has been privately held since 2020. That's why quotes are no longer available.
Wikipedia says
Until March 2020, the company was listed on the Toronto Stock Exchange under the symbol "HBC.TO" until Richard Baker and a group of shareholders took the company private.
…
In February 2020, shareholders of the company voted in favour of a plan to become a private company at a special meeting of shareholders. Under the plan of arrangement, the company will be owned by a group of continuing shareholders led by HBC governor and executive chairman Richard Baker.[119] Effective 3 March 2020, the company was delisted from the Toronto Stock Exchange, with Richard A. Baker replacing Foulkes as CEO.[120][121]
In 2023, Hudson's Bay officially stopped selling animal fur products.
So much for a company founded in 1670.
QWin Premier subscription0 -
@Jim_Harman ahhh, mystery solved! Thank you.
@NotACPA , I hear you but this is not a Canadian only issue, this is QWin issue. It is my understanding that Quicken Canada forum was for items that are specifically / solely Canadian issues whereas this form is for issues that are NOT specifically / solely Canadian issues. To the extent that I have this wrong, pleas let me know BUT, for example, the issue raised in this thread is NOT specific to the Canadian version and, in my humble view, benefits all users.
0 -
@NotACPA I agree this particular issue and discussion applies to both the US and Canada versions.
I do think it would be better in the Investments category rather than Download, Add/Update Accounts
QWin Premier subscription0 -
@joelc, are you running Q US also? How do you know that your posts apply to both?
Q user since February, 1990. DOS Version 4
Now running Quicken Windows Subscription, Business & Personal
Retired "Certified Information Systems Auditor" & Bank Audit VP0 -
It really isn't that hard to judge. There isn't really that much difference between Quicken Windows US and Canadian as long as you aren't talking about the financial institutions or multiple currencies.
Signature:
This is my website: http://www.quicknperlwiz.com/0 -
@Chris_QPW appreciated and thank you.
0 -
@NotACPA I know this discussion applies to the US version of Quicken because I have experimented and seen the same issues.
One stock discussed, Hudson's Bay, is a Canadian stock, but US users have similar issues when companies or funds merge, are bought out, etc.
QWin Premier subscription0 -
@Jim_Harman appreciated and thank you.
0 -
One stock discussed, Hudson's Bay, is a Canadian stock, but US users have similar issues when companies or funds merge, are bought out, etc.
I actually owned a similar US stock namely Aetna (AET) which was purchased by CVS in 2018.
Hope that helps.
0 -
@Jim_Harman , I took a final look and have foudn out athat of the 14 securities that do not update:
1 is a GIC. This makes sense.
8 are companies that have been sold, including Aetna and Kansas City Southern. This makes sense.
5 are mutual funds which have suspended trading and/or their symbol not recognized by the stock quote provider, I wish I could dig deeper on these but I am stuck, Google had nothing on them that I cold find.
0 -
Thanks for the update. It's good to know it is fixed for you now.
FYI you can avoid many of these issues by un-checking the Watch List box for securities you no longer own and aren't interested in. That will speed up your quotes, make your file grow a little less, and prevent Quicken from trying to download prices it does not need. If you ever buy the securities again, the prices will start to download again.
Were you able to tell what made the report fail when you first started all this? For me it was securities with good data but 1-letter tickers, but there may other causes as well.
QWin Premier subscription0 -
@Jim_Harman , it was a lot but am happy it is fixed which I could not have done without you; again thank you.
I do wish I could get a bead for the mutual funds; I guess I will need to settle for where I am.
As to what broke it in the first place, I will investigate that tomorrow and report back.
0 -
A deed for the mutual funds? What is that?
I summarized the issues with the report and sent the details via Report a Problem. With any luck, they will take a look at it this time.
See this post
QWin Premier subscription0
