Hello Julia, I just completed watching your video in how to create custom PCF's for scans. I need help in creating a formula for a scan that would pull all stocks whose LR13 (Linear Regreation 13) is rising on a monthly chart.  Thank you in advance. - sid lodaya

ny20132,
TC2000 version 12.3 Platinum has a tick time frame and uses data from the consolidated tape including trades on all of the exchanges for its streaming real time data.

TC2000 version 12.3 Gold only uses data from the BATS exchange for its streaming real time data, but uses data from the consolidated tape on a fifteen minute delayed basis.

Siddharth,
You probably do not want to create a Condition Formula for this. Just add the Linear Regression indicator to the chart and adjust its settings as desired. Then click on the Linear Regression indicator and select Create Scan Condition.

Create Conditions from Your Chart

You would probably want to choose Moving Up Net with the Net Change > setting set to 0. If the Linear Regression indicator is a Linear Regression Line, it is important that the Period setting be set to 1, but if the Linear Regression indicator is a Moving Linear Regression, you can set the Period to anything you want.

Note that it is possible to create a Condition Formula for this. The Using Linear Regression vs Classical Peaks/Valleys for Divergence Analysis topic goes into the specifics. A Condition Formula for a 13-Period Linear Regression Line having a positive Linear Regression Slope could be written as:

(6 * C + 5 * C1 + 4 * C2 + 3 * C3 + 2 * C4 + C5 - C7 - 2 * C8 - 3 * C9 - 4 * C10 - 5 * C11 - 6 * C12) / 182 > 0

Which can be shortened somewhat to:

6 * (C - C12) + 5 * (C1 - C11) + 4 * (C2 - C10) + 3 * (C3 - C9) + 2 * (C4 - C8) + C5 > C7

While a Condition Formula for the 13-Period Moving Linear Regression increasing from one bar to the next could be written as:

AVGC13 + 6 * (6 * C + 5 * C1 + 4 * C2 + 3 * C3 + 2 * C4 + C5 - C7 - 2 * C8 - 3 * C9 - 4 * C10 - 5 * C11 - 6 * C12) / 182 > AVGC13.1 + 6 * (6 * C1 + 5 * C2 + 4 * C3 + 3 * C4 + 2 * C5 + C6 - C8 - 2 * C9 - 3 * C10 - 4 * C11 - 5 * C12 - 6 * C13) / 182

Thank you Bruce.

platinum ,how can pay it?as foreigners.

We do not accept PayPal. Your best option would be to get a Visa or Mastercard and use it to pay.

I like this regression line pcf a lot. I was wondering if you could create a pcf for aregression line going from begative to positive slope. Thanks.

and if you could do one for a 13, 20 and 50 period that would be great.

Wilder's RSI-3 on a 1-period ROC

Have tried on TC2000 v12.3, also on TC2000 beta.  No luck.  I have a pcf for the RSI-3, but cannot figure out how to apply it to the ROC.  Any suggestions?

julian1000,
A Condition Formula for a 13-Period Linear Regression Line going from a negative to a positive slope between the previous bar and the current bar could be written as:

6 * C + 5 * C1 + 4 * C2 + 3 * C3 + 2 * C4 + C5 - C7 - 2 * C8 - 3 * C9 - 4 * C10 - 5 * C11 - 6 * C12 > 0 AND 6 * C1 + 5 * C2 + 4 * C3 + 3 * C4 + 2 * C5 + C6 - C8 - 2 * C9 - 3 * C10 - 4 * C11 - 5 * C12 - 6 * C13 < 0

A Condition Formula for a 20-Period Linear Regression Line going from a negative to a positive slope between the previous bar and the current bar could be written as:

9.5 * C + 8.5 * C1 + 7.5 * C2 + 6.5 * C3 + 5.5 * C4 + 4.5 * C5 + 3.5 * C6 + 2.5 * C7 + 1.5 * C8 + 0.5 * C9 - 0.5 * C10 - 1.5 * C11 - 2.5 * C12 - 3.5 * C13 - 4.5 * C14 - 5.5 * C15 - 6.5 * C16 - 7.5 * C17 - 8.5 * C18 - 9.5 * C19 > 0 AND 9.5 * C1 + 8.5 * C2 + 7.5 * C3 + 6.5 * C4 + 5.5 * C5 + 4.5 * C6 + 3.5 * C7 + 2.5 * C8 + 1.5 * C9 + 0.5 * C10 - 0.5 * C11 - 1.5 * C12 - 2.5 * C13 - 3.5 * C14 - 4.5 * C15 - 5.5 * C16 - 6.5 * C17 - 7.5 * C18 - 8.5 * C19 - 9.5 * C20 < 0

A Condition Formula for a 50-Period Linear Regression Line going from a negative to a positive slope between the previous bar and the current bar could be written as:

24.5 * C + 23.5 * C1 + 22.5 * C2 + 21.5 * C3 + 20.5 * C4 + 19.5 * C5 + 18.5 * C6 + 17.5 * C7 + 16.5 * C8 + 15.5 * C9 + 14.5 * C10 + 13.5 * C11 + 12.5 * C12 + 11.5 * C13 + 10.5 * C14 + 9.5 * C15 + 8.5 * C16 + 7.5 * C17 + 6.5 * C18 + 5.5 * C19 + 4.5 * C20 + 3.5 * C21 + 2.5 * C22 + 1.5 * C23 + 0.5 * C24 - 0.5 * C25 - 1.5 * C26 - 2.5 * C27 - 3.5 * C28 - 4.5 * C29 - 5.5 * C30 - 6.5 * C31 - 7.5 * C32 - 8.5 * C33 - 9.5 * C34 - 10.5 * C35 - 11.5 * C36 - 12.5 * C37 - 13.5 * C38 - 14.5 * C39 - 15.5 * C40 - 16.5 * C41 - 17.5 * C42 - 18.5 * C43 - 19.5 * C44 - 20.5 * C45 - 21.5 * C46 - 22.5 * C47 - 23.5 * C48 - 24.5 * C49 > 0 AND 24.5 * C1 + 23.5 * C2 + 22.5 * C3 + 21.5 * C4 + 20.5 * C5 + 19.5 * C6 + 18.5 * C7 + 17.5 * C8 + 16.5 * C9 + 15.5 * C10 + 14.5 * C11 + 13.5 * C12 + 12.5 * C13 + 11.5 * C14 + 10.5 * C15 + 9.5 * C16 + 8.5 * C17 + 7.5 * C18 + 6.5 * C19 + 5.5 * C20 + 4.5 * C21 + 3.5 * C22 + 2.5 * C23 + 1.5 * C24 + 0.5 * C25 - 0.5 * C26 - 1.5 * C27 - 2.5 * C28 - 3.5 * C29 - 4.5 * C30 - 5.5 * C31 - 6.5 * C32 - 7.5 * C33 - 8.5 * C34 - 9.5 * C35 - 10.5 * C36 - 11.5 * C37 - 12.5 * C38 - 13.5 * C39 - 14.5 * C40 - 15.5 * C41 - 16.5 * C42 - 17.5 * C43 - 18.5 * C44 - 19.5 * C45 - 20.5 * C46 - 21.5 * C47 - 22.5 * C48 - 23.5 * C49 - 24.5 * C50 < 0

orchidman,
If you have already added the Wilder's RSI and Rate of Change indicators to the chart, you can click on the Wilder's RSI indicator in TC2000 version 12.4 and select Edit. Near the bottom of the Edit RSI window which comes up, there should be a Data Source setting. You will want to change this to the Rate of Change indicator.

These instructions will not work in TC2000 version 12.3 as changing the Data Source of an indicator is a feature which was added in TC2000 version 12.4.

Thank you very much.

You're welcome.