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

WRSI fibs Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
dhirenshah
Posted : Sunday, March 18, 2018 10:57:26 PM
Registered User
Joined: 3/10/2012
Posts: 465

Bruce hope u had good weekend ... 

1) have two part question as below 

a) I want to convert the below formula to overlay on WRSI14 low so what will be the new formula

L13 * ABS(MINL13 > L13 AND L13 < MINL13.14) 

b) I want to convert the below formula to overlay on WRSI14 high so what will be new formula

H13 * ABS(MAXH13 < H13 AND H13 > MAXH13.14) 

 

Second question i will ask after your response to the first one as i will be asking after a little back testing from your response

thanks 

Bruce_L
Posted : Monday, March 19, 2018 10:04:14 AM


Worden Trainer

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

a)

WRSI14.13 * ABS(MIN(WRSI14, 13) > WRSI14.13 AND WRSI14.13 < MIN(WRSI14.14, 13))

b)

WRSI14.13 * ABS(MAX(WRSI14, 13) < WRSI14.13 AND WRSI14.13 > MAX(WRSI14.14, 13))



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
dhirenshah
Posted : Monday, March 19, 2018 12:23:25 PM
Registered User
Joined: 3/10/2012
Posts: 465

Ok Bruce thanks for above formula

Now we only need to identify the swing low 13 and we don't have to try and identify the swing high at all. All we do is use the highest high since the swing low (excluding the bar of the swing low) 

So when i draw fib retracement on WRSI 13 bar swing LOW i want to identify where is current WRSI in terms of fib ratio... you did this on price for me .. as below formula 

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))))))))))))))))))))))))))))))))))))))))))))))))))

 
 
Bruce_L
Posted : Monday, March 19, 2018 4:58:35 PM


Worden Trainer

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

Re-using that basic structure works, but is way too long and slow to be practical or post in the forums when using Wilder's RSI instead of price. I have tried a few alternate structures, but so far, none have made the formula fast enough to post.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
dhirenshah
Posted : Tuesday, March 20, 2018 9:55:23 AM
Registered User
Joined: 3/10/2012
Posts: 465

No problem Bruce , thanks for Trying .. 

Cheers

Bruce_L
Posted : Tuesday, March 20, 2018 9:57:13 AM


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.