Thom Hartle

This midweek look shows the best performer in the Japanese market is the TSE REIT Index, Sep 24 contract with a -0.31% loss. The best performer in the US markets is the E-mini Dow ($5), Sep… more

The best performer in the Japanese market is the TSE REIT Index, Sep 24 contract with a +1.98% gain. The best performer in the US markets is the E-mini Dow ($5), Sep 24 contract showing a… more

The Moving Average Convergence/Divergence indicator (MACD) was invented by Gerald Appel over 40 years ago. The study is an unbounded oscillator with two lines: MACD and MACDA.

This midweek snapshot shows a positive performance for the Equity Index futures markets. However, he best performer in the Japanese market is the TSE REIT Index, Sep 24 contract with a -0.… more

This posts details the use of two Excel functions: AVERAGEIFS and COUNTIFS. To start, a simple example of using the AVERAGEIFS function is presented.

In the image below column cells A2:A10… more

This midweek snapshot shows a positive performance for the Equity Index futures markets. The best performer in the Japanese market is the TOPIX, Sep 24 contract with a +4.34% gain. The best… more

A Pareto chart is a histogram chart displaying columns sorted in a descending order and a line representing the cumulative total percentage. Pareto charts highlight the largest factors in a data… more

This midweek snapshot shows a mostly negative performance for the Equity Index futures markets. The best performer in the Japanese market is the TSE REIT Index, Sep 24 contract with a +0.78… more

The post "Excel Combining SORTBY, CHOOSECOLS, and TAKE Functions" discusses Excel 365's Dynamic Arrays and the concept of returned data automatically "spilling" into a collection of cells.

… more

This midweek snapshot shows a positive performance for the Equity Index futures markets. The best performer in the Japanese market is the Nikkei 225 (Osaka), Sep 24contract with a +2.55% %… more