RealTimeToExcel software updates real-time stock and option data from Yahoo! Finance, Google Finance, and MSN Money directly into Excel. Users have access to regular Excel formulas to obtain stock and option quotes along with fundamental and technical data.
RealTimeToExcel is an excellent software that facilitates the update of stock and option data from various finance sources such as Yahoo! Finance, Google Finance, and MSN Money, all within Excel. With this software, regular Excel formulas may be utilized to obtain stock and option quotes, historical, fundamental, and technical data.
This software is highly efficient as it allows the creation of watchlists and the tracking of portfolios without any hassle. An example of how to obtain the last price of AAPL would be by using the formula: =RTD('gartle.rtd',,'YahooFinanceWatchList','AAPL','Last')
To obtain option data, on the other hand, one may use formulas like =RTD('gartle.rtd',,'YahooFinanceOptions','AAPL','2015-01-17',100,'CALL','OpenInt'). It's also worth noting that the product comes with examples for all available formulas to hasten the process of acquiring necessary data.
Lastly, the software allows free access to data for 50 tickers, making it an excellent tool for stock traders who are just starting out or who want to try it out first. Overall, RealTimeToExcel is an excellent software for stock and option traders who wish to optimize the use of Excel for better results.
This software is highly efficient as it allows the creation of watchlists and the tracking of portfolios without any hassle. An example of how to obtain the last price of AAPL would be by using the formula: =RTD('gartle.rtd',,'YahooFinanceWatchList','AAPL','Last')
To obtain option data, on the other hand, one may use formulas like =RTD('gartle.rtd',,'YahooFinanceOptions','AAPL','2015-01-17',100,'CALL','OpenInt'). It's also worth noting that the product comes with examples for all available formulas to hasten the process of acquiring necessary data.
Lastly, the software allows free access to data for 50 tickers, making it an excellent tool for stock traders who are just starting out or who want to try it out first. Overall, RealTimeToExcel is an excellent software for stock and option traders who wish to optimize the use of Excel for better results.
What's New
Version 3.3:
Yahoo! Finance Financials.
Google Finance Financials.
Universal HTML provider.
French and Italian translations.
PostgreSQL support.