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

33 day low Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
thnkbigr
Posted : Tuesday, January 30, 2018 8:15:46 PM
Platinum Customer Platinum Customer

Joined: 3/31/2006
Posts: 3,207

Bruce 

What's the suimplest way to write a PCF that would plot the value of the last 33 Day Low 

If today's low is a 33 day low the indicator wil plot that value so if the stock continues to drop and make new 33 day lows the indicator will continue to adj and plot the new 33 day low but once price begins to rise the indicator will plot the last 33 day low for 100 bars  

Bruce_L
Posted : Wednesday, January 31, 2018 9:32:49 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

If you really mean just the 33 day low, then you wouldn't need to keep plotting it for 100 bars since you only need to look at 33 bars to know the 33 day low.

MINL33

If you mean the low of the current bar was lower than any of the previous 33 bars, then there isn't an easy way to do it. The formula is going to be pretty long.

IIF(L < MINL33.1, L, IIF(L1 < MINL33.2, L1, IIF(L2 < MINL33.3, L2, IIF(L3 < MINL33.4, L3, IIF(L4 < MINL33.5, L4, IIF(L5 < MINL33.6, L5, IIF(L6 < MINL33.7, L6, IIF(L7 < MINL33.8, L7, IIF(L8 < MINL33.9, L8, IIF(L9 < MINL33.10, L9, IIF(L10 < MINL33.11, L10, IIF(L11 < MINL33.12, L11, IIF(L12 < MINL33.13, L12, IIF(L13 < MINL33.14, L13, IIF(L14 < MINL33.15, L14, IIF(L15 < MINL33.16, L15, IIF(L16 < MINL33.17, L16, IIF(L17 < MINL33.18, L17, IIF(L18 < MINL33.19, L18, IIF(L19 < MINL33.20, L19, IIF(L20 < MINL33.21, L20, IIF(L21 < MINL33.22, L21, IIF(L22 < MINL33.23, L22, IIF(L23 < MINL33.24, L23, IIF(L24 < MINL33.25, L24, IIF(L25 < MINL33.26, L25, IIF(L26 < MINL33.27, L26, IIF(L27 < MINL33.28, L27, IIF(L28 < MINL33.29, L28, IIF(L29 < MINL33.30, L29, IIF(L30 < MINL33.31, L30, IIF(L31 < MINL33.32, L31, IIF(L32 < MINL33.33, L32, IIF(L33 < MINL33.34, L33, IIF(L34 < MINL33.35, L34, IIF(L35 < MINL33.36, L35, IIF(L36 < MINL33.37, L36, IIF(L37 < MINL33.38, L37, IIF(L38 < MINL33.39, L38, IIF(L39 < MINL33.40, L39, IIF(L40 < MINL33.41, L40, IIF(L41 < MINL33.42, L41, IIF(L42 < MINL33.43, L42, IIF(L43 < MINL33.44, L43, IIF(L44 < MINL33.45, L44, IIF(L45 < MINL33.46, L45, IIF(L46 < MINL33.47, L46, IIF(L47 < MINL33.48, L47, IIF(L48 < MINL33.49, L48, IIF(L49 < MINL33.50, L49, IIF(L50 < MINL33.51, L50, IIF(L51 < MINL33.52, L51, IIF(L52 < MINL33.53, L52, IIF(L53 < MINL33.54, L53, IIF(L54 < MINL33.55, L54, IIF(L55 < MINL33.56, L55, IIF(L56 < MINL33.57, L56, IIF(L57 < MINL33.58, L57, IIF(L58 < MINL33.59, L58, IIF(L59 < MINL33.60, L59, IIF(L60 < MINL33.61, L60, IIF(L61 < MINL33.62, L61, IIF(L62 < MINL33.63, L62, IIF(L63 < MINL33.64, L63, IIF(L64 < MINL33.65, L64, IIF(L65 < MINL33.66, L65, IIF(L66 < MINL33.67, L66, IIF(L67 < MINL33.68, L67, IIF(L68 < MINL33.69, L68, IIF(L69 < MINL33.70, L69, IIF(L70 < MINL33.71, L70, IIF(L71 < MINL33.72, L71, IIF(L72 < MINL33.73, L72, IIF(L73 < MINL33.74, L73, IIF(L74 < MINL33.75, L74, IIF(L75 < MINL33.76, L75, IIF(L76 < MINL33.77, L76, IIF(L77 < MINL33.78, L77, IIF(L78 < MINL33.79, L78, IIF(L79 < MINL33.80, L79, IIF(L80 < MINL33.81, L80, IIF(L81 < MINL33.82, L81, IIF(L82 < MINL33.83, L82, IIF(L83 < MINL33.84, L83, IIF(L84 < MINL33.85, L84, IIF(L85 < MINL33.86, L85, IIF(L86 < MINL33.87, L86, IIF(L87 < MINL33.88, L87, IIF(L88 < MINL33.89, L88, IIF(L89 < MINL33.90, L89, IIF(L90 < MINL33.91, L90, IIF(L91 < MINL33.92, L91, IIF(L92 < MINL33.93, L92, IIF(L93 < MINL33.94, L93, IIF(L94 < MINL33.95, L94, IIF(L95 < MINL33.96, L95, IIF(L96 < MINL33.97, L96, IIF(L97 < MINL33.98, L97, IIF(L98 < MINL33.99, L98, IIF(L99 < MINL33.100, L99, 1 / 0))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
thnkbigr
Posted : Wednesday, January 31, 2018 2:15:49 PM
Platinum Customer Platinum Customer

Joined: 3/31/2006
Posts: 3,207

Is there an easy way that you can teach me to change all the 33's to 22 or another value 

So this will plot MINL22

Bruce_L
Posted : Wednesday, January 31, 2018 2:24:17 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

Put it in a text editor and use the replace function?

IIF(L < MINL22.1, L, IIF(L1 < MINL22.2, L1, IIF(L2 < MINL22.3, L2, IIF(L3 < MINL22.4, L3, IIF(L4 < MINL22.5, L4, IIF(L5 < MINL22.6, L5, IIF(L6 < MINL22.7, L6, IIF(L7 < MINL22.8, L7, IIF(L8 < MINL22.9, L8, IIF(L9 < MINL22.10, L9, IIF(L10 < MINL22.11, L10, IIF(L11 < MINL22.12, L11, IIF(L12 < MINL22.13, L12, IIF(L13 < MINL22.14, L13, IIF(L14 < MINL22.15, L14, IIF(L15 < MINL22.16, L15, IIF(L16 < MINL22.17, L16, IIF(L17 < MINL22.18, L17, IIF(L18 < MINL22.19, L18, IIF(L19 < MINL22.20, L19, IIF(L20 < MINL22.21, L20, IIF(L21 < MINL22.22, L21, IIF(L22 < MINL22.23, L22, IIF(L23 < MINL22.24, L23, IIF(L24 < MINL22.25, L24, IIF(L25 < MINL22.26, L25, IIF(L26 < MINL22.27, L26, IIF(L27 < MINL22.28, L27, IIF(L28 < MINL22.29, L28, IIF(L29 < MINL22.30, L29, IIF(L30 < MINL22.31, L30, IIF(L31 < MINL22.32, L31, IIF(L32 < MINL22.33, L32, IIF(L33 < MINL22.34, L33, IIF(L34 < MINL22.35, L34, IIF(L35 < MINL22.36, L35, IIF(L36 < MINL22.37, L36, IIF(L37 < MINL22.38, L37, IIF(L38 < MINL22.39, L38, IIF(L39 < MINL22.40, L39, IIF(L40 < MINL22.41, L40, IIF(L41 < MINL22.42, L41, IIF(L42 < MINL22.43, L42, IIF(L43 < MINL22.44, L43, IIF(L44 < MINL22.45, L44, IIF(L45 < MINL22.46, L45, IIF(L46 < MINL22.47, L46, IIF(L47 < MINL22.48, L47, IIF(L48 < MINL22.49, L48, IIF(L49 < MINL22.50, L49, IIF(L50 < MINL22.51, L50, IIF(L51 < MINL22.52, L51, IIF(L52 < MINL22.53, L52, IIF(L53 < MINL22.54, L53, IIF(L54 < MINL22.55, L54, IIF(L55 < MINL22.56, L55, IIF(L56 < MINL22.57, L56, IIF(L57 < MINL22.58, L57, IIF(L58 < MINL22.59, L58, IIF(L59 < MINL22.60, L59, IIF(L60 < MINL22.61, L60, IIF(L61 < MINL22.62, L61, IIF(L62 < MINL22.63, L62, IIF(L63 < MINL22.64, L63, IIF(L64 < MINL22.65, L64, IIF(L65 < MINL22.66, L65, IIF(L66 < MINL22.67, L66, IIF(L67 < MINL22.68, L67, IIF(L68 < MINL22.69, L68, IIF(L69 < MINL22.70, L69, IIF(L70 < MINL22.71, L70, IIF(L71 < MINL22.72, L71, IIF(L72 < MINL22.73, L72, IIF(L73 < MINL22.74, L73, IIF(L74 < MINL22.75, L74, IIF(L75 < MINL22.76, L75, IIF(L76 < MINL22.77, L76, IIF(L77 < MINL22.78, L77, IIF(L78 < MINL22.79, L78, IIF(L79 < MINL22.80, L79, IIF(L80 < MINL22.81, L80, IIF(L81 < MINL22.82, L81, IIF(L82 < MINL22.83, L82, IIF(L83 < MINL22.84, L83, IIF(L84 < MINL22.85, L84, IIF(L85 < MINL22.86, L85, IIF(L86 < MINL22.87, L86, IIF(L87 < MINL22.88, L87, IIF(L88 < MINL22.89, L88, IIF(L89 < MINL22.90, L89, IIF(L90 < MINL22.91, L90, IIF(L91 < MINL22.92, L91, IIF(L92 < MINL22.93, L92, IIF(L93 < MINL22.94, L93, IIF(L94 < MINL22.95, L94, IIF(L95 < MINL22.96, L95, IIF(L96 < MINL22.97, L96, IIF(L97 < MINL22.98, L97, IIF(L98 < MINL22.99, L98, IIF(L99 < MINL22.100, L99, 1 / 0))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
thnkbigr
Posted : Wednesday, January 31, 2018 2:43:53 PM
Platinum Customer Platinum Customer

Joined: 3/31/2006
Posts: 3,207

No idea what text editor is. lol 

Bruce_L
Posted : Wednesday, January 31, 2018 2:48:03 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

The most common one for Windows is called Notepad and comes as part of the operating system.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
thnkbigr
Posted : Wednesday, January 31, 2018 3:11:24 PM
Platinum Customer Platinum Customer

Joined: 3/31/2006
Posts: 3,207

got it. thx

Bruce_L
Posted : Wednesday, January 31, 2018 3:14:13 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

You're welcome.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.