8/18/2023: I have released a new working version of the Excel Quotes Add-In that uses Microsoft's new Quote Web Service!
It works the same as the previous version, but will require you to switch from the old "Financial Instrument" symbols to the new "Financial Instrument ID" symbols.
For example, switch from using "126.1.GOOG.NAS" to "a1u3p2" to identify Google. Also, the new version no longer supports the EPS, Beta, Dividend Yield and Industry fields because those datapoints are no longer available.
Download the Excel Quotes Add-In Version 2.0 below to replace the older version, switch all "Financial Instrument" references to its corresponding "Financial Instrument ID", and start getting quotes again!
Please see this post for more information.
A long time ago, my team at Microsoft built an Excel plug-in to get stock quotes from MSN Money. It looked something like this: MSNStockQuote("MSFT","Last").
Unfortunately Microsoft hasn't supported this plug-in for years :(
While building MSMoneyQuotes, I reconginzed Excel was still lacking a decent Add-In to get quotes. So I built one!
The Excel Add-In I developed uses Microsoft's own quote web services to retrieve quotes. Therefore it supports getting quotes for any securities that work on the MSN Money website and/or the Windows 10 Money app.
I also added the ability to get cryptocurrency quotes using the CryptoCompare API.
I have made it freely available from my website. However, I do accept donations which help offset the many hours put towards building, improving and supporting this software.
After you've downloaded and installed the Add-In, please see my sample Excel file to see how this works!
QuotesAddInExample.xlsx
The Excel Quote Add-In works by providing a new Excel function (aka formula) called =QUOTE(). It can be used to retrieve quote data like last, open, day high/low, year high/low, etc.
The function accepts two parameters:
=QUOTE("Financial Instrument ID", "Quote Field")
=QUOTE("a1u3p2", "Last") =QUOTE("a1u3p2", "Currency") =QUOTE("a1u3p2", "Change") =QUOTE("a1u3p2", "Date") -- Or get the financial instrument ID from the A1 cell (or whatever cell) =QUOTE(A1, "Last") =QUOTE(A1, "Currency") =QUOTE(A1, "Change") =QUOTE(A1, "Date")
I've build in a basic search pane that makes finding a MSN Money supported financial instrument ID easy. Go to the custom "Quotes" tab and click the "Search" button.
The "Quotes" tab has a "Search", "Update Now" and "Start Auto Update" buttons:
In the search pane, you can search by symbol or company name and hopefully find what you're looking for. Just start typing in the search field and the listbox will automatically load relevant results. This uses the same search service used by the MSN Money website, so I can't control the search behavior and/or results.
Once you find what you're looking for, you have the option to:
Cryptocurrencies are a hot topic recently, so I also added support for those. I leverage the CryptoCompare API to get quotes.
If you know the cryptocurrnecy pair, you can simply type the formula directly into the cell.
For example:
=QUOTE("BTC/USD", "Last") =QUOTE("BTC/USD", "Market Cap") =QUOTE("ETH/JPY", "Change") =QUOTE("XRP/CAD", "Date") =QUOTE("BTC/ETH", "Day High")Or you can use the "Cryptocurrency" tab in the search pane. Same as the other tab, start typing in the search field and relevant results will show up.
Here's a list of Quote Fields and which security types they're generally applicable to. Not all fields work for every security.
Quote Field | Indexes | Stocks | ETFs | Funds | Currency Rates | Cryptocurrencies |
---|---|---|---|---|---|---|
Symbol | X | X | X | X | X | X |
Name | X | X | X | X | ||
Currency | X | X | X | X | ||
Last | X | X | X | X | X | X |
Change | X | X | X | X | X | X |
Date | X | X | X | X | X | |
Type | X | X | ||||
Exchange | X | X | X | |||
Previous Close | X | X | X | |||
Day High | X | X | X | X | ||
Day Low | X | X | X | X | ||
Open | X | X | X | X | ||
PE | X | |||||
Volume | X | X | X | X | ||
Avg Volume | X | X | X | |||
Year High | X | X | X | X | ||
Year High | X | X | X | X | ||
Market Cap | X | X | ||||
Ask | X | X | X | |||
Bid | X | X | X |
Once the cell(s) are setup with the proper =QUOTE() forumla, you can go to the custom "Quotes" tab and click the "Update Now" button. This button forces a "re-calculation" of all =QUOTE() forumulas, which invokes my add-in to retrieve quotes from the relevant web service APIs.
To automatically update quotes every 1 minute, click the "Start Auto Update"" button. Essentially this starts a timer to automatically run the "Update Now" logic every minute.
Click "Stop Auto Update" to stop the auto update timer.
Note: Quotes are cached for 30 seconds, so the if you try to click the "Update Now" button more often than that nothing will happen.
I've made this free to avoid creating a sense of obligation that I'll provide support. I don't guarentee it will work in every scenario or that I'll provide support when it doesn't work. With that said, if you do have a problem that you think I can help with shoot me an email and I'll reply if I can.
Please recognized I am no longer a Microsoft employee and cannot fix quote issues on MSN Money. Nor can I address outages that the MSN Money quote web service may have.
My Excel Quote Add-In is not responsible for the actual quote values returned by MSN Money, so please don't email asking me to fix such issues. Same with the cryptocurrency quotes from the CryptoCompare API.
I can be reached at my support email address: support@gaiersoftware.com