The Excel DGET function extracts a single value from a column of a list or database that matches conditions that you specify.
The syntax is DGET(database, field, criteria).
The DGET… more
This midweek look shows the Nikkei 225 (Osaka), Jun 26 contract, with a gain of +4.11%. The best performer in the US market is the E-mini NASDAQ 100, Jun 26 contract showing a gain of +2.75… more
Midweek, the OSE 10 Year JGB, Jun 26 contract is higher by +0.15%. The best performer in the US market is the 30yr US Treasury Bond (Globex), Jun 26 contract, which is up +0.53%. 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
This post presents a macro enabled Excel Light Crude Oil dashboard using combined functionality detailed in previous Workspace posts. The dashboard uses numerous RTD calls for today's market… more
This post builds upon the post: Excel Agriculture Dashboard Using the FILTER Function.
The original post built market quote display blocks using a data tab with specific row ranges employed… more
Gold corrected from the late January record high after ten consecutive quarterly new highsThe bull market began in 1999. Corrections have been "golden" buying opportunitiesThe case for gold… more
This midweek look shows the Nikkei 225 (Osaka), Jun 26 contract, with a loss of -1.31%. The best performer in the US market is the E-mini S&P 500, Jun 26 contract showing a loss of -0.… more
Midweek, the OSE 10 Year JGB, Jun 26 contract is lower by -0.34%. The best performer in the US market is the 2yr US Treasury Note (Globex), Jun 26 contract, which is down -0.2229%. 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