Using MARKET.RTD
Concept
MARKET.RTD allows loading quotes, historical prices, key statistics, financials, option chains for Yahoo Finance and MSN Money.
For example, you can 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 can 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 more at the Formula Builder description.
Also, you can find formatted reports in the Examples folder of the downloaded package.
Refresh Intervals
You can 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 can ban your IP.
Tickers
Use Yahoo Finance or MSN Money websites to find tickers.
Examples
You can 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 can 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 Value | Meaning |
|---|---|
| 1 | The value is changed up |
| 0 | The value is unchanged |
| -1 | The value is changed down |
Tick fields can be used for conditional formatting of the underlying fields or as independent columns.
Monitoring
You can 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 the complete list of the special data cells.
Configuring
You can change some of the application settings.
You can open the file using Start Menu, All Programs, MARKET.RTD, Configuration File.