New version 18 available now


Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Profile: dhirenshah
About
User Name: dhirenshah
Groups: Gold User, Member, Platinum User, TeleChart
Rank: Registered User
Real Name:
Location
Occupation:
Interests:
Gender: Gender:
Statistics
Joined: Saturday, March 10, 2012
Last Visit: Thursday, May 17, 2018 7:56:13 PM
Number of Posts: 322
[0.11% of all post / 0.14 posts per day]
Avatar
Last 10 Posts
Topic: Inverse the formula please
Posted: Friday, May 04, 2018 11:39:25 AM

Ok Bruce No problem i will continue eyeballing the trades... 

Thanks have a great weekend ... 

Topic: Inverse the formula please
Posted: Friday, May 04, 2018 10:25:40 AM

Hi Bruce 

these below two formula you wrote for me while back and they work fantastic as they are.. but i m trying to Inverse them and use for a different reason and having no luck doing it right... 

Example AAPL on daily April 24,2018 was true with this formula as below 

1) C < IIF(MINL2 > L2 AND L2 < MINL2.3, C, IIF(MINL2.1 > L3 AND L3 < MINL2.4, L3, IIF(MINL2.2 > L4 AND L4 < MINL2.5, IIF(C1 > L4, L4, C), IIF(MINL2.3 > L5 AND L5 < MINL2.6, IIF(MINC2.1 > L5, L5, C), IIF(MINL2.4 > L6 AND L6 < MINL2.7, IIF(MINC3.1 > L6, L6, C), IIF(MINL2.5 > L7 AND L7 < MINL2.8, IIF(MINC4.1 > L7, L7, C), IIF(MINL2.6 > L8 AND L8 < MINL2.9, IIF(MINC5.1 > L8, L8, C), IIF(MINL2.7 > L9 AND L9 < MINL2.10, IIF(MINC6.1 > L9, L9, C), IIF(MINL2.8 > L10 AND L10 < MINL2.11, IIF(MINC7.1 > L10, L10, C), IIF(MINL2.9 > L11 AND L11 < MINL2.12, IIF(MINC8.1 > L11, L11, C), IIF(MINL2.10 > L12 AND L12 < MINL2.13, IIF(MINC9.1 > L12, L12, C), IIF(MINL2.11 > L13 AND L13 < MINL2.14, IIF(MINC10.1 > L13, L13, C), IIF(MINL2.12 > L14 AND L14 < MINL2.15, IIF(MINC11.1 > L14, L14, C), IIF(MINL2.13 > L15 AND L15 < MINL2.16, IIF(MINC12.1 > L15, L15, C), IIF(MINL2.14 > L16 AND L16 < MINL2.17, IIF(MINC13.1 > L16, L16, C), IIF(MINL2.15 > L17 AND L17 < MINL2.18, IIF(MINC14.1 > L17, L17, C), IIF(MINL2.16 > L18 AND L18 < MINL2.19, IIF(MINC15.1 > L18, L18, C), IIF(MINL2.17 > L19 AND L19 < MINL2.20, IIF(MINC16.1 > L19, L19, C), IIF(MINL2.18 > L20 AND L20 < MINL2.21, IIF(MINC17.1 > L20, L20, C), IIF(MINL2.19 > L21 AND L21 < MINL2.22, IIF(MINC18.1 > L21, L21, C), IIF(MINL2.20 > L22 AND L22 < MINL2.23, IIF(MINC19.1 > L22, L22, C), IIF(MINL2.21 > L23 AND L23 < MINL2.24, IIF(MINC20.1 > L23, L23, C), IIF(MINL2.22 > L24 AND L24 < MINL2.25, IIF(MINC21.1 > L24, L24, C), IIF(MINL2.23 > L25 AND L25 < MINL2.26, IIF(MINC22.1 > L25, L25, C), IIF(MINL2.24 > L26 AND L26 < MINL2.27, IIF(MINC23.1 > L26, L26, C), IIF(MINL2.25 > L27 AND L27 < MINL2.28, IIF(MINC24.1 > L27, L27, C), IIF(MINL2.26 > L28 AND L28 < MINL2.29, IIF(MINC25.1 > L28, L28, C), IIF(MINL2.27 > L29 AND L29 < MINL2.30, IIF(MINC26.1 > L29, L29, C), IIF(MINL2.28 > L30 AND L30 < MINL2.31, IIF(MINC27.1 > L30, L30, C), IIF(MINL2.29 > L31 AND L31 < MINL2.32, IIF(MINC28.1 > L31, L31, C), IIF(MINL2.30 > L32 AND L32 < MINL2.33, IIF(MINC29.1 > L32, L32, C), IIF(MINL2.31 > L33 AND L33 < MINL2.34, IIF(MINC30.1 > L33, L33, C), IIF(MINL2.32 > L34 AND L34 < MINL2.35, IIF(MINC31.1 > L34, L34, C), IIF(MINL2.33 > L35 AND L35 < MINL2.36, IIF(MINC32.1 > L35, L35, C), IIF(MINL2.34 > L36 AND L36 < MINL2.37, IIF(MINC33.1 > L36, L36, C), IIF(MINL2.35 > L37 AND L37 < MINL2.38, IIF(MINC34.1 > L37, L37, C), IIF(MINL2.36 > L38 AND L38 < MINL2.39, IIF(MINC35.1 > L38, L38, C), IIF(MINL2.37 > L39 AND L39 < MINL2.40, IIF(MINC36.1 > L39, L39, C), IIF(MINL2.38 > L40 AND L40 < MINL2.41, IIF(MINC37.1 > L40, L40, C), IIF(MINL2.39 > L41 AND L41 < MINL2.42, IIF(MINC38.1 > L41, L41, C), IIF(MINL2.40 > L42 AND L42 < MINL2.43, IIF(MINC39.1 > L42, L42, C), IIF(MINL2.41 > L43 AND L43 < MINL2.44, IIF(MINC40.1 > L43, L43, C), IIF(MINL2.42 > L44 AND L44 < MINL2.45, IIF(MINC41.1 > L44, L44, C), IIF(MINL2.43 > L45 AND L45 < MINL2.46, IIF(MINC42.1 > L45, L45, C), IIF(MINL2.44 > L46 AND L46 < MINL2.47, IIF(MINC43.1 > L46, L46, C), IIF(MINL2.45 > L47 AND L47 < MINL2.48, IIF(MINC44.1 > L47, L47, C), IIF(MINL2.46 > L48 AND L48 < MINL2.49, IIF(MINC45.1 > L48, L48, C), IIF(MINL2.47 > L49 AND L49 < MINL2.50, IIF(MINC46.1 > L49, L49, C), IIF(MINL2.48 > L50 AND L50 < MINL2.51, IIF(MINC47.1 > L50, L50, C), IIF(MINL2.49 > L51 AND L51 < MINL2.52, IIF(MINC48.1 > L51, L51, C), IIF(MINL2.50 > L52 AND L52 < MINL2.53, IIF(MINC49.1 > L52, L52, C), IIF(MINL2.51 > L53 AND L53 < MINL2.54, IIF(MINC50.1 > L53, L53, C), IIF(MINL2.52 > L54 AND L54 < MINL2.55, IIF(MINC51.1 > L54, L54, C), IIF(MINL2.53 > L55 AND L55 < MINL2.56, IIF(MINC52.1 > L55, L55, C), IIF(MINL2.54 > L56 AND L56 < MINL2.57, IIF(MINC53.1 > L56, L56, C), IIF(MINL2.55 > L57 AND L57 < MINL2.58, IIF(MINC54.1 > L57, L57, C), IIF(MINL2.56 > L58 AND L58 < MINL2.59, IIF(MINC55.1 > L58, L58, C), IIF(MINL2.57 > L59 AND L59 < MINL2.60, IIF(MINC56.1 > L59, L59, C), IIF(MINL2.58 > L60 AND L60 < MINL2.61, IIF(MINC57.1 > L60, L60, C), IIF(MINL2.59 > L61 AND L61 < MINL2.62, IIF(MINC58.1 > L61, L61, C), IIF(MINL2.60 > L62 AND L62 < MINL2.63, IIF(MINC59.1 > L62, L62, C), IIF(MINL2.61 > L63 AND L63 < MINL2.64, IIF(MINC60.1 > L63, L63, C), IIF(MINL2.62 > L64 AND L64 < MINL2.65, IIF(MINC61.1 > L64, L64, C), IIF(MINL2.63 > L65 AND L65 < MINL2.66, IIF(MINC62.1 > L65, L65, C), IIF(MINL2.64 > L66 AND L66 < MINL2.67, IIF(MINC63.1 > L66, L66, C), IIF(MINL2.65 > L67 AND L67 < MINL2.68, IIF(MINC64.1 > L67, L67, C), IIF(MINL2.66 > L68 AND L68 < MINL2.69, IIF(MINC65.1 > L68, L68, C), IIF(MINL2.67 > L69 AND L69 < MINL2.70, IIF(MINC66.1 > L69, L69, C), IIF(MINL2.68 > L70 AND L70 < MINL2.71, IIF(MINC67.1 > L70, L70, C), IIF(MINL2.69 > L71 AND L71 < MINL2.72, IIF(MINC68.1 > L71, L71, C), IIF(MINL2.70 > L72 AND L72 < MINL2.73, IIF(MINC69.1 > L72, L72, C), IIF(MINL2.71 > L73 AND L73 < MINL2.74, IIF(MINC70.1 > L73, L73, C), IIF(MINL2.72 > L74 AND L74 < MINL2.75, IIF(MINC71.1 > L74, L74, C), IIF(MINL2.73 > L75 AND L75 < MINL2.76, IIF(MINC72.1 > L75, L75, C), IIF(MINL2.74 > L76 AND L76 < MINL2.77, IIF(MINC73.1 > L76, L76, C), IIF(MINL2.75 > L77 AND L77 < MINL2.78, IIF(MINC74.1 > L77, L77, C), IIF(MINL2.76 > L78 AND L78 < MINL2.79, IIF(MINC75.1 > L78, L78, C), IIF(MINL2.77 > L79 AND L79 < MINL2.80, IIF(MINC76.1 > L79, L79, C), IIF(MINL2.78 > L80 AND L80 < MINL2.81, IIF(MINC77.1 > L80, L80, C), IIF(MINL2.79 > L81 AND L81 < MINL2.82, IIF(MINC78.1 > L81, L81, C), IIF(MINL2.80 > L82 AND L82 < MINL2.83, IIF(MINC79.1 > L82, L82, C), IIF(MINL2.81 > L83 AND L83 < MINL2.84, IIF(MINC80.1 > L83, L83, C), IIF(MINL2.82 > L84 AND L84 < MINL2.85, IIF(MINC81.1 > L84, L84, C), IIF(MINL2.83 > L85 AND L85 < MINL2.86, IIF(MINC82.1 > L85, L85, C), IIF(MINL2.84 > L86 AND L86 < MINL2.87, IIF(MINC83.1 > L86, L86, C), IIF(MINL2.85 > L87 AND L87 < MINL2.88, IIF(MINC84.1 > L87, L87, C), IIF(MINL2.86 > L88 AND L88 < MINL2.89, IIF(MINC85.1 > L88, L88, C), IIF(MINL2.87 > L89 AND L89 < MINL2.90, IIF(MINC86.1 > L89, L89, C), IIF(MINL2.88 > L90 AND L90 < MINL2.91, IIF(MINC87.1 > L90, L90, C), IIF(MINL2.89 > L91 AND L91 < MINL2.92, IIF(MINC88.1 > L91, L91, C), IIF(MINL2.90 > L92 AND L92 < MINL2.93, IIF(MINC89.1 > L92, L92, C), IIF(MINL2.91 > L93 AND L93 < MINL2.94, IIF(MINC90.1 > L93, L93, C), IIF(MINL2.92 > L94 AND L94 < MINL2.95, IIF(MINC91.1 > L94, L94, C), IIF(MINL2.93 > L95 AND L95 < MINL2.96, IIF(MINC92.1 > L95, L95, C), IIF(MINL2.94 > L96 AND L96 < MINL2.97, IIF(MINC93.1 > L96, L96, C), IIF(MINL2.95 > L97 AND L97 < MINL2.98, IIF(MINC94.1 > L97, L97, C), IIF(MINL2.96 > L98 AND L98 < MINL2.99, IIF(MINC95.1 > L98, L98, C), IIF(MINL2.97 > L99 AND L99 < MINL2.100, IIF(MINC96.1 > L99, L99, C), IIF(MINL2.98 > L100 AND L100 < MINL2.101, IIF(MINC97.1 > L100, L100, C), IIF(MINL2.99 > L101 AND L101 < MINL2.102, IIF(MINC98.1 > L101, L101, C), C))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

So i want the new pcf to have spike when AAPl crossed high of April 24th bar and closed above that which happened on May 01,2018
 
 
2) Same for the Inverse you wrote this below formula for me so  the pcf is true on AAPL daily on April 13th,2018 and I want the new pcf to spike when it crossed and closed below the APril 13th bar which happened on April 19th bar 
 
C > IIF(MAXH2 < H2 AND H2 > MAXH2.3, C, IIF(MAXH2.1 < H3 AND H3 > MAXH2.4, H3, IIF(MAXH2.2 < H4 AND H4 > MAXH2.5, IIF(C1 < H4, H4, C), IIF(MAXH2.3 < H5 AND H5 > MAXH2.6, IIF(MAXC2.1 < H5, H5, C), IIF(MAXH2.4 < H6 AND H6 > MAXH2.7, IIF(MAXC3.1 < H6, H6, C), IIF(MAXH2.5 < H7 AND H7 > MAXH2.8, IIF(MAXC4.1 < H7, H7, C), IIF(MAXH2.6 < H8 AND H8 > MAXH2.9, IIF(MAXC5.1 < H8, H8, C), IIF(MAXH2.7 < H9 AND H9 > MAXH2.10, IIF(MAXC6.1 < H9, H9, C), IIF(MAXH2.8 < H10 AND H10 > MAXH2.11, IIF(MAXC7.1 < H10, H10, C), IIF(MAXH2.9 < H11 AND H11 > MAXH2.12, IIF(MAXC8.1 < H11, H11, C), IIF(MAXH2.10 < H12 AND H12 > MAXH2.13, IIF(MAXC9.1 < H12, H12, C), IIF(MAXH2.11 < H13 AND H13 > MAXH2.14, IIF(MAXC10.1 < H13, H13, C), IIF(MAXH2.12 < H14 AND H14 > MAXH2.15, IIF(MAXC11.1 < H14, H14, C), IIF(MAXH2.13 < H15 AND H15 > MAXH2.16, IIF(MAXC12.1 < H15, H15, C), IIF(MAXH2.14 < H16 AND H16 > MAXH2.17, IIF(MAXC13.1 < H16, H16, C), IIF(MAXH2.15 < H17 AND H17 > MAXH2.18, IIF(MAXC14.1 < H17, H17, C), IIF(MAXH2.16 < H18 AND H18 > MAXH2.19, IIF(MAXC15.1 < H18, H18, C), IIF(MAXH2.17 < H19 AND H19 > MAXH2.20, IIF(MAXC16.1 < H19, H19, C), IIF(MAXH2.18 < H20 AND H20 > MAXH2.21, IIF(MAXC17.1 < H20, H20, C), IIF(MAXH2.19 < H21 AND H21 > MAXH2.22, IIF(MAXC18.1 < H21, H21, C), IIF(MAXH2.20 < H22 AND H22 > MAXH2.23, IIF(MAXC19.1 < H22, H22, C), IIF(MAXH2.21 < H23 AND H23 > MAXH2.24, IIF(MAXC20.1 < H23, H23, C), IIF(MAXH2.22 < H24 AND H24 > MAXH2.25, IIF(MAXC21.1 < H24, H24, C), IIF(MAXH2.23 < H25 AND H25 > MAXH2.26, IIF(MAXC22.1 < H25, H25, C), IIF(MAXH2.24 < H26 AND H26 > MAXH2.27, IIF(MAXC23.1 < H26, H26, C), IIF(MAXH2.25 < H27 AND H27 > MAXH2.28, IIF(MAXC24.1 < H27, H27, C), IIF(MAXH2.26 < H28 AND H28 > MAXH2.29, IIF(MAXC25.1 < H28, H28, C), IIF(MAXH2.27 < H29 AND H29 > MAXH2.30, IIF(MAXC26.1 < H29, H29, C), IIF(MAXH2.28 < H30 AND H30 > MAXH2.31, IIF(MAXC27.1 < H30, H30, C), IIF(MAXH2.29 < H31 AND H31 > MAXH2.32, IIF(MAXC28.1 < H31, H31, C), IIF(MAXH2.30 < H32 AND H32 > MAXH2.33, IIF(MAXC29.1 < H32, H32, C), IIF(MAXH2.31 < H33 AND H33 > MAXH2.34, IIF(MAXC30.1 < H33, H33, C), IIF(MAXH2.32 < H34 AND H34 > MAXH2.35, IIF(MAXC31.1 < H34, H34, C), IIF(MAXH2.33 < H35 AND H35 > MAXH2.36, IIF(MAXC32.1 < H35, H35, C), IIF(MAXH2.34 < H36 AND H36 > MAXH2.37, IIF(MAXC33.1 < H36, H36, C), IIF(MAXH2.35 < H37 AND H37 > MAXH2.38, IIF(MAXC34.1 < H37, H37, C), IIF(MAXH2.36 < H38 AND H38 > MAXH2.39, IIF(MAXC35.1 < H38, H38, C), IIF(MAXH2.37 < H39 AND H39 > MAXH2.40, IIF(MAXC36.1 < H39, H39, C), IIF(MAXH2.38 < H40 AND H40 > MAXH2.41, IIF(MAXC37.1 < H40, H40, C), IIF(MAXH2.39 < H41 AND H41 > MAXH2.42, IIF(MAXC38.1 < H41, H41, C), IIF(MAXH2.40 < H42 AND H42 > MAXH2.43, IIF(MAXC39.1 < H42, H42, C), IIF(MAXH2.41 < H43 AND H43 > MAXH2.44, IIF(MAXC40.1 < H43, H43, C), IIF(MAXH2.42 < H44 AND H44 > MAXH2.45, IIF(MAXC41.1 < H44, H44, C), IIF(MAXH2.43 < H45 AND H45 > MAXH2.46, IIF(MAXC42.1 < H45, H45, C), IIF(MAXH2.44 < H46 AND H46 > MAXH2.47, IIF(MAXC43.1 < H46, H46, C), IIF(MAXH2.45 < H47 AND H47 > MAXH2.48, IIF(MAXC44.1 < H47, H47, C), IIF(MAXH2.46 < H48 AND H48 > MAXH2.49, IIF(MAXC45.1 < H48, H48, C), IIF(MAXH2.47 < H49 AND H49 > MAXH2.50, IIF(MAXC46.1 < H49, H49, C), IIF(MAXH2.48 < H50 AND H50 > MAXH2.51, IIF(MAXC47.1 < H50, H50, C), IIF(MAXH2.49 < H51 AND H51 > MAXH2.52, IIF(MAXC48.1 < H51, H51, C), IIF(MAXH2.50 < H52 AND H52 > MAXH2.53, IIF(MAXC49.1 < H52, H52, C), IIF(MAXH2.51 < H53 AND H53 > MAXH2.54, IIF(MAXC50.1 < H53, H53, C), IIF(MAXH2.52 < H54 AND H54 > MAXH2.55, IIF(MAXC51.1 < H54, H54, C), IIF(MAXH2.53 < H55 AND H55 > MAXH2.56, IIF(MAXC52.1 < H55, H55, C), IIF(MAXH2.54 < H56 AND H56 > MAXH2.57, IIF(MAXC53.1 < H56, H56, C), IIF(MAXH2.55 < H57 AND H57 > MAXH2.58, IIF(MAXC54.1 < H57, H57, C), IIF(MAXH2.56 < H58 AND H58 > MAXH2.59, IIF(MAXC55.1 < H58, H58, C), IIF(MAXH2.57 < H59 AND H59 > MAXH2.60, IIF(MAXC56.1 < H59, H59, C), IIF(MAXH2.58 < H60 AND H60 > MAXH2.61, IIF(MAXC57.1 < H60, H60, C), IIF(MAXH2.59 < H61 AND H61 > MAXH2.62, IIF(MAXC58.1 < H61, H61, C), IIF(MAXH2.60 < H62 AND H62 > MAXH2.63, IIF(MAXC59.1 < H62, H62, C), IIF(MAXH2.61 < H63 AND H63 > MAXH2.64, IIF(MAXC60.1 < H63, H63, C), IIF(MAXH2.62 < H64 AND H64 > MAXH2.65, IIF(MAXC61.1 < H64, H64, C), IIF(MAXH2.63 < H65 AND H65 > MAXH2.66, IIF(MAXC62.1 < H65, H65, C), IIF(MAXH2.64 < H66 AND H66 > MAXH2.67, IIF(MAXC63.1 < H66, H66, C), IIF(MAXH2.65 < H67 AND H67 > MAXH2.68, IIF(MAXC64.1 < H67, H67, C), IIF(MAXH2.66 < H68 AND H68 > MAXH2.69, IIF(MAXC65.1 < H68, H68, C), IIF(MAXH2.67 < H69 AND H69 > MAXH2.70, IIF(MAXC66.1 < H69, H69, C), IIF(MAXH2.68 < H70 AND H70 > MAXH2.71, IIF(MAXC67.1 < H70, H70, C), IIF(MAXH2.69 < H71 AND H71 > MAXH2.72, IIF(MAXC68.1 < H71, H71, C), IIF(MAXH2.70 < H72 AND H72 > MAXH2.73, IIF(MAXC69.1 < H72, H72, C), IIF(MAXH2.71 < H73 AND H73 > MAXH2.74, IIF(MAXC70.1 < H73, H73, C), IIF(MAXH2.72 < H74 AND H74 > MAXH2.75, IIF(MAXC71.1 < H74, H74, C), IIF(MAXH2.73 < H75 AND H75 > MAXH2.76, IIF(MAXC72.1 < H75, H75, C), IIF(MAXH2.74 < H76 AND H76 > MAXH2.77, IIF(MAXC73.1 < H76, H76, C), IIF(MAXH2.75 < H77 AND H77 > MAXH2.78, IIF(MAXC74.1 < H77, H77, C), IIF(MAXH2.76 < H78 AND H78 > MAXH2.79, IIF(MAXC75.1 < H78, H78, C), IIF(MAXH2.77 < H79 AND H79 > MAXH2.80, IIF(MAXC76.1 < H79, H79, C), IIF(MAXH2.78 < H80 AND H80 > MAXH2.81, IIF(MAXC77.1 < H80, H80, C), IIF(MAXH2.79 < H81 AND H81 > MAXH2.82, IIF(MAXC78.1 < H81, H81, C), IIF(MAXH2.80 < H82 AND H82 > MAXH2.83, IIF(MAXC79.1 < H82, H82, C), IIF(MAXH2.81 < H83 AND H83 > MAXH2.84, IIF(MAXC80.1 < H83, H83, C), IIF(MAXH2.82 < H84 AND H84 > MAXH2.85, IIF(MAXC81.1 < H84, H84, C), IIF(MAXH2.83 < H85 AND H85 > MAXH2.86, IIF(MAXC82.1 < H85, H85, C), IIF(MAXH2.84 < H86 AND H86 > MAXH2.87, IIF(MAXC83.1 < H86, H86, C), IIF(MAXH2.85 < H87 AND H87 > MAXH2.88, IIF(MAXC84.1 < H87, H87, C), IIF(MAXH2.86 < H88 AND H88 > MAXH2.89, IIF(MAXC85.1 < H88, H88, C), IIF(MAXH2.87 < H89 AND H89 > MAXH2.90, IIF(MAXC86.1 < H89, H89, C), IIF(MAXH2.88 < H90 AND H90 > MAXH2.91, IIF(MAXC87.1 < H90, H90, C), IIF(MAXH2.89 < H91 AND H91 > MAXH2.92, IIF(MAXC88.1 < H91, H91, C), IIF(MAXH2.90 < H92 AND H92 > MAXH2.93, IIF(MAXC89.1 < H92, H92, C), IIF(MAXH2.91 < H93 AND H93 > MAXH2.94, IIF(MAXC90.1 < H93, H93, C), IIF(MAXH2.92 < H94 AND H94 > MAXH2.95, IIF(MAXC91.1 < H94, H94, C), IIF(MAXH2.93 < H95 AND H95 > MAXH2.96, IIF(MAXC92.1 < H95, H95, C), IIF(MAXH2.94 < H96 AND H96 > MAXH2.97, IIF(MAXC93.1 < H96, H96, C), IIF(MAXH2.95 < H97 AND H97 > MAXH2.98, IIF(MAXC94.1 < H97, H97, C), IIF(MAXH2.96 < H98 AND H98 > MAXH2.99, IIF(MAXC95.1 < H98, H98, C), IIF(MAXH2.97 < H99 AND H99 > MAXH2.100, IIF(MAXC96.1 < H99, H99, C), IIF(MAXH2.98 < H100 AND H100 > MAXH2.101, IIF(MAXC97.1 < H100, H100, C), IIF(MAXH2.99 < H101 AND H101 > MAXH2.102, IIF(MAXC98.1 < H101, H101, C), C))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
 
thanks a lot 
 
Dhiren
 
 
 
 
Topic: Interpretation
Posted: Thursday, May 03, 2018 12:26:51 PM

Bruce thanks a lot that was very helpful , 

Cheers

Topic: Interpretation
Posted: Wednesday, May 02, 2018 12:34:19 PM

Ok Bruce let me back test a bit on them i will come back to you on the same with my response ... if i need alterations

On another note non related question Market faciliation Index colours can that be overlayed onto  the Price candlestick bars itself ???

 

thanks 

Topic: Interpretation
Posted: Wednesday, May 02, 2018 10:59:38 AM

Hmm Bruce the main idea what I was trying to achieve is when Most recent Pivot high is detected then the previous Pivot high should obviously stop plotting dots and same for pivot low when detected then the previos pivot low should stop plotting 

Now taking example of "HRS on daily chart 

the trend price is down so it started plotting dots on Pivot high from April 27,2018 and of i use moving average 1 period and off set -3 it will plot exact at April 24,2018

So in the histogram below i want that to plot below the ZERO LINE until it detects the new Pivot Low and that will PLOT on Histogram as Above Zero Line 

 

hope it helps 

Topic: Interpretation
Posted: Tuesday, May 01, 2018 11:57:32 AM

Okay Until it detects the next pivot high " thats what i was missing... thanks

So now my last question is how can we make this pcf in form of histogram where it appears like macd or awesome oscillator idea.. when the following happens

1) If pivot high dots stays active then the histogram should stay below ZERO LINE and 

2) If Pivot low  dots stays active then the histogram should stay above zero line 

And i m using simple moving average with 1 period and off set of -3 so that it detects exact  most recent pivot high and pivot lows

 

Topic: Interpretation
Posted: Tuesday, May 01, 2018 11:29:23 AM

No Bruce i got that part but count of the dots plotting to the right of most recent pivot high or low what does that signify ??  as the dots on some high or lows are more in count and some have less in count so thats what i wanted to know ??

Topic: Interpretation
Posted: Tuesday, May 01, 2018 11:04:22 AM
Hi Bruce 
hope u doing well , could please interpret this below formulas for me .. as i must have listed them incorrect in wordings so just want to understand them for support and resistance and what does the plotting style number of dots going horizontally imply ?
 
thanks 
Dhiren
 
 
for Low
 
ABS(MINL3 > L3 AND L3 < MINL3.4) * L3 + ABS(MINL3 <= L3 OR L3 >= MINL3.4) * (ABS(MINL3.1 > L4 AND L4 < MINL3.5) * L4 + ABS(MINL3.1 <= L4 OR L4 >= MINL3.5) * (ABS(MINL3.2 > L5 AND L5 < MINL3.6) * L5 + ABS(MINL3.2 <= L5 OR L5 >= MINL3.6) * (ABS(MINL3.3 > L6 AND L6 < MINL3.7) * L6 + ABS(MINL3.3 <= L6 OR L6 >= MINL3.7) * (ABS(MINL3.4 > L7 AND L7 < MINL3.8) * L7 + ABS(MINL3.4 <= L7 OR L7 >= MINL3.8) * (ABS(MINL3.5 > L8 AND L8 < MINL3.9) * L8 + ABS(MINL3.5 <= L8 OR L8 >= MINL3.9) * (ABS(MINL3.6 > L9 AND L9 < MINL3.10) * L9 + ABS(MINL3.6 <= L9 OR L9 >= MINL3.10) * (ABS(MINL3.7 > L10 AND L10 < MINL3.11) * L10 + ABS(MINL3.7 <= L10 OR L10 >= MINL3.11) * (ABS(MINL3.8 > L11 AND L11 < MINL3.12) * L11 + ABS(MINL3.8 <= L11 OR L11 >= MINL3.12) * (ABS(MINL3.9 > L12 AND L12 < MINL3.13) * L12 + ABS(MINL3.9 <= L12 OR L12 >= MINL3.13) * (ABS(MINL3.10 > L13 AND L13 < MINL3.14) * L13 + ABS(MINL3.10 <= L13 OR L13 >= MINL3.14) * (ABS(MINL3.11 > L14 AND L14 < MINL3.15) * L14 + ABS(MINL3.11 <= L14 OR L14 >= MINL3.15) * (ABS(MINL3.12 > L15 AND L15 < MINL3.16) * L15 + ABS(MINL3.12 <= L15 OR L15 >= MINL3.16) * (ABS(MINL3.13 > L16 AND L16 < MINL3.17) * L16 + ABS(MINL3.13 <= L16 OR L16 >= MINL3.17) * (ABS(MINL3.14 > L17 AND L17 < MINL3.18) * L17 + ABS(MINL3.14 <= L17 OR L17 >= MINL3.18) * (ABS(MINL3.15 > L18 AND L18 < MINL3.19) * L18 + ABS(MINL3.15 <= L18 OR L18 >= MINL3.19) * (ABS(MINL3.16 > L19 AND L19 < MINL3.20) * L19 + ABS(MINL3.16 <= L19 OR L19 >= MINL3.20) * (ABS(MINL3.17 > L20 AND L20 < MINL3.21) * L20 + ABS(MINL3.17 <= L20 OR L20 >= MINL3.21) * (ABS(MINL3.18 > L21 AND L21 < MINL3.22) * L21 + ABS(MINL3.18 <= L21 OR L21 >= MINL3.22) * (ABS(MINL3.19 > L22 AND L22 < MINL3.23) * L22 + ABS(MINL3.19 <= L22 OR L22 >= MINL3.23) * (ABS(MINL3.20 > L23 AND L23 < MINL3.24) * L23 + ABS(MINL3.20 <= L23 OR L23 >= MINL3.24) * (ABS(MINL3.21 > L24 AND L24 < MINL3.25) * L24 + ABS(MINL3.21 <= L24 OR L24 >= MINL3.25) * (ABS(MINL3.22 > L25 AND L25 < MINL3.26) * L25 + ABS(MINL3.22 <= L25 OR L25 >= MINL3.26) * (ABS(MINL3.23 > L26 AND L26 < MINL3.27) * L26 + ABS(MINL3.23 <= L26 OR L26 >= MINL3.27) * (ABS(MINL3.24 > L27 AND L27 < MINL3.28) * L27 + ABS(MINL3.24 <= L27 OR L27 >= MINL3.28) * (ABS(MINL3.25 > L28 AND L28 < MINL3.29) * L28 + ABS(MINL3.25 <= L28 OR L28 >= MINL3.29) * (ABS(MINL3.26 > L29 AND L29 < MINL3.30) * L29 + ABS(MINL3.26 <= L29 OR L29 >= MINL3.30) * (ABS(MINL3.27 > L30 AND L30 < MINL3.31) * L30 + ABS(MINL3.27 <= L30 OR L30 >= MINL3.31) * (ABS(MINL3.28 > L31 AND L31 < MINL3.32) * L31 + ABS(MINL3.28 <= L31 OR L31 >= MINL3.32) * (ABS(MINL3.29 > L32 AND L32 < MINL3.33) * L32 + ABS(MINL3.29 <= L32 OR L32 >= MINL3.33) * (ABS(MINL3.30 > L33 AND L33 < MINL3.34) * L33 + ABS(MINL3.30 <= L33 OR L33 >= MINL3.34) * (ABS(MINL3.31 > L34 AND L34 < MINL3.35) * L34 + ABS(MINL3.31 <= L34 OR L34 >= MINL3.35) * (ABS(MINL3.32 > L35 AND L35 < MINL3.36) * L35 + ABS(MINL3.32 <= L35 OR L35 >= MINL3.36) * (ABS(MINL3.33 > L36 AND L36 < MINL3.37) * L36 + ABS(MINL3.33 <= L36 OR L36 >= MINL3.37) * (ABS(MINL3.34 > L37 AND L37 < MINL3.38) * L37 + ABS(MINL3.34 <= L37 OR L37 >= MINL3.38) * (ABS(MINL3.35 > L38 AND L38 < MINL3.39) * L38 + ABS(MINL3.35 <= L38 OR L38 >= MINL3.39) * (ABS(MINL3.36 > L39 AND L39 < MINL3.40) * L39 + ABS(MINL3.36 <= L39 OR L39 >= MINL3.40) * (ABS(MINL3.37 > L40 AND L40 < MINL3.41) * L40 + ABS(MINL3.37 <= L40 OR L40 >= MINL3.41) * (ABS(MINL3.38 > L41 AND L41 < MINL3.42) * L41 + ABS(MINL3.38 <= L41 OR L41 >= MINL3.42) * (ABS(MINL3.39 > L42 AND L42 < MINL3.43) * L42 + ABS(MINL3.39 <= L42 OR L42 >= MINL3.43) * (ABS(MINL3.40 > L43 AND L43 < MINL3.44) * L43 + ABS(MINL3.40 <= L43 OR L43 >= MINL3.44) * (ABS(MINL3.41 > L44 AND L44 < MINL3.45) * L44 + ABS(MINL3.41 <= L44 OR L44 >= MINL3.45) * (ABS(MINL3.42 > L45 AND L45 < MINL3.46) * L45 + ABS(MINL3.42 <= L45 OR L45 >= MINL3.46) * (ABS(MINL3.43 > L46 AND L46 < MINL3.47) * L46 + ABS(MINL3.43 <= L46 OR L46 >= MINL3.47) * (ABS(MINL3.44 > L47 AND L47 < MINL3.48) * L47 + ABS(MINL3.44 <= L47 OR L47 >= MINL3.48) * (ABS(MINL3.45 > L48 AND L48 < MINL3.49) * L48 + ABS(MINL3.45 <= L48 OR L48 >= MINL3.49) * (ABS(MINL3.46 > L49 AND L49 < MINL3.50) * L49 + ABS(MINL3.46 <= L49 OR L49 >= MINL3.50) * (ABS(MINL3.47 > L50 AND L50 < MINL3.51) * L50 + ABS(MINL3.47 <= L50 OR L50 >= MINL3.51) * (ABS(MINL3.48 > L51 AND L51 < MINL3.52) * L51 + ABS(MINL3.48 <= L51 OR L51 >= MINL3.52) * (ABS(MINL3.49 > L52 AND L52 < MINL3.53) * L52 + ABS(MINL3.49 <= L52 OR L52 >= MINL3.53) * (ABS(MINL3.50 > L53 AND L53 < MINL3.54) * L53 + ABS(MINL3.50 <= L53 OR L53 >= MINL3.54) * (ABS(MINL3.51 > L54 AND L54 < MINL3.55) * L54 + ABS(MINL3.51 <= L54 OR L54 >= MINL3.55) * (ABS(MINL3.52 > L55 AND L55 < MINL3.56) * L55 + ABS(MINL3.52 <= L55 OR L55 >= MINL3.56) * (ABS(MINL3.53 > L56 AND L56 < MINL3.57) * L56 + ABS(MINL3.53 <= L56 OR L56 >= MINL3.57) * (ABS(MINL3.54 > L57 AND L57 < MINL3.58) * L57 + ABS(MINL3.54 <= L57 OR L57 >= MINL3.58) * (ABS(MINL3.55 > L58 AND L58 < MINL3.59) * L58 + ABS(MINL3.55 <= L58 OR L58 >= MINL3.59) * (ABS(MINL3.56 > L59 AND L59 < MINL3.60) * L59 + ABS(MINL3.56 <= L59 OR L59 >= MINL3.60) * (ABS(MINL3.57 > L60 AND L60 < MINL3.61) * L60 + ABS(MINL3.57 <= L60 OR L60 >= MINL3.61) * (ABS(MINL3.58 > L61 AND L61 < MINL3.62) * L61 + ABS(MINL3.58 <= L61 OR L61 >= MINL3.62) * (ABS(MINL3.59 > L62 AND L62 < MINL3.63) * L62 + ABS(MINL3.59 <= L62 OR L62 >= MINL3.63) * MINL63)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
 
 
 
for high
 
ABS(MAXH3 < H3 AND H3 > MAXH3.4) * H3 + ABS(MAXH3 >= H3 OR H3 <= MAXH3.4) * (ABS(MAXH3.1 < H4 AND H4 > MAXH3.5) * H4 + ABS(MAXH3.1 >= H4 OR H4 <= MAXH3.5) * (ABS(MAXH3.2 < H5 AND H5 > MAXH3.6) * H5 + ABS(MAXH3.2 >= H5 OR H5 <= MAXH3.6) * (ABS(MAXH3.3 < H6 AND H6 > MAXH3.7) * H6 + ABS(MAXH3.3 >= H6 OR H6 <= MAXH3.7) * (ABS(MAXH3.4 < H7 AND H7 > MAXH3.8) * H7 + ABS(MAXH3.4 >= H7 OR H7 <= MAXH3.8) * (ABS(MAXH3.5 < H8 AND H8 > MAXH3.9) * H8 + ABS(MAXH3.5 >= H8 OR H8 <= MAXH3.9) * (ABS(MAXH3.6 < H9 AND H9 > MAXH3.10) * H9 + ABS(MAXH3.6 >= H9 OR H9 <= MAXH3.10) * (ABS(MAXH3.7 < H10 AND H10 > MAXH3.11) * H10 + ABS(MAXH3.7 >= H10 OR H10 <= MAXH3.11) * (ABS(MAXH3.8 < H11 AND H11 > MAXH3.12) * H11 + ABS(MAXH3.8 >= H11 OR H11 <= MAXH3.12) * (ABS(MAXH3.9 < H12 AND H12 > MAXH3.13) * H12 + ABS(MAXH3.9 >= H12 OR H12 <= MAXH3.13) * (ABS(MAXH3.10 < H13 AND H13 > MAXH3.14) * H13 + ABS(MAXH3.10 >= H13 OR H13 <= MAXH3.14) * (ABS(MAXH3.11 < H14 AND H14 > MAXH3.15) * H14 + ABS(MAXH3.11 >= H14 OR H14 <= MAXH3.15) * (ABS(MAXH3.12 < H15 AND H15 > MAXH3.16) * H15 + ABS(MAXH3.12 >= H15 OR H15 <= MAXH3.16) * (ABS(MAXH3.13 < H16 AND H16 > MAXH3.17) * H16 + ABS(MAXH3.13 >= H16 OR H16 <= MAXH3.17) * (ABS(MAXH3.14 < H17 AND H17 > MAXH3.18) * H17 + ABS(MAXH3.14 >= H17 OR H17 <= MAXH3.18) * (ABS(MAXH3.15 < H18 AND H18 > MAXH3.19) * H18 + ABS(MAXH3.15 >= H18 OR H18 <= MAXH3.19) * (ABS(MAXH3.16 < H19 AND H19 > MAXH3.20) * H19 + ABS(MAXH3.16 >= H19 OR H19 <= MAXH3.20) * (ABS(MAXH3.17 < H20 AND H20 > MAXH3.21) * H20 + ABS(MAXH3.17 >= H20 OR H20 <= MAXH3.21) * (ABS(MAXH3.18 < H21 AND H21 > MAXH3.22) * H21 + ABS(MAXH3.18 >= H21 OR H21 <= MAXH3.22) * (ABS(MAXH3.19 < H22 AND H22 > MAXH3.23) * H22 + ABS(MAXH3.19 >= H22 OR H22 <= MAXH3.23) * (ABS(MAXH3.20 < H23 AND H23 > MAXH3.24) * H23 + ABS(MAXH3.20 >= H23 OR H23 <= MAXH3.24) * (ABS(MAXH3.21 < H24 AND H24 > MAXH3.25) * H24 + ABS(MAXH3.21 >= H24 OR H24 <= MAXH3.25) * (ABS(MAXH3.22 < H25 AND H25 > MAXH3.26) * H25 + ABS(MAXH3.22 >= H25 OR H25 <= MAXH3.26) * (ABS(MAXH3.23 < H26 AND H26 > MAXH3.27) * H26 + ABS(MAXH3.23 >= H26 OR H26 <= MAXH3.27) * (ABS(MAXH3.24 < H27 AND H27 > MAXH3.28) * H27 + ABS(MAXH3.24 >= H27 OR H27 <= MAXH3.28) * (ABS(MAXH3.25 < H28 AND H28 > MAXH3.29) * H28 + ABS(MAXH3.25 >= H28 OR H28 <= MAXH3.29) * (ABS(MAXH3.26 < H29 AND H29 > MAXH3.30) * H29 + ABS(MAXH3.26 >= H29 OR H29 <= MAXH3.30) * (ABS(MAXH3.27 < H30 AND H30 > MAXH3.31) * H30 + ABS(MAXH3.27 >= H30 OR H30 <= MAXH3.31) * (ABS(MAXH3.28 < H31 AND H31 > MAXH3.32) * H31 + ABS(MAXH3.28 >= H31 OR H31 <= MAXH3.32) * (ABS(MAXH3.29 < H32 AND H32 > MAXH3.33) * H32 + ABS(MAXH3.29 >= H32 OR H32 <= MAXH3.33) * (ABS(MAXH3.30 < H33 AND H33 > MAXH3.34) * H33 + ABS(MAXH3.30 >= H33 OR H33 <= MAXH3.34) * (ABS(MAXH3.31 < H34 AND H34 > MAXH3.35) * H34 + ABS(MAXH3.31 >= H34 OR H34 <= MAXH3.35) * (ABS(MAXH3.32 < H35 AND H35 > MAXH3.36) * H35 + ABS(MAXH3.32 >= H35 OR H35 <= MAXH3.36) * (ABS(MAXH3.33 < H36 AND H36 > MAXH3.37) * H36 + ABS(MAXH3.33 >= H36 OR H36 <= MAXH3.37) * (ABS(MAXH3.34 < H37 AND H37 > MAXH3.38) * H37 + ABS(MAXH3.34 >= H37 OR H37 <= MAXH3.38) * (ABS(MAXH3.35 < H38 AND H38 > MAXH3.39) * H38 + ABS(MAXH3.35 >= H38 OR H38 <= MAXH3.39) * (ABS(MAXH3.36 < H39 AND H39 > MAXH3.40) * H39 + ABS(MAXH3.36 >= H39 OR H39 <= MAXH3.40) * (ABS(MAXH3.37 < H40 AND H40 > MAXH3.41) * H40 + ABS(MAXH3.37 >= H40 OR H40 <= MAXH3.41) * (ABS(MAXH3.38 < H41 AND H41 > MAXH3.42) * H41 + ABS(MAXH3.38 >= H41 OR H41 <= MAXH3.42) * (ABS(MAXH3.39 < H42 AND H42 > MAXH3.43) * H42 + ABS(MAXH3.39 >= H42 OR H42 <= MAXH3.43) * (ABS(MAXH3.40 < H43 AND H43 > MAXH3.44) * H43 + ABS(MAXH3.40 >= H43 OR H43 <= MAXH3.44) * (ABS(MAXH3.41 < H44 AND H44 > MAXH3.45) * H44 + ABS(MAXH3.41 >= H44 OR H44 <= MAXH3.45) * (ABS(MAXH3.42 < H45 AND H45 > MAXH3.46) * H45 + ABS(MAXH3.42 >= H45 OR H45 <= MAXH3.46) * (ABS(MAXH3.43 < H46 AND H46 > MAXH3.47) * H46 + ABS(MAXH3.43 >= H46 OR H46 <= MAXH3.47) * (ABS(MAXH3.44 < H47 AND H47 > MAXH3.48) * H47 + ABS(MAXH3.44 >= H47 OR H47 <= MAXH3.48) * (ABS(MAXH3.45 < H48 AND H48 > MAXH3.49) * H48 + ABS(MAXH3.45 >= H48 OR H48 <= MAXH3.49) * (ABS(MAXH3.46 < H49 AND H49 > MAXH3.50) * H49 + ABS(MAXH3.46 >= H49 OR H49 <= MAXH3.50) * (ABS(MAXH3.47 < H50 AND H50 > MAXH3.51) * H50 + ABS(MAXH3.47 >= H50 OR H50 <= MAXH3.51) * (ABS(MAXH3.48 < H51 AND H51 > MAXH3.52) * H51 + ABS(MAXH3.48 >= H51 OR H51 <= MAXH3.52) * (ABS(MAXH3.49 < H52 AND H52 > MAXH3.53) * H52 + ABS(MAXH3.49 >= H52 OR H52 <= MAXH3.53) * (ABS(MAXH3.50 < H53 AND H53 > MAXH3.54) * H53 + ABS(MAXH3.50 >= H53 OR H53 <= MAXH3.54) * (ABS(MAXH3.51 < H54 AND H54 > MAXH3.55) * H54 + ABS(MAXH3.51 >= H54 OR H54 <= MAXH3.55) * (ABS(MAXH3.52 < H55 AND H55 > MAXH3.56) * H55 + ABS(MAXH3.52 >= H55 OR H55 <= MAXH3.56) * (ABS(MAXH3.53 < H56 AND H56 > MAXH3.57) * H56 + ABS(MAXH3.53 >= H56 OR H56 <= MAXH3.57) * (ABS(MAXH3.54 < H57 AND H57 > MAXH3.58) * H57 + ABS(MAXH3.54 >= H57 OR H57 <= MAXH3.58) * (ABS(MAXH3.55 < H58 AND H58 > MAXH3.59) * H58 + ABS(MAXH3.55 >= H58 OR H58 <= MAXH3.59) * (ABS(MAXH3.56 < H59 AND H59 > MAXH3.60) * H59 + ABS(MAXH3.56 >= H59 OR H59 <= MAXH3.60) * (ABS(MAXH3.57 < H60 AND H60 > MAXH3.61) * H60 + ABS(MAXH3.57 >= H60 OR H60 <= MAXH3.61) * (ABS(MAXH3.58 < H61 AND H61 > MAXH3.62) * H61 + ABS(MAXH3.58 >= H61 OR H61 <= MAXH3.62) * (ABS(MAXH3.59 < H62 AND H62 > MAXH3.63) * H62 + ABS(MAXH3.59 >= H62 OR H62 <= MAXH3.63) * MAXH63)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
 
 
 
 
Topic: PCF question
Posted: Friday, April 13, 2018 2:09:47 PM

Ok that works Bruce .. so just for my understanding why in the earlier pcf we used SGN " function 

Topic: PCF question
Posted: Friday, April 13, 2018 1:54:19 PM

Bruce this formula below gives me 2 consecutive close above 8EMA 

SGN(C - XAVG(H + L + C, 8) / 3) = SGN(C1 - XAVG(H + L + C, 8.1) / 3) AND SGN(C1 - XAVG(H + L + C, 8.1) / 3) > SGN(C2 - XAVG(H + L + C, 8.2) / 3)

So my question is how do i write the same above formula where it close above 8ema(hlc) today , and close below 8ema(hlc) yesterday and Close above 8ema(hlc) day before yesterday  and all happening Consecutively in 3 bars

thanks 

Dhiren