From their website:
The iShares Semiconductor ETF seeks to track an U.S. equity index of companies in the semiconductor sector. The fund offers a way to invest in companies across the semiconductor value chain, including those driving innovation in AI and benefiting from capital… more
This post offers a sample spreadsheet with typical RTD formulas used for building a market quotes dashboard. You can download the dashboard and enter in symbols. All capital letters are required. The prices are manually formatted for the proper number of decimals.
The table below presents… more
The London Metal Exchange (LME) is the world center for the trading of industrial metals. The majority of non-ferrous metal futures business is transacted on the LME platforms.
The LME refers to delivery dates as "Prompt Dates." Monthly prompt dates are normally the third Wednesday of the… more
From the iShares website:
The iShares MSCI USA Momentum Factor ETF (Symbol: MTUM) seeks to track an index of U.S. stocks exhibiting relatively high price momentum. The fund offers a way to capture trends in the market by investing in companies with strong recent performance.
This… 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 SPDR® S&P® Metals & Mining ETF.
From The State Street website:
Seeks to provide exposure to the metals & mining segment of the S&P… more
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