/
Preferences

Preferences

The Preferences icon will allow you to turn off both the History and Chart tooltip and the historical data refresh in addition to setting a timezone and hlighiting symbol cells of inactive or settled instruments.

 

Time Zone Settings

Update the timezone in which the ‘Timestamp’, ‘Last Time (Available)’ and ‘VolumeTimestamp’ fields display by selecting Exchange, Local or GMT. Note, the data will require an update (tick) or a restart of excel to take effect.

 

Default History & Chart Tooltip

Disable the History and Chart tooltip modal by turn off this preference. The tooltip is highlighted in red to the left below.

 

Historical Data Refresh

Disable Barchart for Excel’s auto refresh of historical data by turning the Historical Data Refresh off. When disabled, a sheet that contains historical data will not pick up the most recent data and will require a manual refresh.

 

Highlight Symbol Cell When Settled

Opt to Highlight the ‘Symbol’ cell for instruments that are currently settled or have not traded in their current open session.

 

Related content

Preferences
More like this
Watchlists
More like this
Barchart for Excel User Guide
Barchart for Excel User Guide
More like this
Account Menu
Account Menu
More like this
Display Settings
Display Settings
More like this
Chart
More like this