Note: Finance Train’s users now get a 25% exclusive discount on the purchase the stock quotes in excel add-in.
Excel is the most commonly used tool by people to manage and keep track of their stock portfolios. One of the most critical tasks to manage a portfolio in excel is to get the desired stock data in excel. There are many sources of data such as Yahoo Finance API, MSN Money, or Google Finance. Earlier people had no choice but to scrape the data from web pages into their excel spreadsheet and then delete the unwanted data and format the rest. This is a tedious and unreliable method. Another great option that has been popular for many years is the MSN MoneyCentral Stock Quotes Add-in. This has worked successfully and has been the easiest method to get the stock quotes in excel. However, about a month back MSN pulled the plug on this add-in and stopped supporting/updating it. We had many users complaining about how troubled they are because of MSN Stock Quotes Add-in not working.
We have been looking hard to find an alternative that is at least as good as the MSN Stock Quotes Add-in, something that people can even use with their existing spreadsheet and update all their formulae in few minutes. At last we have found a new excel add-in that does the job even better than MSN plugin. The new add-in is simply called “Stock Quotes in Excel” and is developed by a company called Tech Nitya.
This Excel Add-in implements Yahoo Finance API in your Excel workbooks and exposes 84 new functions in Stock Quotes category for you to be able to download live Stock information right in your Excel Workbooks. Apart from Yahoo Finance API, you can also choose MSN Money as a source. It also contains functions to get mutual fund quotes, and MSN money option pricing data.
Just as you would expect, all the functions take the symbol argument, so if you were to get the Ask price for Google then you would create a small function like =Ask(“GOOG”) and you will have the result in your cell.
With this new Excel function library to download Stock quotes right in your Excel workbook, you are in full control. You can download only the information that you need and when you need.
The plugin is available at a very low price and you can purchase it using the following link. Finance Train’s users now get a 25% exclusive discount on the purchase the add-in.
When you buy this add-in, you will get lifetime updates at no extra cost. There is a 30-day money-back guarantee so you can try it risk-free.
The following video demonstrates how the add-in works.