This post details how to use Excel’s Index and Matching function to extract data from a table. The example (downloadable sample at the bottom of the post) uses the 30 stocks in the DJIA as a… more
Workspaces
The CQG Statement Reports Add-In is installed with CQG IC and QTrader. This add-in works with CQG’s Statement Report generated from the Orders & Positions window.
Once you… more
This Microsoft Excel® dashboard displays all of the JPX-traded Japanese Government Bonds (JGB) contracts including volume and open interest data.
The first three columns detail the… more
This Microsoft Excel® dashboard displays all of the JPX-traded Three-Month TONA contracts including volume and open interest data.
The first three columns detail the contract month… more
This Microsoft Excel® dashboard displays all of the ICE-traded Three-Month SARON contracts including volume and open interest data.
The first three columns detail the contract month… more
This study calculates the Market Profile’s value area and point of control (POC). First, a brief overview of the Market Profile chart then the Excel RTD formulas for MPVAPOC, MPVAHigh and the… more
This Microsoft Excel® dashboard displays all of the ICE-traded Three-Month SONIA contracts including volume and open interest data.
The first three columns detail the contract month… more
This Microsoft Excel® dashboard displays all of the Globex-traded Three-Month SOFR contracts including volume and open interest data.
The first three columns detail the contract… more
This Microsoft Excel® macro enabled dashboard pulls in the Three Month SONIA Index Futures Contract which is a cash settled future based on the interest rate on a three month sterling deposit.… more
This Microsoft Excel® macro enabled dashboard pulls in the 30-Day Fed Funds market data traded on the CME Globex platform.
The Dashboard enables the user to enter in the symbol for the… more