cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Instantly extract effect sizes, F-ratios, and FDR-adjusted p-values from your models with the Calculate Effects Sizes extension, available now in the JMP Marketplace!
  • New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
  • Your voice matters! Tell us how you prefer to receive JMP updates, so we can tailor our communication to your needs. Take short survey.

Discussions

Solve problems, and share tips and tricks with other JMP users.
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

Recommended Articles