RealTimeToExcel RTD Server Settings

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.