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")

Stock Quotes from Yahoo! Finance in Excel

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")

Fundamental Stock Data From Yahoo! Finance in Excel

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")

Historical Prices From Yahoo! Finance in Excel

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.

Option Data From Yahoo! Finance in Excel

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.

Stock Watch Lists in Microsoft Excel

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.

Tracking Stock Portfolio in Excel

Market.rtd Editions

PersonalStandardEnterprise
Number of unique tickers in all opened workbooks10002000Unlimited
Commercial useNoYesYes
Annual subscription price, USD499574959995
MARKET.RTD
The app loads data from Yahoo Finance and MSN Money into Microsoft Excel
Version: 5.21 | 03/22/2021 | 4.6MB | Getting Started | What's New | Edition Comparison
Download
BuyBuyBuy

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.