RealTimeToExcel software allows users to effortlessly update stock and option data from Yahoo! Finance, Google Finance, and MSN Money directly into Excel. It also provides access to fundamental and technical data, allowing the use of regular Excel formulas to get real-time quotes.
RealTimeToExcel is a powerful software that enables easy integration of stock and option data from Yahoo! Finance, Google Finance, and MSN Money into Excel. With this software, users can access a vast range of historical, fundamental, and technical data, as well as create watch lists and track their portfolios.
Using regular Excel formulas, users can get stock and option quotes with ease. For instance, to obtain the last price of AAPL, one can use the formula:=RTD('gartle.rtd',,'YahooFinanceWatchList','AAPL','Last'). For option data, formulas like this can be employed: =RTD('gartle.rtd',,'YahooFinanceOptions','AAPL','2015-01-17',100,'CALL','OpenInt').
RealTimeToExcel comes with a variety of formula examples, enabling users to retrieve the required data in a couple of minutes. With the ability to access data for 50 tickers for free, RealTimeToExcel is both a comprehensive and cost-effective solution.
Using regular Excel formulas, users can get stock and option quotes with ease. For instance, to obtain the last price of AAPL, one can use the formula:=RTD('gartle.rtd',,'YahooFinanceWatchList','AAPL','Last'). For option data, formulas like this can be employed: =RTD('gartle.rtd',,'YahooFinanceOptions','AAPL','2015-01-17',100,'CALL','OpenInt').
RealTimeToExcel comes with a variety of formula examples, enabling users to retrieve the required data in a couple of minutes. With the ability to access data for 50 tickers for free, RealTimeToExcel is both a comprehensive and cost-effective solution.
What's New
Version 3.3: Loading option chains from Yahoo! Finance has been fixed.