Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Linear Regression Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
aubrey_dsouza
Posted : Friday, November 30, 2018 2:30:01 PM
Registered User
Joined: 3/10/2013
Posts: 41

Can you please provide a PCF for Linear Regression of price as follows:

Slope for 50 days > 0

and

Slope for last 15 days < 0

and

Slope for last 3 days > 0

Thanks

 

Bruce_L
Posted : Friday, November 30, 2018 2:34:52 PM


Worden Trainer

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

Please try the following condition formulas.

Slope for 50 days > 0

FAVGC50 > AVGC50

Slop for last 15 days < 0

FAVGC15 < AVGC50

Slope for last 3 days > 0

FAVGC3 > AVGC3

Combined:

FAVGC3 > AVGC3 AND FAVGC15 < AVGC15 AND FAVGC50 > AVGC50



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
aubrey_dsouza
Posted : Friday, November 30, 2018 2:58:23 PM
Registered User
Joined: 3/10/2013
Posts: 41

Thanks - when I paste combined FAVGC3 > AVGC3 AND FAVGC15 < AVGC15 AND FAVGC50 > AVGC50 in condition formula I am getting an formula error.

Am i missing something - Thanks

 

Bruce_L
Posted : Friday, November 30, 2018 3:03:37 PM


Worden Trainer

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

I don't get any error messages. What error message are you getting and where are you using the formula when you get the error?

You might want to try copying and pasting the formula from the forums into a text editor (such a Notepad and not a word processor like Word) and then copying and pasting the formula from the text editor into TC2000.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
aubrey_dsouza
Posted : Friday, November 30, 2018 3:14:21 PM
Registered User
Joined: 3/10/2013
Posts: 41

I am using TC2000 12.5 does that make a difference as I have copied formuals from the forum before without any problems. Thanks

aubrey_dsouza
Posted : Friday, November 30, 2018 3:23:08 PM
Registered User
Joined: 3/10/2013
Posts: 41

It does not like FAVGC3

AVGC3 is ok

Bruce_L
Posted : Friday, November 30, 2018 3:37:14 PM


Worden Trainer

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

Sorry. Yes, it is going to make a big difference. The combined formula becomes the following.

C > C2 AND 7 * (C - C14) + 6 * (C1 - C13) + 5 * (C2 - C12) + 4 * (C3 - C11) + 3 * (C4 - C10) + 2 * (C5 - C9) + C6 < C8 AND 49 * (C - C49) + 47 * (C1 - C48) + 45 * (C2 - C47) + 43 * (C3 - C46) + 41 * (C4 - C45) + 39 * (C5 - C44) + 37 * (C6 - C43) + 35 * (C7 - C42) + 33 * (C8 - C41) + 31 * (C9 - C40) + 29 * (C10 - C39) + 27 * (C11 - C38) + 25 * (C12 - C37) + 23 * (C13 - C36) + 21 * (C14 - C35) + 19 * (C15 - C34) + 17 * (C16 - C33) + 15 * (C17 - C32) + 13 * (C18 - C31) + 11 * (C19 - C30) + 9 * (C20 - C29) + 7 * (C21 - C28) + 5 * (C22 - C27) + 3 * (C23 - C26) + C24 > C25



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
aubrey_dsouza
Posted : Friday, November 30, 2018 3:53:28 PM
Registered User
Joined: 3/10/2013
Posts: 41

Thanks that works.

Bruce_L
Posted : Friday, November 30, 2018 3:55:10 PM


Worden Trainer

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

You're welcome.



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