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
Equity
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
Certified stocks are bags of coffee that have been graded by the ICE exchange by ICE approved graders and are warehoused in exchange approved warehouses around the world. ICE reports the current… more
This post details using the Microsoft® Excel “Scatter Plot” Chart to track market performance. In this example, RTD formulas are used to pull in the percent net change of the 30 stocks that are in… 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
Microsoft® Excel 2016 and higher offers the Waterfall Chart. The Waterfall Chart is also known as a bridge chart or a cascade chart. Typically, this kind of chart is used to see how positive or… more
Microsoft® Excel 2016 and higher offer a new chart type: The Treemap. A treemap chart provides a hierarchical view of your data. This view makes it easy to spot patterns, such as which markets are… more
This article builds upon the post titled “Evaluate ETF Constituents Performance Using Excel” that detailed gauging the current price of a stock relative to the high as an indication of relative… more
If you track the performance of ETFs you may be interested in evaluating the performance of the stocks that are held by the ETF, such as the Invesco QQQ ETF, which tracks the Nasdaq-100 Index. Two… more
SPDR® Sector ETFs Analysis Dashboard This Microsoft® Excel dashboard provides analysis of S&P Sectors based on ETFs. The collection of ETFs are:
Symbol Description XLC Communication… more