HYHRD: Google Sheets workaround for stock price of $QQQX #kludge



I’m Pat Rosenheim, a.k.a. the PandA Trader.

Google Finance’s last price for QQQX is from Oct. 31 – Close, which simply will not do. I found another way to get the stock price, but it’s a bit of a kludge, so I hope you don’t mind that. It’s just the best I can do short of entering the price manually (yeah, like that’s gonna happen!). – Navigate Safely, Pat

First, here’s a screenshot from Google Finance, which is where Google Sheets gets the stock price (duh!);


You’ll notice the price is not current, but oddly enough the chart is. They’re both on the same page, for crying out loud!

I have entered a note, which you can see when you hover your mouse pointer over the cell containing QQQX that’s explains the kludge is in use;


I have used the “Report a Problem” link at the bottom of the quote page on Google Finance, but I’ve also reported that their dial gauge doesn’t display properly and haven’t heard a word in over a month. So, I don’t expect they’ll ever correct the situation. They’re probably too busy with writing a politically incorrect office memo or counting profits from their sale of stock to ever answer or respond to that error.


I’m not telling anyone to buy anything or giving anyone any advice, because that’s illegal. You see, I have no letters after my name, like RIA, CFA, etc. I SIMPLY DO NOT GIVE ADVICE. I only tell (and show!) what I do. You, like me, are all alone in this.

And remember, always do your own due diligence!

panda_wildePat Rosenheim
(PandA Trader)
High Yield, High Return Dividend


About PandA Trader

I am, I think... "Disobedience, in the eyes of anyone who has read history, is man's original virtue. It is through disobedience and rebellion that progress has been made." -- Oscar Wilde
This entry was posted in dividend portfolio. Bookmark the permalink.

Don't be shy! Leave a Reply...

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s