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 using the Excel Ribbon for functionality. That post did not cover certain Excel Shortcuts that are not… 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 tracks the day's performance of the holdings of the State Street® SPDR® S&P® Metals & Mining… 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 CME-Emini Options.
The details provided can be used to change the markets monitored from 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 function syntax has the following arguments:
Database: The range of cells that makes up the list or… 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 action for symbols listed on the Display tab.
The dashboard is not password protected. The left… 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 for pulling in symbols. This post uses the entire set of rows on the data tab to search for symbols… 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 that are engaged in the Fund's investment theme of Space Exploration and defense innovation.
… 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, Soybean Oil, Wheat, Corn, Live Cattle, Feeder Cattle, Lean Hogs and Milk Class III.
The Soybean… more
This post is similar to the recent post "Excel 365 GROUPBY and XLOOKUP".
That post introduced using the Excel function GROUPBY to arrange by sectors the stocks in the NASDAQ 100 and identify the stock within each sector with the maximum percentage net change and the stock with minimum… more
This post details a CQG PAC that is a CQG page that can be downloaded and installed to track the day's performance of the holdings of the Schwab U.S. Dividend Equity ETF (Symbol: SCHD).
From Schwab's website:
Objective
The fund's goal is to track as closely as possible, before… more