NEMAC    Net Effective Market Activity Components™   (© 1990 NEMAsystem.com)   B/S  HIGHLIGHTS      Home       About NEMAC      Cautions     Acronyms       Equations      NEMA Data     Indicators using the NEMA components for: S&P 500    BEANS    COPPER   GOLD    BONDS     

__________________________________________________________________________________________________ Equations: Basic calculations used in indicators and the Excel spreadsheet. 

Date numbers that exclude weekend dates for plotting along the x-axis of charts:  This equation was published years ago in the “Lotus Notes” (author is currently unknown).  After the dates are copied down to the end of the spreadsheet, only the date numbers are transferred to the next column, which is used as the x-axis values.  A text box is used to add the months along the x-axis on charts.

DateF8=F7 + 1 + (MOD(F7,7)=6)*2    where the first date is given in column F, row 7, using the Excel DATEVALUE function.

Short term auto-trend (A-T) calculation: Also called the "336 trend", a simple daily trend is calculated using the last 4 days of information for several of the NEMAC indicators, and for the closing price curve.  In this example closing price is used.  The 4 day trend direction, up or down, is calculated in this spreadsheet using the logic that if the current value of today’s smoothed price is greater than the highest value of the previous 3 day’s smoothed price, AND if today’s current raw price is greater than the previous 3 day’s highest raw price, then the trend is up.  Likewise, the trend changes to down, if today’s value is less than the 3 day minimum, for both cases.  In Excel, the below  equation is entered::

 M10=IF(L10>MAX(L7:L9)#AND#K10>MAX(K7:K9),Upvalue, IF(L10<MIN(L7:L9)#AND#K10<MIN(K7:K9),Dnvalue,PrevValue)).

In this example the trend equation is in column M, row 10, the smoothed daily close values are in column L and the raw close values are in column K.  Upvalue & Dnvalue are the up and down values for plotting the trend curve on a chart.  The 6 day EPMA is used for the smoothing.  The value 6 was determined by running a study that compared the results for 4 through 11 day EPMA's.

NEMA component (NEMAC) equations:   The relationship to volume is given by the basic NEMA components equation presented earlier in "AboutNEMA."

        (1)     NL+LC+NS+SC = V     V = daily volume, contracts.

The equations for the above four components are given in this "NEMAC" link.

End Point Moving Average (EPMA): As a reference, the EPMA equations can be seen here.

The resulting equations for the 3, 4, 8, 11, and 13 day EPMA can be used in spreadsheet design applications, where p is the variable to be smoothed.  It is listed in a column of the spreadsheet. When the variable smoothed is daily net buying (NB), a comparison of the results with the close price curve shows that the 11 day EPMA most closely matches (and predicts) the price curve behavior.

Most currently used indicators: The second chart labeled "NBBS" in each of the sets of futures charts (and CBBS in earlier charts) is used to evaluate key indicators.  Earlier charts can be used to show how a current indicator "behaved" in the past.  And some show a progression of indicators that are no longer used, but are included for the record.

The current NBBS charts indicate B/S signals that could result from the above short term trends of two key variables (NB₁₁ A-T & cLASA A-T), and the status of other key variables.

Signal Characteristics of key indicators are shown below for different market conditions.

Strong Up Trend:

Strong Down Trend:

Sideways Trend

Past B/S Signals, Good & Bad:

For inputs to the webmaster,  email info@NEMAsystem.com