RealTimeToExcel RTD Server Settings
You can change the RealTimeToExcel settings in the RealTimeToExcel.dll.config file in the installation folder.
The default installation folder depends on the installed product:
- %ProgramFiles%\Gartle\RealTimeToExcel
- %ProgramFiles%\Gartle\RealTimeToDB
Configuration parameters:
- RefreshTimerInterval
- This integer value defines the minimum interval of data refreshing in milliseconds.
The default value is 500 milliseconds. - DataCacheDirectory
- This string value allows changing the cache directory of downloaded data.
The default value is %USERPROFILE%\AppData\Local\RealTimeToExcel\DataCache on Windows Vista and later,
and %USERPROFILE%\Local Settings\Application Data\RealTimeToExcel\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://learn.microsoft.com/en-us/windows-hardware/manufacture/desktop/default-time-zones?view=windows-11. - TraceDownload
- This boolean value controls download logging.
The default value is False. - LogFileName
- This string value allows changing the log file name.
The default value is %USERPROFILE%\AppData\Local\RealTimeToExcel\RealTimeToExcel.log on Windows Vista and later,
and %USERPROFILE%\Local Settings\Application Data\RealTimeToExcel\RealTimeToExcel.log on Windows XP. - YahooConsumerKey
- This string values used to specify Yahoo! API Consumer Key.
- YahooConsumerSecret
- This string values used to specify Yahoo! API Consumer Secret.
You can get values of server settings into Microsoft Excel. See RealTimeToExcel fields.