Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
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
|
|
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
|
|
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
|
|
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
|
|
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
|
|
Registered User Joined: 3/10/2013 Posts: 41
|
It does not like FAVGC3
AVGC3 is ok
|
|
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
|
|
Registered User Joined: 3/10/2013 Posts: 41
|
Thanks that works.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |