This post details bringing in the Pivot Points study values from IC or QTrader into Excel.
The pivot point is the arithmetic average of the high (H), low (L), and closing (C) prices of the… more
This midweek look shows the Nikkei 225 (Osaka), Sep 25 contract with a -1.14% loss. The best performer in the US market is the E-mini MidCap 400, Sep 25 contract showing a gain of +2.21%.… more
Midweek, the OSE 10 Year JGB, Sep 25 contract is down -0.05%. The best performer in the US market is the 30yr US Treasury Bond (Globex), Sep 25 contract, which is up +0.30%. The best… more
Each Wednesday this article will be updated with the current seasonal study using CQG's Seasonal analysis applied to the Soybean, Wheat and Corn markets. You can download the CQG pac providing the… more
A bullish trend since the 2020 low- Silver breaks above a critical technical resistance level with a powerful Q2 signalA bullish key reversal on the quarterly platinum chart in Q2 2025A bullish key… more
The Excel VSTACK function appends arrays vertically and in sequence to return a larger array.
Syntax:
=VSTACK(array1,[array2],...)As an example, the post "Market Performance Dashboard… more
One important step when building Excel market dashboards is managing screen real estate. For example, in a recent post "CQG CME Markets Dashboards" a section displayed Corn 1-month Calendar… more
Midweek, the OSE 10 Year JGB, Sep 25 contract is down -0.01%. The best performer in the US market is the 30yr US Treasury Bonds (Globex), Sep 25 contract, which is up +0.80%. The best… more
This midweek look shows the Nikkei 225 (Osaka), Sep 25 contract with a +1.49% gain. The best performer in the US market is the E-mini NASDAQ-100, Sep 25 contract showing a gain of +2.82%.… more
Each Wednesday this article will be updated with the current seasonal study using CQG's Seasonal analysis applied to the Soybean, Wheat and Corn markets. You can download the CQG pac providing the… more