RealTimeToExcel Specifications
|
UPdate stock and option data from Yahoo Finance in Excel.
RealTimeToExcel updates stock and option data from Yahoo! Finance in Excel.
You may use regular Excel formulas to get stock and option quotes, historical, fundamental and technical data.
You may easily create watch lists and track your portfolios.
For example, to get the last price of AAPL, use the formula:
=RTD('gartle.rtd',,'YahooFinanceWatchList','AAPL','Last')
To get option data, use formulas like this:
=RTD('gartle.rtd',,'YahooFinanceOptions','AAPL','2015-01-17',100,'CALL','OpenInt')
The product includes examples for all available formulas.
So you may get required data in a couple of minutes.
Yahoo! Finance publishes data from 60 world exchanges. You may get it for free.
RealTimeToExcel complies with Yahoo! Terms of Services.
Download (6.95MB)