Get Stock Quotes in Excel
Spreadsheet template with simple custom-built formulas to get stock quotes from Yahoo Finance - no more fiddling with VBA code.
Monitor and analyze your stock portfolio right from this Excel spreadsheet. This spreadsheet provides you the formulas and a template with graphs and charts to get stock quotes from Yahoo finance. No tinkering with VBA code, and no complicated installation process required. The formulas just work. Have your stock symbols ready, download the spreadsheet, enable the marcos, and the spreadsheet simply just works right out of the box.
How to Use the Spreadsheet
A Note About the Data Source
The delayed stock prices are downloaded from Yahoo Finance's API, which is a free service and could be temporarily unavailable from time to time for various reasons. In this case, try refreshing the stock prices again at another time. If the issue persists for a few days, possibly due to a permanent change in the API's web address, please come back to this page and download the latest file.
Below are the custom-built formulas, in alphabetical order, that perform the magic of delivering stock price data from Yahoo Finance right into the cells of the stock quote spreadsheet. Use the custom formulas just like any built-in formulas. If you are not sure how to get started, the spreadsheet contains examples of all the formulas documented below.
Returns the ask price.
Returns the bid price.
Returns the dollar value change in stock price since it last closed.
Returns the change in stock price as a percent.
Returns the highest trade price for the day.
Returns the lowest trade price for the day.
Returns the dividend per share.
Returns the dividend yield.
Returns the earnings before interest, taxes, depreciation, and amortization.
Returns the earnings per share.
Returns the market capitalization.
Returns the name of the company, limited to a maximum length of 17 characters due to the API.
Returns the open price.
Returns the price to earnings ratio.
Returns the closing price on the previous trading day.
Returns delayed stock quote from Yahoo finance.
Returns the number of shares traded for the day.
Returns the 52-week high.
Returns the 52-week low.
This stock quote spreadsheet comes with charts to help you stay on top of your stock investments. You also have the flexibility to put together your own stock portfolio tool using the available custom-built formulas within the file. And if you need further customization or more advanced functionalities such as getting financial information for publicly traded companies in Excel, don't hesitate to contact me.
I really enjoy putting together simple yet practical spreadsheet tools - from coding the core functionalities to designing an intuitive template - that people would actually use regularly. Any feedback or suggestion to help improve this spreadsheet is sincerely appreciated.