Market Data - Equity

Version 1.0.0.0 (659 KB) by Mario Santos
Gets equity prices and dividends from yahoo finance directly to Excel
0.0
(0)
156 Downloads
Updated 3 Aug 2015

View License

Using Spreadsheet Link EX, this simple but quite useful macro connects to Yahoo finance to download market data from the list of securities specified in the first sheet.
Prices and cash dividends are downloaded and some direct calculations are computed (log returns, volatilities and historical max/mins).

IMPORTANT: the exact location of DataFeed.m must be specified within "DataFeed" module in VBA.

Cite As

Mario Santos (2024). Market Data - Equity (https://www.mathworks.com/matlabcentral/fileexchange/52376-market-data-equity), MATLAB Central File Exchange. Retrieved .

MATLAB Release Compatibility
Created with R2015a
Compatible with any release
Platform Compatibility
Windows macOS Linux

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Equitymarketdata/

Version Published Release Notes
1.0.0.0