Getting Started with Market.rtd

Getting Started with Market.rtd

Market.rtd allows loading data from Yahoo Finance, Google Finance, and MSN Money into Microsoft Excel spreadsheets.

Here is a pivot table of available data:

CategoryYahoo FinanceGoogle FinanceMSN Money
Quotes 
Historical Prices
Intraday Prices 
Options Chains 
Financials 
Instruments:
Stocks
Options (US market only)
Futures (US market only)  
Indexes 
Currencies 

You may create refreshable models using Excel RTD formulas like this:

The report uses formulas like these: 

=RTD("market.rtd",,"YahooFinanceQuotesCSV","AAPL","Open")
=RTD("market.rtd",,"YahooFinanceQuotesCSV","AAPL","High")
=RTD("market.rtd",,"YahooFinanceQuotesCSV","AAPL","Low")
=RTD("market.rtd",,"YahooFinanceQuotesCSV","AAPL","Last")

You may get ready-to-use formulas for any data provider using Formula Builder:

Also, you may find models for different data providers in the Examples folder of the downloaded package.

Market.rtd is an easy-to-use product.

Active your trial after setup. Then open examples from the downloaded package to see the common picture.

Then try Formula Builder and create your models.

When your trial period ends, choose an edition. If you have less than ten tickers, you may register Market.rtd for free.

Also, read Using Market.rtd to understand the product features deeply.