This post builds upon the previous post: Excel 365 TRIMRANGE Function.
That post detailed how to build a quote display using the TRIMRANGE function to automatically manage working with… more
Workspaces
Microsoft Excel 365 offers the TRIMRANGE function which excludes all empty rows and/or columns from the outer edges of a range or array. This post details how this function is useful for designing… more
This Excel Dashboard uses RTD Calls to pull in the Net Percent Change of a collection of markets by a particular date.
For example, April 9, 2025:
"Markets News, April 9, 2025: Dow… more
This post details adding HTML News Links to an Excel dashboard for monitoring equities and ETFs.
The news source is Finance.Yahoo.com. An example link for Microsoft is https://finance.yahoo.… more
This post details an Excel dashboard tracking Country Equity ETFs performance. The dashboard ranks and sorts the Country ETFs traded using the NYSE American enablement. Fifty-one ETFs are tracked… more
This post details the downloadable Excel Market Performance Dashboard's features and functions. The dashboard has seven tabs (the first is data and the other tabs display a chart and a table of… more
Recent posts detailed observing market data during pre-, current, and post-market sessions. The post View Pre and Post Sessions for Stocks detailed the steps to displaying a chart that included… more
CQG IC and QTrader users can chart bid and ask orders activity for stocks during pre-market trading hours and after-market trading hours. This requires a custom session and setting the chart data… more
The Excel MAXIF function returns the maximum value from a range of cells and a criteria range. For example. The downloadable sample at the bottom of this post is determining the best performance… more
Introduction
Cboe Europe Derivatives (CEDX) is a European derivatives marketplace which enables participants to access equity derivatives markets for quotes and trade execution.
CEDX offers a… more