The S&P Metals & Mining Select Industry Index represents the metals and mining sub-industry portion of the S&P Total Market Index. This post details a Microsoft Excel dashboard that… more
Thom Hartle
This midweek look shows the Nikkei 225 (Osaka), Jun 26 contract, with a gain of +0.68%. The best performer in the US market is the E-mini S&P 500, Jun 26 contract showing a gain of +0.… more
This options dashboard uses a combination of functionality from the CQG RTD Toolkit and Excel functions including SORT, FILTER, and RIGHT to track the options market. The markets monitored are the… more
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
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
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
The ARK Space & Defense Innovation ETF (Symbol: ARKX) goal is an actively managed ETF seeking long-term growth of capital by investing in domestic and foreign equity securities of companies… more
This Excel dashboard tracks agriculture markets and uses Excel's FILTER Function to pull the same month's contract data from each year.
The markets tracked are Soybeans, Soybean Meal,… more
This midweek look shows the Nikkei 225 (Osaka), Jun 26 contract, with a gain of +1.67%. The best performer in the US market is the E-mini NASDAQ 100, Jun 26 contract showing a gain of +0.76… more