Registered User Joined: 3/10/2012 Posts: 465
|
Bruce using your past pcf idea i created this below pcf , and it picks up the spike as desired but i want to filter many fake spikes to get the B" point with a controlled fib ratios adding into a new PCF, please see the attached Link and pcf below that i did
https://www.dhirenshah.com/bearish-shark-5-0/
I need B point as a spike after if it meets the following points
1) B point must be a New lowest low or new lowest high
2) When fib retracement drawn from X point to A point when A point is most recent , so the B point must be between fib ratios of 100.01 and 200 % OF XA
3) When Fib retracement drawn from O to X then the High of "A" point must be between 38% and 65% retracement of OX when X is the most recent point
thanks
FAVGC10 < AVGC10 AND C < C9 and H < IIF(MINH2 > H2 AND H2 < MINH2.3, H, IIF(MINH2.1 > H3 AND H3 < MINH2.4, H3, IIF(MINH2.2 > H4 AND H4 < MINH2.5, IIF(H1 > H4, H4, H), IIF(MINH2.3 > H5 AND H5 < MINH2.6, IIF(MINH2.1 > H5, H5, H), IIF(MINH2.4 > H6 AND H6 < MINH2.7, IIF(MINH3.1 > H6, H6, H), IIF(MINH2.5 > H7 AND H7 < MINH2.8, IIF(MINH4.1 > H7, H7, H), IIF(MINH2.6 > H8 AND H8 < MINH2.9, IIF(MINH5.1 > H8, H8, H), IIF(MINH2.7 > H9 AND H9 < MINH2.10, IIF(MINH6.1 > H9, H9, H), IIF(MINH2.8 > H10 AND H10 < MINH2.11, IIF(MINH7.1 > H10, H10, H), IIF(MINH2.9 > H11 AND H11 < MINH2.12, IIF(MINH8.1 > H11, H11, H), IIF(MINH2.10 > H12 AND H12 < MINH2.13, IIF(MINH9.1 > H12, H12, H), IIF(MINH2.11 > H13 AND H13 < MINH2.14, IIF(MINH10.1 > H13, H13, H), IIF(MINH2.12 > H14 AND H14 < MINH2.15, IIF(MINH11.1 > H14, H14, H), IIF(MINH2.13 > H15 AND H15 < MINH2.16, IIF(MINH12.1 > H15, H15, H), IIF(MINH2.14 > H16 AND H16 < MINH2.17, IIF(MINH13.1 > H16, H16, H), IIF(MINH2.15 > H17 AND H17 < MINH2.18, IIF(MINH14.1 > H17, H17, H), IIF(MINH2.16 > H18 AND H18 < MINH2.19, IIF(MINH15.1 > H18, H18, H), IIF(MINH2.17 > H19 AND H19 < MINH2.20, IIF(MINH16.1 > H19, H19, H), IIF(MINH2.18 > H20 AND H20 < MINH2.21, IIF(MINH17.1 > H20, H20, H), IIF(MINH2.19 > H21 AND H21 < MINH2.22, IIF(MINH18.1 > H21, H21, H), IIF(MINH2.20 > H22 AND H22 < MINH2.23, IIF(MINH19.1 > H22, H22, H), IIF(MINH2.21 > H23 AND H23 < MINH2.24, IIF(MINH20.1 > H23, H23, H), IIF(MINH2.22 > H24 AND H24 < MINH2.25, IIF(MINH21.1 > H24, H24, H), IIF(MINH2.23 > H25 AND H25 < MINH2.26, IIF(MINH22.1 > H25, H25, H), IIF(MINH2.24 > H26 AND H26 < MINH2.27, IIF(MINH23.1 > H26, H26, H), IIF(MINH2.25 > H27 AND H27 < MINH2.28, IIF(MINH24.1 > H27, H27, H), IIF(MINH2.26 > H28 AND H28 < MINH2.29, IIF(MINH25.1 > H28, H28, H), IIF(MINH2.27 > H29 AND H29 < MINH2.30, IIF(MINH26.1 > H29, H29, H), IIF(MINH2.28 > H30 AND H30 < MINH2.31, IIF(MINH27.1 > H30, H30, H), IIF(MINH2.29 > H31 AND H31 < MINH2.32, IIF(MINH28.1 > H31, H31, H), IIF(MINH2.30 > H32 AND H32 < MINH2.33, IIF(MINH29.1 > H32, H32, H), IIF(MINH2.31 > H33 AND H33 < MINH2.34, IIF(MINH30.1 > H33, H33, H), IIF(MINH2.32 > H34 AND H34 < MINH2.35, IIF(MINH31.1 > H34, H34, H), IIF(MINH2.33 > H35 AND H35 < MINH2.36, IIF(MINH32.1 > H35, H35, H), IIF(MINH2.34 > H36 AND H36 < MINH2.37, IIF(MINH33.1 > H36, H36, H), IIF(MINH2.35 > H37 AND H37 < MINH2.38, IIF(MINH34.1 > H37, H37, H), IIF(MINH2.36 > H38 AND H38 < MINH2.39, IIF(MINH35.1 > H38, H38, H), IIF(MINH2.37 > H39 AND H39 < MINH2.40, IIF(MINH36.1 > H39, H39, H), IIF(MINH2.38 > H40 AND H40 < MINH2.41, IIF(MINH37.1 > H40, H40, H), IIF(MINH2.39 > H41 AND H41 < MINH2.42, IIF(MINH38.1 > H41, H41, H), IIF(MINH2.40 > H42 AND H42 < MINH2.43, IIF(MINH39.1 > H42, H42, H), IIF(MINH2.41 > H43 AND H43 < MINH2.44, IIF(MINH40.1 > H43, H43, H), IIF(MINH2.42 > H44 AND H44 < MINH2.45, IIF(MINH41.1 > H44, H44, H), IIF(MINH2.43 > H45 AND H45 < MINH2.46, IIF(MINH42.1 > H45, H45, H), IIF(MINH2.44 > H46 AND H46 < MINH2.47, IIF(MINH43.1 > H46, H46, H), IIF(MINH2.45 > H47 AND H47 < MINH2.48, IIF(MINH44.1 > H47, H47, H), IIF(MINH2.46 > H48 AND H48 < MINH2.49, IIF(MINH45.1 > H48, H48, H), IIF(MINH2.47 > H49 AND H49 < MINH2.50, IIF(MINH46.1 > H49, H49, H), IIF(MINH2.48 > H50 AND H50 < MINH2.51, IIF(MINH47.1 > H50, H50, H), IIF(MINH2.49 > H51 AND H51 < MINH2.52, IIF(MINH48.1 > H51, H51, H), IIF(MINH2.50 > H52 AND H52 < MINH2.53, IIF(MINH49.1 > H52, H52, H), IIF(MINH2.51 > H53 AND H53 < MINH2.54, IIF(MINH50.1 > H53, H53, H), IIF(MINH2.52 > H54 AND H54 < MINH2.55, IIF(MINH51.1 > H54, H54, H), IIF(MINH2.53 > H55 AND H55 < MINH2.56, IIF(MINH52.1 > H55, H55, H), IIF(MINH2.54 > H56 AND H56 < MINH2.57, IIF(MINH53.1 > H56, H56, H), IIF(MINH2.55 > H57 AND H57 < MINH2.58, IIF(MINH54.1 > H57, H57, H), IIF(MINH2.56 > H58 AND H58 < MINH2.59, IIF(MINH55.1 > H58, H58, H), IIF(MINH2.57 > H59 AND H59 < MINH2.60, IIF(MINH56.1 > H59, H59, H), IIF(MINH2.58 > H60 AND H60 < MINH2.61, IIF(MINH57.1 > H60, H60, H), IIF(MINH2.59 > H61 AND H61 < MINH2.62, IIF(MINH58.1 > H61, H61, H), IIF(MINH2.60 > H62 AND H62 < MINH2.63, IIF(MINH59.1 > H62, H62, H), IIF(MINH2.61 > H63 AND H63 < MINH2.64, IIF(MINH60.1 > H63, H63, H), IIF(MINH2.62 > H64 AND H64 < MINH2.65, IIF(MINH61.1 > H64, H64, H), IIF(MINH2.63 > H65 AND H65 < MINH2.66, IIF(MINH62.1 > H65, H65, H), IIF(MINH2.64 > H66 AND H66 < MINH2.67, IIF(MINH63.1 > H66, H66, H), IIF(MINH2.65 > H67 AND H67 < MINH2.68, IIF(MINH64.1 > H67, H67, H), IIF(MINH2.66 > H68 AND H68 < MINH2.69, IIF(MINH65.1 > H68, H68, H), IIF(MINH2.67 > H69 AND H69 < MINH2.70, IIF(MINH66.1 > H69, H69, H), IIF(MINH2.68 > H70 AND H70 < MINH2.71, IIF(MINH67.1 > H70, H70, H), IIF(MINH2.69 > H71 AND H71 < MINH2.72, IIF(MINH68.1 > H71, H71, H), IIF(MINH2.70 > H72 AND H72 < MINH2.73, IIF(MINH69.1 > H72, H72, H), IIF(MINH2.71 > H73 AND H73 < MINH2.74, IIF(MINH70.1 > H73, H73, H), IIF(MINH2.72 > H74 AND H74 < MINH2.75, IIF(MINH71.1 > H74, H74, H), IIF(MINH2.73 > H75 AND H75 < MINH2.76, IIF(MINH72.1 > H75, H75, H), IIF(MINH2.74 > H76 AND H76 < MINH2.77, IIF(MINH73.1 > H76, H76, H), IIF(MINH2.75 > H77 AND H77 < MINH2.78, IIF(MINH74.1 > H77, H77, H), IIF(MINH2.76 > H78 AND H78 < MINH2.79, IIF(MINH75.1 > H78, H78, H), IIF(MINH2.77 > H79 AND H79 < MINH2.80, IIF(MINH76.1 > H79, H79, H), IIF(MINH2.78 > H80 AND H80 < MINH2.81, IIF(MINH77.1 > H80, H80, H), IIF(MINH2.79 > H81 AND H81 < MINH2.82, IIF(MINH78.1 > H81, H81, H), IIF(MINH2.80 > H82 AND H82 < MINH2.83, IIF(MINH79.1 > H82, H82, H), IIF(MINH2.81 > H83 AND H83 < MINH2.84, IIF(MINH80.1 > H83, H83, H), IIF(MINH2.82 > H84 AND H84 < MINH2.85, IIF(MINH81.1 > H84, H84, H), IIF(MINH2.83 > H85 AND H85 < MINH2.86, IIF(MINH82.1 > H85, H85, H), IIF(MINH2.84 > H86 AND H86 < MINH2.87, IIF(MINH83.1 > H86, H86, H), IIF(MINH2.85 > H87 AND H87 < MINH2.88, IIF(MINH84.1 > H87, H87, H), IIF(MINH2.86 > H88 AND H88 < MINH2.89, IIF(MINH85.1 > H88, H88, H), IIF(MINH2.87 > H89 AND H89 < MINH2.90, IIF(MINH86.1 > H89, H89, H), IIF(MINH2.88 > H90 AND H90 < MINH2.91, IIF(MINH87.1 > H90, H90, H), IIF(MINH2.89 > H91 AND H91 < MINH2.92, IIF(MINH88.1 > H91, H91, H), IIF(MINH2.90 > H92 AND H92 < MINH2.93, IIF(MINH89.1 > H92, H92, H), IIF(MINH2.91 > H93 AND H93 < MINH2.94, IIF(MINH90.1 > H93, H93, H), IIF(MINH2.92 > H94 AND H94 < MINH2.95, IIF(MINH91.1 > H94, H94, H), IIF(MINH2.93 > H95 AND H95 < MINH2.96, IIF(MINH92.1 > H95, H95, H), IIF(MINH2.94 > H96 AND H96 < MINH2.97, IIF(MINH93.1 > H96, H96, H), IIF(MINH2.95 > H97 AND H97 < MINH2.98, IIF(MINH94.1 > H97, H97, H), IIF(MINH2.96 > H98 AND H98 < MINH2.99, IIF(MINH95.1 > H98, H98, H), IIF(MINH2.97 > H99 AND H99 < MINH2.100, IIF(MINH96.1 > H99, H99, H), IIF(MINH2.98 > H100 AND H100 < MINH2.101, IIF(MINH97.1 > H100, H100, H), IIF(MINH2.99 > H101 AND H101 < MINH2.102, IIF(MINH98.1 > H101, H101, H),H))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
|
Registered User Joined: 3/10/2012 Posts: 465
|
Ok One last thing to try on this topic , i need a new spike when this below formula was true 3 times within last 30 bars it has to be 3 times not 2 not 4 the spike must happen only if it was true 3 times
thanks
IIF(MINL2 > L2 AND L2 < MINL2.3 AND L2 < IIF(MINL2.3 > L5 AND L5 < MINL2.6, L5, IIF(MINL2.4 > L6 AND L6 < MINL2.7, L6, IIF(MINL2.5 > L7 AND L7 < MINL2.8, L7, IIF(MINL2.6 > L8 AND L8 < MINL2.9, L8, IIF(MINL2.7 > L9 AND L9 < MINL2.10, L9, IIF(MINL2.8 > L10 AND L10 < MINL2.11, L10, IIF(MINL2.9 > L11 AND L11 < MINL2.12, L11, IIF(MINL2.10 > L12 AND L12 < MINL2.13, L12, IIF(MINL2.11 > L13 AND L13 < MINL2.14, L13, IIF(MINL2.12 > L14 AND L14 < MINL2.15, L14, IIF(MINL2.13 > L15 AND L15 < MINL2.16, L15, IIF(MINL2.14 > L16 AND L16 < MINL2.17, L16, IIF(MINL2.15 > L17 AND L17 < MINL2.18, L17, IIF(MINL2.16 > L18 AND L18 < MINL2.19, L18, IIF(MINL2.17 > L19 AND L19 < MINL2.20, L19, IIF(MINL2.18 > L20 AND L20 < MINL2.21, L20, IIF(MINL2.19 > L21 AND L21 < MINL2.22, L21, IIF(MINL2.20 > L22 AND L22 < MINL2.23, L22, IIF(MINL2.21 > L23 AND L23 < MINL2.24, L23, IIF(MINL2.22 > L24 AND L24 < MINL2.25, L24, IIF(MINL2.23 > L25 AND L25 < MINL2.26, L25, IIF(MINL2.24 > L26 AND L26 < MINL2.27, L26, IIF(MINL2.25 > L27 AND L27 < MINL2.28, L27, IIF(MINL2.26 > L28 AND L28 < MINL2.29, L28, IIF(MINL2.27 > L29 AND L29 < MINL2.30, L29, IIF(MINL2.28 > L30 AND L30 < MINL2.31, L30, IIF(MINL2.29 > L31 AND L31 < MINL2.32, L31, IIF(MINL2.30 > L32 AND L32 < MINL2.33, L32, IIF(MINL2.31 > L33 AND L33 < MINL2.34, L33, IIF(MINL2.32 > L34 AND L34 < MINL2.35, L34, IIF(MINL2.33 > L35 AND L35 < MINL2.36, L35, IIF(MINL2.34 > L36 AND L36 < MINL2.37, L36, IIF(MINL2.35 > L37 AND L37 < MINL2.38, L37, IIF(MINL2.36 > L38 AND L38 < MINL2.39, L38, IIF(MINL2.37 > L39 AND L39 < MINL2.40, L39, IIF(MINL2.38 > L40 AND L40 < MINL2.41, L40, IIF(MINL2.39 > L41 AND L41 < MINL2.42, L41, IIF(MINL2.40 > L42 AND L42 < MINL2.43, L42, IIF(MINL2.41 > L43 AND L43 < MINL2.44, L43, IIF(MINL2.42 > L44 AND L44 < MINL2.45, L44, IIF(MINL2.43 > L45 AND L45 < MINL2.46, L45, IIF(MINL2.44 > L46 AND L46 < MINL2.47, L46, IIF(MINL2.45 > L47 AND L47 < MINL2.48, L47, IIF(MINL2.46 > L48 AND L48 < MINL2.49, L48, IIF(MINL2.47 > L49 AND L49 < MINL2.50, L49, IIF(MINL2.48 > L50 AND L50 < MINL2.51, L50, IIF(MINL2.49 > L51 AND L51 < MINL2.52, L51, IIF(MINL2.50 > L52 AND L52 < MINL2.53, L52, IIF(MINL2.51 > L53 AND L53 < MINL2.54, L53, IIF(MINL2.52 > L54 AND L54 < MINL2.55, L54, IIF(MINL2.53 > L55 AND L55 < MINL2.56, L55, IIF(MINL2.54 > L56 AND L56 < MINL2.57, L56, IIF(MINL2.55 > L57 AND L57 < MINL2.58, L57, IIF(MINL2.56 > L58 AND L58 < MINL2.59, L58, IIF(MINL2.57 > L59 AND L59 < MINL2.60, L59, IIF(MINL2.58 > L60 AND L60 < MINL2.61, L60, IIF(MINL2.59 > L61 AND L61 < MINL2.62, L61, IIF(MINL2.60 > L62 AND L62 < MINL2.63, L62, IIF(MINL2.61 > L63 AND L63 < MINL2.64, L63, IIF(MINL2.62 > L64 AND L64 < MINL2.65, L64, 1 / 0)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))), L2, 0)
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
So just a condition formula to use in a Custom PCF % True Indicator?
CountTrue(MINL2 > L2 AND L2 < MINL2.3 AND L2 < IIF(MINL2.3 > L5 AND L5 < MINL2.6, L5, IIF(MINL2.4 > L6 AND L6 < MINL2.7, L6, IIF(MINL2.5 > L7 AND L7 < MINL2.8, L7, IIF(MINL2.6 > L8 AND L8 < MINL2.9, L8, IIF(MINL2.7 > L9 AND L9 < MINL2.10, L9, IIF(MINL2.8 > L10 AND L10 < MINL2.11, L10, IIF(MINL2.9 > L11 AND L11 < MINL2.12, L11, IIF(MINL2.10 > L12 AND L12 < MINL2.13, L12, IIF(MINL2.11 > L13 AND L13 < MINL2.14, L13, IIF(MINL2.12 > L14 AND L14 < MINL2.15, L14, IIF(MINL2.13 > L15 AND L15 < MINL2.16, L15, IIF(MINL2.14 > L16 AND L16 < MINL2.17, L16, IIF(MINL2.15 > L17 AND L17 < MINL2.18, L17, IIF(MINL2.16 > L18 AND L18 < MINL2.19, L18, IIF(MINL2.17 > L19 AND L19 < MINL2.20, L19, IIF(MINL2.18 > L20 AND L20 < MINL2.21, L20, IIF(MINL2.19 > L21 AND L21 < MINL2.22, L21, IIF(MINL2.20 > L22 AND L22 < MINL2.23, L22, IIF(MINL2.21 > L23 AND L23 < MINL2.24, L23, IIF(MINL2.22 > L24 AND L24 < MINL2.25, L24, IIF(MINL2.23 > L25 AND L25 < MINL2.26, L25, IIF(MINL2.24 > L26 AND L26 < MINL2.27, L26, IIF(MINL2.25 > L27 AND L27 < MINL2.28, L27, IIF(MINL2.26 > L28 AND L28 < MINL2.29, L28, IIF(MINL2.27 > L29 AND L29 < MINL2.30, L29, IIF(MINL2.28 > L30 AND L30 < MINL2.31, L30, IIF(MINL2.29 > L31 AND L31 < MINL2.32, L31, IIF(MINL2.30 > L32 AND L32 < MINL2.33, L32, IIF(MINL2.31 > L33 AND L33 < MINL2.34, L33, IIF(MINL2.32 > L34 AND L34 < MINL2.35, L34, IIF(MINL2.33 > L35 AND L35 < MINL2.36, L35, IIF(MINL2.34 > L36 AND L36 < MINL2.37, L36, IIF(MINL2.35 > L37 AND L37 < MINL2.38, L37, IIF(MINL2.36 > L38 AND L38 < MINL2.39, L38, IIF(MINL2.37 > L39 AND L39 < MINL2.40, L39, IIF(MINL2.38 > L40 AND L40 < MINL2.41, L40, IIF(MINL2.39 > L41 AND L41 < MINL2.42, L41, IIF(MINL2.40 > L42 AND L42 < MINL2.43, L42, IIF(MINL2.41 > L43 AND L43 < MINL2.44, L43, IIF(MINL2.42 > L44 AND L44 < MINL2.45, L44, IIF(MINL2.43 > L45 AND L45 < MINL2.46, L45, IIF(MINL2.44 > L46 AND L46 < MINL2.47, L46, IIF(MINL2.45 > L47 AND L47 < MINL2.48, L47, IIF(MINL2.46 > L48 AND L48 < MINL2.49, L48, IIF(MINL2.47 > L49 AND L49 < MINL2.50, L49, IIF(MINL2.48 > L50 AND L50 < MINL2.51, L50, IIF(MINL2.49 > L51 AND L51 < MINL2.52, L51, IIF(MINL2.50 > L52 AND L52 < MINL2.53, L52, IIF(MINL2.51 > L53 AND L53 < MINL2.54, L53, IIF(MINL2.52 > L54 AND L54 < MINL2.55, L54, IIF(MINL2.53 > L55 AND L55 < MINL2.56, L55, IIF(MINL2.54 > L56 AND L56 < MINL2.57, L56, IIF(MINL2.55 > L57 AND L57 < MINL2.58, L57, IIF(MINL2.56 > L58 AND L58 < MINL2.59, L58, IIF(MINL2.57 > L59 AND L59 < MINL2.60, L59, IIF(MINL2.58 > L60 AND L60 < MINL2.61, L60, IIF(MINL2.59 > L61 AND L61 < MINL2.62, L61, IIF(MINL2.60 > L62 AND L62 < MINL2.63, L62, IIF(MINL2.61 > L63 AND L63 < MINL2.64, L63, IIF(MINL2.62 > L64 AND L64 < MINL2.65, L64, 1 / 0)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))), 30) = 3
-Bruce Personal Criteria Formulas TC2000 Support Articles
|