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
How To
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.
... moreJun 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
Dec 06, 2016
CQG Integrated Client and CQG QTrader customers can pull the time the high and low occurred during today’s session into a Microsoft Excel® spreadsheet using these RTD formulas:
=RTD("CQG.RTD", ,"ContractData", "EP", "... more