Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 6/4/2008 Posts: 2
|
Hi all, am looking to find a way to compare today's close with the high from the day with highest volume over the previous 100 days (up or down days, just need the high from highest vol day). For example, on the stock 'OPEN', I'd be looking to compare C with the H from 6/25/10. Any way to do this in TC?
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Welcome to the forums. A very good foundation for learning how to use TeleChart can be gained by reviewing the following:
If you are new to TeleChart READ THIS FIRST!
The following formula should return the Percent that the current Close is above or below the High of the most recent Bar with the highest Volume in the previous 100-Bars.
100 * (C / (ABS(V1 = MAXV2.1) * H1 + ABS(V1 < MAXV2.1) * (ABS(V2 = MAXV3.1) * H2 + ABS(V2 < MAXV3.1) * (ABS(V3 = MAXV4.1) * H3 + ABS(V3 < MAXV4.1) * (ABS(V4 = MAXV5.1) * H4 + ABS(V4 < MAXV5.1) * (ABS(V5 = MAXV6.1) * H5 + ABS(V5 < MAXV6.1) * (ABS(V6 = MAXV7.1) * H6 + ABS(V6 < MAXV7.1) * (ABS(V7 = MAXV8.1) * H7 + ABS(V7 < MAXV8.1) * (ABS(V8 = MAXV9.1) * H8 + ABS(V8 < MAXV9.1) * (ABS(V9 = MAXV10.1) * H9 + ABS(V9 < MAXV10.1) * (ABS(V10 = MAXV11.1) * H10 + ABS(V10 < MAXV11.1) * (ABS(V11 = MAXV12.1) * H11 + ABS(V11 < MAXV12.1) * (ABS(V12 = MAXV13.1) * H12 + ABS(V12 < MAXV13.1) * (ABS(V13 = MAXV14.1) * H13 + ABS(V13 < MAXV14.1) * (ABS(V14 = MAXV15.1) * H14 + ABS(V14 < MAXV15.1) * (ABS(V15 = MAXV16.1) * H15 + ABS(V15 < MAXV16.1) * (ABS(V16 = MAXV17.1) * H16 + ABS(V16 < MAXV17.1) * (ABS(V17 = MAXV18.1) * H17 + ABS(V17 < MAXV18.1) * (ABS(V18 = MAXV19.1) * H18 + ABS(V18 < MAXV19.1) * (ABS(V19 = MAXV20.1) * H19 + ABS(V19 < MAXV20.1) * (ABS(V20 = MAXV21.1) * H20 + ABS(V20 < MAXV21.1) * (ABS(V21 = MAXV22.1) * H21 + ABS(V21 < MAXV22.1) * (ABS(V22 = MAXV23.1) * H22 + ABS(V22 < MAXV23.1) * (ABS(V23 = MAXV24.1) * H23 + ABS(V23 < MAXV24.1) * (ABS(V24 = MAXV25.1) * H24 + ABS(V24 < MAXV25.1) * (ABS(V25 = MAXV26.1) * H25 + ABS(V25 < MAXV26.1) * (ABS(V26 = MAXV27.1) * H26 + ABS(V26 < MAXV27.1) * (ABS(V27 = MAXV28.1) * H27 + ABS(V27 < MAXV28.1) * (ABS(V28 = MAXV29.1) * H28 + ABS(V28 < MAXV29.1) * (ABS(V29 = MAXV30.1) * H29 + ABS(V29 < MAXV30.1) * (ABS(V30 = MAXV31.1) * H30 + ABS(V30 < MAXV31.1) * (ABS(V31 = MAXV32.1) * H31 + ABS(V31 < MAXV32.1) * (ABS(V32 = MAXV33.1) * H32 + ABS(V32 < MAXV33.1) * (ABS(V33 = MAXV34.1) * H33 + ABS(V33 < MAXV34.1) * (ABS(V34 = MAXV35.1) * H34 + ABS(V34 < MAXV35.1) * (ABS(V35 = MAXV36.1) * H35 + ABS(V35 < MAXV36.1) * (ABS(V36 = MAXV37.1) * H36 + ABS(V36 < MAXV37.1) * (ABS(V37 = MAXV38.1) * H37 + ABS(V37 < MAXV38.1) * (ABS(V38 = MAXV39.1) * H38 + ABS(V38 < MAXV39.1) * (ABS(V39 = MAXV40.1) * H39 + ABS(V39 < MAXV40.1) * (ABS(V40 = MAXV41.1) * H40 + ABS(V40 < MAXV41.1) * (ABS(V41 = MAXV42.1) * H41 + ABS(V41 < MAXV42.1) * (ABS(V42 = MAXV43.1) * H42 + ABS(V42 < MAXV43.1) * (ABS(V43 = MAXV44.1) * H43 + ABS(V43 < MAXV44.1) * (ABS(V44 = MAXV45.1) * H44 + ABS(V44 < MAXV45.1) * (ABS(V45 = MAXV46.1) * H45 + ABS(V45 < MAXV46.1) * (ABS(V46 = MAXV47.1) * H46 + ABS(V46 < MAXV47.1) * (ABS(V47 = MAXV48.1) * H47 + ABS(V47 < MAXV48.1) * (ABS(V48 = MAXV49.1) * H48 + ABS(V48 < MAXV49.1) * (ABS(V49 = MAXV50.1) * H49 + ABS(V49 < MAXV50.1) * (ABS(V50 = MAXV51.1) * H50 + ABS(V50 < MAXV51.1) * (ABS(V51 = MAXV52.1) * H51 + ABS(V51 < MAXV52.1) * (ABS(V52 = MAXV53.1) * H52 + ABS(V52 < MAXV53.1) * (ABS(V53 = MAXV54.1) * H53 + ABS(V53 < MAXV54.1) * (ABS(V54 = MAXV55.1) * H54 + ABS(V54 < MAXV55.1) * (ABS(V55 = MAXV56.1) * H55 + ABS(V55 < MAXV56.1) * (ABS(V56 = MAXV57.1) * H56 + ABS(V56 < MAXV57.1) * (ABS(V57 = MAXV58.1) * H57 + ABS(V57 < MAXV58.1) * (ABS(V58 = MAXV59.1) * H58 + ABS(V58 < MAXV59.1) * (ABS(V59 = MAXV60.1) * H59 + ABS(V59 < MAXV60.1) * (ABS(V60 = MAXV61.1) * H60 + ABS(V60 < MAXV61.1) * (ABS(V61 = MAXV62.1) * H61 + ABS(V61 < MAXV62.1) * (ABS(V62 = MAXV63.1) * H62 + ABS(V62 < MAXV63.1) * (ABS(V63 = MAXV64.1) * H63 + ABS(V63 < MAXV64.1) * (ABS(V64 = MAXV65.1) * H64 + ABS(V64 < MAXV65.1) * (ABS(V65 = MAXV66.1) * H65 + ABS(V65 < MAXV66.1) * (ABS(V66 = MAXV67.1) * H66 + ABS(V66 < MAXV67.1) * (ABS(V67 = MAXV68.1) * H67 + ABS(V67 < MAXV68.1) * (ABS(V68 = MAXV69.1) * H68 + ABS(V68 < MAXV69.1) * (ABS(V69 = MAXV70.1) * H69 + ABS(V69 < MAXV70.1) * (ABS(V70 = MAXV71.1) * H70 + ABS(V70 < MAXV71.1) * (ABS(V71 = MAXV72.1) * H71 + ABS(V71 < MAXV72.1) * (ABS(V72 = MAXV73.1) * H72 + ABS(V72 < MAXV73.1) * (ABS(V73 = MAXV74.1) * H73 + ABS(V73 < MAXV74.1) * (ABS(V74 = MAXV75.1) * H74 + ABS(V74 < MAXV75.1) * (ABS(V75 = MAXV76.1) * H75 + ABS(V75 < MAXV76.1) * (ABS(V76 = MAXV77.1) * H76 + ABS(V76 < MAXV77.1) * (ABS(V77 = MAXV78.1) * H77 + ABS(V77 < MAXV78.1) * (ABS(V78 = MAXV79.1) * H78 + ABS(V78 < MAXV79.1) * (ABS(V79 = MAXV80.1) * H79 + ABS(V79 < MAXV80.1) * (ABS(V80 = MAXV81.1) * H80 + ABS(V80 < MAXV81.1) * (ABS(V81 = MAXV82.1) * H81 + ABS(V81 < MAXV82.1) * (ABS(V82 = MAXV83.1) * H82 + ABS(V82 < MAXV83.1) * (ABS(V83 = MAXV84.1) * H83 + ABS(V83 < MAXV84.1) * (ABS(V84 = MAXV85.1) * H84 + ABS(V84 < MAXV85.1) * (ABS(V85 = MAXV86.1) * H85 + ABS(V85 < MAXV86.1) * (ABS(V86 = MAXV87.1) * H86 + ABS(V86 < MAXV87.1) * (ABS(V87 = MAXV88.1) * H87 + ABS(V87 < MAXV88.1) * (ABS(V88 = MAXV89.1) * H88 + ABS(V88 < MAXV89.1) * (ABS(V89 = MAXV90.1) * H89 + ABS(V89 < MAXV90.1) * (ABS(V90 = MAXV91.1) * H90 + ABS(V90 < MAXV91.1) * (ABS(V91 = MAXV92.1) * H91 + ABS(V91 < MAXV92.1) * (ABS(V92 = MAXV93.1) * H92 + ABS(V92 < MAXV93.1) * (ABS(V93 = MAXV94.1) * H93 + ABS(V93 < MAXV94.1) * (ABS(V94 = MAXV95.1) * H94 + ABS(V94 < MAXV95.1) * (ABS(V95 = MAXV96.1) * H95 + ABS(V95 < MAXV96.1) * (ABS(V96 = MAXV97.1) * H96 + ABS(V96 < MAXV97.1) * (ABS(V97 = MAXV98.1) * H97 + ABS(V97 < MAXV98.1) * (ABS(V98 = MAXV99.1) * H98 + ABS(V98 < MAXV99.1) * (ABS(V99 = MAXV100.1) * H99 + ABS(V99 < MAXV100.1) * (ABS(V100 = MAXV101.1) * H100)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) - 1)
How to create a Personal Criteria Forumula (PCF)
Days Since Last Peak (or other day-counting needs)
PCF Formula Descriptions
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 6/4/2008 Posts: 2
|
Bruce you rock! Thank you for all the effort to put that together.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |