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.
manatee_736,
THANKS !!!!!!! Works for me too.
I did find one other change I had to make ... for the daily % change value, I had to change my code from this ...
=MSNStockQuote($A6,"% Change","US")
to this ...
=MSNStockQuote($A6,"% Change","USD")/1000
[that is I had to use USD and, for some strange reason, I had to divide the return value by 1000 to get the proper percentage]
Can you provide a link to the post where you found the info about arbitrary syntax change?
Very unprofessional for Microsoft to make an unannounced syntax change, and then leave it to their customers to figure out what happened. Notice the complete absence of any posts in this thread from Microsoft engaged Moderators.
This does work, but it is a pain in the butt, as I have around 60 symbols to change with 8 columns, so that's 480 changes I would have to make. I tried it on three entries, and it works. There's got to be a better way!!! i DID FIND A BETTER WAY. "FIND AND REPLACE"
I found a solution on a post which stated the following:
It appears that they made an arbitrary syntactical change without notifying users or maintaining backward compatibility.
old syntax:
=MSNStockQuote($A2"Last Price","US"
where $A2 is a reference to a cell containing the ticker symbol: e.g. GOOG:
New syntax:
=MSNStockQuote($A2"Last Price","USD"
Change all cells from "US" to "USD"
This seemed to work for me.
Why does Microsoft keep making updates without letting users know what they are changing. I have set automatic updates to OFF and I don't think I will ever update again. It makes you wonder why you buy Microsoft software. I have Apple and Microsoft computers. Both the companies make changes that effect the end users and software developers without letting them know what was changed. A simple explanation would do or a response when users, like us, repot a problem. I think they may be to big to care.