Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 4/29/2006 Posts: 75
|
Hi Bruce,
I have two custom indicators and need help developing a PCF to calculate the difference between them.
FIrst Indicator
Period: 55
Average Type: Exponential
Formula: (C-xavgC2.1)*(V/xavgV2.1)*1000
Data Source: Price History
Second Indicator
Period: 48
Offset: 0
Average Type: Front Weighted
Data Source: First Indicator
Your help is greatly appreciated.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
I cannot think of a way to create a formula for this which would be short and fast enough to post in the forums.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 4/29/2006 Posts: 75
|
Would it be possible if we make all averages "simple",except those within the PCF fomulas of the first indicator, and omit the "1000"?
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
The *1000 part doesn't make any difference.
It should be possible with both averages being simple, both averages being front weighted or one moving average being simple and the other being front weighted. It will still be a very long and slow formula though.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 4/29/2006 Posts: 75
|
After applying your suggestions and viewing my indicators I would prefer both averages be front weighted with the PCF formula remaining unchanged. I am more interested in being able to scan at the end of the day than see it in realtime so the speed is not that important.
Thanks,
Investalert
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Just want to verify you actually need a formula for this. If not, you can set up the first indicator (you can even have the Average Type set to Exponential) and add a MACD 1,48 to the chart with the Average Type set to Front Weighted.
Then change the Data Source of the MACD to use the first indicator.
How to change the data source for an Indicator
Just for reference, the Indicator Formula for the difference between the first and second indicators when the Average Type of both is set to Front Weighted can be written as follows.
25 * (62040 * V * (C - XAVGC2.1) / XAVGV2.1 + 58327 * V1 * (C1 - XAVGC2.2) / XAVGV2.2 + 54716 * V2 * (C2 - XAVGC2.3) / XAVGV2.3 + 51206 * V3 * (C3 - XAVGC2.4) / XAVGV2.4 + 47796 * V4 * (C4 - XAVGC2.5) / XAVGV2.5 + 44485 * V5 * (C5 - XAVGC2.6) / XAVGV2.6 + 41272 * V6 * (C6 - XAVGC2.7) / XAVGV2.7 + 38156 * V7 * (C7 - XAVGC2.8) / XAVGV2.8 + 35136 * V8 * (C8 - XAVGC2.9) / XAVGV2.9 + 32211 * V9 * (C9 - XAVGC2.10) / XAVGV2.10 + 29380 * V10 * (C10 - XAVGC2.11) / XAVGV2.11 + 26642 * V11 * (C11 - XAVGC2.12) / XAVGV2.12 + 23996 * V12 * (C12 - XAVGC2.13) / XAVGV2.13 + 21441 * V13 * (C13 - XAVGC2.14) / XAVGV2.14 + 18976 * V14 * (C14 - XAVGC2.15) / XAVGV2.15 + 16600 * V15 * (C15 - XAVGC2.16) / XAVGV2.16 + 14312 * V16 * (C16 - XAVGC2.17) / XAVGV2.17 + 12111 * V17 * (C17 - XAVGC2.18) / XAVGV2.18 + 9996 * V18 * (C18 - XAVGC2.19) / XAVGV2.19 + 7966 * V19 * (C19 - XAVGC2.20) / XAVGV2.20 + 6020 * V20 * (C20 - XAVGC2.21) / XAVGV2.21 + 4157 * V21 * (C21 - XAVGC2.22) / XAVGV2.22 + 2376 * V22 * (C22 - XAVGC2.23) / XAVGV2.23 + 676 * V23 * (C23 - XAVGC2.24) / XAVGV2.24 - 944 * V24 * (C24 - XAVGC2.25) / XAVGV2.25 - 2485 * V25 * (C25 - XAVGC2.26) / XAVGV2.26 - 3948 * V26 * (C26 - XAVGC2.27) / XAVGV2.27 - 5334 * V27 * (C27 - XAVGC2.28) / XAVGV2.28 - 6644 * V28 * (C28 - XAVGC2.29) / XAVGV2.29 - 7879 * V29 * (C29 - XAVGC2.30) / XAVGV2.30 - 9040 * V30 * (C30 - XAVGC2.31) / XAVGV2.31 - 10128 * V31 * (C31 - XAVGC2.32) / XAVGV2.32 - 11144 * V32 * (C32 - XAVGC2.33) / XAVGV2.33 - 12089 * V33 * (C33 - XAVGC2.34) / XAVGV2.34 - 12964 * V34 * (C34 - XAVGC2.35) / XAVGV2.35 - 13770 * V35 * (C35 - XAVGC2.36) / XAVGV2.36 - 14508 * V36 * (C36 - XAVGC2.37) / XAVGV2.37 - 15179 * V37 * (C37 - XAVGC2.38) / XAVGV2.38 - 15784 * V38 * (C38 - XAVGC2.39) / XAVGV2.39 - 16324 * V39 * (C39 - XAVGC2.40) / XAVGV2.40 - 16800 * V40 * (C40 - XAVGC2.41) / XAVGV2.41 - 17213 * V41 * (C41 - XAVGC2.42) / XAVGV2.42 - 17564 * V42 * (C42 - XAVGC2.43) / XAVGV2.43 - 17854 * V43 * (C43 - XAVGC2.44) / XAVGV2.44 - 18084 * V44 * (C44 - XAVGC2.45) / XAVGV2.45 - 18255 * V45 * (C45 - XAVGC2.46) / XAVGV2.46 - 18368 * V46 * (C46 - XAVGC2.47) / XAVGV2.47 - 18424 * (V47 * (C47 - XAVGC2.48) / XAVGV2.48 + V48 * (C48 - XAVGC2.49) / XAVGV2.49 + V49 * (C49 - XAVGC2.50) / XAVGV2.50 + V50 * (C50 - XAVGC2.51) / XAVGV2.51 + V51 * (C51 - XAVGC2.52) / XAVGV2.52 + V52 * (C52 - XAVGC2.53) / XAVGV2.53 + V53 * (C53 - XAVGC2.54) / XAVGV2.54 + V54 * (C54 - XAVGC2.55) / XAVGV2.55 + V55 * (C55 - XAVGC2.56) / XAVGV2.56) - 17296 * V56 * (C56 - XAVGC2.57) / XAVGV2.57 - 16215 * V57 * (C57 - XAVGC2.58) / XAVGV2.58 - 15180 * V58 * (C58 - XAVGC2.59) / XAVGV2.59 - 14190 * V59 * (C59 - XAVGC2.60) / XAVGV2.60 - 13244 * V60 * (C60 - XAVGC2.61) / XAVGV2.61 - 12341 * V61 * (C61 - XAVGC2.62) / XAVGV2.62 - 11480 * V62 * (C62 - XAVGC2.63) / XAVGV2.63 - 10660 * V63 * (C63 - XAVGC2.64) / XAVGV2.64 - 9880 * V64 * (C64 - XAVGC2.65) / XAVGV2.65 - 9139 * V65 * (C65 - XAVGC2.66) / XAVGV2.66 - 8436 * V66 * (C66 - XAVGC2.67) / XAVGV2.67 - 7770 * V67 * (C67 - XAVGC2.68) / XAVGV2.68 - 7140 * V68 * (C68 - XAVGC2.69) / XAVGV2.69 - 6545 * V69 * (C69 - XAVGC2.70) / XAVGV2.70 - 5984 * V70 * (C70 - XAVGC2.71) / XAVGV2.71 - 5456 * V71 * (C71 - XAVGC2.72) / XAVGV2.72 - 4960 * V72 * (C72 - XAVGC2.73) / XAVGV2.73 - 4495 * V73 * (C73 - XAVGC2.74) / XAVGV2.74 - 4060 * V74 * (C74 - XAVGC2.75) / XAVGV2.75 - 3654 * V75 * (C75 - XAVGC2.76) / XAVGV2.76 - 3276 * V76 * (C76 - XAVGC2.77) / XAVGV2.77 - 2925 * V77 * (C77 - XAVGC2.78) / XAVGV2.78 - 2600 * V78 * (C78 - XAVGC2.79) / XAVGV2.79 - 2300 * V79 * (C79 - XAVGC2.80) / XAVGV2.80 - 2024 * V80 * (C80 - XAVGC2.81) / XAVGV2.81 - 1771 * V81 * (C81 - XAVGC2.82) / XAVGV2.82 - 1540 * V82 * (C82 - XAVGC2.83) / XAVGV2.83 - 1330 * V83 * (C83 - XAVGC2.84) / XAVGV2.84 - 1140 * V84 * (C84 - XAVGC2.85) / XAVGV2.85 - 969 * V85 * (C85 - XAVGC2.86) / XAVGV2.86 - 816 * V86 * (C86 - XAVGC2.87) / XAVGV2.87 - 680 * V87 * (C87 - XAVGC2.88) / XAVGV2.88 - 560 * V88 * (C88 - XAVGC2.89) / XAVGV2.89 - 455 * V89 * (C89 - XAVGC2.90) / XAVGV2.90 - 364 * V90 * (C90 - XAVGC2.91) / XAVGV2.91 - 286 * V91 * (C91 - XAVGC2.92) / XAVGV2.92 - 220 * V92 * (C92 - XAVGC2.93) / XAVGV2.93 - 165 * V93 * (C93 - XAVGC2.94) / XAVGV2.94 - 120 * V94 * (C94 - XAVGC2.95) / XAVGV2.95 - 84 * V95 * (C95 - XAVGC2.96) / XAVGV2.96 - 56 * V96 * (C96 - XAVGC2.97) / XAVGV2.97 - 35 * V97 * (C97 - XAVGC2.98) / XAVGV2.98 - 20 * V98 * (C98 - XAVGC2.99) / XAVGV2.99 - 10 * V99 * (C99 - XAVGC2.100) / XAVGV2.100 - 4 * V100 * (C100 - XAVGC2.101) / XAVGV2.101 - V101 * (C101 - XAVGC2.102) / XAVGV2.102) / 45276
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |