« More Friday Humor – “Sagging” Explained… | Main | A Review of Jason Kelly’s “Financially Stupid People Are Everywhere” »
Microsoft Takes Away Refreshable Stock Quotes for Excel…
By JLP | June 27, 2010
I was updating one of my investment Excel Spreadsheets. I needed to add a refreshable stock quote, so I went to the research pane, typed in my symbol and it tells me that it’s not available. Upon further research, it turns out that the add-in has expired and Microsoft is no longer going to support the add-in.
What the hell?!?
This feature, which you can read about here, was one of the most useful features of Excel. I found a thread on one of Microsoft forums about the missing add-in. Someone from Microsoft curtly responded:
“The link has been removed as the addin has expired, There will be no more uploads for this addin on Microsoft.com”
I hope Microsoft reconsiders this because it was one of the most helpful tools of their program.
Topics: Miscellaneous | 6 Comments »
June 27th, 2010 at 3:40 pm
You can hire a college programmer to crank out a replacement Excel add-in for you. It wouldn’t take that long and I would imagine it’d be fairly cheap.
June 27th, 2010 at 8:38 pm
You probably already know this, but you can embed quotes into google docs. You can put quotes and a lot of other financial info right into their spreadsheets, and they do refresh. It seems to work quite well.
June 28th, 2010 at 7:59 am
They took it away from Microsoft Money as well but I think that was a few months ago.
June 28th, 2010 at 8:28 am
I use the MSN Money Stock quotes add-in. Works for me (6/28, 9 am). No problems with retrieving quotes.
June 29th, 2010 at 10:24 am
SmartTags are still working for me. I’m not sure what you are using but in Office 2007 you just type the symbol (all caps) in a field and an information icon pops up with options to embed the refreshable stock quote. Of note is that my quote has a copyright of 2010 in it.
July 7th, 2010 at 1:47 pm
I did get hit with the same – here is a work around and it works until Microsoft removes stock update from money.
If you read this link
http://allfinancialmatters.com/2006/11/15/how-to-insert-refreshable-stock-quotes-into-excel/
Step 6 says ….which you must have done in past
Just copy all the stuff from an old symbol insert and go to toolbar to edit the query – replace the old symbol with the new one. Import and viola – you have the new symbol working.