Getting Started with MARKET.RTD

Getting Started with MARKET.RTD

MARKET.RTD allows loading data from Yahoo Finance and MSN Money into Microsoft Excel spreadsheets.

Here is a pivot table of available data:

CategoryYahoo 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.

Also, read Using MARKET.RTD to understand the product features deeply.

This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.