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.
MACD =… moreThom Hartle
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
This midweek snapshot shows a mostly negative performance for the Equity Index futures markets. However, the best performer in the Japanese market is the JPX Prime 150 Index, Sep 24… more
Tracking and analyzing cash market data is more difficult because most cash market data is a single print for the day of the report, that is there is no open, high, low or close, just the close.… more