RealTimeToExcel is software that integrates Yahoo! Finance, Google Finance, and MSN Money data into Excel. It allows users to access stock and option quotes, fundamental and technical data using regular Excel formulas.
If you are looking for a powerful and easy-to-use software for updating stock and option data in Excel, you may want to check out RealTimeToExcel. This comprehensive tool allows you to access and utilize live stock and option data from Yahoo! Finance, Google Finance, and MSN Money within Excel.
One of the great features of RealTimeToExcel is the ability to use regular Excel formulas to retrieve a wide range of market data, including quotes, historical data, fundamental data, and technical data. This makes it easy to get the information you need to make informed investment decisions.
Another useful function of RealTimeToExcel is the ability to create watch lists and track portfolios. This means that you can easily monitor the performance of multiple stocks or options at once, allowing you to stay updated and make changes as needed.
To use RealTimeToExcel, all you need to do is enter a formula into Excel. For example, to get the last price of AAPL, you can simply use the formula:=RTD('gartle.rtd',,'YahooFinanceWatchList','AAPL','Last'). If you want option data, you can use a formula like this:=RTD('gartle.rtd',,'YahooFinanceOptions','AAPL','2015-01-17',100,'CALL','OpenInt'). And if you need help getting started, the product includes examples for all available formulas.
With RealTimeToExcel, you can get the data you need in just a couple of minutes. And the best part is that you can get data for up to 50 tickers for free. So if you are ready to take your investing to the next level, give RealTimeToExcel a try today!
One of the great features of RealTimeToExcel is the ability to use regular Excel formulas to retrieve a wide range of market data, including quotes, historical data, fundamental data, and technical data. This makes it easy to get the information you need to make informed investment decisions.
Another useful function of RealTimeToExcel is the ability to create watch lists and track portfolios. This means that you can easily monitor the performance of multiple stocks or options at once, allowing you to stay updated and make changes as needed.
To use RealTimeToExcel, all you need to do is enter a formula into Excel. For example, to get the last price of AAPL, you can simply use the formula:=RTD('gartle.rtd',,'YahooFinanceWatchList','AAPL','Last'). If you want option data, you can use a formula like this:=RTD('gartle.rtd',,'YahooFinanceOptions','AAPL','2015-01-17',100,'CALL','OpenInt'). And if you need help getting started, the product includes examples for all available formulas.
With RealTimeToExcel, you can get the data you need in just a couple of minutes. And the best part is that you can get data for up to 50 tickers for free. So if you are ready to take your investing to the next level, give RealTimeToExcel a try today!
What's New
Version 3.3:
Yahoo! Finance Financials.
Google Finance Financials.
Universal HTML provider.
French and Italian translations.
PostgreSQL support.