Tech Support Guy banner
Status
Not open for further replies.

Solved: Stock quotes in Excel

4K views 7 replies 3 participants last post by  Groggy 
#1 ·
I have been using the MSN Stock Quote add-in to Excel 2002 for years. Suddenly, it has stopped working. Each cell where I ask for stock info (not real time, but end-of-day) shows an error. A typical instruction in the cell is =MSNStockQuote($C5,"Company Name") where the company's symbol (in this case) is in cell C5. Other items I used to be able to download included, Last Price, Change, etc. NONE works now.

The site at MSN Money seems to indicate the format of the instruction has not changed.

Any ideas???

Thanks
 
#2 ·
Have you installed any Microsoft Updates lately, if one of those coincides with when it stopped working try rolling back your Computer with a System Restore to see if that fixes it.
You could try using the Add-in Manager to delete and re-add your MSN Stock Quote in case it has been sommehow corrupted. You could even try re-installing/repairing Excel if you have the Disks.
 
#4 ·
Hi there,

Have you tried disabling all other add-ins and internet security programs? Did this occur when you installed any other applications? Do you use Google Desktop? (Known to have issues with Excel.) How many symbols are you using? Have you tried the add-in on another computer?

I would suggest reading these as well...
http://www.pcreview.co.uk/forums/thread-3642504.php
http://forums.techguy.org/business-applications/756426-solved-vista-problem-downloading-share.html
http://fransking.blogspot.com/2006/06/getting-stock-prices-into-excel.html
http://office.microsoft.com/en-us/excel/HA010346101033.aspx
http://www.excelforum.com/excel-programming/614266-msn-stock-quote-add-in.html
 
#5 ·
Thanks for your response. It seems that many people have started having trouble with this function, after using it for years. I strongly suspect that MoneyCentral or Microsoft has changed something and isn't about to inform the users.

I found another Excel Template on the net that works. It seems I can add VB code to it to get it to duplicate what I had before. It's just a bunch of new code that I have to write, but there doesn't seem to be any alternative.

I've tried system restoring to a previous date, un-installing and re-installing, nothing works. I don't have another computer I can check this out on, so...back to the coding table.

Thanks all.
 
Status
Not open for further replies.
You have insufficient privileges to reply here.
Top