This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I installed the MSN Money Stock Quotes add-in in Excel 2013 and it was working perfectly yesterday, but for some reason it has stopped updating quotes today. The selection for "Update Quotes" from the add-in toolbar is not active. However, the "Insert Stock Quotes" button is active and when I press it, I get the Stock Quotes dialog box. It will insert the formula for the quotes in the spreadsheet, but it does not provide an up-to-date quote. I would appreciate any help on this, as this add-in is a big time-saver for me. I did notice that my software was automatically updated yesterday. (I believe that it was a Windows update, but I am not 100% sure.) I do not know whether this might have something to do with the change, since, as I said, the add-in was working yesteday.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Did you ever get your MS Money to work? I had the same problem just yesterday. The "Update Quotes" tab wouldn't do anything, but the "Insert Stock Quotes" tab would. I went ahead and re-inserted all the stock symbols by highlilighting my entire selection and everything updated and is working fine again.
Re entered all of the codes and they still do not show the gains or losses in green and red like before.
I have been using the plugin below for quite some time. Works great for me. It use Yahoo API and integrate it seamlessly with Excel as exposed custom functions. This is a good alternative to MSN plugin
From my perspective, the problem is not solved, as COMSFT suggests.
I can get the quotes by following the advice given throughout this thread, but it is cumbersome. For example, sometimes, the "USD" parameter does not work, so I shift to "USA" and it works. Other times, "USA" does not work, so changing it to "USD" does.
There also does not seem to be any consistency to which formulas work and which do not. So sometimes, the "USD" parameter works and sometimes it does not. Formula updates fail randomly.
I suspect that it is not the actual parameter - i.e. whether I use "USA" or "USD" - that causes MSNStockQuotes to work. Rather, it seems to me that for some reason, Excel does not trigger an automatic update of these formulas. So by editing the formula, the calculating engine kicks into gear. To prove this, I entered "abc" as a parameter in place of "USD" in a failed formula and got a successful update!
I suppose that it would not be too difficult to write some VBA code that would find the failures and automatically process all of the updates, but it would take time, especially for someone like me who is a VBA novice.
I wish that Microsoft would publish an update to MSNStockQuotes. I would even be willing to pay a reasonable fee for it. I suspect that others who depend upon this add-in would be willing to pay for it as well.
Thanks to all for your help on this ... I've been able to restore my US stock quotes as a result.
However, my Canadian stock quotes (i.e. "CA") still do not work. Any ideas how to get those repaired too?...