Workspaces

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

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

The Net Change Curve chart displays a collection of symbols’ daily net price change or daily net percentage change making it easy to compare on a relative basis each market’s current session’s… more

This Microsoft® Excel Dashboard comes frontloaded with 30 Sector and Industry symbols. However, you can enter in whatever symbols you like using the Symbols tab. The long description of the symbol… more

Traders and investors have a multitude of opportunities for theme investing. That is, ETFs are structured to invest in companies that are part of an industry, such as Biotech, Internet, Aerospace… more