Registered User Joined: 3/10/2012 Posts: 465
|
Hi Bruce
good morning... you did a PCF for me as below and it works perfect, but what i want this time is to count number of bars as output result using that same formula from below ...
So example " MON "on daily identifiable 13 bar swing low was July 13,2017 and current low of price today (August 18,2017) so when i count bars to the right from 13 bar swing low to current day low the total number of trading bars including both days were "26"
so could i please get pcf to get that number "26" as out put result ....
thanks
Dhiren
100 * (IIF(MINL13 > L13 AND L13 < MINL13.14, MAXH13, IIF(MINL13.1 > L14 AND L14 < MINL13.15, MAXH14, IIF(MINL13.2 > L15 AND L15 < MINL13.16, MAXH15, IIF(MINL13.3 > L16 AND L16 < MINL13.17, MAXH16, IIF(MINL13.4 > L17 AND L17 < MINL13.18, MAXH17, IIF(MINL13.5 > L18 AND L18 < MINL13.19, MAXH18, IIF(MINL13.6 > L19 AND L19 < MINL13.20, MAXH19, IIF(MINL13.7 > L20 AND L20 < MINL13.21, MAXH20, IIF(MINL13.8 > L21 AND L21 < MINL13.22, MAXH21, IIF(MINL13.9 > L22 AND L22 < MINL13.23, MAXH22, IIF(MINL13.10 > L23 AND L23 < MINL13.24, MAXH23, IIF(MINL13.11 > L24 AND L24 < MINL13.25, MAXH24, IIF(MINL13.12 > L25 AND L25 < MINL13.26, MAXH25, IIF(MINL13.13 > L26 AND L26 < MINL13.27, MAXH26, IIF(MINL13.14 > L27 AND L27 < MINL13.28, MAXH27, IIF(MINL13.15 > L28 AND L28 < MINL13.29, MAXH28, IIF(MINL13.16 > L29 AND L29 < MINL13.30, MAXH29, IIF(MINL13.17 > L30 AND L30 < MINL13.31, MAXH30, IIF(MINL13.18 > L31 AND L31 < MINL13.32, MAXH31, IIF(MINL13.19 > L32 AND L32 < MINL13.33, MAXH32, IIF(MINL13.20 > L33 AND L33 < MINL13.34, MAXH33, IIF(MINL13.21 > L34 AND L34 < MINL13.35, MAXH34, IIF(MINL13.22 > L35 AND L35 < MINL13.36, MAXH35, IIF(MINL13.23 > L36 AND L36 < MINL13.37, MAXH36, IIF(MINL13.24 > L37 AND L37 < MINL13.38, MAXH37, IIF(MINL13.25 > L38 AND L38 < MINL13.39, MAXH38, IIF(MINL13.26 > L39 AND L39 < MINL13.40, MAXH39, IIF(MINL13.27 > L40 AND L40 < MINL13.41, MAXH40, IIF(MINL13.28 > L41 AND L41 < MINL13.42, MAXH41, IIF(MINL13.29 > L42 AND L42 < MINL13.43, MAXH42, IIF(MINL13.30 > L43 AND L43 < MINL13.44, MAXH43, IIF(MINL13.31 > L44 AND L44 < MINL13.45, MAXH44, IIF(MINL13.32 > L45 AND L45 < MINL13.46, MAXH45, IIF(MINL13.33 > L46 AND L46 < MINL13.47, MAXH46, IIF(MINL13.34 > L47 AND L47 < MINL13.48, MAXH47, IIF(MINL13.35 > L48 AND L48 < MINL13.49, MAXH48, IIF(MINL13.36 > L49 AND L49 < MINL13.50, MAXH49, IIF(MINL13.37 > L50 AND L50 < MINL13.51, MAXH50, IIF(MINL13.38 > L51 AND L51 < MINL13.52, MAXH51, IIF(MINL13.39 > L52 AND L52 < MINL13.53, MAXH52, IIF(MINL13.40 > L53 AND L53 < MINL13.54, MAXH53, IIF(MINL13.41 > L54 AND L54 < MINL13.55, MAXH54, IIF(MINL13.42 > L55 AND L55 < MINL13.56, MAXH55, IIF(MINL13.43 > L56 AND L56 < MINL13.57, MAXH56, IIF(MINL13.44 > L57 AND L57 < MINL13.58, MAXH57, IIF(MINL13.45 > L58 AND L58 < MINL13.59, MAXH58, IIF(MINL13.46 > L59 AND L59 < MINL13.60, MAXH59, IIF(MINL13.47 > L60 AND L60 < MINL13.61, MAXH60, IIF(MINL13.48 > L61 AND L61 < MINL13.62, MAXH61, IIF(MINL13.49 > L62 AND L62 < MINL13.63, MAXH62, 1/0)))))))))))))))))))))))))))))))))))))))))))))))))) - L) / IIF(MINL13 > L13 AND L13 < MINL13.14, MAXH13 - L13, IIF(MINL13.1 > L14 AND L14 < MINL13.15, MAXH14 - L14, IIF(MINL13.2 > L15 AND L15 < MINL13.16, MAXH15 - L15, IIF(MINL13.3 > L16 AND L16 < MINL13.17, MAXH16 - L16, IIF(MINL13.4 > L17 AND L17 < MINL13.18, MAXH17 - L17, IIF(MINL13.5 > L18 AND L18 < MINL13.19, MAXH18 - L18, IIF(MINL13.6 > L19 AND L19 < MINL13.20, MAXH19 - L19, IIF(MINL13.7 > L20 AND L20 < MINL13.21, MAXH20 - L20, IIF(MINL13.8 > L21 AND L21 < MINL13.22, MAXH21 - L21, IIF(MINL13.9 > L22 AND L22 < MINL13.23, MAXH22 - L22, IIF(MINL13.10 > L23 AND L23 < MINL13.24, MAXH23 - L23, IIF(MINL13.11 > L24 AND L24 < MINL13.25, MAXH24 - L24, IIF(MINL13.12 > L25 AND L25 < MINL13.26, MAXH25 - L25, IIF(MINL13.13 > L26 AND L26 < MINL13.27, MAXH26 - L26, IIF(MINL13.14 > L27 AND L27 < MINL13.28, MAXH27 - L27, IIF(MINL13.15 > L28 AND L28 < MINL13.29, MAXH28 - L28, IIF(MINL13.16 > L29 AND L29 < MINL13.30, MAXH29 - L29, IIF(MINL13.17 > L30 AND L30 < MINL13.31, MAXH30 - L30, IIF(MINL13.18 > L31 AND L31 < MINL13.32, MAXH31 - L31, IIF(MINL13.19 > L32 AND L32 < MINL13.33, MAXH32 - L32, IIF(MINL13.20 > L33 AND L33 < MINL13.34, MAXH33 - L33, IIF(MINL13.21 > L34 AND L34 < MINL13.35, MAXH34 - L34, IIF(MINL13.22 > L35 AND L35 < MINL13.36, MAXH35 - L35, IIF(MINL13.23 > L36 AND L36 < MINL13.37, MAXH36 - L36, IIF(MINL13.24 > L37 AND L37 < MINL13.38, MAXH37 - L37, IIF(MINL13.25 > L38 AND L38 < MINL13.39, MAXH38 - L38, IIF(MINL13.26 > L39 AND L39 < MINL13.40, MAXH39 - L39, IIF(MINL13.27 > L40 AND L40 < MINL13.41, MAXH40 - L40, IIF(MINL13.28 > L41 AND L41 < MINL13.42, MAXH41 - L41, IIF(MINL13.29 > L42 AND L42 < MINL13.43, MAXH42 - L42, IIF(MINL13.30 > L43 AND L43 < MINL13.44, MAXH43 - L43, IIF(MINL13.31 > L44 AND L44 < MINL13.45, MAXH44 - L44, IIF(MINL13.32 > L45 AND L45 < MINL13.46, MAXH45 - L45, IIF(MINL13.33 > L46 AND L46 < MINL13.47, MAXH46 - L46, IIF(MINL13.34 > L47 AND L47 < MINL13.48, MAXH47 - L47, IIF(MINL13.35 > L48 AND L48 < MINL13.49, MAXH48 - L48, IIF(MINL13.36 > L49 AND L49 < MINL13.50, MAXH49 - L49, IIF(MINL13.37 > L50 AND L50 < MINL13.51, MAXH50 - L50, IIF(MINL13.38 > L51 AND L51 < MINL13.52, MAXH51 - L51, IIF(MINL13.39 > L52 AND L52 < MINL13.53, MAXH52 - L52, IIF(MINL13.40 > L53 AND L53 < MINL13.54, MAXH53 - L53, IIF(MINL13.41 > L54 AND L54 < MINL13.55, MAXH54 - L54, IIF(MINL13.42 > L55 AND L55 < MINL13.56, MAXH55 - L55, IIF(MINL13.43 > L56 AND L56 < MINL13.57, MAXH56 - L56, IIF(MINL13.44 > L57 AND L57 < MINL13.58, MAXH57 - L57, IIF(MINL13.45 > L58 AND L58 < MINL13.59, MAXH58 - L58, IIF(MINL13.46 > L59 AND L59 < MINL13.60, MAXH59 - L59, IIF(MINL13.47 > L60 AND L60 < MINL13.61, MAXH60 - L60, IIF(MINL13.48 > L61 AND L61 < MINL13.62, MAXH61 - L61, IIF(MINL13.49 > L62 AND L62 < MINL13.63, MAXH62 - L62, 1/0))))))))))))))))))))))))))))))))))))))))))))))))))
|