Bruce for MACD3.8 gives 3 period and 8 period convergence divergence 

so how do i do for Tenkan and Kijun 

MACD(MAXH9 + MINL9) / 2) . (MAXH26 + MINL26) / 2)   ?? not getting right 

Maybe:

(XAVG(MAXH9 + MINL9, 3) - XAVG(MAXH9 + MINL9, 8)) / 2

And:

(XAVG(MAXH26 + MINL26, 3) - XAVG(MAXH26 + MINL26, 8)) / 2

Bruce that works perfect and 

how do i do plot histogram for divergence distance of tenkan and kijun please see the link 

Blue line is Tenkan 9 period and Pink line is Kijun 26 period 

https://www.dhirenshah.com/distance-tenkan-kijun/

Maybe:

(MAXH9 + MINL9 - MAXH26 - MINL26) / 2

thanks

You're welcome.