Download Financial Market Time Series Data
  • Download Financial Market Time Series Data
  • Download Financial Market Time Series Data
  • Download Financial Market Time Series Data
  • Download Financial Market Time Series Data
Originally published: 14/05/2019 10:08
Publication number: ELQ-78821-1
View all versions & Certificate
certified

Download Financial Market Time Series Data

Download and align Open, High, Low, Close and Volume stock and index data for multiple symbols and time frequencies.

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.

This business tool includes
1 Excel file

Business Spreadsheets offers you this business tool for free!

download for free

Add to bookmarks

Discuss

Further information

Download time series data for multiple financial market symbols

Requiring historical data for stocks and indices for analysis

Performing complex analysis of financial market data

Reviews

  • No review yet!

keyboard_arrow_leftkeyboard_arrow_right

More tools from Business Spreadsheets

See all
keyboard_arrow_leftkeyboard_arrow_right

Any questions on Download Financial Market Time Series Data?

The user community and author are here to help. Go ahead!

please wait...