This Microsoft Excel® dashboard has two parts: the top half pulls the forward curves for soybeans, corn, and wheat traded on the CME Globex platform and the bottom half pulls the USDA Crop Progress Reports by date. The USDA reports are issued at... more
This Microsoft Excel® dashboard presents two charts of the Nasdaq-100 futures contract and market data for the one hundred stocks that are constituents of the Nasdaq 100 Index.
The chart in the top left corner displays the 10-day... more
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
This is an updated post detailing new features in the original dashboards from a previous post. The three downloadable Microsoft Excel® dashboards present a unique view of four markets. Each overlay chart displays 5-minute percent net change... more
This Microsoft Excel® spreadsheet pulls in market data for NFX WTI Crude Oil Penultimate Financial (symbol: NTQ) and NFX Brent Crude (symbol: BFQ), both traded on the NASDAQ OMX Futures Exchange (NFX).
The forward curves display... more
This article walks through the details of using three Microsoft Excel® functions: RANK, COUNTIF, and VLOOUP. These functions are used to build an Excel dashboard that automatically ranks a collection of markets based on percent net change and... more
This article introduces a collection of RTD formulas that returns time values instead of market or study values.
CQG provides the time of the highest high and the time of the lowest low from the current session via RTD:... more
This Microsoft Excel® dashboard displays market data for a user-selected symbol. The standard market data includes the CQG Algo Orders study, which is only available in CQG’s flagship product, CQG Integrated Client (CQG IC). This study monitors... more
Various markets have different times for their trading sessions. Some markets, such as the Bund contract (symbol: DB) traded on Eurex, has only one session. Other markets, such as the E-mini S&P 500 contract (symbol: EP) traded on the CME... more
This Microsoft Excel® spreadsheet pulls in five Imoku studies along with open, high, low, and close bar values. You can change the symbol and the time frame. You can retrieve up to 300 daily bars and up to 3,000 intraday bar values. The... more