Worden Discussion Forum

Welcome Guest, please sign in to participate in a discussion.

Worden Discussion Forum » Customer Training & Support » Ask a Trainer - TC2000 version 7 » PCF for MACD histogram - At or Below The Zero Line for 20 at least 20 days

PCF for MACD histogram - At or Below The Zero Line for 20 at least 20 days

Rate this Topic:

Previous Topic · Next Topic

Watch this topic · Print this topic ·

Hafeez31

Posted : Thursday, October 1, 2009 10:19:13 PM

Registered User
Joined: 5/9/2009
Posts: 31

Hello Trainers,
Can you please advise the PCF for the above indicated scan for daily timeframe. I would also need the same for the weekly timeframe as well.

Thanks in advance

Bruce_L

Posted : Friday, October 2, 2009 8:40:03 AM

Worden Trainer

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

It should be noted that while I will try, the Weekly version may end up being too long to be practical. In any case, I will need to know the settings of the MACD to proceed:

- Short: ?
- Long: ?
- Period: ?
- Average Type: Simple or Exponential?
- Plot MACD as Histogram: Checked

You may wish to review the following:

Understanding MACD
How to create a Personal Criteria Forumula (PCF)
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!

-Bruce
Personal Criteria Formulas
TC2000 Support Articles

Hafeez31

Posted : Friday, October 2, 2009 11:52:42 AM

Registered User
Joined: 5/9/2009
Posts: 31

Hi Bruce,
I totally forgot the settings. 11,22,8 (period). Exponential)

Thanks

Bruce_L

Posted : Friday, October 2, 2009 12:13:01 PM

Worden Trainer

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

One way to write the Daily version would be:

3 * XAVGC22 + 11 * XAVGC8 <= 14 * XAVGC11 AND 3 * XAVGC22.1 + 11 * XAVGC8.1 <= 14 * XAVGC11.1 AND 3 * XAVGC22.2 + 11 * XAVGC8.2 <= 14 * XAVGC11.2 AND 3 * XAVGC22.3 + 11 * XAVGC8.3 <= 14 * XAVGC11.3 AND 3 * XAVGC22.4 + 11 * XAVGC8.4 <= 14 * XAVGC11.4 AND 3 * XAVGC22.5 + 11 * XAVGC8.5 <= 14 * XAVGC11.5 AND 3 * XAVGC22.6 + 11 * XAVGC8.6 <= 14 * XAVGC11.6 AND 3 * XAVGC22.7 + 11 * XAVGC8.7 <= 14 * XAVGC11.7 AND 3 * XAVGC22.8 + 11 * XAVGC8.8 <= 14 * XAVGC11.8 AND 3 * XAVGC22.9 + 11 * XAVGC8.9 <= 14 * XAVGC11.9 AND 3 * XAVGC22.10 + 11 * XAVGC8.10 <= 14 * XAVGC11.10 AND 3 * XAVGC22.11 + 11 * XAVGC8.11 <= 14 * XAVGC11.11 AND 3 * XAVGC22.12 + 11 * XAVGC8.12 <= 14 * XAVGC11.12 AND 3 * XAVGC22.13 + 11 * XAVGC8.13 <= 14 * XAVGC11.13 AND 3 * XAVGC22.14 + 11 * XAVGC8.14 <= 14 * XAVGC11.14 AND 3 * XAVGC22.15 + 11 * XAVGC8.15 <= 14 * XAVGC11.15 AND 3 * XAVGC22.16 + 11 * XAVGC8.16 <= 14 * XAVGC11.16 AND 3 * XAVGC22.17 + 11 * XAVGC8.17 <= 14 * XAVGC11.17 AND 3 * XAVGC22.18 + 11 * XAVGC8.18 <= 14 * XAVGC11.18 AND 3 * XAVGC22.19 + 11 * XAVGC8.19 <= 14 * XAVGC11.19

I'm still not sure if it is going to be short enough to be practical or not, but do you want the Weekly version to be at or below zero for the most recent 20-Days or do you want to use the most recent 20-Weekly Bars currently plotted on the Weekly Chart?

-Bruce
Personal Criteria Formulas
TC2000 Support Articles

Hafeez31

Posted : Friday, October 2, 2009 12:51:30 PM

Registered User
Joined: 5/9/2009
Posts: 31

Hi Bruce,
For the weekly version, lets do it for last 4 weekly bars only. Also, just wanted to reconfirm that the above formula is for MACD-Histogram being at or below zero and not MACD avg lines being at or below zero.

THanks

Bruce_L

Posted : Friday, October 2, 2009 1:06:09 PM

Worden Trainer

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

3 * XAVGC22 + 11 * XAVGC8 <= 14 * XAVGC11

Is a slightly shortened version of (done this way to make the Weekly version significantly shorter):

XAVGC11 - XAVGC22 - XAVG(XAVGC11,8) + XAVG(XAVGC22,8) <= 0

You can test to see if this is for the Histogram yourself by comparing it to the charts.

Please try the following for the Weekly Histogram being at or below zero for the four most recent currently plotted Weekly Bars:

.261129106319734 * (C + 21 / 23 * (C5 + 21 / 23 * (C10 + 21 / 23 * (C15 + 21 / 23 * (C20 + 21 / 23 * (C25 + 21 / 23 * (C30 + 21 / 23 * (C35 + 21 / 23 * (C40 + 21 / 23 * (C45 + 21 / 23 * (C50 + 21 / 23 * (C55 + 21 / 23 * (C60 + 21 / 23 * (C65 + 21 / 23 * (C70 + 21 / 23 * (C75 + 21 / 23 * (C80 + 21 / 23 * (C85 + 21 / 23 * (C90 + 21 / 23 * (C95 + 21 / 23 * (C100 + 21 / 23 * (C105 + 21 / 23 * (C110 + 21 / 23 * (C115 + 21 / 23 * (C120 + 21 / 23 * (C125 + 21 / 23 * (C130 + 21 / 23 * (C135 + 21 / 23 * (C140 + 21 / 23 * (C145 + 21 / 23 * (C150 + 21 / 23 * (C155 + 21 / 23 * (C160 + 21 / 23 * (C165 + 21 / 23 * (C170 + 21 / 23 * (C175 + 21 / 23 * (C180 + 21 / 23 * (C185 + 21 / 23 * (C190 + 21 / 23 * (C195 + 21 / 23 * (C200 + 21 / 23 * (C205 + 21 / 23 * (C210 + 21 / 23 * (C215 + 21 / 23 * (C220 + 21 / 23 * (C225 + 21 / 23 * (C230 + 21 / 23 * (C235 + 21 / 23 * (C240 + 21 / 23 * (C245 + 21 / 23 * (C250 + 21 / 23 * (C255 + 21 / 23 * (C260 + 21 / 23 * (C265 + 21 / 23 * (C270 + 21 / 23 * (C275 + 21 / 23 * (C280 + 21 / 23 * (C285 + 21 / 23 * (C290 + 21 / 23 * (C295 + 21 / 23 * (C300 + 21 / 23 * (C305 + 21 / 23 * (C310 + 21 / 23 * (C315 + 21 / 23 * (C320 + 21 / 23 * (C325 + 21 / 23 * (C330 + 21 / 23 * (C335 + 21 / 23 * (C340 + 21 / 23 * (C345 + 21 / 23 * (C350 + 21 / 23 * (C355 + 21 / 23 * (C360 + 21 / 23 * (C365 + 21 / 23 * (C370 + 21 / 23 * (C375)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + 2.44659483285259 * (C + 7 / 9 * (C5 + 7 / 9 * (C10 + 7 / 9 * (C15 + 7 / 9 * (C20 + 7 / 9 * (C25 + 7 / 9 * (C30 + 7 / 9 * (C35 + 7 / 9 * (C40 + 7 / 9 * (C45 + 7 / 9 * (C50 + 7 / 9 * (C55 + 7 / 9 * (C60 + 7 / 9 * (C65 + 7 / 9 * (C70 + 7 / 9 * (C75 + 7 / 9 * (C80 + 7 / 9 * (C85 + 7 / 9 * (C90 + 7 / 9 * (C95 + 7 / 9 * (C100 + 7 / 9 * (C105 + 7 / 9 * (C110 + 7 / 9 * (C115 + 7 / 9 * (C120 + 7 / 9 * (C125 + 7 / 9 * (C130 + 7 / 9 * (C135)))))))))))))))))))))))))))) <= 2.33562164482462 * (C + 5 / 6 * (C5 + 5 / 6 * (C10 + 5 / 6 * (C15 + 5 / 6 * (C20 + 5 / 6 * (C25 + 5 / 6 * (C30 + 5 / 6 * (C35 + 5 / 6 * (C40 + 5 / 6 * (C45 + 5 / 6 * (C50 + 5 / 6 * (C55 + 5 / 6 * (C60 + 5 / 6 * (C65 + 5 / 6 * (C70 + 5 / 6 * (C75 + 5 / 6 * (C80 + 5 / 6 * (C85 + 5 / 6 * (C90 + 5 / 6 * (C95 + 5 / 6 * (C100 + 5 / 6 * (C105 + 5 / 6 * (C110 + 5 / 6 * (C115 + 5 / 6 * (C120 + 5 / 6 * (C125 + 5 / 6 * (C130 + 5 / 6 * (C135 + 5 / 6 * (C140 + 5 / 6 * (C145 + 5 / 6 * (C150 + 5 / 6 * (C155 + 5 / 6 * (C160 + 5 / 6 * (C165 + 5 / 6 * (C170 + 5 / 6 * (C175 + 5 / 6 * (C180 + 5 / 6 * (C185)))))))))))))))))))))))))))))))))))))) AND .261129106319734 * (C5 + 21 / 23 * (C10 + 21 / 23 * (C15 + 21 / 23 * (C20 + 21 / 23 * (C25 + 21 / 23 * (C30 + 21 / 23 * (C35 + 21 / 23 * (C40 + 21 / 23 * (C45 + 21 / 23 * (C50 + 21 / 23 * (C55 + 21 / 23 * (C60 + 21 / 23 * (C65 + 21 / 23 * (C70 + 21 / 23 * (C75 + 21 / 23 * (C80 + 21 / 23 * (C85 + 21 / 23 * (C90 + 21 / 23 * (C95 + 21 / 23 * (C100 + 21 / 23 * (C105 + 21 / 23 * (C110 + 21 / 23 * (C115 + 21 / 23 * (C120 + 21 / 23 * (C125 + 21 / 23 * (C130 + 21 / 23 * (C135 + 21 / 23 * (C140 + 21 / 23 * (C145 + 21 / 23 * (C150 + 21 / 23 * (C155 + 21 / 23 * (C160 + 21 / 23 * (C165 + 21 / 23 * (C170 + 21 / 23 * (C175 + 21 / 23 * (C180 + 21 / 23 * (C185 + 21 / 23 * (C190 + 21 / 23 * (C195 + 21 / 23 * (C200 + 21 / 23 * (C205 + 21 / 23 * (C210 + 21 / 23 * (C215 + 21 / 23 * (C220 + 21 / 23 * (C225 + 21 / 23 * (C230 + 21 / 23 * (C235 + 21 / 23 * (C240 + 21 / 23 * (C245 + 21 / 23 * (C250 + 21 / 23 * (C255 + 21 / 23 * (C260 + 21 / 23 * (C265 + 21 / 23 * (C270 + 21 / 23 * (C275 + 21 / 23 * (C280 + 21 / 23 * (C285 + 21 / 23 * (C290 + 21 / 23 * (C295 + 21 / 23 * (C300 + 21 / 23 * (C305 + 21 / 23 * (C310 + 21 / 23 * (C315 + 21 / 23 * (C320 + 21 / 23 * (C325 + 21 / 23 * (C330 + 21 / 23 * (C335 + 21 / 23 * (C340 + 21 / 23 * (C345 + 21 / 23 * (C350 + 21 / 23 * (C355 + 21 / 23 * (C360 + 21 / 23 * (C365 + 21 / 23 * (C370 + 21 / 23 * (C375 + 21 / 23 * (C380)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + 2.44659483285259 * (C5 + 7 / 9 * (C10 + 7 / 9 * (C15 + 7 / 9 * (C20 + 7 / 9 * (C25 + 7 / 9 * (C30 + 7 / 9 * (C35 + 7 / 9 * (C40 + 7 / 9 * (C45 + 7 / 9 * (C50 + 7 / 9 * (C55 + 7 / 9 * (C60 + 7 / 9 * (C65 + 7 / 9 * (C70 + 7 / 9 * (C75 + 7 / 9 * (C80 + 7 / 9 * (C85 + 7 / 9 * (C90 + 7 / 9 * (C95 + 7 / 9 * (C100 + 7 / 9 * (C105 + 7 / 9 * (C110 + 7 / 9 * (C115 + 7 / 9 * (C120 + 7 / 9 * (C125 + 7 / 9 * (C130 + 7 / 9 * (C135 + 7 / 9 * (C140)))))))))))))))))))))))))))) <= 2.33562164482462 * (C5 + 5 / 6 * (C10 + 5 / 6 * (C15 + 5 / 6 * (C20 + 5 / 6 * (C25 + 5 / 6 * (C30 + 5 / 6 * (C35 + 5 / 6 * (C40 + 5 / 6 * (C45 + 5 / 6 * (C50 + 5 / 6 * (C55 + 5 / 6 * (C60 + 5 / 6 * (C65 + 5 / 6 * (C70 + 5 / 6 * (C75 + 5 / 6 * (C80 + 5 / 6 * (C85 + 5 / 6 * (C90 + 5 / 6 * (C95 + 5 / 6 * (C100 + 5 / 6 * (C105 + 5 / 6 * (C110 + 5 / 6 * (C115 + 5 / 6 * (C120 + 5 / 6 * (C125 + 5 / 6 * (C130 + 5 / 6 * (C135 + 5 / 6 * (C140 + 5 / 6 * (C145 + 5 / 6 * (C150 + 5 / 6 * (C155 + 5 / 6 * (C160 + 5 / 6 * (C165 + 5 / 6 * (C170 + 5 / 6 * (C175 + 5 / 6 * (C180 + 5 / 6 * (C185 + 5 / 6 * (C190)))))))))))))))))))))))))))))))))))))) AND .261129106319734 * (C10 + 21 / 23 * (C15 + 21 / 23 * (C20 + 21 / 23 * (C25 + 21 / 23 * (C30 + 21 / 23 * (C35 + 21 / 23 * (C40 + 21 / 23 * (C45 + 21 / 23 * (C50 + 21 / 23 * (C55 + 21 / 23 * (C60 + 21 / 23 * (C65 + 21 / 23 * (C70 + 21 / 23 * (C75 + 21 / 23 * (C80 + 21 / 23 * (C85 + 21 / 23 * (C90 + 21 / 23 * (C95 + 21 / 23 * (C100 + 21 / 23 * (C105 + 21 / 23 * (C110 + 21 / 23 * (C115 + 21 / 23 * (C120 + 21 / 23 * (C125 + 21 / 23 * (C130 + 21 / 23 * (C135 + 21 / 23 * (C140 + 21 / 23 * (C145 + 21 / 23 * (C150 + 21 / 23 * (C155 + 21 / 23 * (C160 + 21 / 23 * (C165 + 21 / 23 * (C170 + 21 / 23 * (C175 + 21 / 23 * (C180 + 21 / 23 * (C185 + 21 / 23 * (C190 + 21 / 23 * (C195 + 21 / 23 * (C200 + 21 / 23 * (C205 + 21 / 23 * (C210 + 21 / 23 * (C215 + 21 / 23 * (C220 + 21 / 23 * (C225 + 21 / 23 * (C230 + 21 / 23 * (C235 + 21 / 23 * (C240 + 21 / 23 * (C245 + 21 / 23 * (C250 + 21 / 23 * (C255 + 21 / 23 * (C260 + 21 / 23 * (C265 + 21 / 23 * (C270 + 21 / 23 * (C275 + 21 / 23 * (C280 + 21 / 23 * (C285 + 21 / 23 * (C290 + 21 / 23 * (C295 + 21 / 23 * (C300 + 21 / 23 * (C305 + 21 / 23 * (C310 + 21 / 23 * (C315 + 21 / 23 * (C320 + 21 / 23 * (C325 + 21 / 23 * (C330 + 21 / 23 * (C335 + 21 / 23 * (C340 + 21 / 23 * (C345 + 21 / 23 * (C350 + 21 / 23 * (C355 + 21 / 23 * (C360 + 21 / 23 * (C365 + 21 / 23 * (C370 + 21 / 23 * (C375 + 21 / 23 * (C380 + 21 / 23 * (C385)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + 2.44659483285259 * (C10 + 7 / 9 * (C15 + 7 / 9 * (C20 + 7 / 9 * (C25 + 7 / 9 * (C30 + 7 / 9 * (C35 + 7 / 9 * (C40 + 7 / 9 * (C45 + 7 / 9 * (C50 + 7 / 9 * (C55 + 7 / 9 * (C60 + 7 / 9 * (C65 + 7 / 9 * (C70 + 7 / 9 * (C75 + 7 / 9 * (C80 + 7 / 9 * (C85 + 7 / 9 * (C90 + 7 / 9 * (C95 + 7 / 9 * (C100 + 7 / 9 * (C105 + 7 / 9 * (C110 + 7 / 9 * (C115 + 7 / 9 * (C120 + 7 / 9 * (C125 + 7 / 9 * (C130 + 7 / 9 * (C135 + 7 / 9 * (C140 + 7 / 9 * (C145)))))))))))))))))))))))))))) <= 2.33562164482462 * (C10 + 5 / 6 * (C15 + 5 / 6 * (C20 + 5 / 6 * (C25 + 5 / 6 * (C30 + 5 / 6 * (C35 + 5 / 6 * (C40 + 5 / 6 * (C45 + 5 / 6 * (C50 + 5 / 6 * (C55 + 5 / 6 * (C60 + 5 / 6 * (C65 + 5 / 6 * (C70 + 5 / 6 * (C75 + 5 / 6 * (C80 + 5 / 6 * (C85 + 5 / 6 * (C90 + 5 / 6 * (C95 + 5 / 6 * (C100 + 5 / 6 * (C105 + 5 / 6 * (C110 + 5 / 6 * (C115 + 5 / 6 * (C120 + 5 / 6 * (C125 + 5 / 6 * (C130 + 5 / 6 * (C135 + 5 / 6 * (C140 + 5 / 6 * (C145 + 5 / 6 * (C150 + 5 / 6 * (C155 + 5 / 6 * (C160 + 5 / 6 * (C165 + 5 / 6 * (C170 + 5 / 6 * (C175 + 5 / 6 * (C180 + 5 / 6 * (C185 + 5 / 6 * (C190 + 5 / 6 * (C195)))))))))))))))))))))))))))))))))))))) AND .261129106319734 * (C15 + 21 / 23 * (C20 + 21 / 23 * (C25 + 21 / 23 * (C30 + 21 / 23 * (C35 + 21 / 23 * (C40 + 21 / 23 * (C45 + 21 / 23 * (C50 + 21 / 23 * (C55 + 21 / 23 * (C60 + 21 / 23 * (C65 + 21 / 23 * (C70 + 21 / 23 * (C75 + 21 / 23 * (C80 + 21 / 23 * (C85 + 21 / 23 * (C90 + 21 / 23 * (C95 + 21 / 23 * (C100 + 21 / 23 * (C105 + 21 / 23 * (C110 + 21 / 23 * (C115 + 21 / 23 * (C120 + 21 / 23 * (C125 + 21 / 23 * (C130 + 21 / 23 * (C135 + 21 / 23 * (C140 + 21 / 23 * (C145 + 21 / 23 * (C150 + 21 / 23 * (C155 + 21 / 23 * (C160 + 21 / 23 * (C165 + 21 / 23 * (C170 + 21 / 23 * (C175 + 21 / 23 * (C180 + 21 / 23 * (C185 + 21 / 23 * (C190 + 21 / 23 * (C195 + 21 / 23 * (C200 + 21 / 23 * (C205 + 21 / 23 * (C210 + 21 / 23 * (C215 + 21 / 23 * (C220 + 21 / 23 * (C225 + 21 / 23 * (C230 + 21 / 23 * (C235 + 21 / 23 * (C240 + 21 / 23 * (C245 + 21 / 23 * (C250 + 21 / 23 * (C255 + 21 / 23 * (C260 + 21 / 23 * (C265 + 21 / 23 * (C270 + 21 / 23 * (C275 + 21 / 23 * (C280 + 21 / 23 * (C285 + 21 / 23 * (C290 + 21 / 23 * (C295 + 21 / 23 * (C300 + 21 / 23 * (C305 + 21 / 23 * (C310 + 21 / 23 * (C315 + 21 / 23 * (C320 + 21 / 23 * (C325 + 21 / 23 * (C330 + 21 / 23 * (C335 + 21 / 23 * (C340 + 21 / 23 * (C345 + 21 / 23 * (C350 + 21 / 23 * (C355 + 21 / 23 * (C360 + 21 / 23 * (C365 + 21 / 23 * (C370 + 21 / 23 * (C375 + 21 / 23 * (C380 + 21 / 23 * (C385 + 21 / 23 * (C390)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + 2.44659483285259 * (C15 + 7 / 9 * (C20 + 7 / 9 * (C25 + 7 / 9 * (C30 + 7 / 9 * (C35 + 7 / 9 * (C40 + 7 / 9 * (C45 + 7 / 9 * (C50 + 7 / 9 * (C55 + 7 / 9 * (C60 + 7 / 9 * (C65 + 7 / 9 * (C70 + 7 / 9 * (C75 + 7 / 9 * (C80 + 7 / 9 * (C85 + 7 / 9 * (C90 + 7 / 9 * (C95 + 7 / 9 * (C100 + 7 / 9 * (C105 + 7 / 9 * (C110 + 7 / 9 * (C115 + 7 / 9 * (C120 + 7 / 9 * (C125 + 7 / 9 * (C130 + 7 / 9 * (C135 + 7 / 9 * (C140 + 7 / 9 * (C145 + 7 / 9 * (C150)))))))))))))))))))))))))))) <= 2.33562164482462 * (C15 + 5 / 6 * (C20 + 5 / 6 * (C25 + 5 / 6 * (C30 + 5 / 6 * (C35 + 5 / 6 * (C40 + 5 / 6 * (C45 + 5 / 6 * (C50 + 5 / 6 * (C55 + 5 / 6 * (C60 + 5 / 6 * (C65 + 5 / 6 * (C70 + 5 / 6 * (C75 + 5 / 6 * (C80 + 5 / 6 * (C85 + 5 / 6 * (C90 + 5 / 6 * (C95 + 5 / 6 * (C100 + 5 / 6 * (C105 + 5 / 6 * (C110 + 5 / 6 * (C115 + 5 / 6 * (C120 + 5 / 6 * (C125 + 5 / 6 * (C130 + 5 / 6 * (C135 + 5 / 6 * (C140 + 5 / 6 * (C145 + 5 / 6 * (C150 + 5 / 6 * (C155 + 5 / 6 * (C160 + 5 / 6 * (C165 + 5 / 6 * (C170 + 5 / 6 * (C175 + 5 / 6 * (C180 + 5 / 6 * (C185 + 5 / 6 * (C190 + 5 / 6 * (C195 + 5 / 6 * (C200))))))))))))))))))))))))))))))))))))))

-Bruce
Personal Criteria Formulas
TC2000 Support Articles

diceman

Posted : Friday, October 2, 2009 1:08:24 PM

Registered User
Joined: 1/28/2005
Posts: 6,049

One possible short cut would be to use:

55,110,40

daily settings as an equivalent for the weekly.

Thanks

diceman

Hafeez31

Posted : Friday, October 2, 2009 1:10:23 PM

Registered User
Joined: 5/9/2009
Posts: 31

Thanks for your prompt reply ..i'll try this out this evening ... .as I am at work .... which is not stock trading :)

Bruce_L

Posted : Friday, October 2, 2009 1:11:09 PM

Worden Trainer

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

Hafeez31,
You're welcome. Our pleasure.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles

Hafeez31

Posted : Friday, October 2, 2009 1:13:22 PM

Registered User
Joined: 5/9/2009
Posts: 31

QUOTE (diceman)

One possible short cut would be to use:

55,110,40

daily settings as an equivalent for the weekly.

Thanks

diceman

THanks for your response. Much apprecaited

Hafeez31

Posted : Friday, October 2, 2009 1:14:17 PM

Registered User
Joined: 5/9/2009
Posts: 31

Bruce, just a quick after thought ...if I need to shorten the daily version to 10 days ...where should i cut it off.?

Bruce_L

Posted : Friday, October 2, 2009 1:22:58 PM

Worden Trainer

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

Hafeez31,
The ten day version would be:

3 * XAVGC22 + 11 * XAVGC8 <= 14 * XAVGC11 AND 3 * XAVGC22.1 + 11 * XAVGC8.1 <= 14 * XAVGC11.1 AND 3 * XAVGC22.2 + 11 * XAVGC8.2 <= 14 * XAVGC11.2 AND 3 * XAVGC22.3 + 11 * XAVGC8.3 <= 14 * XAVGC11.3 AND 3 * XAVGC22.4 + 11 * XAVGC8.4 <= 14 * XAVGC11.4 AND 3 * XAVGC22.5 + 11 * XAVGC8.5 <= 14 * XAVGC11.5 AND 3 * XAVGC22.6 + 11 * XAVGC8.6 <= 14 * XAVGC11.6 AND 3 * XAVGC22.7 + 11 * XAVGC8.7 <= 14 * XAVGC11.7 AND 3 * XAVGC22.8 + 11 * XAVGC8.8 <= 14 * XAVGC11.8 AND 3 * XAVGC22.9 + 11 * XAVGC8.9 <= 14 * XAVGC11.9

-Bruce
Personal Criteria Formulas
TC2000 Support Articles

Hafeez31

Posted : Saturday, October 3, 2009 1:29:25 PM

Registered User
Joined: 5/9/2009
Posts: 31

QUOTE (Bruce_L)

Hi Bruce,
In the above post you indicated the shorter version for weekly. Can you please answer the following Q:
1. Instead of the long PCF I am assuming to use the "3 * XAVGC22 + 11 * XAVGC8 <= 14 * XAVGC11 ...if correct then what is the second PCF "XAVGC11 - XAVGC22 - XAVG(XAVGC11,8) + XAVG(XAVGC22,8)" or both need to combined?.

Bruce_L

Posted : Saturday, October 3, 2009 8:53:35 PM

Worden Trainer

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

Hafeez31,
You don't need to combine them. The formulas return the same results.

If you reviewed the Understanding MACD topic, it would explain how to create the longer version of the formula.

The shorter version of the formula was derived using the techniques outlined in Cascades of Moving Averages.

It's not a big saving in the size of the daily formula, but it creates a significantly shorter weekly formula.

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