Using WEB.RTD

Using WEB.RTD

Concept

WEB.RTD do the following:

  1. Downloads data from the specified URL and saves the data to a file.
  2. Parses the file and creates a navigation path for every topic.
  3. Refreshes RTD formula data in Excel.

WEB.RTD supports the following types of web data sources: JSON, XML, HTML, and CSV.

Navigation paths depend on data sources and look like

[0].Chart.Series[0].P

RTD formulas look like:

=RTD("web.rtd",,$A$1,"[0].Chart.Series[0].P")

You do not care about paths and formulas as you insert ready-to-use formulas using WEB.RTD Formula Builder.

However, you may modify formulas to customize your models. The formulas are valid while the page structure remains the same.

You may set the refresh interval for every URL. The default interval is 24 hours.

WEB.RTD makes two requests per second. So, refreshing data of 1000 URLs requires at least 500 seconds.

The default folder of downloaded files is %USERPROFILE%\AppData\Local\WEB.RTD\DataCache.
You may change it using the DataCacheDirectory setting.

You may find examples of loading data for stocks, options, and futures from Yahoo Finance, Google Finance, and MSN Money in the downloaded package.

Important Notes

Read terms of services of the websites before using WEB.RTD.

Some websites strictly prohibit automatic downloads. Do not use WEB.RTD in such cases.

For example, do not use WEB.RTD with www.cboe.com.

Also, do not make a lot of requests to websites. Otherwise, the websites may ban your IP.

Creating Reports

  1. Run WEB.RTD Formula Builder.
  2. Select the formula style, A1 or RC, and the formula separator, comma or semicolon.
  3. Paste the target URL and click Go.
  4. Click Copy Formulas.

  1. Create a new worksheet like source.
  2. Select cell A1 and paste the content.

  1. Copy the source worksheet to a new worksheet like report.
  2. Remove unnecessary cells and create a report as you need.
  3. Remove the source worksheet.

Useful Tips

  1. Insert Formula Builder formulas at cell A1.
    Cell A1 contains the requested URL. Keep it at cell A1 if possible. This allows adding formulas later in an easy way.
  2. Keep the formula that controls the refresh interval (in seconds) at the worksheet.
    The formula looks like
    =RTD("web.rtd",,$A$1,"RTD_REFRESHINTERVAL",24*60*60)

Changing Refresh Intervals

Set the refresh interval in seconds using formulas like this:

=RTD("web.rtd",,$A$1,"RTD_REFRESHINTERVAL",24*60*60)

where $A$1 contains the configured URL.