I have searched the forum but have come up empty in getting what I am trying to accomplish.  I was hoping to have a PCF that gives me yesterday's closing bar value of the Wilder RSI 15 on a 10 minute bar timeframe.

There really isn't a way to create an Indicator Formula which would automatically calculate the correct value at any point in the day. We can create an Indicator Formula for the current Wilder's RSI15:

50 * (C - XAVGC29.1) / 15 / (.0666731065612527 * (ABS(C - C1) + 14 / 15 * (ABS(C1 - C2) + 14 / 15 * (ABS(C2 - C3) + 14 / 15 * (ABS(C3 - C4) + 14 / 15 * (ABS(C4 - C5) + 14 / 15 * (ABS(C5 - C6) + 14 / 15 * (ABS(C6 - C7) + 14 / 15 * (ABS(C7 - C8) + 14 / 15 * (ABS(C8 - C9) + 14 / 15 * (ABS(C9 - C10) + 14 / 15 * (ABS(C10 - C11) + 14 / 15 * (ABS(C11 - C12) + 14 / 15 * (ABS(C12 - C13) + 14 / 15 * (ABS(C13 - C14) + 14 / 15 * (ABS(C14 - C15) + 14 / 15 * (ABS(C15 - C16) + 14 / 15 * (ABS(C16 - C17) + 14 / 15 * (ABS(C17 - C18) + 14 / 15 * (ABS(C18 - C19) + 14 / 15 * (ABS(C19 - C20) + 14 / 15 * (ABS(C20 - C21) + 14 / 15 * (ABS(C21 - C22) + 14 / 15 * (ABS(C22 - C23) + 14 / 15 * (ABS(C23 - C24) + 14 / 15 * (ABS(C24 - C25) + 14 / 15 * (ABS(C25 - C26) + 14 / 15 * (ABS(C26 - C27) + 14 / 15 * (ABS(C27 - C28) + 14 / 15 * (ABS(C28 - C29) + 14 / 15 * (ABS(C29 - C30) + 14 / 15 * (ABS(C30 - C31) + 14 / 15 * (ABS(C31 - C32) + 14 / 15 * (ABS(C32 - C33) + 14 / 15 * (ABS(C33 - C34) + 14 / 15 * (ABS(C34 - C35) + 14 / 15 * (ABS(C35 - C36) + 14 / 15 * (ABS(C36 - C37) + 14 / 15 * (ABS(C37 - C38) + 14 / 15 * (ABS(C38 - C39) + 14 / 15 * (ABS(C39 - C40) + 14 / 15 * (ABS(C40 - C41) + 14 / 15 * (ABS(C41 - C42) + 14 / 15 * (ABS(C42 - C43) + 14 / 15 * (ABS(C43 - C44) + 14 / 15 * (ABS(C44 - C45) + 14 / 15 * (ABS(C45 - C46) + 14 / 15 * (ABS(C46 - C47) + 14 / 15 * (ABS(C47 - C48) + 14 / 15 * (ABS(C48 - C49) + 14 / 15 * (ABS(C49 - C50) + 14 / 15 * (ABS(C50 - C51) + 14 / 15 * (ABS(C51 - C52) + 14 / 15 * (ABS(C52 - C53) + 14 / 15 * (ABS(C53 - C54) + 14 / 15 * (ABS(C54 - C55) + 14 / 15 * (ABS(C55 - C56) + 14 / 15 * (ABS(C56 - C57) + 14 / 15 * (ABS(C57 - C58) + 14 / 15 * (ABS(C58 - C59) + 14 / 15 * (ABS(C59 - C60) + 14 / 15 * (ABS(C60 - C61) + 14 / 15 * (ABS(C61 - C62) + 14 / 15 * (ABS(C62 - C63) + 14 / 15 * (ABS(C63 - C64) + 14 / 15 * (ABS(C64 - C65) + 14 / 15 * (ABS(C65 - C66) + 14 / 15 * (ABS(C66 - C67) + 14 / 15 * (ABS(C67 - C68) + 14 / 15 * (ABS(C68 - C69) + 14 / 15 * (ABS(C69 - C70) + 14 / 15 * (ABS(C70 - C71) + 14 / 15 * (ABS(C71 - C72) + 14 / 15 * (ABS(C72 - C73) + 14 / 15 * (ABS(C73 - C74) + 14 / 15 * (ABS(C74 - C75) + 14 / 15 * (ABS(C75 - C76) + 14 / 15 * (ABS(C76 - C77) + 14 / 15 * (ABS(C77 - C78) + 14 / 15 * (ABS(C78 - C79) + 14 / 15 * (ABS(C79 - C80) + 14 / 15 * (ABS(C80 - C81) + 14 / 15 * (ABS(C81 - C82) + 14 / 15 * (ABS(C82 - C83) + 14 / 15 * (ABS(C83 - C84) + 14 / 15 * (ABS(C84 - C85) + 14 / 15 * (ABS(C85 - C86) + 14 / 15 * (ABS(C86 - C87) + 14 / 15 * (ABS(C87 - C88) + 14 / 15 * (ABS(C88 - C89) + 14 / 15 * (ABS(C89 - C90) + 14 / 15 * (ABS(C90 - C91) + 14 / 15 * (ABS(C91 - C92) + 14 / 15 * (ABS(C92 - C93) + 14 / 15 * (ABS(C93 - C94) + 14 / 15 * (ABS(C94 - C95) + 14 / 15 * (ABS(C95 - C96) + 14 / 15 * (ABS(C96 - C97) + 14 / 15 * (ABS(C97 - C98) + 14 / 15 * (ABS(C98 - C99) + 14 / 15 * (ABS(C99 - C100) + 14 / 15 * (ABS(C100 - C101) + 14 / 15 * (ABS(C101 - C102) + 14 / 15 * (ABS(C102 - C103) + 14 / 15 * (ABS(C103 - C104) + 14 / 15 * (ABS(C104 - C105) + 14 / 15 * (ABS(C105 - C106) + 14 / 15 * (ABS(C106 - C107) + 14 / 15 * (ABS(C107 - C108) + 14 / 15 * (ABS(C108 - C109) + 14 / 15 * (ABS(C109 - C110) + 14 / 15 * (ABS(C110 - C111) + 14 / 15 * (ABS(C111 - C112) + 14 / 15 * (ABS(C112 - C113) + 14 / 15 * (ABS(C113 - C114) + 14 / 15 * (ABS(C114 - C115) + 14 / 15 * (ABS(C115 - C116) + 14 / 15 * (ABS(C116 - C117) + 14 / 15 * (ABS(C117 - C118) + 14 / 15 * (ABS(C118 - C119) + 14 / 15 * (ABS(C119 - C120) + 14 / 15 * (ABS(C120 - C121) + 14 / 15 * (ABS(C121 - C122) + 14 / 15 * (ABS(C122 - C123) + 14 / 15 * (ABS(C123 - C124) + 14 / 15 * (ABS(C124 - C125) + 14 / 15 * (ABS(C125 - C126) + 14 / 15 * (ABS(C126 - C127) + 14 / 15 * (ABS(C127 - C128) + 14 / 15 * (ABS(C128 - C129) + 14 / 15 * (ABS(C129 - C130) + 14 / 15 * (ABS(C130 - C131) + 14 / 15 * (ABS(C131 - C132) + 14 / 15 * (ABS(C132 - C133) + 14 / 15 * (ABS(C133 - C134)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + 50

But there is no syntax in the Personal Criteria Formula Language which can determine the time of day on an intraday time frame. So we would need to add 1 to all of the bars ago parameters during the first bar of the next trading day:

50 * (C1 - XAVGC29.2) / 15 / (.0666731065612527 * (ABS(C1 - C2) + 14 / 15 * (ABS(C2 - C3) + 14 / 15 * (ABS(C3 - C4) + 14 / 15 * (ABS(C4 - C5) + 14 / 15 * (ABS(C5 - C6) + 14 / 15 * (ABS(C6 - C7) + 14 / 15 * (ABS(C7 - C8) + 14 / 15 * (ABS(C8 - C9) + 14 / 15 * (ABS(C9 - C10) + 14 / 15 * (ABS(C10 - C11) + 14 / 15 * (ABS(C11 - C12) + 14 / 15 * (ABS(C12 - C13) + 14 / 15 * (ABS(C13 - C14) + 14 / 15 * (ABS(C14 - C15) + 14 / 15 * (ABS(C15 - C16) + 14 / 15 * (ABS(C16 - C17) + 14 / 15 * (ABS(C17 - C18) + 14 / 15 * (ABS(C18 - C19) + 14 / 15 * (ABS(C19 - C20) + 14 / 15 * (ABS(C20 - C21) + 14 / 15 * (ABS(C21 - C22) + 14 / 15 * (ABS(C22 - C23) + 14 / 15 * (ABS(C23 - C24) + 14 / 15 * (ABS(C24 - C25) + 14 / 15 * (ABS(C25 - C26) + 14 / 15 * (ABS(C26 - C27) + 14 / 15 * (ABS(C27 - C28) + 14 / 15 * (ABS(C28 - C29) + 14 / 15 * (ABS(C29 - C30) + 14 / 15 * (ABS(C30 - C31) + 14 / 15 * (ABS(C31 - C32) + 14 / 15 * (ABS(C32 - C33) + 14 / 15 * (ABS(C33 - C34) + 14 / 15 * (ABS(C34 - C35) + 14 / 15 * (ABS(C35 - C36) + 14 / 15 * (ABS(C36 - C37) + 14 / 15 * (ABS(C37 - C38) + 14 / 15 * (ABS(C38 - C39) + 14 / 15 * (ABS(C39 - C40) + 14 / 15 * (ABS(C40 - C41) + 14 / 15 * (ABS(C41 - C42) + 14 / 15 * (ABS(C42 - C43) + 14 / 15 * (ABS(C43 - C44) + 14 / 15 * (ABS(C44 - C45) + 14 / 15 * (ABS(C45 - C46) + 14 / 15 * (ABS(C46 - C47) + 14 / 15 * (ABS(C47 - C48) + 14 / 15 * (ABS(C48 - C49) + 14 / 15 * (ABS(C49 - C50) + 14 / 15 * (ABS(C50 - C51) + 14 / 15 * (ABS(C51 - C52) + 14 / 15 * (ABS(C52 - C53) + 14 / 15 * (ABS(C53 - C54) + 14 / 15 * (ABS(C54 - C55) + 14 / 15 * (ABS(C55 - C56) + 14 / 15 * (ABS(C56 - C57) + 14 / 15 * (ABS(C57 - C58) + 14 / 15 * (ABS(C58 - C59) + 14 / 15 * (ABS(C59 - C60) + 14 / 15 * (ABS(C60 - C61) + 14 / 15 * (ABS(C61 - C62) + 14 / 15 * (ABS(C62 - C63) + 14 / 15 * (ABS(C63 - C64) + 14 / 15 * (ABS(C64 - C65) + 14 / 15 * (ABS(C65 - C66) + 14 / 15 * (ABS(C66 - C67) + 14 / 15 * (ABS(C67 - C68) + 14 / 15 * (ABS(C68 - C69) + 14 / 15 * (ABS(C69 - C70) + 14 / 15 * (ABS(C70 - C71) + 14 / 15 * (ABS(C71 - C72) + 14 / 15 * (ABS(C72 - C73) + 14 / 15 * (ABS(C73 - C74) + 14 / 15 * (ABS(C74 - C75) + 14 / 15 * (ABS(C75 - C76) + 14 / 15 * (ABS(C76 - C77) + 14 / 15 * (ABS(C77 - C78) + 14 / 15 * (ABS(C78 - C79) + 14 / 15 * (ABS(C79 - C80) + 14 / 15 * (ABS(C80 - C81) + 14 / 15 * (ABS(C81 - C82) + 14 / 15 * (ABS(C82 - C83) + 14 / 15 * (ABS(C83 - C84) + 14 / 15 * (ABS(C84 - C85) + 14 / 15 * (ABS(C85 - C86) + 14 / 15 * (ABS(C86 - C87) + 14 / 15 * (ABS(C87 - C88) + 14 / 15 * (ABS(C88 - C89) + 14 / 15 * (ABS(C89 - C90) + 14 / 15 * (ABS(C90 - C91) + 14 / 15 * (ABS(C91 - C92) + 14 / 15 * (ABS(C92 - C93) + 14 / 15 * (ABS(C93 - C94) + 14 / 15 * (ABS(C94 - C95) + 14 / 15 * (ABS(C95 - C96) + 14 / 15 * (ABS(C96 - C97) + 14 / 15 * (ABS(C97 - C98) + 14 / 15 * (ABS(C98 - C99) + 14 / 15 * (ABS(C99 - C100) + 14 / 15 * (ABS(C100 - C101) + 14 / 15 * (ABS(C101 - C102) + 14 / 15 * (ABS(C102 - C103) + 14 / 15 * (ABS(C103 - C104) + 14 / 15 * (ABS(C104 - C105) + 14 / 15 * (ABS(C105 - C106) + 14 / 15 * (ABS(C106 - C107) + 14 / 15 * (ABS(C107 - C108) + 14 / 15 * (ABS(C108 - C109) + 14 / 15 * (ABS(C109 - C110) + 14 / 15 * (ABS(C110 - C111) + 14 / 15 * (ABS(C111 - C112) + 14 / 15 * (ABS(C112 - C113) + 14 / 15 * (ABS(C113 - C114) + 14 / 15 * (ABS(C114 - C115) + 14 / 15 * (ABS(C115 - C116) + 14 / 15 * (ABS(C116 - C117) + 14 / 15 * (ABS(C117 - C118) + 14 / 15 * (ABS(C118 - C119) + 14 / 15 * (ABS(C119 - C120) + 14 / 15 * (ABS(C120 - C121) + 14 / 15 * (ABS(C121 - C122) + 14 / 15 * (ABS(C122 - C123) + 14 / 15 * (ABS(C123 - C124) + 14 / 15 * (ABS(C124 - C125) + 14 / 15 * (ABS(C125 - C126) + 14 / 15 * (ABS(C126 - C127) + 14 / 15 * (ABS(C127 - C128) + 14 / 15 * (ABS(C128 - C129) + 14 / 15 * (ABS(C129 - C130) + 14 / 15 * (ABS(C130 - C131) + 14 / 15 * (ABS(C131 - C132) + 14 / 15 * (ABS(C132 - C133) + 14 / 15 * (ABS(C133 - C134) + 14 / 15 * (ABS(C134 - C135)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + 50

But 10 minutes later when we have a second bar, we would again need an entirely different formula and have to add 2 instead of 1 to all of the bars ago parameters in the original formula:

50 * (C2 - XAVGC29.3) / 15 / (.0666731065612527 * (ABS(C2 - C3) + 14 / 15 * (ABS(C3 - C4) + 14 / 15 * (ABS(C4 - C5) + 14 / 15 * (ABS(C5 - C6) + 14 / 15 * (ABS(C6 - C7) + 14 / 15 * (ABS(C7 - C8) + 14 / 15 * (ABS(C8 - C9) + 14 / 15 * (ABS(C9 - C10) + 14 / 15 * (ABS(C10 - C11) + 14 / 15 * (ABS(C11 - C12) + 14 / 15 * (ABS(C12 - C13) + 14 / 15 * (ABS(C13 - C14) + 14 / 15 * (ABS(C14 - C15) + 14 / 15 * (ABS(C15 - C16) + 14 / 15 * (ABS(C16 - C17) + 14 / 15 * (ABS(C17 - C18) + 14 / 15 * (ABS(C18 - C19) + 14 / 15 * (ABS(C19 - C20) + 14 / 15 * (ABS(C20 - C21) + 14 / 15 * (ABS(C21 - C22) + 14 / 15 * (ABS(C22 - C23) + 14 / 15 * (ABS(C23 - C24) + 14 / 15 * (ABS(C24 - C25) + 14 / 15 * (ABS(C25 - C26) + 14 / 15 * (ABS(C26 - C27) + 14 / 15 * (ABS(C27 - C28) + 14 / 15 * (ABS(C28 - C29) + 14 / 15 * (ABS(C29 - C30) + 14 / 15 * (ABS(C30 - C31) + 14 / 15 * (ABS(C31 - C32) + 14 / 15 * (ABS(C32 - C33) + 14 / 15 * (ABS(C33 - C34) + 14 / 15 * (ABS(C34 - C35) + 14 / 15 * (ABS(C35 - C36) + 14 / 15 * (ABS(C36 - C37) + 14 / 15 * (ABS(C37 - C38) + 14 / 15 * (ABS(C38 - C39) + 14 / 15 * (ABS(C39 - C40) + 14 / 15 * (ABS(C40 - C41) + 14 / 15 * (ABS(C41 - C42) + 14 / 15 * (ABS(C42 - C43) + 14 / 15 * (ABS(C43 - C44) + 14 / 15 * (ABS(C44 - C45) + 14 / 15 * (ABS(C45 - C46) + 14 / 15 * (ABS(C46 - C47) + 14 / 15 * (ABS(C47 - C48) + 14 / 15 * (ABS(C48 - C49) + 14 / 15 * (ABS(C49 - C50) + 14 / 15 * (ABS(C50 - C51) + 14 / 15 * (ABS(C51 - C52) + 14 / 15 * (ABS(C52 - C53) + 14 / 15 * (ABS(C53 - C54) + 14 / 15 * (ABS(C54 - C55) + 14 / 15 * (ABS(C55 - C56) + 14 / 15 * (ABS(C56 - C57) + 14 / 15 * (ABS(C57 - C58) + 14 / 15 * (ABS(C58 - C59) + 14 / 15 * (ABS(C59 - C60) + 14 / 15 * (ABS(C60 - C61) + 14 / 15 * (ABS(C61 - C62) + 14 / 15 * (ABS(C62 - C63) + 14 / 15 * (ABS(C63 - C64) + 14 / 15 * (ABS(C64 - C65) + 14 / 15 * (ABS(C65 - C66) + 14 / 15 * (ABS(C66 - C67) + 14 / 15 * (ABS(C67 - C68) + 14 / 15 * (ABS(C68 - C69) + 14 / 15 * (ABS(C69 - C70) + 14 / 15 * (ABS(C70 - C71) + 14 / 15 * (ABS(C71 - C72) + 14 / 15 * (ABS(C72 - C73) + 14 / 15 * (ABS(C73 - C74) + 14 / 15 * (ABS(C74 - C75) + 14 / 15 * (ABS(C75 - C76) + 14 / 15 * (ABS(C76 - C77) + 14 / 15 * (ABS(C77 - C78) + 14 / 15 * (ABS(C78 - C79) + 14 / 15 * (ABS(C79 - C80) + 14 / 15 * (ABS(C80 - C81) + 14 / 15 * (ABS(C81 - C82) + 14 / 15 * (ABS(C82 - C83) + 14 / 15 * (ABS(C83 - C84) + 14 / 15 * (ABS(C84 - C85) + 14 / 15 * (ABS(C85 - C86) + 14 / 15 * (ABS(C86 - C87) + 14 / 15 * (ABS(C87 - C88) + 14 / 15 * (ABS(C88 - C89) + 14 / 15 * (ABS(C89 - C90) + 14 / 15 * (ABS(C90 - C91) + 14 / 15 * (ABS(C91 - C92) + 14 / 15 * (ABS(C92 - C93) + 14 / 15 * (ABS(C93 - C94) + 14 / 15 * (ABS(C94 - C95) + 14 / 15 * (ABS(C95 - C96) + 14 / 15 * (ABS(C96 - C97) + 14 / 15 * (ABS(C97 - C98) + 14 / 15 * (ABS(C98 - C99) + 14 / 15 * (ABS(C99 - C100) + 14 / 15 * (ABS(C100 - C101) + 14 / 15 * (ABS(C101 - C102) + 14 / 15 * (ABS(C102 - C103) + 14 / 15 * (ABS(C103 - C104) + 14 / 15 * (ABS(C104 - C105) + 14 / 15 * (ABS(C105 - C106) + 14 / 15 * (ABS(C106 - C107) + 14 / 15 * (ABS(C107 - C108) + 14 / 15 * (ABS(C108 - C109) + 14 / 15 * (ABS(C109 - C110) + 14 / 15 * (ABS(C110 - C111) + 14 / 15 * (ABS(C111 - C112) + 14 / 15 * (ABS(C112 - C113) + 14 / 15 * (ABS(C113 - C114) + 14 / 15 * (ABS(C114 - C115) + 14 / 15 * (ABS(C115 - C116) + 14 / 15 * (ABS(C116 - C117) + 14 / 15 * (ABS(C117 - C118) + 14 / 15 * (ABS(C118 - C119) + 14 / 15 * (ABS(C119 - C120) + 14 / 15 * (ABS(C120 - C121) + 14 / 15 * (ABS(C121 - C122) + 14 / 15 * (ABS(C122 - C123) + 14 / 15 * (ABS(C123 - C124) + 14 / 15 * (ABS(C124 - C125) + 14 / 15 * (ABS(C125 - C126) + 14 / 15 * (ABS(C126 - C127) + 14 / 15 * (ABS(C127 - C128) + 14 / 15 * (ABS(C128 - C129) + 14 / 15 * (ABS(C129 - C130) + 14 / 15 * (ABS(C130 - C131) + 14 / 15 * (ABS(C131 - C132) + 14 / 15 * (ABS(C132 - C133) + 14 / 15 * (ABS(C133 - C134) + 14 / 15 * (ABS(C134 - C135) + 14 / 15 * (ABS(C135 - C136)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + 50

So you would end up needing 39 different formulas depending on the time of day.

Bruce,

What needs to change in this forumula to make it Wilder's RSI(14)?

50 * (C - XAVGC29.1) / 15 / (.0666731065612527 * (ABS(C - C1) + 14 / 15 * (ABS(C1 - C2) + 14 / 15 * (ABS(C2 - C3) + 14 / 15 * (ABS(C3 - C4) + 14 / 15 * (ABS(C4 - C5) + 14 / 15 * (ABS(C5 - C6) + 14 / 15 * (ABS(C6 - C7) + 14 / 15 * (ABS(C7 - C8) + 14 / 15 * (ABS(C8 - C9) + 14 / 15 * (ABS(C9 - C10) + 14 / 15 * (ABS(C10 - C11) + 14 / 15 * (ABS(C11 - C12) + 14 / 15 * (ABS(C12 - C13) + 14 / 15 * (ABS(C13 - C14) + 14 / 15 * (ABS(C14 - C15) + 14 / 15 * (ABS(C15 - C16) + 14 / 15 * (ABS(C16 - C17) + 14 / 15 * (ABS(C17 - C18) + 14 / 15 * (ABS(C18 - C19) + 14 / 15 * (ABS(C19 - C20) + 14 / 15 * (ABS(C20 - C21) + 14 / 15 * (ABS(C21 - C22) + 14 / 15 * (ABS(C22 - C23) + 14 / 15 * (ABS(C23 - C24) + 14 / 15 * (ABS(C24 - C25) + 14 / 15 * (ABS(C25 - C26) + 14 / 15 * (ABS(C26 - C27) + 14 / 15 * (ABS(C27 - C28) + 14 / 15 * (ABS(C28 - C29) + 14 / 15 * (ABS(C29 - C30) + 14 / 15 * (ABS(C30 - C31) + 14 / 15 * (ABS(C31 - C32) + 14 / 15 * (ABS(C32 - C33) + 14 / 15 * (ABS(C33 - C34) + 14 / 15 * (ABS(C34 - C35) + 14 / 15 * (ABS(C35 - C36) + 14 / 15 * (ABS(C36 - C37) + 14 / 15 * (ABS(C37 - C38) + 14 / 15 * (ABS(C38 - C39) + 14 / 15 * (ABS(C39 - C40) + 14 / 15 * (ABS(C40 - C41) + 14 / 15 * (ABS(C41 - C42) + 14 / 15 * (ABS(C42 - C43) + 14 / 15 * (ABS(C43 - C44) + 14 / 15 * (ABS(C44 - C45) + 14 / 15 * (ABS(C45 - C46) + 14 / 15 * (ABS(C46 - C47) + 14 / 15 * (ABS(C47 - C48) + 14 / 15 * (ABS(C48 - C49) + 14 / 15 * (ABS(C49 - C50) + 14 / 15 * (ABS(C50 - C51) + 14 / 15 * (ABS(C51 - C52) + 14 / 15 * (ABS(C52 - C53) + 14 / 15 * (ABS(C53 - C54) + 14 / 15 * (ABS(C54 - C55) + 14 / 15 * (ABS(C55 - C56) + 14 / 15 * (ABS(C56 - C57) + 14 / 15 * (ABS(C57 - C58) + 14 / 15 * (ABS(C58 - C59) + 14 / 15 * (ABS(C59 - C60) + 14 / 15 * (ABS(C60 - C61) + 14 / 15 * (ABS(C61 - C62) + 14 / 15 * (ABS(C62 - C63) + 14 / 15 * (ABS(C63 - C64) + 14 / 15 * (ABS(C64 - C65) + 14 / 15 * (ABS(C65 - C66) + 14 / 15 * (ABS(C66 - C67) + 14 / 15 * (ABS(C67 - C68) + 14 / 15 * (ABS(C68 - C69) + 14 / 15 * (ABS(C69 - C70) + 14 / 15 * (ABS(C70 - C71) + 14 / 15 * (ABS(C71 - C72) + 14 / 15 * (ABS(C72 - C73) + 14 / 15 * (ABS(C73 - C74) + 14 / 15 * (ABS(C74 - C75) + 14 / 15 * (ABS(C75 - C76) + 14 / 15 * (ABS(C76 - C77) + 14 / 15 * (ABS(C77 - C78) + 14 / 15 * (ABS(C78 - C79) + 14 / 15 * (ABS(C79 - C80) + 14 / 15 * (ABS(C80 - C81) + 14 / 15 * (ABS(C81 - C82) + 14 / 15 * (ABS(C82 - C83) + 14 / 15 * (ABS(C83 - C84) + 14 / 15 * (ABS(C84 - C85) + 14 / 15 * (ABS(C85 - C86) + 14 / 15 * (ABS(C86 - C87) + 14 / 15 * (ABS(C87 - C88) + 14 / 15 * (ABS(C88 - C89) + 14 / 15 * (ABS(C89 - C90) + 14 / 15 * (ABS(C90 - C91) + 14 / 15 * (ABS(C91 - C92) + 14 / 15 * (ABS(C92 - C93) + 14 / 15 * (ABS(C93 - C94) + 14 / 15 * (ABS(C94 - C95) + 14 / 15 * (ABS(C95 - C96) + 14 / 15 * (ABS(C96 - C97) + 14 / 15 * (ABS(C97 - C98) + 14 / 15 * (ABS(C98 - C99) + 14 / 15 * (ABS(C99 - C100) + 14 / 15 * (ABS(C100 - C101) + 14 / 15 * (ABS(C101 - C102) + 14 / 15 * (ABS(C102 - C103) + 14 / 15 * (ABS(C103 - C104) + 14 / 15 * (ABS(C104 - C105) + 14 / 15 * (ABS(C105 - C106) + 14 / 15 * (ABS(C106 - C107) + 14 / 15 * (ABS(C107 - C108) + 14 / 15 * (ABS(C108 - C109) + 14 / 15 * (ABS(C109 - C110) + 14 / 15 * (ABS(C110 - C111) + 14 / 15 * (ABS(C111 - C112) + 14 / 15 * (ABS(C112 - C113) + 14 / 15 * (ABS(C113 - C114) + 14 / 15 * (ABS(C114 - C115) + 14 / 15 * (ABS(C115 - C116) + 14 / 15 * (ABS(C116 - C117) + 14 / 15 * (ABS(C117 - C118) + 14 / 15 * (ABS(C118 - C119) + 14 / 15 * (ABS(C119 - C120) + 14 / 15 * (ABS(C120 - C121) + 14 / 15 * (ABS(C121 - C122) + 14 / 15 * (ABS(C122 - C123) + 14 / 15 * (ABS(C123 - C124) + 14 / 15 * (ABS(C124 - C125) + 14 / 15 * (ABS(C125 - C126) + 14 / 15 * (ABS(C126 - C127) + 14 / 15 * (ABS(C127 - C128) + 14 / 15 * (ABS(C128 - C129) + 14 / 15 * (ABS(C129 - C130) + 14 / 15 * (ABS(C130 - C131) + 14 / 15 * (ABS(C131 - C132) + 14 / 15 * (ABS(C132 - C133) + 14 / 15 * (ABS(C133 - C134)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + 50

Use this for Wilder's RSI 14:

50 * (C - XAVGC27.1) / 14 / (.071435345156143 * (ABS(C - C1) + 13 / 14 * (ABS(C1 - C2) + 13 / 14 * (ABS(C2 - C3) + 13 / 14 * (ABS(C3 - C4) + 13 / 14 * (ABS(C4 - C5) + 13 / 14 * (ABS(C5 - C6) + 13 / 14 * (ABS(C6 - C7) + 13 / 14 * (ABS(C7 - C8) + 13 / 14 * (ABS(C8 - C9) + 13 / 14 * (ABS(C9 - C10) + 13 / 14 * (ABS(C10 - C11) + 13 / 14 * (ABS(C11 - C12) + 13 / 14 * (ABS(C12 - C13) + 13 / 14 * (ABS(C13 - C14) + 13 / 14 * (ABS(C14 - C15) + 13 / 14 * (ABS(C15 - C16) + 13 / 14 * (ABS(C16 - C17) + 13 / 14 * (ABS(C17 - C18) + 13 / 14 * (ABS(C18 - C19) + 13 / 14 * (ABS(C19 - C20) + 13 / 14 * (ABS(C20 - C21) + 13 / 14 * (ABS(C21 - C22) + 13 / 14 * (ABS(C22 - C23) + 13 / 14 * (ABS(C23 - C24) + 13 / 14 * (ABS(C24 - C25) + 13 / 14 * (ABS(C25 - C26) + 13 / 14 * (ABS(C26 - C27) + 13 / 14 * (ABS(C27 - C28) + 13 / 14 * (ABS(C28 - C29) + 13 / 14 * (ABS(C29 - C30) + 13 / 14 * (ABS(C30 - C31) + 13 / 14 * (ABS(C31 - C32) + 13 / 14 * (ABS(C32 - C33) + 13 / 14 * (ABS(C33 - C34) + 13 / 14 * (ABS(C34 - C35) + 13 / 14 * (ABS(C35 - C36) + 13 / 14 * (ABS(C36 - C37) + 13 / 14 * (ABS(C37 - C38) + 13 / 14 * (ABS(C38 - C39) + 13 / 14 * (ABS(C39 - C40) + 13 / 14 * (ABS(C40 - C41) + 13 / 14 * (ABS(C41 - C42) + 13 / 14 * (ABS(C42 - C43) + 13 / 14 * (ABS(C43 - C44) + 13 / 14 * (ABS(C44 - C45) + 13 / 14 * (ABS(C45 - C46) + 13 / 14 * (ABS(C46 - C47) + 13 / 14 * (ABS(C47 - C48) + 13 / 14 * (ABS(C48 - C49) + 13 / 14 * (ABS(C49 - C50) + 13 / 14 * (ABS(C50 - C51) + 13 / 14 * (ABS(C51 - C52) + 13 / 14 * (ABS(C52 - C53) + 13 / 14 * (ABS(C53 - C54) + 13 / 14 * (ABS(C54 - C55) + 13 / 14 * (ABS(C55 - C56) + 13 / 14 * (ABS(C56 - C57) + 13 / 14 * (ABS(C57 - C58) + 13 / 14 * (ABS(C58 - C59) + 13 / 14 * (ABS(C59 - C60) + 13 / 14 * (ABS(C60 - C61) + 13 / 14 * (ABS(C61 - C62) + 13 / 14 * (ABS(C62 - C63) + 13 / 14 * (ABS(C63 - C64) + 13 / 14 * (ABS(C64 - C65) + 13 / 14 * (ABS(C65 - C66) + 13 / 14 * (ABS(C66 - C67) + 13 / 14 * (ABS(C67 - C68) + 13 / 14 * (ABS(C68 - C69) + 13 / 14 * (ABS(C69 - C70) + 13 / 14 * (ABS(C70 - C71) + 13 / 14 * (ABS(C71 - C72) + 13 / 14 * (ABS(C72 - C73) + 13 / 14 * (ABS(C73 - C74) + 13 / 14 * (ABS(C74 - C75) + 13 / 14 * (ABS(C75 - C76) + 13 / 14 * (ABS(C76 - C77) + 13 / 14 * (ABS(C77 - C78) + 13 / 14 * (ABS(C78 - C79) + 13 / 14 * (ABS(C79 - C80) + 13 / 14 * (ABS(C80 - C81) + 13 / 14 * (ABS(C81 - C82) + 13 / 14 * (ABS(C82 - C83) + 13 / 14 * (ABS(C83 - C84) + 13 / 14 * (ABS(C84 - C85) + 13 / 14 * (ABS(C85 - C86) + 13 / 14 * (ABS(C86 - C87) + 13 / 14 * (ABS(C87 - C88) + 13 / 14 * (ABS(C88 - C89) + 13 / 14 * (ABS(C89 - C90) + 13 / 14 * (ABS(C90 - C91) + 13 / 14 * (ABS(C91 - C92) + 13 / 14 * (ABS(C92 - C93) + 13 / 14 * (ABS(C93 - C94) + 13 / 14 * (ABS(C94 - C95) + 13 / 14 * (ABS(C95 - C96) + 13 / 14 * (ABS(C96 - C97) + 13 / 14 * (ABS(C97 - C98) + 13 / 14 * (ABS(C98 - C99) + 13 / 14 * (ABS(C99 - C100) + 13 / 14 * (ABS(C100 - C101) + 13 / 14 * (ABS(C101 - C102) + 13 / 14 * (ABS(C102 - C103) + 13 / 14 * (ABS(C103 - C104) + 13 / 14 * (ABS(C104 - C105) + 13 / 14 * (ABS(C105 - C106) + 13 / 14 * (ABS(C106 - C107) + 13 / 14 * (ABS(C107 - C108) + 13 / 14 * (ABS(C108 - C109) + 13 / 14 * (ABS(C109 - C110) + 13 / 14 * (ABS(C110 - C111) + 13 / 14 * (ABS(C111 - C112) + 13 / 14 * (ABS(C112 - C113) + 13 / 14 * (ABS(C113 - C114) + 13 / 14 * (ABS(C114 - C115) + 13 / 14 * (ABS(C115 - C116) + 13 / 14 * (ABS(C116 - C117) + 13 / 14 * (ABS(C117 - C118) + 13 / 14 * (ABS(C118 - C119) + 13 / 14 * (ABS(C119 - C120) + 13 / 14 * (ABS(C120 - C121) + 13 / 14 * (ABS(C121 - C122) + 13 / 14 * (ABS(C122 - C123) + 13 / 14 * (ABS(C123 - C124) + 13 / 14 * (ABS(C124 - C125))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + 50

Please I need the formula for Wilder´s RSI 2 for today, yesterday and 2 days ago. 

Thanks for your support. 

An Indicator Formula for the current 2-period Wilder's RSI can be written as:

50 * (C - XAVGC3.1) / 2 / (.5000305 * (ABS(C - C1) + .5 * (ABS(C1 - C2) + .5 * (ABS(C2 - C3) + .5 * (ABS(C3 - C4) + .5 * (ABS(C4 - C5) + .5 * (ABS(C5 - C6) + .5 * (ABS(C6 - C7) + .5 * (ABS(C7 - C8) + .5 * (ABS(C8 - C9) + .5 * (ABS(C9 - C10) + .5 * (ABS(C10 - C11) + .5 * (ABS(C11 - C12) + .5 * (ABS(C12 - C13) + .5 * (ABS(C13 - C14)))))))))))))))) + 50

An Indicator Formula for the previous 2-period Wilder's RSI can be written as:

50 * (C1 - XAVGC3.2) / 2 / (.5000305 * (ABS(C1 - C2) + .5 * (ABS(C2 - C3) + .5 * (ABS(C3 - C4) + .5 * (ABS(C4 - C5) + .5 * (ABS(C5 - C6) + .5 * (ABS(C6 - C7) + .5 * (ABS(C7 - C8) + .5 * (ABS(C8 - C9) + .5 * (ABS(C9 - C10) + .5 * (ABS(C10 - C11) + .5 * (ABS(C11 - C12) + .5 * (ABS(C12 - C13) + .5 * (ABS(C13 - C14) + .5 * (ABS(C14 - C15)))))))))))))))) + 50

An Indicator Formula for the 2-period Wilder's RSI of 2 bars ago can be written as:

50 * (C2 - XAVGC3.3) / 2 / (.5000305 * (ABS(C2 - C3) + .5 * (ABS(C3 - C4) + .5 * (ABS(C4 - C5) + .5 * (ABS(C5 - C6) + .5 * (ABS(C6 - C7) + .5 * (ABS(C7 - C8) + .5 * (ABS(C8 - C9) + .5 * (ABS(C9 - C10) + .5 * (ABS(C10 - C11) + .5 * (ABS(C11 - C12) + .5 * (ABS(C12 - C13) + .5 * (ABS(C13 - C14) + .5 * (ABS(C14 - C15) + .5 * (ABS(C15 - C16)))))))))))))))) + 50

Bruce:   Could you please calculate the formula for an 18 period Wilder's RSI to be used as a PCF?

Thanks in advance.

Regards,

Mark Roth

Please try the following Indicator Formula.

50 * (C - XAVGC35.1) / 18 / (.055560844 * (ABS(C - C1) + 17 / 18 * (ABS(C1 - C2) + 17 / 18 * (ABS(C2 - C3) + 17 / 18 * (ABS(C3 - C4) + 17 / 18 * (ABS(C4 - C5) + 17 / 18 * (ABS(C5 - C6) + 17 / 18 * (ABS(C6 - C7) + 17 / 18 * (ABS(C7 - C8) + 17 / 18 * (ABS(C8 - C9) + 17 / 18 * (ABS(C9 - C10) + 17 / 18 * (ABS(C10 - C11) + 17 / 18 * (ABS(C11 - C12) + 17 / 18 * (ABS(C12 - C13) + 17 / 18 * (ABS(C13 - C14) + 17 / 18 * (ABS(C14 - C15) + 17 / 18 * (ABS(C15 - C16) + 17 / 18 * (ABS(C16 - C17) + 17 / 18 * (ABS(C17 - C18) + 17 / 18 * (ABS(C18 - C19) + 17 / 18 * (ABS(C19 - C20) + 17 / 18 * (ABS(C20 - C21) + 17 / 18 * (ABS(C21 - C22) + 17 / 18 * (ABS(C22 - C23) + 17 / 18 * (ABS(C23 - C24) + 17 / 18 * (ABS(C24 - C25) + 17 / 18 * (ABS(C25 - C26) + 17 / 18 * (ABS(C26 - C27) + 17 / 18 * (ABS(C27 - C28) + 17 / 18 * (ABS(C28 - C29) + 17 / 18 * (ABS(C29 - C30) + 17 / 18 * (ABS(C30 - C31) + 17 / 18 * (ABS(C31 - C32) + 17 / 18 * (ABS(C32 - C33) + 17 / 18 * (ABS(C33 - C34) + 17 / 18 * (ABS(C34 - C35) + 17 / 18 * (ABS(C35 - C36) + 17 / 18 * (ABS(C36 - C37) + 17 / 18 * (ABS(C37 - C38) + 17 / 18 * (ABS(C38 - C39) + 17 / 18 * (ABS(C39 - C40) + 17 / 18 * (ABS(C40 - C41) + 17 / 18 * (ABS(C41 - C42) + 17 / 18 * (ABS(C42 - C43) + 17 / 18 * (ABS(C43 - C44) + 17 / 18 * (ABS(C44 - C45) + 17 / 18 * (ABS(C45 - C46) + 17 / 18 * (ABS(C46 - C47) + 17 / 18 * (ABS(C47 - C48) + 17 / 18 * (ABS(C48 - C49) + 17 / 18 * (ABS(C49 - C50) + 17 / 18 * (ABS(C50 - C51) + 17 / 18 * (ABS(C51 - C52) + 17 / 18 * (ABS(C52 - C53) + 17 / 18 * (ABS(C53 - C54) + 17 / 18 * (ABS(C54 - C55) + 17 / 18 * (ABS(C55 - C56) + 17 / 18 * (ABS(C56 - C57) + 17 / 18 * (ABS(C57 - C58) + 17 / 18 * (ABS(C58 - C59) + 17 / 18 * (ABS(C59 - C60) + 17 / 18 * (ABS(C60 - C61) + 17 / 18 * (ABS(C61 - C62) + 17 / 18 * (ABS(C62 - C63) + 17 / 18 * (ABS(C63 - C64) + 17 / 18 * (ABS(C64 - C65) + 17 / 18 * (ABS(C65 - C66) + 17 / 18 * (ABS(C66 - C67) + 17 / 18 * (ABS(C67 - C68) + 17 / 18 * (ABS(C68 - C69) + 17 / 18 * (ABS(C69 - C70) + 17 / 18 * (ABS(C70 - C71) + 17 / 18 * (ABS(C71 - C72) + 17 / 18 * (ABS(C72 - C73) + 17 / 18 * (ABS(C73 - C74) + 17 / 18 * (ABS(C74 - C75) + 17 / 18 * (ABS(C75 - C76) + 17 / 18 * (ABS(C76 - C77) + 17 / 18 * (ABS(C77 - C78) + 17 / 18 * (ABS(C78 - C79) + 17 / 18 * (ABS(C79 - C80) + 17 / 18 * (ABS(C80 - C81) + 17 / 18 * (ABS(C81 - C82) + 17 / 18 * (ABS(C82 - C83) + 17 / 18 * (ABS(C83 - C84) + 17 / 18 * (ABS(C84 - C85) + 17 / 18 * (ABS(C85 - C86) + 17 / 18 * (ABS(C86 - C87) + 17 / 18 * (ABS(C87 - C88) + 17 / 18 * (ABS(C88 - C89) + 17 / 18 * (ABS(C89 - C90) + 17 / 18 * (ABS(C90 - C91) + 17 / 18 * (ABS(C91 - C92) + 17 / 18 * (ABS(C92 - C93) + 17 / 18 * (ABS(C93 - C94) + 17 / 18 * (ABS(C94 - C95) + 17 / 18 * (ABS(C95 - C96) + 17 / 18 * (ABS(C96 - C97) + 17 / 18 * (ABS(C97 - C98) + 17 / 18 * (ABS(C98 - C99) + 17 / 18 * (ABS(C99 - C100) + 17 / 18 * (ABS(C100 - C101) + 17 / 18 * (ABS(C101 - C102) + 17 / 18 * (ABS(C102 - C103) + 17 / 18 * (ABS(C103 - C104) + 17 / 18 * (ABS(C104 - C105) + 17 / 18 * (ABS(C105 - C106) + 17 / 18 * (ABS(C106 - C107) + 17 / 18 * (ABS(C107 - C108) + 17 / 18 * (ABS(C108 - C109) + 17 / 18 * (ABS(C109 - C110) + 17 / 18 * (ABS(C110 - C111) + 17 / 18 * (ABS(C111 - C112) + 17 / 18 * (ABS(C112 - C113) + 17 / 18 * (ABS(C113 - C114) + 17 / 18 * (ABS(C114 - C115) + 17 / 18 * (ABS(C115 - C116) + 17 / 18 * (ABS(C116 - C117) + 17 / 18 * (ABS(C117 - C118) + 17 / 18 * (ABS(C118 - C119) + 17 / 18 * (ABS(C119 - C120) + 17 / 18 * (ABS(C120 - C121) + 17 / 18 * (ABS(C121 - C122) + 17 / 18 * (ABS(C122 - C123) + 17 / 18 * (ABS(C123 - C124) + 17 / 18 * (ABS(C124 - C125) + 17 / 18 * (ABS(C125 - C126) + 17 / 18 * (ABS(C126 - C127) + 17 / 18 * (ABS(C127 - C128) + 17 / 18 * (ABS(C128 - C129) + 17 / 18 * (ABS(C129 - C130) + 17 / 18 * (ABS(C130 - C131) + 17 / 18 * (ABS(C131 - C132) + 17 / 18 * (ABS(C132 - C133) + 17 / 18 * (ABS(C133 - C134) + 17 / 18 * (ABS(C134 - C135) + 17 / 18 * (ABS(C135 - C136) + 17 / 18 * (ABS(C136 - C137) + 17 / 18 * (ABS(C137 - C138) + 17 / 18 * (ABS(C138 - C139) + 17 / 18 * (ABS(C139 - C140) + 17 / 18 * (ABS(C140 - C141) + 17 / 18 * (ABS(C141 - C142) + 17 / 18 * (ABS(C142 - C143) + 17 / 18 * (ABS(C143 - C144) + 17 / 18 * (ABS(C144 - C145) + 17 / 18 * (ABS(C145 - C146) + 17 / 18 * (ABS(C146 - C147) + 17 / 18 * (ABS(C147 - C148) + 17 / 18 * (ABS(C148 - C149) + 17 / 18 * (ABS(C149 - C150) + 17 / 18 * (ABS(C150 - C151) + 17 / 18 * (ABS(C151 - C152) + 17 / 18 * (ABS(C152 - C153) + 17 / 18 * (ABS(C153 - C154) + 17 / 18 * (ABS(C154 - C155) + 17 / 18 * (ABS(C155 - C156) + 17 / 18 * (ABS(C156 - C157) + 17 / 18 * (ABS(C157 - C158) + 17 / 18 * (ABS(C158 - C159) + 17 / 18 * (ABS(C159 - C160) + 17 / 18 * (ABS(C160 - C161) + 17 / 18 * (ABS(C161 - C162)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + 50