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.