Registered User
Joined: 11/13/2004
Posts: 121
|
In he August 6, 2004 Worden Report, Sir TANSTAAFL presented a Volume-weighted MACD indicator, which works great in TC2005. I am wanting to create pcfs that show 1) when the VMACD 12-26-9 is crossing 0 and 2) when VMACD is crossing its signal line. How would I go about that? Would adding volume to each step of this calculation give me the correct formula for crossing a signal line, for example? If that would work that would allow me also to test with other periods than 12,26 and 9. Any thoughts much appreciated.
XAVGC12 - XAVGC26 > XAVG(XAVGC12,9) - XAVG(XAVGC26,9) AND (XAVGC12.1 - XAVGC26.1 < XAVG(XAVGC12.1,9) - XAVG(XAVGC26.1,9))
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Here is the indicator from the report:
(C*V+ C1*V1+ C2*V2+ C3*V3+ C4*V4+ C5*V5+ C6*V6+ C7*V7+ C8*V8+ C9*V9+ C10*V10+ C11*V11) * (1/12/AvgV12 -1/26/AvgV26) - (C12*V12+ C13*V13+ C14*V14+ C15*V15+ C16*V16+ C17*V17+ C18*V18+ C19*V19+ C20*V20+ C21*V21+ C22*V22+ C23*V23+ C24*V24+ C25*V25) /26 /AvgV26
It really isn't a "MACD" as much as a volume-wieghted PROC of some sort.
For crossing the 0 line try this:
((C*V+ C1*V1+ C2*V2+ C3*V3+ C4*V4+ C5*V5+ C6*V6+ C7*V7+ C8*V8+ C9*V9+ C10*V10+ C11*V11) * (1/12/AvgV12 -1/26/AvgV26) - (C12*V12+ C13*V13+ C14*V14+ C15*V15+ C16*V16+ C17*V17+ C18*V18+ C19*V19+ C20*V20+ C21*V21+ C22*V22+ C23*V23+ C24*V24+ C25*V25) /26 /AvgV26)>0 AND ((C26*V26+ C1*V1+ C2*V2+ C3*V3+ C4*V4+ C5*V5+ C6*V6+ C7*V7+ C8*V8+ C9*V9+ C10*V10+ C11*V11) * (1/12/AvgV12 -1/26/AvgV26.1) - (C12*V12+ C13*V13+ C14*V14+ C15*V15+ C16*V16+ C17*V17+ C18*V18+ C19*V19+ C20*V20+ C21*V21+ C22*V22+ C23*V23+ C24*V24+ C25*V25) /26 /AvgV26.1)
For crossing the signal line you are best off using the visual difference sorting method mentioned by him in the report.
Comparing indicators using Visual Difference sorts
- Craig
Here to Help!
|
|
Registered User
Joined: 11/13/2004
Posts: 121
|
Thank you for your pcf. I compared the entry and exit signals it gives (using a Percent True custom indicator) to the VMACD setup with 9-day ema in the Worden Report. It gives very different signals. Dumb question, but you said the pcf in the report was more of a "PROC." Do you mean price rate-of-change? It isn't really a true VMACD then? And the one you have presented is? I don't want to start an idealogical argument going :) I just need to understand better. Is there a way to write a pcf for a VMACD crossing its 9 ema signal line? Also, is there a way to create a VMACD line and its signal line in TC2005 so I can view it line I would a regular MACD? I know I am loaded with questions here, but John Bollinger talks alot about VMACD but I can find little in the literature on how to create one, both with pcf signals and as an indicator to view on a chart... Thanks for any help.
|
|
Registered User
Joined: 1/28/2005
Posts: 6,049
|
gsn
Craig's PCF is triggered when Tanstaafls first equation goes positive.
As Tanstaafl stated it is too complex to create it with the 9 exp
signal.
That is why he used the sorting method he did.
Your best bet is to use the first equation and add a 9 period mav to it and
do a difference sort. This will show you stocks where the line is about to cross.
Thanks
|
|
Registered User
Joined: 11/13/2004
Posts: 121
|
If you chart out Tanstaafl's indicator and then overlay Craig's pcf as a Percent True indicator (a way to backtest in TC2005), I think you will see that the entry signals are not the same.
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
What do you mean?
If you plot this as a CUSTOM INDICATOR (be sure to check the CENTER ZERO LINE option)
(C*V+ C1*V1+ C2*V2+ C3*V3+ C4*V4+ C5*V5+ C6*V6+ C7*V7+ C8*V8+ C9*V9+ C10*V10+ C11*V11) * (1/12/AvgV12 -1/26/AvgV26) - (C12*V12+ C13*V13+ C14*V14+ C15*V15+ C16*V16+ C17*V17+ C18*V18+ C19*V19+ C20*V20+ C21*V21+ C22*V22+ C23*V23+ C24*V24+ C25*V25) /26 /AvgV26
And this as a Custom Percent TRUE:
((C*V+ C1*V1+ C2*V2+ C3*V3+ C4*V4+ C5*V5+ C6*V6+ C7*V7+ C8*V8+ C9*V9+ C10*V10+ C11*V11) * (1/12/AvgV12 -1/26/AvgV26) - (C12*V12+ C13*V13+ C14*V14+ C15*V15+ C16*V16+ C17*V17+ C18*V18+ C19*V19+ C20*V20+ C21*V21+ C22*V22+ C23*V23+ C24*V24+ C25*V25) /26 /AvgV26)>0 AND ((C26*V26+ C1*V1+ C2*V2+ C3*V3+ C4*V4+ C5*V5+ C6*V6+ C7*V7+ C8*V8+ C9*V9+ C10*V10+ C11*V11) * (1/12/AvgV12 -1/26/AvgV26.1) - (C12*V12+ C13*V13+ C14*V14+ C15*V15+ C16*V16+ C17*V17+ C18*V18+ C19*V19+ C20*V20+ C21*V21+ C22*V22+ C23*V23+ C24*V24+ C25*V25) /26 /AvgV26.1)
I think you will find they match up (one spikes to 100 when the other is above zero.)
- Craig
Here to Help!
|
|
Registered User
Joined: 1/28/2005
Posts: 6,049
|
Quote;"If you chart out Tanstaafl's indicator and then overlay Craig's pcf as a Percent True indicator (a way to backtest in TC2005), I think you will see that the entry signals are not the same."
That is what I looked at.
You may not have the "center zero line"
checked.
Thanks
|
|
Registered User
Joined: 11/13/2004
Posts: 121
|
I see now that the custom indicator and the VWMACD match up. Thank you. What did you mean by the pcf in the Worden Report was more of a "PROC?" Is there a way to write a pcf for a VWMACD crossing its 9 ema signal line below zero?
QUOTE (gsn) Thank you for your pcf. I compared the entry and exit signals it gives (using a Percent True custom indicator) to the VMACD setup with 9-day ema in the Worden Report. It gives very different signals. Dumb question, but you said the pcf in the report was more of a "PROC." Do you mean price rate-of-change? It isn't really a true VMACD then? And the one you have presented is? I don't want to start an idealogical argument going :) I just need to understand better. Is there a way to write a pcf for a VMACD crossing its 9 ema signal line? Also, is there a way to create a VMACD line and its signal line in TC2005 so I can view it line I would a regular MACD? I know I am loaded with questions here, but John Bollinger talks alot about VMACD but I can find little in the literature on how to create one, both with pcf signals and as an indicator to view on a chart... Thanks for any help.
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
PROC is price rate of change. No real meaning other than it looked more like a rate of change with price and volume to me than a MACD (which is the difference between two price moving averages)?
Create and EasyScan and include this PCF:
(C*V+ C1*V1+ C2*V2+ C3*V3+ C4*V4+ C5*V5+ C6*V6+ C7*V7+ C8*V8+ C9*V9+ C10*V10+ C11*V11) * (1/12/AvgV12 -1/26/AvgV26) - (C12*V12+ C13*V13+ C14*V14+ C15*V15+ C16*V16+ C17*V17+ C18*V18+ C19*V19+ C20*V20+ C21*V21+ C22*V22+ C23*V23+ C24*V24+ C25*V25) /26 /AvgV26
Set the VALUE limit to MIN to less than zero.
Then do a VISUAL DIFFERENCE sort of the results by comparing the plotted indicator to the plotted 9ema of itself. You will concentrate on the stocks with a visual difference close to zero.
Here is a video on visual diffference sorting: Comparing indicators using Visual Difference sorts
For the PCF you would need to replace the C below with the PCF going back days as needed:
Here is a template for a 9ema (with 95% accuracy)
0.209200746115747 *
(C + 8 / 10 *
(C1 + 8 / 10 *
(C2 + 8 / 10 *
(C3 + 8 / 10 *
(C4 + 8 / 10 *
(C5 + 8 / 10 *
(C6 + 8 / 10 *
(C7 + 8 / 10 *
(C8 + 8 / 10 *
(C9 + 8 / 10 *
(C10 + 8 / 10 *
(C11 + 8 / 10 *
(C12 + 8 / 10 *
(C13))))))))))))))
Replace C with:
((C*V+ C1*V1+ C2*V2+ C3*V3+ C4*V4+ C5*V5+ C6*V6+ C7*V7+ C8*V8+ C9*V9+ C10*V10+ C11*V11) * (1/12/AvgV12 -1/26/AvgV26) - (C12*V12+ C13*V13+ C14*V14+ C15*V15+ C16*V16+ C17*V17+ C18*V18+ C19*V19+ C20*V20+ C21*V21+ C22*V22+ C23*V23+ C24*V24+ C25*V25) /26 /AvgV26)
you would then set each term back one day and replace the C1 in the ema formula with:
((C1*V1+ C2*V2+ C3*V3+ C4*V4+ C5*V5+ C6*V6+ C7*V7+ C8*V8+ C9*V9+ C10*V10+ C11*V11+ C12*V12) * (1/12/AvgV12.1 -1/26/AvgV26.1) - (C13*V13+ C14*V14+ C15*V15+ C16*V16+ C17*V17+ C18*V18+ C19*V19+ C20*V20+ C21*V21+ C22*V22+ C23*V23+ C24*V24+ C25*V25+ C26*V26) /26 /AvgV26.1)
The monster PCF you would end up with would be a very close approximation of the 9ema of the original formula. You could then write a PCF that has it below the original formula yesterday but above it today.
It can be done, if you want to take the time. Personally, I think doing a visual difference sort of the EasyScan I mentioned above would be easier.
- Craig
Here to Help!
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
gsn,
The following formula does appear to be a Simple Volume Weighted MACD (12,26):
(C * V + C1 * V1 + C2 * V2 + C3 * V3 + C4 * V4 + C5 * V5 + C6 * V6 + C7 * V7 + C8 * V8 + C9 * V9 + C10 * V10 + C11 * V11) * (1 / 12 / AVGV12 - 1 / 26 / AVGV26) - (C12 * V12 + C13 * V13 + C14 * V14 + C15 * V15 + C16 * V16 + C17 * V17 + C18 * V18 + C19 * V19 + C20 * V20 + C21 * V21 + C22 * V22 + C23 * V23 + C24 * V24 + C25 * V25) / 26 / AVGV26
Considering the fact that the Trigger line is an Exponential Moving Average, I would have thought the raw MACD would be an Exponential Volume Weighted MACD (12,26), but, unlike Tanstaafl, I haven't read Bollinger's book (so while his formula is probably the correct one, I'm providing an Exponential version):
(.153984303064341 * (C * V + 11 / 13 * (C1 * V1 + 11 / 13 * (C2 * V2 + 11 / 13 * (C3 * V3 + 11 / 13 * (C4 * V4 + 11 / 13 * (C5 * V5 + 11 / 13 * (C6 * V6 + 11 / 13 * (C7 * V7 + 11 / 13 * (C8 * V8 + 11 / 13 * (C9 * V9 + 11 / 13 * (C10 * V10 + 11 / 13 * (C11 * V11 + 11 / 13 * (C12 * V12 + 11 / 13 * (C13 * V13 + 11 / 13 * (C14 * V14 + 11 / 13 * (C15 * V15 + 11 / 13 * (C16 * V16 + 11 / 13 * (C17 * V17 + 11 / 13 * (C18 * V18 + 11 / 13 * (C19 * V19 + 11 / 13 * (C20 * V20 + 11 / 13 * (C21 * V21 + 11 / 13 * (C22 * V22 + 11 / 13 * (C23 * V23 + 11 / 13 * (C24 * V24 + 11 / 13 * (C25 * V25 + 11 / 13 * (C26 * V26 + 11 / 13 * (C27 * V27 + 11 / 13 * (C28 * V28 + 11 / 13 * (C29 * V29 + 11 / 13 * (C30 * V30 + 11 / 13 * (C31 * V31 + 11 / 13 * (C32 * V32 + 11 / 13 * (C33 * V33 + 11 / 13 * (C34 * V34 + 11 / 13 * (C35 * V35 + 11 / 13 * (C36 * V36 + 11 / 13 * (C37 * V37 + 11 / 13 * (C38 * V38 + 11 / 13 * (C39 * V39 + 11 / 13 * (C40 * V40 + 11 / 13 * (C41 * V41)))))))))))))))))))))))))))))))))))))))))) * XAVGV26 - .0741468444601841 * (C * V + 25 / 27 * (C1 * V1 + 25 / 27 * (C2 * V2 + 25 / 27 * (C3 * V3 + 25 / 27 * (C4 * V4 + 25 / 27 * (C5 * V5 + 25 / 27 * (C6 * V6 + 25 / 27 * (C7 * V7 + 25 / 27 * (C8 * V8 + 25 / 27 * (C9 * V9 + 25 / 27 * (C10 * V10 + 25 / 27 * (C11 * V11 + 25 / 27 * (C12 * V12 + 25 / 27 * (C13 * V13 + 25 / 27 * (C14 * V14 + 25 / 27 * (C15 * V15 + 25 / 27 * (C16 * V16 + 25 / 27 * (C17 * V17 + 25 / 27 * (C18 * V18 + 25 / 27 * (C19 * V19 + 25 / 27 * (C20 * V20 + 25 / 27 * (C21 * V21 + 25 / 27 * (C22 * V22 + 25 / 27 * (C23 * V23 + 25 / 27 * (C24 * V24 + 25 / 27 * (C25 * V25 + 25 / 27 * (C26 * V26 + 25 / 27 * (C27 * V27 + 25 / 27 * (C28 * V28 + 25 / 27 * (C29 * V29 + 25 / 27 * (C30 * V30 + 25 / 27 * (C31 * V31 + 25 / 27 * (C32 * V32 + 25 / 27 * (C33 * V33 + 25 / 27 * (C34 * V34 + 25 / 27 * (C35 * V35 + 25 / 27 * (C36 * V36 + 25 / 27 * (C37 * V37 + 25 / 27 * (C38 * V38 + 25 / 27 * (C39 * V39 + 25 / 27 * (C40 * V40 + 25 / 27 * (C41 * V41 + 25 / 27 * (C42 * V42 + 25 / 27 * (C43 * V43 + 25 / 27 * (C44 * V44 + 25 / 27 * (C45 * V45 + 25 / 27 * (C46 * V46 + 25 / 27 * (C47 * V47 + 25 / 27 * (C48 * V48 + 25 / 27 * (C49 * V49 + 25 / 27 * (C50 * V50 + 25 / 27 * (C51 * V51 + 25 / 27 * (C52 * V52 + 25 / 27 * (C53 * V53 + 25 / 27 * (C54 * V54 + 25 / 27 * (C55 * V55 + 25 / 27 * (C56 * V56 + 25 / 27 * (C57 * V57 + 25 / 27 * (C58 * V58 + 25 / 27 * (C59 * V59 + 25 / 27 * (C60 * V60 + 25 / 27 * (C61 * V61 + 25 / 27 * (C62 * V62 + 25 / 27 * (C63 * V63 + 25 / 27 * (C64 * V64 + 25 / 27 * (C65 * V65 + 25 / 27 * (C66 * V66 + 25 / 27 * (C67 * V67 + 25 / 27 * (C68 * V68 + 25 / 27 * (C69 * V69 + 25 / 27 * (C70 * V70 + 25 / 27 * (C71 * V71 + 25 / 27 * (C72 * V72 + 25 / 27 * (C73 * V73 + 25 / 27 * (C74 * V74 + 25 / 27 * (C75 * V75 + 25 / 27 * (C76 * V76 + 25 / 27 * (C77 * V77 + 25 / 27 * (C78 * V78 + 25 / 27 * (C79 * V79 + 25 / 27 * (C80 * V80 + 25 / 27 * (C81 * V81 + 25 / 27 * (C82 * V82 + 25 / 27 * (C83 * V83 + 25 / 27 * (C84 * V84 + 25 / 27 * (C85 * V85 + 25 / 27 * (C86 * V86 + 25 / 27 * (C87 * V87 + 25 / 27 * (C88 * V88 + 25 / 27 * (C89 * V89)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) * XAVGV12) / XAVGV12 / XAVGV26
In either case, the Indicator Sort method outlined by Tanstaafl in the Friday, August 6, 2004 Worden Report is an effective method of detecting crossovers. I have been trying to create a Personal Criteria Formula based solution, but the results so far have not been particularly practical when attempting to create reasonably accurate approximations of a 9-Period EMA.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 1/1/2005
Posts: 2,645
|
Craig,
I have just read this thread and believe you may have some unintended statements and errors.
QUOTE (Craig_S) What do you mean?
If you plot this as a CUSTOM INDICATOR (be sure to check the CENTER ZERO LINE option)
(C*V+ C1*V1+ C2*V2+ C3*V3+ C4*V4+ C5*V5+ C6*V6+ C7*V7+ C8*V8+ C9*V9+ C10*V10+ C11*V11) * (1/12/AvgV12 -1/26/AvgV26) - (C12*V12+ C13*V13+ C14*V14+ C15*V15+ C16*V16+ C17*V17+ C18*V18+ C19*V19+ C20*V20+ C21*V21+ C22*V22+ C23*V23+ C24*V24+ C25*V25) /26 /AvgV26
And this as a Custom Percent TRUE:
((C*V+ C1*V1+ C2*V2+ C3*V3+ C4*V4+ C5*V5+ C6*V6+ C7*V7+ C8*V8+ C9*V9+ C10*V10+ C11*V11) * (1/12/AvgV12 -1/26/AvgV26) - (C12*V12+ C13*V13+ C14*V14+ C15*V15+ C16*V16+ C17*V17+ C18*V18+ C19*V19+ C20*V20+ C21*V21+ C22*V22+ C23*V23+ C24*V24+ C25*V25) /26 /AvgV26)>0 AND ((C26*V26+ C1*V1+ C2*V2+ C3*V3+ C4*V4+ C5*V5+ C6*V6+ C7*V7+ C8*V8+ C9*V9+ C10*V10+ C11*V11) * (1/12/AvgV12 -1/26/AvgV26.1) - (C12*V12+ C13*V13+ C14*V14+ C15*V15+ C16*V16+ C17*V17+ C18*V18+ C19*V19+ C20*V20+ C21*V21+ C22*V22+ C23*V23+ C24*V24+ C25*V25) /26 /AvgV26.1)
I think you will find they match up (one spikes to 100 when the other is above zero.)
The second PCF should read:
((C*V+ C1*V1+ C2*V2+ C3*V3+ C4*V4+ C5*V5+ C6*V6+ C7*V7+ C8*V8+ C9*V9+ C10*V10+ C11*V11) * (1/12/AvgV12 -1/26/AvgV26) - (C12*V12+ C13*V13+ C14*V14+ C15*V15+ C16*V16+ C17*V17+ C18*V18+ C19*V19+ C20*V20+ C21*V21+ C22*V22+ C23*V23+ C24*V24+ C25*V25) /26 /AvgV26)>0 AND ((C1*V1+ C2*V2+ C3*V3+ C4*V4+ C5*V5+ C6*V6+ C7*V7+ C8*V8+ C9*V9+ C10*V10+ C11*V11+ C12*V12) * (1/12/AvgV12.1 -1/26/AvgV26.1) - (C13*V13+ C14*V14+ C15*V15+ C16*V16+ C17*V17+ C18*V18+ C19*V19+ C20*V20+ C21*V21+ C22*V22+ C23*V23+ C24*V24+ C25*V25+ C26*V26) /26 /AvgV26.1)<=0
The incorrect PCF appears in two places.
QUOTE (Craig_S) PROC is price rate of change. No real meaning other than it looked more like a rate of change with price and volume to me than a MACD (which is the difference between two price moving averages)?
The PCF is the difference between the two VWMAs of price with like terms of the form Ck*Vk combined.
QUOTE (Craig_S) Create and EasyScan and include this PCF:
(C*V+ C1*V1+ C2*V2+ C3*V3+ C4*V4+ C5*V5+ C6*V6+ C7*V7+ C8*V8+ C9*V9+ C10*V10+ C11*V11) * (1/12/AvgV12 -1/26/AvgV26) - (C12*V12+ C13*V13+ C14*V14+ C15*V15+ C16*V16+ C17*V17+ C18*V18+ C19*V19+ C20*V20+ C21*V21+ C22*V22+ C23*V23+ C24*V24+ C25*V25) /26 /AvgV26
Set the VALUE limit to MIN to less than zero.
Then do a VISUAL DIFFERENCE sort of the results by comparing the plotted indicator to the plotted 9ema of itself. You will concentrate on the stocks with a visual difference close to zero.
The requirement in the Worden Report was to find items for which the VWMACD Histogram upcrossed zero. The EasyScan eliminates the items for which the VWMACD Line is above zero regardless of whether the VWMACD Histogram upcrossed zero. I doubt that was your intention.
Your comments will be appreciated.
Thanks,
Jim Murphy
|
|
 Platinum Customer
Joined: 1/5/2005
Posts: 4
|
Bruce or Craig,
I have been using the following formula provided by Bruce (Wednesday, July 05, 2006 2:18:43 PM) because the indicator is timelier than the original formula provided by Tanstaafl. However, I would like to use a PCF and Scan with either a 9 day SMA or EMA, but need some guidance with the formula. To determine the crossover of the 9 day SMA or EMA, I would need to calculate the SMA or EMA for the past 10 days. I will assume the calculation for the 9 day simple ma is much simpler than the 9 day exponential ma, so I would be thrilled if you can provide the formula for the indicator value for the prior day, and I would expect that I can then calculate the indicator for the prior days.
I am not clear as to whether I should I be using the .153984303064341 and the .0741468444601841 decimal amounts or a different decimal amounts? Should I be multiplying by 11/13, and continue calculations through 41 days, and multiply by the 26 day exponential volume?
In the second part of the calculation should the calculation remain 25/27, and continue the calculation through 89 days? And what would the exponential calculation at the end be?
Your assistance is greatly appreciated.
Michael
(.153984303064341 * (C * V + 11 / 13 * (C1 * V1 + 11 / 13 * (C2 * V2 + 11 / 13 * (C3 * V3 + 11 / 13 * (C4 * V4 + 11 / 13 * (C5 * V5 + 11 / 13 * (C6 * V6 + 11 / 13 * (C7 * V7 + 11 / 13 * (C8 * V8 + 11 / 13 * (C9 * V9 + 11 / 13 * (C10 * V10 + 11 / 13 * (C11 * V11 + 11 / 13 * (C12 * V12 + 11 / 13 * (C13 * V13 + 11 / 13 * (C14 * V14 + 11 / 13 * (C15 * V15 + 11 / 13 * (C16 * V16 + 11 / 13 * (C17 * V17 + 11 / 13 * (C18 * V18 + 11 / 13 * (C19 * V19 + 11 / 13 * (C20 * V20 + 11 / 13 * (C21 * V21 + 11 / 13 * (C22 * V22 + 11 / 13 * (C23 * V23 + 11 / 13 * (C24 * V24 + 11 / 13 * (C25 * V25 + 11 / 13 * (C26 * V26 + 11 / 13 * (C27 * V27 + 11 / 13 * (C28 * V28 + 11 / 13 * (C29 * V29 + 11 / 13 * (C30 * V30 + 11 / 13 * (C31 * V31 + 11 / 13 * (C32 * V32 + 11 / 13 * (C33 * V33 + 11 / 13 * (C34 * V34 + 11 / 13 * (C35 * V35 + 11 / 13 * (C36 * V36 + 11 / 13 * (C37 * V37 + 11 / 13 * (C38 * V38 + 11 / 13 * (C39 * V39 + 11 / 13 * (C40 * V40 + 11 / 13 * (C41 * V41)))))))))))))))))))))))))))))))))))))))))) * XAVGV26 -
.0741468444601841 * (C * V + 25 / 27 * (C1 * V1 + 25 / 27 * (C2 * V2 + 25 / 27 * (C3 * V3 + 25 / 27 * (C4 * V4 + 25 / 27 * (C5 * V5 + 25 / 27 * (C6 * V6 + 25 / 27 * (C7 * V7 + 25 / 27 * (C8 * V8 + 25 / 27 * (C9 * V9 + 25 / 27 * (C10 * V10 + 25 / 27 * (C11 * V11 + 25 / 27 * (C12 * V12 + 25 / 27 * (C13 * V13 + 25 / 27 * (C14 * V14 + 25 / 27 * (C15 * V15 + 25 / 27 * (C16 * V16 + 25 / 27 * (C17 * V17 + 25 / 27 * (C18 * V18 + 25 / 27 * (C19 * V19 + 25 / 27 * (C20 * V20 + 25 / 27 * (C21 * V21 + 25 / 27 * (C22 * V22 + 25 / 27 * (C23 * V23 + 25 / 27 * (C24 * V24 + 25 / 27 * (C25 * V25 + 25 / 27 * (C26 * V26 + 25 / 27 * (C27 * V27 + 25 / 27 * (C28 * V28 + 25 / 27 * (C29 * V29 + 25 / 27 * (C30 * V30 + 25 / 27 * (C31 * V31 + 25 / 27 * (C32 * V32 + 25 / 27 * (C33 * V33 + 25 / 27 * (C34 * V34 + 25 / 27 * (C35 * V35 + 25 / 27 * (C36 * V36 + 25 / 27 * (C37 * V37 + 25 / 27 * (C38 * V38 + 25 / 27 * (C39 * V39 + 25 / 27 * (C40 * V40 + 25 / 27 * (C41 * V41 + 25 / 27 * (C42 * V42 + 25 / 27 * (C43 * V43 + 25 / 27 * (C44 * V44 + 25 / 27 * (C45 * V45 + 25 / 27 * (C46 * V46 + 25 / 27 * (C47 * V47 + 25 / 27 * (C48 * V48 + 25 / 27 * (C49 * V49 + 25 / 27 * (C50 * V50 + 25 / 27 * (C51 * V51 + 25 / 27 * (C52 * V52 + 25 / 27 * (C53 * V53 + 25 / 27 * (C54 * V54 + 25 / 27 * (C55 * V55 + 25 / 27 * (C56 * V56 + 25 / 27 * (C57 * V57 + 25 / 27 * (C58 * V58 + 25 / 27 * (C59 * V59 + 25 / 27 * (C60 * V60 + 25 / 27 * (C61 * V61 + 25 / 27 * (C62 * V62 + 25 / 27 * (C63 * V63 + 25 / 27 * (C64 * V64 + 25 / 27 * (C65 * V65 + 25 / 27 * (C66 * V66 + 25 / 27 * (C67 * V67 + 25 / 27 * (C68 * V68 + 25 / 27 * (C69 * V69 + 25 / 27 * (C70 * V70 + 25 / 27 * (C71 * V71 + 25 / 27 * (C72 * V72 + 25 / 27 * (C73 * V73 + 25 / 27 * (C74 * V74 + 25 / 27 * (C75 * V75 + 25 / 27 * (C76 * V76 + 25 / 27 * (C77 * V77 + 25 / 27 * (C78 * V78 + 25 / 27 * (C79 * V79 + 25 / 27 * (C80 * V80 + 25 / 27 * (C81 * V81 + 25 / 27 * (C82 * V82 + 25 / 27 * (C83 * V83 + 25 / 27 * (C84 * V84 + 25 / 27 * (C85 * V85 + 25 / 27 * (C86 * V86 + 25 / 27 * (C87 * V87 + 25 / 27 * (C88 * V88 + 25 / 27 * (C89 * V89)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) * XAVGV12) / XAVGV12 / XAVGV26
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
allstravel,
One way to write a formula for a 9-Period Simple Moving Average of the Volume Weighted Exponential MACD 12,26 would be:
((.153984303064341 * (C * V + 11 / 13 * (C1 * C1 + 11 / 13 * (C2 * C2 + 11 / 13 * (C3 * C3 + 11 / 13 * (C4 * C4 + 11 / 13 * (C5 * C5 + 11 / 13 * (C6 * C6 + 11 / 13 * (C7 * C7 + 11 / 13 * (C8 * C8 + 11 / 13 * (C9 * C9 + 11 / 13 * (C10 * C10 + 11 / 13 * (C11 * C11 + 11 / 13 * (C12 * C12 + 11 / 13 * (C13 * C13 + 11 / 13 * (C14 * C14 + 11 / 13 * (C15 * C15 + 11 / 13 * (C16 * C16 + 11 / 13 * (C17 * C17 + 11 / 13 * (C18 * C18 + 11 / 13 * (C19 * C19 + 11 / 13 * (C20 * C20 + 11 / 13 * (C21 * C21 + 11 / 13 * (C22 * C22 + 11 / 13 * (C23 * C23 + 11 / 13 * (C24 * C24 + 11 / 13 * (C25 * C25 + 11 / 13 * (C26 * C26 + 11 / 13 * (C27 * C27 + 11 / 13 * (C28 * C28 + 11 / 13 * (C29 * C29 + 11 / 13 * (C30 * C30 + 11 / 13 * (C31 * C31 + 11 / 13 * (C32 * C32 + 11 / 13 * (C33 * C33 + 11 / 13 * (C34 * C34 + 11 / 13 * (C35 * C35 + 11 / 13 * (C36 * C36 + 11 / 13 * (C37 * C37 + 11 / 13 * (C38 * C38 + 11 / 13 * (C39 * C39 + 11 / 13 * (C40 * C40 + 11 / 13 * (C41 * C41)))))))))))))))))))))))))))))))))))))))))) * XAVGV26 - .0741468444601841 * (C * V + 25 / 27 * (C1 * C1 + 25 / 27 * (C2 * C2 + 25 / 27 * (C3 * C3 + 25 / 27 * (C4 * C4 + 25 / 27 * (C5 * C5 + 25 / 27 * (C6 * C6 + 25 / 27 * (C7 * C7 + 25 / 27 * (C8 * C8 + 25 / 27 * (C9 * C9 + 25 / 27 * (C10 * C10 + 25 / 27 * (C11 * C11 + 25 / 27 * (C12 * C12 + 25 / 27 * (C13 * C13 + 25 / 27 * (C14 * C14 + 25 / 27 * (C15 * C15 + 25 / 27 * (C16 * C16 + 25 / 27 * (C17 * C17 + 25 / 27 * (C18 * C18 + 25 / 27 * (C19 * C19 + 25 / 27 * (C20 * C20 + 25 / 27 * (C21 * C21 + 25 / 27 * (C22 * C22 + 25 / 27 * (C23 * C23 + 25 / 27 * (C24 * C24 + 25 / 27 * (C25 * C25 + 25 / 27 * (C26 * C26 + 25 / 27 * (C27 * C27 + 25 / 27 * (C28 * C28 + 25 / 27 * (C29 * C29 + 25 / 27 * (C30 * C30 + 25 / 27 * (C31 * C31 + 25 / 27 * (C32 * C32 + 25 / 27 * (C33 * C33 + 25 / 27 * (C34 * C34 + 25 / 27 * (C35 * C35 + 25 / 27 * (C36 * C36 + 25 / 27 * (C37 * C37 + 25 / 27 * (C38 * C38 + 25 / 27 * (C39 * C39 + 25 / 27 * (C40 * C40 + 25 / 27 * (C41 * C41 + 25 / 27 * (C42 * C42 + 25 / 27 * (C43 * C43 + 25 / 27 * (C44 * C44 + 25 / 27 * (C45 * C45 + 25 / 27 * (C46 * C46 + 25 / 27 * (C47 * C47 + 25 / 27 * (C48 * C48 + 25 / 27 * (C49 * C49 + 25 / 27 * (C50 * C50 + 25 / 27 * (C51 * C51 + 25 / 27 * (C52 * C52 + 25 / 27 * (C53 * C53 + 25 / 27 * (C54 * C54 + 25 / 27 * (C55 * C55 + 25 / 27 * (C56 * C56 + 25 / 27 * (C57 * C57 + 25 / 27 * (C58 * C58 + 25 / 27 * (C59 * C59 + 25 / 27 * (C60 * C60 + 25 / 27 * (C61 * C61 + 25 / 27 * (C62 * C62 + 25 / 27 * (C63 * C63 + 25 / 27 * (C64 * C64 + 25 / 27 * (C65 * C65 + 25 / 27 * (C66 * C66 + 25 / 27 * (C67 * C67 + 25 / 27 * (C68 * C68 + 25 / 27 * (C69 * C69 + 25 / 27 * (C70 * C70 + 25 / 27 * (C71 * C71 + 25 / 27 * (C72 * C72 + 25 / 27 * (C73 * C73 + 25 / 27 * (C74 * C74 + 25 / 27 * (C75 * C75 + 25 / 27 * (C76 * C76 + 25 / 27 * (C77 * C77 + 25 / 27 * (C78 * C78 + 25 / 27 * (C79 * C79 + 25 / 27 * (C80 * C80 + 25 / 27 * (C81 * C81 + 25 / 27 * (C82 * C82 + 25 / 27 * (C83 * C83 + 25 / 27 * (C84 * C84 + 25 / 27 * (C85 * C85 + 25 / 27 * (C86 * C86 + 25 / 27 * (C87 * C87 + 25 / 27 * (C88 * C88 + 25 / 27 * (C89 * C89)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) * XAVGV12) / XAVGV12 / XAVGV26 + (.153984303064341 * (C1 * V1 + 11 / 13 * (C2 * C2 + 11 / 13 * (C3 * C3 + 11 / 13 * (C4 * C4 + 11 / 13 * (C5 * C5 + 11 / 13 * (C6 * C6 + 11 / 13 * (C7 * C7 + 11 / 13 * (C8 * C8 + 11 / 13 * (C9 * C9 + 11 / 13 * (C10 * C10 + 11 / 13 * (C11 * C11 + 11 / 13 * (C12 * C12 + 11 / 13 * (C13 * C13 + 11 / 13 * (C14 * C14 + 11 / 13 * (C15 * C15 + 11 / 13 * (C16 * C16 + 11 / 13 * (C17 * C17 + 11 / 13 * (C18 * C18 + 11 / 13 * (C19 * C19 + 11 / 13 * (C20 * C20 + 11 / 13 * (C21 * C21 + 11 / 13 * (C22 * C22 + 11 / 13 * (C23 * C23 + 11 / 13 * (C24 * C24 + 11 / 13 * (C25 * C25 + 11 / 13 * (C26 * C26 + 11 / 13 * (C27 * C27 + 11 / 13 * (C28 * C28 + 11 / 13 * (C29 * C29 + 11 / 13 * (C30 * C30 + 11 / 13 * (C31 * C31 + 11 / 13 * (C32 * C32 + 11 / 13 * (C33 * C33 + 11 / 13 * (C34 * C34 + 11 / 13 * (C35 * C35 + 11 / 13 * (C36 * C36 + 11 / 13 * (C37 * C37 + 11 / 13 * (C38 * C38 + 11 / 13 * (C39 * C39 + 11 / 13 * (C40 * C40 + 11 / 13 * (C41 * C41 + 11 / 13 * (C42 * C42)))))))))))))))))))))))))))))))))))))))))) * XAVGV26.1 - .0741468444601841 * (C1 * V1 + 25 / 27 * (C2 * C2 + 25 / 27 * (C3 * C3 + 25 / 27 * (C4 * C4 + 25 / 27 * (C5 * C5 + 25 / 27 * (C6 * C6 + 25 / 27 * (C7 * C7 + 25 / 27 * (C8 * C8 + 25 / 27 * (C9 * C9 + 25 / 27 * (C10 * C10 + 25 / 27 * (C11 * C11 + 25 / 27 * (C12 * C12 + 25 / 27 * (C13 * C13 + 25 / 27 * (C14 * C14 + 25 / 27 * (C15 * C15 + 25 / 27 * (C16 * C16 + 25 / 27 * (C17 * C17 + 25 / 27 * (C18 * C18 + 25 / 27 * (C19 * C19 + 25 / 27 * (C20 * C20 + 25 / 27 * (C21 * C21 + 25 / 27 * (C22 * C22 + 25 / 27 * (C23 * C23 + 25 / 27 * (C24 * C24 + 25 / 27 * (C25 * C25 + 25 / 27 * (C26 * C26 + 25 / 27 * (C27 * C27 + 25 / 27 * (C28 * C28 + 25 / 27 * (C29 * C29 + 25 / 27 * (C30 * C30 + 25 / 27 * (C31 * C31 + 25 / 27 * (C32 * C32 + 25 / 27 * (C33 * C33 + 25 / 27 * (C34 * C34 + 25 / 27 * (C35 * C35 + 25 / 27 * (C36 * C36 + 25 / 27 * (C37 * C37 + 25 / 27 * (C38 * C38 + 25 / 27 * (C39 * C39 + 25 / 27 * (C40 * C40 + 25 / 27 * (C41 * C41 + 25 / 27 * (C42 * C42 + 25 / 27 * (C43 * C43 + 25 / 27 * (C44 * C44 + 25 / 27 * (C45 * C45 + 25 / 27 * (C46 * C46 + 25 / 27 * (C47 * C47 + 25 / 27 * (C48 * C48 + 25 / 27 * (C49 * C49 + 25 / 27 * (C50 * C50 + 25 / 27 * (C51 * C51 + 25 / 27 * (C52 * C52 + 25 / 27 * (C53 * C53 + 25 / 27 * (C54 * C54 + 25 / 27 * (C55 * C55 + 25 / 27 * (C56 * C56 + 25 / 27 * (C57 * C57 + 25 / 27 * (C58 * C58 + 25 / 27 * (C59 * C59 + 25 / 27 * (C60 * C60 + 25 / 27 * (C61 * C61 + 25 / 27 * (C62 * C62 + 25 / 27 * (C63 * C63 + 25 / 27 * (C64 * C64 + 25 / 27 * (C65 * C65 + 25 / 27 * (C66 * C66 + 25 / 27 * (C67 * C67 + 25 / 27 * (C68 * C68 + 25 / 27 * (C69 * C69 + 25 / 27 * (C70 * C70 + 25 / 27 * (C71 * C71 + 25 / 27 * (C72 * C72 + 25 / 27 * (C73 * C73 + 25 / 27 * (C74 * C74 + 25 / 27 * (C75 * C75 + 25 / 27 * (C76 * C76 + 25 / 27 * (C77 * C77 + 25 / 27 * (C78 * C78 + 25 / 27 * (C79 * C79 + 25 / 27 * (C80 * C80 + 25 / 27 * (C81 * C81 + 25 / 27 * (C82 * C82 + 25 / 27 * (C83 * C83 + 25 / 27 * (C84 * C84 + 25 / 27 * (C85 * C85 + 25 / 27 * (C86 * C86 + 25 / 27 * (C87 * C87 + 25 / 27 * (C88 * C88 + 25 / 27 * (C89 * C89 + 25 / 27 * (C90 * C90)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) * XAVGV12.1) / XAVGV12.1 / XAVGV26.1 + (.153984303064341 * (C2 * V2 + 11 / 13 * (C3 * C3 + 11 / 13 * (C4 * C4 + 11 / 13 * (C5 * C5 + 11 / 13 * (C6 * C6 + 11 / 13 * (C7 * C7 + 11 / 13 * (C8 * C8 + 11 / 13 * (C9 * C9 + 11 / 13 * (C10 * C10 + 11 / 13 * (C11 * C11 + 11 / 13 * (C12 * C12 + 11 / 13 * (C13 * C13 + 11 / 13 * (C14 * C14 + 11 / 13 * (C15 * C15 + 11 / 13 * (C16 * C16 + 11 / 13 * (C17 * C17 + 11 / 13 * (C18 * C18 + 11 / 13 * (C19 * C19 + 11 / 13 * (C20 * C20 + 11 / 13 * (C21 * C21 + 11 / 13 * (C22 * C22 + 11 / 13 * (C23 * C23 + 11 / 13 * (C24 * C24 + 11 / 13 * (C25 * C25 + 11 / 13 * (C26 * C26 + 11 / 13 * (C27 * C27 + 11 / 13 * (C28 * C28 + 11 / 13 * (C29 * C29 + 11 / 13 * (C30 * C30 + 11 / 13 * (C31 * C31 + 11 / 13 * (C32 * C32 + 11 / 13 * (C33 * C33 + 11 / 13 * (C34 * C34 + 11 / 13 * (C35 * C35 + 11 / 13 * (C36 * C36 + 11 / 13 * (C37 * C37 + 11 / 13 * (C38 * C38 + 11 / 13 * (C39 * C39 + 11 / 13 * (C40 * C40 + 11 / 13 * (C41 * C41 + 11 / 13 * (C42 * C42 + 11 / 13 * (C43 * C43)))))))))))))))))))))))))))))))))))))))))) * XAVGV26.2 - .0741468444601841 * (C2 * V2 + 25 / 27 * (C3 * C3 + 25 / 27 * (C4 * C4 + 25 / 27 * (C5 * C5 + 25 / 27 * (C6 * C6 + 25 / 27 * (C7 * C7 + 25 / 27 * (C8 * C8 + 25 / 27 * (C9 * C9 + 25 / 27 * (C10 * C10 + 25 / 27 * (C11 * C11 + 25 / 27 * (C12 * C12 + 25 / 27 * (C13 * C13 + 25 / 27 * (C14 * C14 + 25 / 27 * (C15 * C15 + 25 / 27 * (C16 * C16 + 25 / 27 * (C17 * C17 + 25 / 27 * (C18 * C18 + 25 / 27 * (C19 * C19 + 25 / 27 * (C20 * C20 + 25 / 27 * (C21 * C21 + 25 / 27 * (C22 * C22 + 25 / 27 * (C23 * C23 + 25 / 27 * (C24 * C24 + 25 / 27 * (C25 * C25 + 25 / 27 * (C26 * C26 + 25 / 27 * (C27 * C27 + 25 / 27 * (C28 * C28 + 25 / 27 * (C29 * C29 + 25 / 27 * (C30 * C30 + 25 / 27 * (C31 * C31 + 25 / 27 * (C32 * C32 + 25 / 27 * (C33 * C33 + 25 / 27 * (C34 * C34 + 25 / 27 * (C35 * C35 + 25 / 27 * (C36 * C36 + 25 / 27 * (C37 * C37 + 25 / 27 * (C38 * C38 + 25 / 27 * (C39 * C39 + 25 / 27 * (C40 * C40 + 25 / 27 * (C41 * C41 + 25 / 27 * (C42 * C42 + 25 / 27 * (C43 * C43 + 25 / 27 * (C44 * C44 + 25 / 27 * (C45 * C45 + 25 / 27 * (C46 * C46 + 25 / 27 * (C47 * C47 + 25 / 27 * (C48 * C48 + 25 / 27 * (C49 * C49 + 25 / 27 * (C50 * C50 + 25 / 27 * (C51 * C51 + 25 / 27 * (C52 * C52 + 25 / 27 * (C53 * C53 + 25 / 27 * (C54 * C54 + 25 / 27 * (C55 * C55 + 25 / 27 * (C56 * C56 + 25 / 27 * (C57 * C57 + 25 / 27 * (C58 * C58 + 25 / 27 * (C59 * C59 + 25 / 27 * (C60 * C60 + 25 / 27 * (C61 * C61 + 25 / 27 * (C62 * C62 + 25 / 27 * (C63 * C63 + 25 / 27 * (C64 * C64 + 25 / 27 * (C65 * C65 + 25 / 27 * (C66 * C66 + 25 / 27 * (C67 * C67 + 25 / 27 * (C68 * C68 + 25 / 27 * (C69 * C69 + 25 / 27 * (C70 * C70 + 25 / 27 * (C71 * C71 + 25 / 27 * (C72 * C72 + 25 / 27 * (C73 * C73 + 25 / 27 * (C74 * C74 + 25 / 27 * (C75 * C75 + 25 / 27 * (C76 * C76 + 25 / 27 * (C77 * C77 + 25 / 27 * (C78 * C78 + 25 / 27 * (C79 * C79 + 25 / 27 * (C80 * C80 + 25 / 27 * (C81 * C81 + 25 / 27 * (C82 * C82 + 25 / 27 * (C83 * C83 + 25 / 27 * (C84 * C84 + 25 / 27 * (C85 * C85 + 25 / 27 * (C86 * C86 + 25 / 27 * (C87 * C87 + 25 / 27 * (C88 * C88 + 25 / 27 * (C89 * C89 + 25 / 27 * (C90 * C90 + 25 / 27 * (C91 * C91)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) * XAVGV12.2) / XAVGV12.2 / XAVGV26.2 + (.153984303064341 * (C3 * V3 + 11 / 13 * (C4 * C4 + 11 / 13 * (C5 * C5 + 11 / 13 * (C6 * C6 + 11 / 13 * (C7 * C7 + 11 / 13 * (C8 * C8 + 11 / 13 * (C9 * C9 + 11 / 13 * (C10 * C10 + 11 / 13 * (C11 * C11 + 11 / 13 * (C12 * C12 + 11 / 13 * (C13 * C13 + 11 / 13 * (C14 * C14 + 11 / 13 * (C15 * C15 + 11 / 13 * (C16 * C16 + 11 / 13 * (C17 * C17 + 11 / 13 * (C18 * C18 + 11 / 13 * (C19 * C19 + 11 / 13 * (C20 * C20 + 11 / 13 * (C21 * C21 + 11 / 13 * (C22 * C22 + 11 / 13 * (C23 * C23 + 11 / 13 * (C24 * C24 + 11 / 13 * (C25 * C25 + 11 / 13 * (C26 * C26 + 11 / 13 * (C27 * C27 + 11 / 13 * (C28 * C28 + 11 / 13 * (C29 * C29 + 11 / 13 * (C30 * C30 + 11 / 13 * (C31 * C31 + 11 / 13 * (C32 * C32 + 11 / 13 * (C33 * C33 + 11 / 13 * (C34 * C34 + 11 / 13 * (C35 * C35 + 11 / 13 * (C36 * C36 + 11 / 13 * (C37 * C37 + 11 / 13 * (C38 * C38 + 11 / 13 * (C39 * C39 + 11 / 13 * (C40 * C40 + 11 / 13 * (C41 * C41 + 11 / 13 * (C42 * C42 + 11 / 13 * (C43 * C43 + 11 / 13 * (C44 * C44)))))))))))))))))))))))))))))))))))))))))) * XAVGV26.3 - .0741468444601841 * (C3 * V3 + 25 / 27 * (C4 * C4 + 25 / 27 * (C5 * C5 + 25 / 27 * (C6 * C6 + 25 / 27 * (C7 * C7 + 25 / 27 * (C8 * C8 + 25 / 27 * (C9 * C9 + 25 / 27 * (C10 * C10 + 25 / 27 * (C11 * C11 + 25 / 27 * (C12 * C12 + 25 / 27 * (C13 * C13 + 25 / 27 * (C14 * C14 + 25 / 27 * (C15 * C15 + 25 / 27 * (C16 * C16 + 25 / 27 * (C17 * C17 + 25 / 27 * (C18 * C18 + 25 / 27 * (C19 * C19 + 25 / 27 * (C20 * C20 + 25 / 27 * (C21 * C21 + 25 / 27 * (C22 * C22 + 25 / 27 * (C23 * C23 + 25 / 27 * (C24 * C24 + 25 / 27 * (C25 * C25 + 25 / 27 * (C26 * C26 + 25 / 27 * (C27 * C27 + 25 / 27 * (C28 * C28 + 25 / 27 * (C29 * C29 + 25 / 27 * (C30 * C30 + 25 / 27 * (C31 * C31 + 25 / 27 * (C32 * C32 + 25 / 27 * (C33 * C33 + 25 / 27 * (C34 * C34 + 25 / 27 * (C35 * C35 + 25 / 27 * (C36 * C36 + 25 / 27 * (C37 * C37 + 25 / 27 * (C38 * C38 + 25 / 27 * (C39 * C39 + 25 / 27 * (C40 * C40 + 25 / 27 * (C41 * C41 + 25 / 27 * (C42 * C42 + 25 / 27 * (C43 * C43 + 25 / 27 * (C44 * C44 + 25 / 27 * (C45 * C45 + 25 / 27 * (C46 * C46 + 25 / 27 * (C47 * C47 + 25 / 27 * (C48 * C48 + 25 / 27 * (C49 * C49 + 25 / 27 * (C50 * C50 + 25 / 27 * (C51 * C51 + 25 / 27 * (C52 * C52 + 25 / 27 * (C53 * C53 + 25 / 27 * (C54 * C54 + 25 / 27 * (C55 * C55 + 25 / 27 * (C56 * C56 + 25 / 27 * (C57 * C57 + 25 / 27 * (C58 * C58 + 25 / 27 * (C59 * C59 + 25 / 27 * (C60 * C60 + 25 / 27 * (C61 * C61 + 25 / 27 * (C62 * C62 + 25 / 27 * (C63 * C63 + 25 / 27 * (C64 * C64 + 25 / 27 * (C65 * C65 + 25 / 27 * (C66 * C66 + 25 / 27 * (C67 * C67 + 25 / 27 * (C68 * C68 + 25 / 27 * (C69 * C69 + 25 / 27 * (C70 * C70 + 25 / 27 * (C71 * C71 + 25 / 27 * (C72 * C72 + 25 / 27 * (C73 * C73 + 25 / 27 * (C74 * C74 + 25 / 27 * (C75 * C75 + 25 / 27 * (C76 * C76 + 25 / 27 * (C77 * C77 + 25 / 27 * (C78 * C78 + 25 / 27 * (C79 * C79 + 25 / 27 * (C80 * C80 + 25 / 27 * (C81 * C81 + 25 / 27 * (C82 * C82 + 25 / 27 * (C83 * C83 + 25 / 27 * (C84 * C84 + 25 / 27 * (C85 * C85 + 25 / 27 * (C86 * C86 + 25 / 27 * (C87 * C87 + 25 / 27 * (C88 * C88 + 25 / 27 * (C89 * C89 + 25 / 27 * (C90 * C90 + 25 / 27 * (C91 * C91 + 25 / 27 * (C92 * C92)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) * XAVGV12.3) / XAVGV12.3 / XAVGV26.3 + (.153984303064341 * (C4 * V4 + 11 / 13 * (C5 * C5 + 11 / 13 * (C6 * C6 + 11 / 13 * (C7 * C7 + 11 / 13 * (C8 * C8 + 11 / 13 * (C9 * C9 + 11 / 13 * (C10 * C10 + 11 / 13 * (C11 * C11 + 11 / 13 * (C12 * C12 + 11 / 13 * (C13 * C13 + 11 / 13 * (C14 * C14 + 11 / 13 * (C15 * C15 + 11 / 13 * (C16 * C16 + 11 / 13 * (C17 * C17 + 11 / 13 * (C18 * C18 + 11 / 13 * (C19 * C19 + 11 / 13 * (C20 * C20 + 11 / 13 * (C21 * C21 + 11 / 13 * (C22 * C22 + 11 / 13 * (C23 * C23 + 11 / 13 * (C24 * C24 + 11 / 13 * (C25 * C25 + 11 / 13 * (C26 * C26 + 11 / 13 * (C27 * C27 + 11 / 13 * (C28 * C28 + 11 / 13 * (C29 * C29 + 11 / 13 * (C30 * C30 + 11 / 13 * (C31 * C31 + 11 / 13 * (C32 * C32 + 11 / 13 * (C33 * C33 + 11 / 13 * (C34 * C34 + 11 / 13 * (C35 * C35 + 11 / 13 * (C36 * C36 + 11 / 13 * (C37 * C37 + 11 / 13 * (C38 * C38 + 11 / 13 * (C39 * C39 + 11 / 13 * (C40 * C40 + 11 / 13 * (C41 * C41 + 11 / 13 * (C42 * C42 + 11 / 13 * (C43 * C43 + 11 / 13 * (C44 * C44 + 11 / 13 * (C45 * C45)))))))))))))))))))))))))))))))))))))))))) * XAVGV26.4 - .0741468444601841 * (C4 * V4 + 25 / 27 * (C5 * C5 + 25 / 27 * (C6 * C6 + 25 / 27 * (C7 * C7 + 25 / 27 * (C8 * C8 + 25 / 27 * (C9 * C9 + 25 / 27 * (C10 * C10 + 25 / 27 * (C11 * C11 + 25 / 27 * (C12 * C12 + 25 / 27 * (C13 * C13 + 25 / 27 * (C14 * C14 + 25 / 27 * (C15 * C15 + 25 / 27 * (C16 * C16 + 25 / 27 * (C17 * C17 + 25 / 27 * (C18 * C18 + 25 / 27 * (C19 * C19 + 25 / 27 * (C20 * C20 + 25 / 27 * (C21 * C21 + 25 / 27 * (C22 * C22 + 25 / 27 * (C23 * C23 + 25 / 27 * (C24 * C24 + 25 / 27 * (C25 * C25 + 25 / 27 * (C26 * C26 + 25 / 27 * (C27 * C27 + 25 / 27 * (C28 * C28 + 25 / 27 * (C29 * C29 + 25 / 27 * (C30 * C30 + 25 / 27 * (C31 * C31 + 25 / 27 * (C32 * C32 + 25 / 27 * (C33 * C33 + 25 / 27 * (C34 * C34 + 25 / 27 * (C35 * C35 + 25 / 27 * (C36 * C36 + 25 / 27 * (C37 * C37 + 25 / 27 * (C38 * C38 + 25 / 27 * (C39 * C39 + 25 / 27 * (C40 * C40 + 25 / 27 * (C41 * C41 + 25 / 27 * (C42 * C42 + 25 / 27 * (C43 * C43 + 25 / 27 * (C44 * C44 + 25 / 27 * (C45 * C45 + 25 / 27 * (C46 * C46 + 25 / 27 * (C47 * C47 + 25 / 27 * (C48 * C48 + 25 / 27 * (C49 * C49 + 25 / 27 * (C50 * C50 + 25 / 27 * (C51 * C51 + 25 / 27 * (C52 * C52 + 25 / 27 * (C53 * C53 + 25 / 27 * (C54 * C54 + 25 / 27 * (C55 * C55 + 25 / 27 * (C56 * C56 + 25 / 27 * (C57 * C57 + 25 / 27 * (C58 * C58 + 25 / 27 * (C59 * C59 + 25 / 27 * (C60 * C60 + 25 / 27 * (C61 * C61 + 25 / 27 * (C62 * C62 + 25 / 27 * (C63 * C63 + 25 / 27 * (C64 * C64 + 25 / 27 * (C65 * C65 + 25 / 27 * (C66 * C66 + 25 / 27 * (C67 * C67 + 25 / 27 * (C68 * C68 + 25 / 27 * (C69 * C69 + 25 / 27 * (C70 * C70 + 25 / 27 * (C71 * C71 + 25 / 27 * (C72 * C72 + 25 / 27 * (C73 * C73 + 25 / 27 * (C74 * C74 + 25 / 27 * (C75 * C75 + 25 / 27 * (C76 * C76 + 25 / 27 * (C77 * C77 + 25 / 27 * (C78 * C78 + 25 / 27 * (C79 * C79 + 25 / 27 * (C80 * C80 + 25 / 27 * (C81 * C81 + 25 / 27 * (C82 * C82 + 25 / 27 * (C83 * C83 + 25 / 27 * (C84 * C84 + 25 / 27 * (C85 * C85 + 25 / 27 * (C86 * C86 + 25 / 27 * (C87 * C87 + 25 / 27 * (C88 * C88 + 25 / 27 * (C89 * C89 + 25 / 27 * (C90 * C90 + 25 / 27 * (C91 * C91 + 25 / 27 * (C92 * C92 + 25 / 27 * (C93 * C93)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) * XAVGV12.4) / XAVGV12.4 / XAVGV26.4 + (.153984303064341 * (C5 * V5 + 11 / 13 * (C6 * C6 + 11 / 13 * (C7 * C7 + 11 / 13 * (C8 * C8 + 11 / 13 * (C9 * C9 + 11 / 13 * (C10 * C10 + 11 / 13 * (C11 * C11 + 11 / 13 * (C12 * C12 + 11 / 13 * (C13 * C13 + 11 / 13 * (C14 * C14 + 11 / 13 * (C15 * C15 + 11 / 13 * (C16 * C16 + 11 / 13 * (C17 * C17 + 11 / 13 * (C18 * C18 + 11 / 13 * (C19 * C19 + 11 / 13 * (C20 * C20 + 11 / 13 * (C21 * C21 + 11 / 13 * (C22 * C22 + 11 / 13 * (C23 * C23 + 11 / 13 * (C24 * C24 + 11 / 13 * (C25 * C25 + 11 / 13 * (C26 * C26 + 11 / 13 * (C27 * C27 + 11 / 13 * (C28 * C28 + 11 / 13 * (C29 * C29 + 11 / 13 * (C30 * C30 + 11 / 13 * (C31 * C31 + 11 / 13 * (C32 * C32 + 11 / 13 * (C33 * C33 + 11 / 13 * (C34 * C34 + 11 / 13 * (C35 * C35 + 11 / 13 * (C36 * C36 + 11 / 13 * (C37 * C37 + 11 / 13 * (C38 * C38 + 11 / 13 * (C39 * C39 + 11 / 13 * (C40 * C40 + 11 / 13 * (C41 * C41 + 11 / 13 * (C42 * C42 + 11 / 13 * (C43 * C43 + 11 / 13 * (C44 * C44 + 11 / 13 * (C45 * C45 + 11 / 13 * (C46 * C46)))))))))))))))))))))))))))))))))))))))))) * XAVGV26.5 - .0741468444601841 * (C5 * V5 + 25 / 27 * (C6 * C6 + 25 / 27 * (C7 * C7 + 25 / 27 * (C8 * C8 + 25 / 27 * (C9 * C9 + 25 / 27 * (C10 * C10 + 25 / 27 * (C11 * C11 + 25 / 27 * (C12 * C12 + 25 / 27 * (C13 * C13 + 25 / 27 * (C14 * C14 + 25 / 27 * (C15 * C15 + 25 / 27 * (C16 * C16 + 25 / 27 * (C17 * C17 + 25 / 27 * (C18 * C18 + 25 / 27 * (C19 * C19 + 25 / 27 * (C20 * C20 + 25 / 27 * (C21 * C21 + 25 / 27 * (C22 * C22 + 25 / 27 * (C23 * C23 + 25 / 27 * (C24 * C24 + 25 / 27 * (C25 * C25 + 25 / 27 * (C26 * C26 + 25 / 27 * (C27 * C27 + 25 / 27 * (C28 * C28 + 25 / 27 * (C29 * C29 + 25 / 27 * (C30 * C30 + 25 / 27 * (C31 * C31 + 25 / 27 * (C32 * C32 + 25 / 27 * (C33 * C33 + 25 / 27 * (C34 * C34 + 25 / 27 * (C35 * C35 + 25 / 27 * (C36 * C36 + 25 / 27 * (C37 * C37 + 25 / 27 * (C38 * C38 + 25 / 27 * (C39 * C39 + 25 / 27 * (C40 * C40 + 25 / 27 * (C41 * C41 + 25 / 27 * (C42 * C42 + 25 / 27 * (C43 * C43 + 25 / 27 * (C44 * C44 + 25 / 27 * (C45 * C45 + 25 / 27 * (C46 * C46 + 25 / 27 * (C47 * C47 + 25 / 27 * (C48 * C48 + 25 / 27 * (C49 * C49 + 25 / 27 * (C50 * C50 + 25 / 27 * (C51 * C51 + 25 / 27 * (C52 * C52 + 25 / 27 * (C53 * C53 + 25 / 27 * (C54 * C54 + 25 / 27 * (C55 * C55 + 25 / 27 * (C56 * C56 + 25 / 27 * (C57 * C57 + 25 / 27 * (C58 * C58 + 25 / 27 * (C59 * C59 + 25 / 27 * (C60 * C60 + 25 / 27 * (C61 * C61 + 25 / 27 * (C62 * C62 + 25 / 27 * (C63 * C63 + 25 / 27 * (C64 * C64 + 25 / 27 * (C65 * C65 + 25 / 27 * (C66 * C66 + 25 / 27 * (C67 * C67 + 25 / 27 * (C68 * C68 + 25 / 27 * (C69 * C69 + 25 / 27 * (C70 * C70 + 25 / 27 * (C71 * C71 + 25 / 27 * (C72 * C72 + 25 / 27 * (C73 * C73 + 25 / 27 * (C74 * C74 + 25 / 27 * (C75 * C75 + 25 / 27 * (C76 * C76 + 25 / 27 * (C77 * C77 + 25 / 27 * (C78 * C78 + 25 / 27 * (C79 * C79 + 25 / 27 * (C80 * C80 + 25 / 27 * (C81 * C81 + 25 / 27 * (C82 * C82 + 25 / 27 * (C83 * C83 + 25 / 27 * (C84 * C84 + 25 / 27 * (C85 * C85 + 25 / 27 * (C86 * C86 + 25 / 27 * (C87 * C87 + 25 / 27 * (C88 * C88 + 25 / 27 * (C89 * C89 + 25 / 27 * (C90 * C90 + 25 / 27 * (C91 * C91 + 25 / 27 * (C92 * C92 + 25 / 27 * (C93 * C93 + 25 / 27 * (C94 * C94)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) * XAVGV12.5) / XAVGV12.5 / XAVGV26.5 + (.153984303064341 * (C6 * V6 + 11 / 13 * (C7 * C7 + 11 / 13 * (C8 * C8 + 11 / 13 * (C9 * C9 + 11 / 13 * (C10 * C10 + 11 / 13 * (C11 * C11 + 11 / 13 * (C12 * C12 + 11 / 13 * (C13 * C13 + 11 / 13 * (C14 * C14 + 11 / 13 * (C15 * C15 + 11 / 13 * (C16 * C16 + 11 / 13 * (C17 * C17 + 11 / 13 * (C18 * C18 + 11 / 13 * (C19 * C19 + 11 / 13 * (C20 * C20 + 11 / 13 * (C21 * C21 + 11 / 13 * (C22 * C22 + 11 / 13 * (C23 * C23 + 11 / 13 * (C24 * C24 + 11 / 13 * (C25 * C25 + 11 / 13 * (C26 * C26 + 11 / 13 * (C27 * C27 + 11 / 13 * (C28 * C28 + 11 / 13 * (C29 * C29 + 11 / 13 * (C30 * C30 + 11 / 13 * (C31 * C31 + 11 / 13 * (C32 * C32 + 11 / 13 * (C33 * C33 + 11 / 13 * (C34 * C34 + 11 / 13 * (C35 * C35 + 11 / 13 * (C36 * C36 + 11 / 13 * (C37 * C37 + 11 / 13 * (C38 * C38 + 11 / 13 * (C39 * C39 + 11 / 13 * (C40 * C40 + 11 / 13 * (C41 * C41 + 11 / 13 * (C42 * C42 + 11 / 13 * (C43 * C43 + 11 / 13 * (C44 * C44 + 11 / 13 * (C45 * C45 + 11 / 13 * (C46 * C46 + 11 / 13 * (C47 * C47)))))))))))))))))))))))))))))))))))))))))) * XAVGV26.6 - .0741468444601841 * (C6 * V6 + 25 / 27 * (C7 * C7 + 25 / 27 * (C8 * C8 + 25 / 27 * (C9 * C9 + 25 / 27 * (C10 * C10 + 25 / 27 * (C11 * C11 + 25 / 27 * (C12 * C12 + 25 / 27 * (C13 * C13 + 25 / 27 * (C14 * C14 + 25 / 27 * (C15 * C15 + 25 / 27 * (C16 * C16 + 25 / 27 * (C17 * C17 + 25 / 27 * (C18 * C18 + 25 / 27 * (C19 * C19 + 25 / 27 * (C20 * C20 + 25 / 27 * (C21 * C21 + 25 / 27 * (C22 * C22 + 25 / 27 * (C23 * C23 + 25 / 27 * (C24 * C24 + 25 / 27 * (C25 * C25 + 25 / 27 * (C26 * C26 + 25 / 27 * (C27 * C27 + 25 / 27 * (C28 * C28 + 25 / 27 * (C29 * C29 + 25 / 27 * (C30 * C30 + 25 / 27 * (C31 * C31 + 25 / 27 * (C32 * C32 + 25 / 27 * (C33 * C33 + 25 / 27 * (C34 * C34 + 25 / 27 * (C35 * C35 + 25 / 27 * (C36 * C36 + 25 / 27 * (C37 * C37 + 25 / 27 * (C38 * C38 + 25 / 27 * (C39 * C39 + 25 / 27 * (C40 * C40 + 25 / 27 * (C41 * C41 + 25 / 27 * (C42 * C42 + 25 / 27 * (C43 * C43 + 25 / 27 * (C44 * C44 + 25 / 27 * (C45 * C45 + 25 / 27 * (C46 * C46 + 25 / 27 * (C47 * C47 + 25 / 27 * (C48 * C48 + 25 / 27 * (C49 * C49 + 25 / 27 * (C50 * C50 + 25 / 27 * (C51 * C51 + 25 / 27 * (C52 * C52 + 25 / 27 * (C53 * C53 + 25 / 27 * (C54 * C54 + 25 / 27 * (C55 * C55 + 25 / 27 * (C56 * C56 + 25 / 27 * (C57 * C57 + 25 / 27 * (C58 * C58 + 25 / 27 * (C59 * C59 + 25 / 27 * (C60 * C60 + 25 / 27 * (C61 * C61 + 25 / 27 * (C62 * C62 + 25 / 27 * (C63 * C63 + 25 / 27 * (C64 * C64 + 25 / 27 * (C65 * C65 + 25 / 27 * (C66 * C66 + 25 / 27 * (C67 * C67 + 25 / 27 * (C68 * C68 + 25 / 27 * (C69 * C69 + 25 / 27 * (C70 * C70 + 25 / 27 * (C71 * C71 + 25 / 27 * (C72 * C72 + 25 / 27 * (C73 * C73 + 25 / 27 * (C74 * C74 + 25 / 27 * (C75 * C75 + 25 / 27 * (C76 * C76 + 25 / 27 * (C77 * C77 + 25 / 27 * (C78 * C78 + 25 / 27 * (C79 * C79 + 25 / 27 * (C80 * C80 + 25 / 27 * (C81 * C81 + 25 / 27 * (C82 * C82 + 25 / 27 * (C83 * C83 + 25 / 27 * (C84 * C84 + 25 / 27 * (C85 * C85 + 25 / 27 * (C86 * C86 + 25 / 27 * (C87 * C87 + 25 / 27 * (C88 * C88 + 25 / 27 * (C89 * C89 + 25 / 27 * (C90 * C90 + 25 / 27 * (C91 * C91 + 25 / 27 * (C92 * C92 + 25 / 27 * (C93 * C93 + 25 / 27 * (C94 * C94 + 25 / 27 * (C95 * C95)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) * XAVGV12.6) / XAVGV12.6 / XAVGV26.6 + (.153984303064341 * (C7 * V7 + 11 / 13 * (C8 * C8 + 11 / 13 * (C9 * C9 + 11 / 13 * (C10 * C10 + 11 / 13 * (C11 * C11 + 11 / 13 * (C12 * C12 + 11 / 13 * (C13 * C13 + 11 / 13 * (C14 * C14 + 11 / 13 * (C15 * C15 + 11 / 13 * (C16 * C16 + 11 / 13 * (C17 * C17 + 11 / 13 * (C18 * C18 + 11 / 13 * (C19 * C19 + 11 / 13 * (C20 * C20 + 11 / 13 * (C21 * C21 + 11 / 13 * (C22 * C22 + 11 / 13 * (C23 * C23 + 11 / 13 * (C24 * C24 + 11 / 13 * (C25 * C25 + 11 / 13 * (C26 * C26 + 11 / 13 * (C27 * C27 + 11 / 13 * (C28 * C28 + 11 / 13 * (C29 * C29 + 11 / 13 * (C30 * C30 + 11 / 13 * (C31 * C31 + 11 / 13 * (C32 * C32 + 11 / 13 * (C33 * C33 + 11 / 13 * (C34 * C34 + 11 / 13 * (C35 * C35 + 11 / 13 * (C36 * C36 + 11 / 13 * (C37 * C37 + 11 / 13 * (C38 * C38 + 11 / 13 * (C39 * C39 + 11 / 13 * (C40 * C40 + 11 / 13 * (C41 * C41 + 11 / 13 * (C42 * C42 + 11 / 13 * (C43 * C43 + 11 / 13 * (C44 * C44 + 11 / 13 * (C45 * C45 + 11 / 13 * (C46 * C46 + 11 / 13 * (C47 * C47 + 11 / 13 * (C48 * C48)))))))))))))))))))))))))))))))))))))))))) * XAVGV26.7 - .0741468444601841 * (C7 * V7 + 25 / 27 * (C8 * C8 + 25 / 27 * (C9 * C9 + 25 / 27 * (C10 * C10 + 25 / 27 * (C11 * C11 + 25 / 27 * (C12 * C12 + 25 / 27 * (C13 * C13 + 25 / 27 * (C14 * C14 + 25 / 27 * (C15 * C15 + 25 / 27 * (C16 * C16 + 25 / 27 * (C17 * C17 + 25 / 27 * (C18 * C18 + 25 / 27 * (C19 * C19 + 25 / 27 * (C20 * C20 + 25 / 27 * (C21 * C21 + 25 / 27 * (C22 * C22 + 25 / 27 * (C23 * C23 + 25 / 27 * (C24 * C24 + 25 / 27 * (C25 * C25 + 25 / 27 * (C26 * C26 + 25 / 27 * (C27 * C27 + 25 / 27 * (C28 * C28 + 25 / 27 * (C29 * C29 + 25 / 27 * (C30 * C30 + 25 / 27 * (C31 * C31 + 25 / 27 * (C32 * C32 + 25 / 27 * (C33 * C33 + 25 / 27 * (C34 * C34 + 25 / 27 * (C35 * C35 + 25 / 27 * (C36 * C36 + 25 / 27 * (C37 * C37 + 25 / 27 * (C38 * C38 + 25 / 27 * (C39 * C39 + 25 / 27 * (C40 * C40 + 25 / 27 * (C41 * C41 + 25 / 27 * (C42 * C42 + 25 / 27 * (C43 * C43 + 25 / 27 * (C44 * C44 + 25 / 27 * (C45 * C45 + 25 / 27 * (C46 * C46 + 25 / 27 * (C47 * C47 + 25 / 27 * (C48 * C48 + 25 / 27 * (C49 * C49 + 25 / 27 * (C50 * C50 + 25 / 27 * (C51 * C51 + 25 / 27 * (C52 * C52 + 25 / 27 * (C53 * C53 + 25 / 27 * (C54 * C54 + 25 / 27 * (C55 * C55 + 25 / 27 * (C56 * C56 + 25 / 27 * (C57 * C57 + 25 / 27 * (C58 * C58 + 25 / 27 * (C59 * C59 + 25 / 27 * (C60 * C60 + 25 / 27 * (C61 * C61 + 25 / 27 * (C62 * C62 + 25 / 27 * (C63 * C63 + 25 / 27 * (C64 * C64 + 25 / 27 * (C65 * C65 + 25 / 27 * (C66 * C66 + 25 / 27 * (C67 * C67 + 25 / 27 * (C68 * C68 + 25 / 27 * (C69 * C69 + 25 / 27 * (C70 * C70 + 25 / 27 * (C71 * C71 + 25 / 27 * (C72 * C72 + 25 / 27 * (C73 * C73 + 25 / 27 * (C74 * C74 + 25 / 27 * (C75 * C75 + 25 / 27 * (C76 * C76 + 25 / 27 * (C77 * C77 + 25 / 27 * (C78 * C78 + 25 / 27 * (C79 * C79 + 25 / 27 * (C80 * C80 + 25 / 27 * (C81 * C81 + 25 / 27 * (C82 * C82 + 25 / 27 * (C83 * C83 + 25 / 27 * (C84 * C84 + 25 / 27 * (C85 * C85 + 25 / 27 * (C86 * C86 + 25 / 27 * (C87 * C87 + 25 / 27 * (C88 * C88 + 25 / 27 * (C89 * C89 + 25 / 27 * (C90 * C90 + 25 / 27 * (C91 * C91 + 25 / 27 * (C92 * C92 + 25 / 27 * (C93 * C93 + 25 / 27 * (C94 * C94 + 25 / 27 * (C95 * C95 + 25 / 27 * (C96 * C96)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) * XAVGV12.7) / XAVGV12.7 / XAVGV26.7 + (.153984303064341 * (C8 * V8 + 11 / 13 * (C9 * C9 + 11 / 13 * (C10 * C10 + 11 / 13 * (C11 * C11 + 11 / 13 * (C12 * C12 + 11 / 13 * (C13 * C13 + 11 / 13 * (C14 * C14 + 11 / 13 * (C15 * C15 + 11 / 13 * (C16 * C16 + 11 / 13 * (C17 * C17 + 11 / 13 * (C18 * C18 + 11 / 13 * (C19 * C19 + 11 / 13 * (C20 * C20 + 11 / 13 * (C21 * C21 + 11 / 13 * (C22 * C22 + 11 / 13 * (C23 * C23 + 11 / 13 * (C24 * C24 + 11 / 13 * (C25 * C25 + 11 / 13 * (C26 * C26 + 11 / 13 * (C27 * C27 + 11 / 13 * (C28 * C28 + 11 / 13 * (C29 * C29 + 11 / 13 * (C30 * C30 + 11 / 13 * (C31 * C31 + 11 / 13 * (C32 * C32 + 11 / 13 * (C33 * C33 + 11 / 13 * (C34 * C34 + 11 / 13 * (C35 * C35 + 11 / 13 * (C36 * C36 + 11 / 13 * (C37 * C37 + 11 / 13 * (C38 * C38 + 11 / 13 * (C39 * C39 + 11 / 13 * (C40 * C40 + 11 / 13 * (C41 * C41 + 11 / 13 * (C42 * C42 + 11 / 13 * (C43 * C43 + 11 / 13 * (C44 * C44 + 11 / 13 * (C45 * C45 + 11 / 13 * (C46 * C46 + 11 / 13 * (C47 * C47 + 11 / 13 * (C48 * C48 + 11 / 13 * (C49 * C49)))))))))))))))))))))))))))))))))))))))))) * XAVGV26.8 - .0741468444601841 * (C8 * V8 + 25 / 27 * (C9 * C9 + 25 / 27 * (C10 * C10 + 25 / 27 * (C11 * C11 + 25 / 27 * (C12 * C12 + 25 / 27 * (C13 * C13 + 25 / 27 * (C14 * C14 + 25 / 27 * (C15 * C15 + 25 / 27 * (C16 * C16 + 25 / 27 * (C17 * C17 + 25 / 27 * (C18 * C18 + 25 / 27 * (C19 * C19 + 25 / 27 * (C20 * C20 + 25 / 27 * (C21 * C21 + 25 / 27 * (C22 * C22 + 25 / 27 * (C23 * C23 + 25 / 27 * (C24 * C24 + 25 / 27 * (C25 * C25 + 25 / 27 * (C26 * C26 + 25 / 27 * (C27 * C27 + 25 / 27 * (C28 * C28 + 25 / 27 * (C29 * C29 + 25 / 27 * (C30 * C30 + 25 / 27 * (C31 * C31 + 25 / 27 * (C32 * C32 + 25 / 27 * (C33 * C33 + 25 / 27 * (C34 * C34 + 25 / 27 * (C35 * C35 + 25 / 27 * (C36 * C36 + 25 / 27 * (C37 * C37 + 25 / 27 * (C38 * C38 + 25 / 27 * (C39 * C39 + 25 / 27 * (C40 * C40 + 25 / 27 * (C41 * C41 + 25 / 27 * (C42 * C42 + 25 / 27 * (C43 * C43 + 25 / 27 * (C44 * C44 + 25 / 27 * (C45 * C45 + 25 / 27 * (C46 * C46 + 25 / 27 * (C47 * C47 + 25 / 27 * (C48 * C48 + 25 / 27 * (C49 * C49 + 25 / 27 * (C50 * C50 + 25 / 27 * (C51 * C51 + 25 / 27 * (C52 * C52 + 25 / 27 * (C53 * C53 + 25 / 27 * (C54 * C54 + 25 / 27 * (C55 * C55 + 25 / 27 * (C56 * C56 + 25 / 27 * (C57 * C57 + 25 / 27 * (C58 * C58 + 25 / 27 * (C59 * C59 + 25 / 27 * (C60 * C60 + 25 / 27 * (C61 * C61 + 25 / 27 * (C62 * C62 + 25 / 27 * (C63 * C63 + 25 / 27 * (C64 * C64 + 25 / 27 * (C65 * C65 + 25 / 27 * (C66 * C66 + 25 / 27 * (C67 * C67 + 25 / 27 * (C68 * C68 + 25 / 27 * (C69 * C69 + 25 / 27 * (C70 * C70 + 25 / 27 * (C71 * C71 + 25 / 27 * (C72 * C72 + 25 / 27 * (C73 * C73 + 25 / 27 * (C74 * C74 + 25 / 27 * (C75 * C75 + 25 / 27 * (C76 * C76 + 25 / 27 * (C77 * C77 + 25 / 27 * (C78 * C78 + 25 / 27 * (C79 * C79 + 25 / 27 * (C80 * C80 + 25 / 27 * (C81 * C81 + 25 / 27 * (C82 * C82 + 25 / 27 * (C83 * C83 + 25 / 27 * (C84 * C84 + 25 / 27 * (C85 * C85 + 25 / 27 * (C86 * C86 + 25 / 27 * (C87 * C87 + 25 / 27 * (C88 * C88 + 25 / 27 * (C89 * C89 + 25 / 27 * (C90 * C90 + 25 / 27 * (C91 * C91 + 25 / 27 * (C92 * C92 + 25 / 27 * (C93 * C93 + 25 / 27 * (C94 * C94 + 25 / 27 * (C95 * C95 + 25 / 27 * (C96 * C96 + 25 / 27 * (C97 * C97)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) * XAVGV12.8) / XAVGV12.8 / XAVGV26.8) / 9
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Platinum Customer
Joined: 1/5/2005
Posts: 4
|
Bruce,
Thanks for the formula; will let you know how the scan turns out.
Michael
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
allstravel,
You're welcome. Our pleasure.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 12/10/2004
Posts: 25
|
How do I create a exponential PCF for TSV 27 - MA 12 which 10 days ago above the MA and 2 days ago was below the MA?
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
wildcat7129,
If both the TSV and the Moving Average are Exponential:
XAVG(TSV1.10,27) < XAVG(TSV1.10,12) AND XAVG(TSV1.2,27) > XAVG(TSV1.2,12)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 3/31/2011
Posts: 68
|
I have a question.
If I want to have 32 - 53 - 9 volume weighted MACD, how do I change the formula below?
QUOTE (Bruce_L) gsn,
The following formula does appear to be a Simple Volume Weighted MACD (12,26):
(C * V + C1 * V1 + C2 * V2 + C3 * V3 + C4 * V4 + C5 * V5 + C6 * V6 + C7 * V7 + C8 * V8 + C9 * V9 + C10 * V10 + C11 * V11) * (1 / 12 / AVGV12 - 1 / 26 / AVGV26) - (C12 * V12 + C13 * V13 + C14 * V14 + C15 * V15 + C16 * V16 + C17 * V17 + C18 * V18 + C19 * V19 + C20 * V20 + C21 * V21 + C22 * V22 + C23 * V23 + C24 * V24 + C25 * V25) / 26 / AVGV26
Considering the fact that the Trigger line is an Exponential Moving Average, I would have thought the raw MACD would be an Exponential Volume Weighted MACD (12,26), but, unlike Tanstaafl, I haven't read Bollinger's book (so while his formula is probably the correct one, I'm providing an Exponential version):
(.153984303064341 * (C * V + 11 / 13 * (C1 * V1 + 11 / 13 * (C2 * V2 + 11 / 13 * (C3 * V3 + 11 / 13 * (C4 * V4 + 11 / 13 * (C5 * V5 + 11 / 13 * (C6 * V6 + 11 / 13 * (C7 * V7 + 11 / 13 * (C8 * V8 + 11 / 13 * (C9 * V9 + 11 / 13 * (C10 * V10 + 11 / 13 * (C11 * V11 + 11 / 13 * (C12 * V12 + 11 / 13 * (C13 * V13 + 11 / 13 * (C14 * V14 + 11 / 13 * (C15 * V15 + 11 / 13 * (C16 * V16 + 11 / 13 * (C17 * V17 + 11 / 13 * (C18 * V18 + 11 / 13 * (C19 * V19 + 11 / 13 * (C20 * V20 + 11 / 13 * (C21 * V21 + 11 / 13 * (C22 * V22 + 11 / 13 * (C23 * V23 + 11 / 13 * (C24 * V24 + 11 / 13 * (C25 * V25 + 11 / 13 * (C26 * V26 + 11 / 13 * (C27 * V27 + 11 / 13 * (C28 * V28 + 11 / 13 * (C29 * V29 + 11 / 13 * (C30 * V30 + 11 / 13 * (C31 * V31 + 11 / 13 * (C32 * V32 + 11 / 13 * (C33 * V33 + 11 / 13 * (C34 * V34 + 11 / 13 * (C35 * V35 + 11 / 13 * (C36 * V36 + 11 / 13 * (C37 * V37 + 11 / 13 * (C38 * V38 + 11 / 13 * (C39 * V39 + 11 / 13 * (C40 * V40 + 11 / 13 * (C41 * V41)))))))))))))))))))))))))))))))))))))))))) * XAVGV26 - .0741468444601841 * (C * V + 25 / 27 * (C1 * V1 + 25 / 27 * (C2 * V2 + 25 / 27 * (C3 * V3 + 25 / 27 * (C4 * V4 + 25 / 27 * (C5 * V5 + 25 / 27 * (C6 * V6 + 25 / 27 * (C7 * V7 + 25 / 27 * (C8 * V8 + 25 / 27 * (C9 * V9 + 25 / 27 * (C10 * V10 + 25 / 27 * (C11 * V11 + 25 / 27 * (C12 * V12 + 25 / 27 * (C13 * V13 + 25 / 27 * (C14 * V14 + 25 / 27 * (C15 * V15 + 25 / 27 * (C16 * V16 + 25 / 27 * (C17 * V17 + 25 / 27 * (C18 * V18 + 25 / 27 * (C19 * V19 + 25 / 27 * (C20 * V20 + 25 / 27 * (C21 * V21 + 25 / 27 * (C22 * V22 + 25 / 27 * (C23 * V23 + 25 / 27 * (C24 * V24 + 25 / 27 * (C25 * V25 + 25 / 27 * (C26 * V26 + 25 / 27 * (C27 * V27 + 25 / 27 * (C28 * V28 + 25 / 27 * (C29 * V29 + 25 / 27 * (C30 * V30 + 25 / 27 * (C31 * V31 + 25 / 27 * (C32 * V32 + 25 / 27 * (C33 * V33 + 25 / 27 * (C34 * V34 + 25 / 27 * (C35 * V35 + 25 / 27 * (C36 * V36 + 25 / 27 * (C37 * V37 + 25 / 27 * (C38 * V38 + 25 / 27 * (C39 * V39 + 25 / 27 * (C40 * V40 + 25 / 27 * (C41 * V41 + 25 / 27 * (C42 * V42 + 25 / 27 * (C43 * V43 + 25 / 27 * (C44 * V44 + 25 / 27 * (C45 * V45 + 25 / 27 * (C46 * V46 + 25 / 27 * (C47 * V47 + 25 / 27 * (C48 * V48 + 25 / 27 * (C49 * V49 + 25 / 27 * (C50 * V50 + 25 / 27 * (C51 * V51 + 25 / 27 * (C52 * V52 + 25 / 27 * (C53 * V53 + 25 / 27 * (C54 * V54 + 25 / 27 * (C55 * V55 + 25 / 27 * (C56 * V56 + 25 / 27 * (C57 * V57 + 25 / 27 * (C58 * V58 + 25 / 27 * (C59 * V59 + 25 / 27 * (C60 * V60 + 25 / 27 * (C61 * V61 + 25 / 27 * (C62 * V62 + 25 / 27 * (C63 * V63 + 25 / 27 * (C64 * V64 + 25 / 27 * (C65 * V65 + 25 / 27 * (C66 * V66 + 25 / 27 * (C67 * V67 + 25 / 27 * (C68 * V68 + 25 / 27 * (C69 * V69 + 25 / 27 * (C70 * V70 + 25 / 27 * (C71 * V71 + 25 / 27 * (C72 * V72 + 25 / 27 * (C73 * V73 + 25 / 27 * (C74 * V74 + 25 / 27 * (C75 * V75 + 25 / 27 * (C76 * V76 + 25 / 27 * (C77 * V77 + 25 / 27 * (C78 * V78 + 25 / 27 * (C79 * V79 + 25 / 27 * (C80 * V80 + 25 / 27 * (C81 * V81 + 25 / 27 * (C82 * V82 + 25 / 27 * (C83 * V83 + 25 / 27 * (C84 * V84 + 25 / 27 * (C85 * V85 + 25 / 27 * (C86 * V86 + 25 / 27 * (C87 * V87 + 25 / 27 * (C88 * V88 + 25 / 27 * (C89 * V89)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) * XAVGV12) / XAVGV12 / XAVGV26
In either case, the Indicator Sort method outlined by Tanstaafl in the Friday, August 6, 2004 Worden Report is an effective method of detecting crossovers. I have been trying to create a Personal Criteria Formula based solution, but the results so far have not been particularly practical when attempting to create reasonably accurate approximations of a 9-Period EMA.
|
|
|
Guest-1 |