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 (2024). Market Data - Equity (https://www.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 についてさらに検索
タグ
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!Equitymarketdata/
バージョン | 公開済み | リリース ノート | |
---|---|---|---|
1.0.0.0 |