Platinum Customer
Joined: 3/31/2006 Posts: 3,207
|
Bruce
MAXC63 plots the max high in the last 63 days but the issue I have is when 63 days pass by and we don't have a new 63 day high. In that case the indicator continues to drop plotting the highest point in the last 63 days. Take a look at MDGL as an ex. Starting 9/12 the MAXC63 indicator starts to drop
The PCF below is what I use which continues to plot the last 63 day high up to 100 days and only adjusts when the stock makes another 63 day closing high. I like to have this plot for longer than 100 bars but in that case the PCF becomes longer and longer
By any chance is there a shorter way to plot the PCF below
IIF(C>= MAXC63.1, C,IIF(C1 >= MAXC63.2, C1, IIF(C2 >= MAXC63.3, C2, IIF(C3 >= MAXC63.4, C3, IIF(C4 >= MAXC63.5, C4, IIF(C5 >= MAXC63.6, C5, IIF(C6 >= MAXC63.7, C6, IIF(C7 >= MAXC63.8, C7, IIF(C8 >= MAXC63.9, C8, IIF(C9 >= MAXC63.10, C9, IIF(C10 >= MAXC63.11, C10, IIF(C11 >= MAXC63.12, C11, IIF(C12 >= MAXC63.13, C12, IIF(C13 >= MAXC63.14, C13, IIF(C14 >= MAXC63.15, C14, IIF(C15 >= MAXC63.16, C15, IIF(C16 >= MAXC63.17, C16, IIF(C17 >= MAXC63.18, C17, IIF(C18 >= MAXC63.19, C18, IIF(C19 >= MAXC63.20, C19, IIF(C20 >= MAXC63.21, C20, IIF(C21 >= MAXC63.22, C21, IIF(C22 >= MAXC63.23, C22, IIF(C23 >= MAXC63.24, C23, IIF(C24 >= MAXC63.25, C24, IIF(C25 >= MAXC63.26, C25, IIF(C26 >= MAXC63.27, C26, IIF(C27 >= MAXC63.28, C27, IIF(C28 >= MAXC63.29, C28, IIF(C29 >= MAXC63.30, C29, IIF(C30 >= MAXC63.31, C30, IIF(C31 >= MAXC63.32, C31, IIF(C32 >= MAXC63.33, C32, IIF(C33 >= MAXC63.34, C33, IIF(C34 >= MAXC63.35, C34, IIF(C35 >= MAXC63.36, C35, IIF(C36 >= MAXC63.37, C36, IIF(C37 >= MAXC63.38, C37, IIF(C38 >= MAXC63.39, C38, IIF(C39 >= MAXC63.40, C39, IIF(C40 >= MAXC63.41, C40, IIF(C41 >= MAXC63.42, C41, IIF(C42 >= MAXC63.43, C42, IIF(C43 >= MAXC63.44, C43, IIF(C44 >= MAXC63.45, C44, IIF(C45 >= MAXC63.46, C45, IIF(C46 >= MAXC63.47, C46, IIF(C47 >= MAXC63.48, C47, IIF(C48 >= MAXC63.49, C48, IIF(C49 >= MAXC63.50, C49, IIF(C50 >= MAXC63.51, C50, IIF(C51 >= MAXC63.52, C51, IIF(C52 >= MAXC63.53, C52, IIF(C53 >= MAXC63.54, C53, IIF(C54 >= MAXC63.55, C54, IIF(C55 >= MAXC63.56, C55, IIF(C56 >= MAXC63.57, C56, IIF(C57 >= MAXC63.58, C57, IIF(C58 >= MAXC63.59, C58, IIF(C59 >= MAXC63.60, C59, IIF(C60 >= MAXC63.61, C60, IIF(C61 >= MAXC63.62, C61, IIF(C62 >= MAXC63.63, C62, IIF(C63 >= MAXC63.64, C63, IIF(C64 >= MAXC63.65, C64, IIF(C65 >= MAXC63.66, C65, IIF(C66 >= MAXC63.67, C66, IIF(C67 >= MAXC63.68, C67, IIF(C68 >= MAXC63.69, C68, IIF(C69 >= MAXC63.70, C69, IIF(C70 >= MAXC63.71, C70, IIF(C71 >= MAXC63.72, C71, IIF(C72 >= MAXC63.73, C72, IIF(C73 >= MAXC63.74, C73, IIF(C74 >= MAXC63.75, C74, IIF(C75 >= MAXC63.76, C75, IIF(C76 >= MAXC63.77, C76, IIF(C77 >= MAXC63.78, C77, IIF(C78 >= MAXC63.79, C78, IIF(C79 >= MAXC63.80, C79, IIF(C80 >= MAXC63.81, C80, IIF(C81 >= MAXC63.82, C81, IIF(C82 >= MAXC63.83, C82, IIF(C83 >= MAXC63.84, C83, IIF(C84 >= MAXC63.85, C84, IIF(C85 >= MAXC63.86, C85, IIF(C86 >= MAXC63.87, C86, IIF(C87 >= MAXC63.88, C87, IIF(C88 >= MAXC63.89, C88, IIF(C89 >= MAXC63.90, C89, IIF(C90 >= MAXC63.91, C90, IIF(C91 >= MAXC63.92, C91, IIF(C92 >= MAXC63.93, C92, IIF(C93 >= MAXC63.94, C93, IIF(C94 >= MAXC63.95, C94, IIF(C95 >= MAXC63.96, C95, IIF(C96 >= MAXC63.97, C96, IIF(C97 >= MAXC63.98, C97, IIF(C98 >= MAXC63.99, C98, IIF(C99 >= MAXC63.100, C99, IIF(C100 >= MAXC63.101, C100, 1 / 0)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
|