Market Data - Equity
버전 1.0.0.0 (659 KB) 작성자:
Mario Santos
Gets equity prices and dividends from yahoo finance directly to Excel
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.
인용 양식
Mario Santos (2026). Market Data - Equity (https://kr.mathworks.com/matlabcentral/fileexchange/52376-market-data-equity), MATLAB Central File Exchange. 검색 날짜: .
MATLAB 릴리스 호환 정보
개발 환경:
R2015a
모든 릴리스와 호환
플랫폼 호환성
Windows macOS Linux카테고리
- Computational Finance > Financial Toolbox >
- MATLAB > Data Import and Analysis > Data Import and Export > Standard File Formats > Spreadsheets >
- Computational Finance > Spreadsheet Link > Data Import from MATLAB >
- Computational Finance > Financial Instruments Toolbox > Price Instruments Using Functions > Equity Derivatives >
Help Center 및 MATLAB Answers에서 Financial Toolbox에 대해 자세히 알아보기
태그
Equitymarketdata/
| 버전 | 게시됨 | 릴리스 정보 | |
|---|---|---|---|
| 1.0.0.0 |
