Stock and option data in Microsoft Excel
from Yahoo Finance and MSN Money
Stock Quotes in Microsoft Excel
Yahoo Finance publishes stock quotes from over 70 world exchanges.
Market.rtd allows refreshing stock quotes in Microsoft Excel.
To get stock quotes in Excel, just use formulas like these:
=RTD("market.rtd",,"YahooFinanceQuotes","AAPL","Open")
=RTD("market.rtd",,"YahooFinanceQuotes","AAPL","Last")
Fundamental Data in Microsoft Excel
Yahoo Finance publishes technical and fundamental data.
You can easily get estimated price target, PE, PEG, market cap,
dividends, actual and estimated EPS, etc.
To get the data, just use regular Excel formulas like these:
=RTD("market.rtd",,"YahooFinanceQuotes","FB","PERatio")
=RTD("market.rtd",,"YahooFinanceQuotes","FB","BookValue")
Historical Data in Microsoft Excel
Yahoo Finance publishes historical stock prices.
Market.rtd allows easily getting historical prices in Excel.
Just use Excel formulas like this:
=RTD("market.rtd",,"YahooFinanceHistoricalPrices","GOOG",
"2019-11-10","Close")
Option Data in Microsoft Microsoft Excel
Yahoo Finance publishes option chains.
Market.rtd allows getting option data in two forms:
by contract code and by contract parts.
To get option data in Excel, use formulas like these:
=RTD("market.rtd",,"YahooFinanceOptions","AAPL180119C00100000","OpenInt")
=RTD("market.rtd",,"YahooFinanceOptions","AAPL","2018-01-19",100,"CALL","OpenInt")
Stock and Option Watchlists in Microsoft Excel
You can create stock and option watchlists in Excel.
Just combine all required data using regular Excel formulas,
add formulas and values, apply formatting, etc.
Excel can help you to find trading opportunities.
Just open the workbook and check refreshed lists.
Track Portfolios in Excel
There a lot of excellent online tools for tracking portfolios.
Excel is an excellent tool for training and tracking history
of your trade successes and mistakes.
You can easily create multiple virtual portfolios and document your trade ideas.
Excel will do the other jobs.
Market.rtd Editions
| Personal | Standard | Enterprise | |
|---|---|---|---|
| Number of unique tickers in all opened workbooks | 1000 | 2000 | Unlimited |
| Commercial use | No | Yes | Yes |
| Annual subscription price, USD | 4995 | 7495 | 9995 |
| MARKET.RTD
The app loads data from Yahoo Finance and MSN Money into Microsoft Excel Version: 5.35 | 04/29/2024 | 4.6MB | Getting Started | What's New | Edition Comparison |
Download | Buy | Buy | Buy |
Disclaimer
Yahoo Finance is a logo and registered trademark of Yahoo! Inc.
MSN is a logo and registered trademark of Microsoft Corporation.
Microsoft Excel is a logo and registered trademark of Microsoft Corporation.