Using Market.rtd

Using Market.rtd

Concept

Market.rtd allows loading quotes, historical prices, key statistics, financials, option chains for Yahoo Finance, Google Finance, and MSN Money.

For example, you may create reports like this:

or this:

In both cases, you use regular RTD formulas like:

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

=RTD("market.rtd",,"YahooFinanceOptions","AAPL180119C00120000","Bid")

The formulas have the following rules:

=RTD("market.rtd",,"<provider>"[,<Parameter1>[,<Parameter2>[,<Parameter3>]]],"<Data Field>")

market.rtd is an RTD server name.

<provider> is name of a data provider like MsnMoneyQuotes or YahooFinanceOptions.

Parameters and data fields depend on data providers.

You may get formulas using Formula Builder. In the first step, you select a provider:

In the next steps, you configure formulas and paste them into Excel spreadsheets.

Open Formula Builder using Start, All Programs, Market.rtd, Formula Builder.

See the Formula Builder description here.

Also, you may find formatted reports in the Examples folder of the downloaded package.

Refresh Intervals

You may change the refresh interval (in seconds or as hh:mm:ss) of any provider using the formula like this (15 minutes):

=RTD("market.rtd",,"YahooFinanceQuotes","rtd_RefreshInterval",15*60)

Do not make a lot of requests to the website. Otherwise, the website may ban your IP.

Tickers

Use Yahoo Finance, Google Finance or MSN Money websites to find tickers:

Examples

You may find examples in the Examples folder of the downloaded package.

Use these examples as templates or to troubleshoot formulas and loading data.

Tick Fields

You may use special tick fields. Just add the :tick suffix to the data field name.

For example:

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

=RTD("market.rtd",,"YahooFinanceQuotes","AAPL","Last:tick")

Tick values:

Tick ValueMeaning
1The value is changed up
0The value is unchanged
-1The value is changed down

Tick fields can be used for conditional formatting of the underlying fields or as independent columns.

Monitoring

You may use special data fields to monitor downloading data.

For example:

=RTD("market.rtd",,"YahooFinanceQuotes","AAPL","rtd_LastUpdate")

=RTD("market.rtd",,"YahooFinanceQuotes","AAPL","rtd_LastError")

The formulas above show the last data update time and the last error code for the AAPL ticker.

See a complete list of the special data cells here.

Configuring

You may change some of the application settings.

The most useful setting is the Yahoo! API key that allows refreshing data more frequently.

You may open the file using Start Menu, All Programs, Market.rtd, Configuration File.