This midweek look shows the Nikkei 225 (Osaka), Jun 26 contract, with a loss of -1.11%. The best performer in the US market is the E-mini Dow, Jun 26 contract showing a gain of +0.74%. The… more
Thom Hartle
Knowing Excel Shortcuts will increase your efficiency with designing your Excel dashboards. There is a previous post, "Excel Keyboard Shortcuts," that detailed Excel shortcuts that eliminated… more
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
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