Bruce,

Can you recommend literature to create the formulas in Excel, or do you just start it and let excel complete it in sequence? i.e. 1*2, 1*3, 1*4 .....

Thanks Bruce.

I guess I need to go back to grade school because (21) -1) / 2 = 10

From there, I have no idea how I followed up with 15.5

i.e. XAVG21 + 10 * (10 * C + 15.5

I gotta admit, I was proud, but now I am ashamed :)

Thanks for all you do!

Rod

Bruce,

Let me complete the formula. Sorry

200 * (XAVGC21 + 10 * (10 * C + 15.5 * C1 + 14.5 * C2 + 13.5 * C3 + 12.5 * C4 + 11.5 * C5 + 10.5 * C6 + 9.5 * C7 + 8.5 * C8 + 7.5 * C9 + 6.5 * C10 + 5.5 * C11 + 4.5 * C12 + 3.5 * C13 + 2.5 * C14 + 1.5 * C15 + 0.5 * C16 - 0.5 * C17 - 1.5 * C18 - 2.5 * C19 - 3.5 * C20 - 4.5) / 780)

Bruce,

Does this look right for an EMA 21 Linear Regression Line PCF?

XAVGC21 + 10 * (10 * C + 15.5 * C1 + 14.5 * C2 + 13.5 * C3 + 12.5 * C4 + 11.5 * C5 + 10.5 * C6 + 9.5 * C7 + 8.5 * C8 + 7.5 * C9 + 6.5 * C10 + 5.5 * C11 + 4.5 * C12 + 3.5 * C13 + 2.5 * C14 + 1.5 * C15 + 0.5 * C16 - 0.5 * C17 - 1.5 * C18 - 2.5 * C19 - 3.5 * C20 - 4.5) / 780

As always, thank you for your help

Rod

I found my Syntex error. All is good

Bruce,

I have been trying to write a TC2000 PCF and just can't crack the DNA:

Average Daily Range (30) / Standard Deviation (30)

Seem simple, but I guess it is beyond my paygrade.

If it is possible, is it also possible to have a column in the watchlist with Gold, of just an indicator?

Thanks for all you do!

Rod

Bruce,

would it be possible in StockFinder?

Thank you Bruce,

I came up with the same thing, but was hoping I could stop it at the 30 min mark rather than continuing to update each successive 1 min bar.

Bruce, is it possible to create a PCF for the standard deviation of only the first 30 minutes starting at the open of the day in TC2000?

Thank you Bruce!

It amazes me how I was blind to the simplest and obvious thing. I spent a lot of time trying to see but I guess failed to look at the very end.

Have a geat day!

Rod