MARKET.RTD Application Settings

MARKET.RTD loads application settings from the market.rtd.dll.config file located in the local application folder like

C:\Users\<Your user name>\AppData\Gartle\MARKET.RTD\market.rtd.dll.config

You can open the file using Start Menu, All Programs, MARKET.RTD, Configuration File.

Configuration file example:

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
    <appSettings>
        <add key="StorageType" value="SQLite"/>
        <add key="DataCacheDirectory" value=""/>
        <add key="TimeZone" value="Eastern Standard Time"/>
        <add key="YahooConsumerKey" value=""/>
        <add key="YahooConsumerSecret" value=""/>
    </appSettings>
</configuration>

Configuration parameters:

StorageType

This string value defines where to store downloaded data: an SQLite database or the file system.
Possible values: SQLite (default) and Folder.
The files are located in the DataCacheFolder.

DataCacheDirectory

This string value allows changing the cache directory of downloaded data.
The default value is %USERPROFILE%\AppData\Local\market.rtd\DataCache on Windows Vista and later,
and %USERPROFILE%\Local Settings\Application Data\market.rtd\DataCache on Windows XP.

TimeZone

The string value is used to adjust the PC time used in the rtd_LastUpdate, rtd_LastUpdateDate, and rtd_LastUpdateTime fields.
The default value is Eastern Standard Time.
See available time zones at https://technet.microsoft.com/en-us/library/cc749073(v=ws.10).aspx.

YahooConsumerKey

This string values used to specify Yahoo! API Consumer Key. See below.

YahooConsumerSecret

This string values used to specify Yahoo! API Consumer Secret. See below.

You can get application settings using RTD formulas.

Yahoo! API Key

Yahoo! specifies the following usage limits:

• 1000 calls per hour for IP authenticated users.
• 10000 calls per hour for applications identified by Access Key.

So, you can increase the usage limits. Do the following steps:

1. Get your Yahoo! API Key at https://developer.yahoo.com/apps/.
2. Specify Consumer Key and Consumer Secret in the configuration file.
3. Restart Excel.