Subscription & data-feed pricing Class schedule

 Last 10 Posts Topic: question on fib dot plot Posted: Tuesday, April 9, 2019 11:59:55 AM The bounce template should be the same. Just change what you are using as "your formula here". -Bruce Personal Criteria FormulasTC2000 Support Articles Topic: question on fib dot plot Posted: Tuesday, April 9, 2019 10:25:34 AM The high portion is: `IIF(MAXH5 < H5 AND H5 > MAXH5.6, H5, IIF(MAXH5.1 < H6 AND H6 > MAXH5.7, H6, IIF(MAXH5.2 < H7 AND H7 > MAXH5.8, H7, IIF(MAXH5.3 < H8 AND H8 > MAXH5.9, H8, IIF(MAXH5.4 < H9 AND H9 > MAXH5.10, H9, IIF(MAXH5.5 < H10 AND H10 > MAXH5.11, H10, IIF(MAXH5.6 < H11 AND H11 > MAXH5.12, H11, IIF(MAXH5.7 < H12 AND H12 > MAXH5.13, H12, IIF(MAXH5.8 < H13 AND H13 > MAXH5.14, H13, IIF(MAXH5.9 < H14 AND H14 > MAXH5.15, H14, IIF(MAXH5.10 < H15 AND H15 > MAXH5.16, H15, IIF(MAXH5.11 < H16 AND H16 > MAXH5.17, H16, IIF(MAXH5.12 < H17 AND H17 > MAXH5.18, H17, IIF(MAXH5.13 < H18 AND H18 > MAXH5.19, H18, IIF(MAXH5.14 < H19 AND H19 > MAXH5.20, H19, IIF(MAXH5.15 < H20 AND H20 > MAXH5.21, H20, IIF(MAXH5.16 < H21 AND H21 > MAXH5.22, H21, IIF(MAXH5.17 < H22 AND H22 > MAXH5.23, H22, IIF(MAXH5.18 < H23 AND H23 > MAXH5.24, H23, IIF(MAXH5.19 < H24 AND H24 > MAXH5.25, H24, IIF(MAXH5.20 < H25 AND H25 > MAXH5.26, H25, IIF(MAXH5.21 < H26 AND H26 > MAXH5.27, H26, IIF(MAXH5.22 < H27 AND H27 > MAXH5.28, H27, IIF(MAXH5.23 < H28 AND H28 > MAXH5.29, H28, IIF(MAXH5.24 < H29 AND H29 > MAXH5.30, H29, IIF(MAXH5.25 < H30 AND H30 > MAXH5.31, H30, IIF(MAXH5.26 < H31 AND H31 > MAXH5.32, H31, IIF(MAXH5.27 < H32 AND H32 > MAXH5.33, H32, IIF(MAXH5.28 < H33 AND H33 > MAXH5.34, H33, IIF(MAXH5.29 < H34 AND H34 > MAXH5.35, H34, IIF(MAXH5.30 < H35 AND H35 > MAXH5.36, H35, IIF(MAXH5.31 < H36 AND H36 > MAXH5.37, H36, IIF(MAXH5.32 < H37 AND H37 > MAXH5.38, H37, IIF(MAXH5.33 < H38 AND H38 > MAXH5.39, H38, IIF(MAXH5.34 < H39 AND H39 > MAXH5.40, H39, IIF(MAXH5.35 < H40 AND H40 > MAXH5.41, H40, IIF(MAXH5.36 < H41 AND H41 > MAXH5.42, H41, IIF(MAXH5.37 < H42 AND H42 > MAXH5.43, H42, IIF(MAXH5.38 < H43 AND H43 > MAXH5.44, H43, IIF(MAXH5.39 < H44 AND H44 > MAXH5.45, H44, IIF(MAXH5.40 < H45 AND H45 > MAXH5.46, H45, IIF(MAXH5.41 < H46 AND H46 > MAXH5.47, H46, IIF(MAXH5.42 < H47 AND H47 > MAXH5.48, H47, IIF(MAXH5.43 < H48 AND H48 > MAXH5.49, H48, IIF(MAXH5.44 < H49 AND H49 > MAXH5.50, H49, IIF(MAXH5.45 < H50 AND H50 > MAXH5.51, H50, IIF(MAXH5.46 < H51 AND H51 > MAXH5.52, H51, IIF(MAXH5.47 < H52 AND H52 > MAXH5.53, H52, IIF(MAXH5.48 < H53 AND H53 > MAXH5.54, H53, IIF(MAXH5.49 < H54 AND H54 > MAXH5.55, H54, 1 / 0))))))))))))))))))))))))))))))))))))))))))))))))))` And the low portion is: `IIF(MINL5 > L5 AND L5 < MINL5.6, L5, IIF(MINL5.1 > L6 AND L6 < MINL5.7, L6, IIF(MINL5.2 > L7 AND L7 < MINL5.8, L7, IIF(MINL5.3 > L8 AND L8 < MINL5.9, L8, IIF(MINL5.4 > L9 AND L9 < MINL5.10, L9, IIF(MINL5.5 > L10 AND L10 < MINL5.11, L10, IIF(MINL5.6 > L11 AND L11 < MINL5.12, L11, IIF(MINL5.7 > L12 AND L12 < MINL5.13, L12, IIF(MINL5.8 > L13 AND L13 < MINL5.14, L13, IIF(MINL5.9 > L14 AND L14 < MINL5.15, L14, IIF(MINL5.10 > L15 AND L15 < MINL5.16, L15, IIF(MINL5.11 > L16 AND L16 < MINL5.17, L16, IIF(MINL5.12 > L17 AND L17 < MINL5.18, L17, IIF(MINL5.13 > L18 AND L18 < MINL5.19, L18, IIF(MINL5.14 > L19 AND L19 < MINL5.20, L19, IIF(MINL5.15 > L20 AND L20 < MINL5.21, L20, IIF(MINL5.16 > L21 AND L21 < MINL5.22, L21, IIF(MINL5.17 > L22 AND L22 < MINL5.23, L22, IIF(MINL5.18 > L23 AND L23 < MINL5.24, L23, IIF(MINL5.19 > L24 AND L24 < MINL5.25, L24, IIF(MINL5.20 > L25 AND L25 < MINL5.26, L25, IIF(MINL5.21 > L26 AND L26 < MINL5.27, L26, IIF(MINL5.22 > L27 AND L27 < MINL5.28, L27, IIF(MINL5.23 > L28 AND L28 < MINL5.29, L28, IIF(MINL5.24 > L29 AND L29 < MINL5.30, L29, IIF(MINL5.25 > L30 AND L30 < MINL5.31, L30, IIF(MINL5.26 > L31 AND L31 < MINL5.32, L31, IIF(MINL5.27 > L32 AND L32 < MINL5.33, L32, IIF(MINL5.28 > L33 AND L33 < MINL5.34, L33, IIF(MINL5.29 > L34 AND L34 < MINL5.35, L34, IIF(MINL5.30 > L35 AND L35 < MINL5.36, L35, IIF(MINL5.31 > L36 AND L36 < MINL5.37, L36, IIF(MINL5.32 > L37 AND L37 < MINL5.38, L37, IIF(MINL5.33 > L38 AND L38 < MINL5.39, L38, IIF(MINL5.34 > L39 AND L39 < MINL5.40, L39, IIF(MINL5.35 > L40 AND L40 < MINL5.41, L40, IIF(MINL5.36 > L41 AND L41 < MINL5.42, L41, IIF(MINL5.37 > L42 AND L42 < MINL5.43, L42, IIF(MINL5.38 > L43 AND L43 < MINL5.44, L43, IIF(MINL5.39 > L44 AND L44 < MINL5.45, L44, IIF(MINL5.40 > L45 AND L45 < MINL5.46, L45, IIF(MINL5.41 > L46 AND L46 < MINL5.47, L46, IIF(MINL5.42 > L47 AND L47 < MINL5.48, L47, IIF(MINL5.43 > L48 AND L48 < MINL5.49, L48, IIF(MINL5.44 > L49 AND L49 < MINL5.50, L49, IIF(MINL5.45 > L50 AND L50 < MINL5.51, L50, IIF(MINL5.46 > L51 AND L51 < MINL5.52, L51, IIF(MINL5.47 > L52 AND L52 < MINL5.53, L52, IIF(MINL5.48 > L53 AND L53 < MINL5.54, L53, IIF(MINL5.49 > L54 AND L54 < MINL5.55, L54, 1 / 0))))))))))))))))))))))))))))))))))))))))))))))))))` For the first formula multiply the high portion by .618 and the low portion by .382 and add them together. For the second formula multiply the high portion by 1.618 and the low portion by -.618 and add the together (or multiply the low portion by .618 and subtract it from the high part). -Bruce Personal Criteria FormulasTC2000 Support Articles Topic: how to scan gap ups or downs during the day Posted: Tuesday, April 9, 2019 9:47:01 AM The open just being greater than the previous close is the following. `O > C1` While the open being below the previous close would be the following. `O < C1` -Bruce Personal Criteria FormulasTC2000 Support Articles Topic: New Highs/Lows from Pre-built Conditions Posted: Tuesday, April 9, 2019 9:45:29 AM You can do something like: `C = H` Or: `STOC1 = 100` In a daily time frame to check for the current price to be the high of the trading day, but there really isn't a reliable way to write a formula to check for the high of the current intraday bar being the high of the trading day if the close isn't the high of that bar. -Bruce Personal Criteria FormulasTC2000 Support Articles Topic: Indicator Support Posted: Tuesday, April 9, 2019 9:14:38 AM You're welcome. -Bruce Personal Criteria FormulasTC2000 Support Articles Topic: Bands Breakout Posted: Tuesday, April 9, 2019 9:13:29 AM You're welcome. -Bruce Personal Criteria FormulasTC2000 Support Articles Topic: Excel RTD Posted: Monday, April 8, 2019 4:58:06 PM Thank you for your suggestion. You do already have TC2000 v7, so you can use that to export, but it is going to be daily data only. -Bruce Personal Criteria FormulasTC2000 Support Articles Topic: TTM trend & squeeze Posted: Monday, April 8, 2019 3:01:42 PM I have sent you a copy of the most recent version I have made of the TTM Squeeze indicator via TCMail. -Bruce Personal Criteria FormulasTC2000 Support Articles Topic: New Highs/Lows from Pre-built Conditions Posted: Monday, April 8, 2019 11:55:30 AM There really aren't formulas which correspond to exact way the built in new high and new low conditions work because those conditions can work with fewer bars than the period of the new high and new low. That said, you could create conditions for the high of the current bar being at its highest value in the most recent 50 bars. `H = MAXH50` A similar formula for the low would be: `L = MINL50` Or a condition for the high of the current bar being higher than the highest high over the previous 49 bars. `H > MAXH49.1` A similar formula for the low would be: `L < MINL49.1` And you could check for the current price being above the highest high in the previous 49 bars. `C > MAXH49.1` A similar formula for the lowest price would be: `C < MINL49.1` And you could even check for the current price being at its highest value of the most recent 50 bars. `C = MAXH50` Or: `STOC50 = 100` With a similar formula for being at the lowest price being: `C = MINL50` Or: `STOC50 = 0` But all of these formulas would require at least 50 bars of data be available, while just clicking on price and selecting New High or New Low with the period set to 50 would still work even if there were less than 50 bars of data. -Bruce Personal Criteria FormulasTC2000 Support Articles Topic: Relative Volume Ratio Posted: Monday, April 8, 2019 10:48:15 AM You're welcome. -Bruce Personal Criteria FormulasTC2000 Support Articles