Bulk historical stock quote downloader | Retrieve historical financial data for many stock tickers in Excel |
Stock Quotes in Excel | Download historical stock quotes from Yahoo |
Company Financial Data from Web | Get financial data for multiple companies. Uses the Yahoo Finance API |
OPEC Basket Price History in Excel | Uses Quandl API |
Forex Data in Excel | Automatically downloads historical FX data |
Stock Quotes in Mathcad | Download historical stock quotes from Yahoo |
Historical Stock Quotes | Downloads historical stock quotes from Google Finance into Excel. Automated with VBA. |
Forex Data in Mathcad | Automatically downloads historical FX rates (VBScript) |
Historical Volatility | Calculate historical volatility from Yahoo stock quotes. Completely automated. |
Stock Screener for Excel with Automatic Data Download | Downloads financial data for over 6800 ticker symbols (over 60 items per ticker). |
Stock Comparison Spreadsheet | Compare up to ten stocks. Automatically retrieves financial information from web. |
Finviz Stock Quote Download | Downloads stock quotes for 6855 tickers from Finviz.com. Includes over 65 items of financial data. |
Relative Strength Index from Stock Ticker | Plots Relative Strength Index. Type in a ticker, and Excel downloads data from Yahoo Finance |
Real-Time Live Foreign Exchange Rates | QueryTable that scrapes data from Yahoo Finance |
Foreign Exchange Rates UDF | An Excel UDF and VBA that scrapes live forex rates from Yahoo Finance |
Multiple Historical Stock Quotes Downloader | Get historical quotes for multiple tickers in Excel from Yahoo Finance |
WTI Oil Price History | Data sourced from the US Energy Information Authority |
Bulk Forex History Downloader | Downloads multiple Forex histories via a web service |
Plot RSI for Historical FX rates | Gets historical forex rates from a web service and plots relative strength index |
Historic Gold & Silver Prices | Gets historic prices from a web-service. Choose from many different currencies |
Live Gold Spot Price in Excel | Uses Excel's Web Query functionality |
Brent Oil Price History | Downloads Brent oil price history into Excel from a web service |
Yahoo Finance Stock Ticker Symbols | A complete list of Yahoo Finance stock tickers across many international exchanges |
Intraday Stock Data in Excel | Retrieves intraday backfill from Google for your time interval and ticker |
Bulk Dividend Downloader | Downloads dividends for bulk tickers |
Download Precious Metal Prices and Plot Technical Trading Charts | Automatic download of historical gold, silver, palladium and platinum prices, and plot MACD, RSI, EMA & Volatility |
Live Stock Quotes in Excel | Financial data from the web with a formula |
Plot Candlestick Charts with VBA | An Excel spreadsheet that downloads historical pricing data from Yahoo and plots a candlestick chart |
Sir,
can you give me indication of a vendor of financial data for fixed income products (such as swap curve and rates, caps, floors, volatility etc. for an accessible price?
Thank you
V. Donato
Hi, I like your Excel Programs very much. Do you have any programs to bulk download Option Prices into Excel? If not, do you still write programs for a fee? Thank you very much.
Cheers,
Paul Witzgall
paulwitz@aol.com
Hi, your Bulk Dividend Downloader links to a Stochastic VBA page. Is it still available somewhere? Thanks.
J
It Seems that Excel 2011 for Mac has a subset of the Windows version. Excel 2016 for Mac doesn’t support Macros. I decided to run WIndows 7 as a Virtual machine using Parallels Desktop which which I purchased when I was switching from Windows to Mac. I installed my copy of Office 2010 on it and discovered that some of these VBA packages work on Excel 2010 and other don’t.
Do you have any ideas which of MS’s many version of Excel these VBA macros work on?
/Dave
Do you have a list (or a link to) the data Yahoo provides for mutual funds that I can import into Excel? I have found such a list for stocks, but for mutual funds I am interested in doing a bulk download of annual performance over the past decade. Yahoo provides the information under the PERFORMANCE tab for a mutual fund. Thanks in advance!