Download Financial Market Time Series Data

Description
An Excel VBA driven solution to download time series data from financial markets for multiple symbols. Symbols for stocks, indices or any publicly traded financial instrument can be identified from web lookup links to extract and align the time series data for daily, weekly or monthly periods. Multiple download sources are integrated with optional API key specification options: Yahoo Finance, IEX Global, Quandl (optional API key), and Alpha Vantage (required API key freely available). This is to suit preferences and requirements and also provide backup options should sources stop functioning.

Time series data can be Open, High, Low, Close, Volume or Adjusted Close (for dividends, splits and buybacks) and is aligned by date across symbols for analysis or subsequent system processing.

An analysis tab is provided to compare two symbols, such as a benchmark index and security. The analysis provides statistical and performance metrics and charts including return, correlation, risk and ratio calculations.

A query tab is provided to test the download of data for one symbol and one download source. This gets the raw data for all fields and I used within the main downloading process for date matching and time consolidation. The VBA code is open for viewing and modification if required.