Workspaces

Thom Hartle

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… more

Thom Hartle

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.… more

Thom Hartle

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… 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

Thom Hartle

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 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

Thom Hartle

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

Thom Hartle

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

Thom Hartle

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

Thom Hartle

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