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:

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