Workspaces

Thom Hartle
Jul 11, 2022
Updated: Jul 11, 2022

When using RTD functions in Excel to pull in market prices you have to manually format the prices. Excel does not know that the E-mini S&P 500 price has two decimals places (i.e. 3909.25) and the Euro FX has 5 decimals places (i.e. 1.06525).... more

Thom Hartle
Mar 16, 2022
Updated: Mar 16, 2022

Microsoft Excel spreadsheets have functionality to format cells based on conditions. This feature is also referred to as data visualization. This post details two types of data visualizations available in Excel: heat mapping and data bars.

... more
Thom Hartle
Jun 07, 2018
Updated: Jun 07, 2018

You can easily hide things unnecessary items in Microsoft Excel® to open up more screen real estate. All of my published CQG-powered Excel dashboards show you an image. You may have also noticed that the Excel ribbon, formula bar, and column/row... more