cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
lwx228
Level VIII

How to use JMP to calculate the technical indicators of stock————MACD?

New Year is coming, I wish community friends a happy New Year!
Now I want to use JMP for stock data statistics, but it is still a novice, find a few stock JMP sample file, did not see the calculation of technical indicators example.


For example, in the calculation of "MACD", I still don't understand the calculation of EMA.


After searching the manual books, the formula (mark 1 in the Image) for EMA in the manual is at the first place, but the formula (mark 2) in the example file does not seem to be this one
Consult to everybody expert, thank!

 


MACD calculation formula:


DIF : EMA(CLOSE,12) - EMA(CLOSE,26);
DEA : EMA(DIF,6);
MACD : 2*(DIF-DEA);

 

 

2018-12-31_18-31-46.png

 

12 REPLIES 12
lwx228
Level VIII

Re: How to use JMP to calculate the technical indicators of stock————MACD?

It seems that JMP is mainly used for scientific research and statistical analysis, so it has no further function for stock statistics and drawing.

 

It doesn't seem to be able to make a Candlestick Chart.Can excel.

 

However, JMP calculates statistics very quickly in this respect.
Thank gzmorgan0!

lwx228
Level VIII

Re: How to use JMP to calculate the technical indicators of stock————MACD?

Stock software SMA calculation and JMP SMA calculation is still different.

 

 

There are many calculation steps for technical index "DMI", but there is no complicated formula, which can be implemented by JMP.

lwx228
Level VIII

Re: How to use JMP to calculate the technical indicators of stock————MACD?

In excel, the candle picture is quite perfect.I made it for adjustable quantity.

 

2019-01-03_21-36-39.png