Get financial data for multiple companies in Excel, straight from the web. Retrieve EPS estimates, EBIDTA, dividend yields, PE ratios and more.
This Excel spreadsheet downloads bulk financial information for multiple companies into an Excel spreadsheet. The spreadsheet is web-connected – it uses the Yahoo Finance API.
You can get financial data for 100 or more companies simply by entering their ticker symbols and clicking a button.
The VBA can be viewed and edited – nothing is locked or hidden away. Feel free to post your suggestions for improvements, or perhaps modify the spreadsheet yourself.
The spreadsheet is free – the download link is at the bottom of this post.
Start by entering in a list of stock tickers. You can enter tickers from US exchanges, as well as many European and international exchanges; you just need to know the right ticker symbol to use.
After you click the “Get Data from Yahoo Finance” button, Excel employs some clever VBA to download your data.
You have access to 89 items of financial information for each stock from the Yahoo Finance API, including the ask price, EPS estimates for the current and next year, 52-week high and low, EBIDTA and many more. Simply use the drop-down menus to pick the data you want.
If you like this spreadsheet, then please link to http://investexcel.net wherever you consider appropriate.