Stock and option data in Excel?

From Yahoo Finance, Google Finance, or MSN Money?

Yes, you are in the right place!

Stock Quotes in Excel

Yahoo Finance publishes delayed stock quotes from over 60 world exchanges through the Yahoo YQL web service.
Our product Market.rtd allows getting and refreshing these stock quotes in Microsoft Excel.
To get stock quotes in Excel, just use formulas like these:

=RTD("market.rtd",,"YahooFinanceWatchList","AAPL","Open")

=RTD("market.rtd",,"YahooFinanceWatchList","AAPL","Last")
        

Fundamental Data in Excel

Yahoo Finance publishes technical and fundamental data.
You may 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 Excel

Yahoo Finance publishes historical stock prices.
Market.rtd allows easily getting stock prices for the specified symbol and date in Excel.
Just use Excel formulas like this:

=RTD("market.rtd",,"YahooFinanceHistoricalData","GOOG",
     "2017-05-19","Close")

Option Data in 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 Excel

You may 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 may easily create multiple virtual portfolios and document your trade ideas. Excel will do the other jobs.

Market.rtd Editions

FreePersonalStandardEnterprise
Number of unique tickers in all opened workbooks1010002000Unlimited
Commercial useYesNoYesYes
Price per copy, one timeFree$100$150$200

Disclaimer

Yahoo Finance is a logo and registered trademark of Yahoo! Inc.
Google Finance is a logo and registered trademark of Google Inc.
MSN is a logo and registered trademark of Microsoft Corporation.
Microsoft Excel is a logo and registered trademark of Microsoft Corporation.