| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 9/30/2011
Posts: 788
|
I would like to change the following PCF Formula
1000000 * (2 * LOG (C0) + LOG (C1) -LOG (C3) -2 * LOG (C4)) / 10 - (-2760.42)> 0
with the following parameter: Price trends over the last two days greater than 5% higher than the Nasdaq Composite and Amex composite markets.
Thank you and goodbye.
Raider45
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
There isn't a way to reference another symbol in the Personal Criteria Formula Language in order to write the desired formula.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 9/30/2011
Posts: 788
|
If it's not possible on the Nasdaq and Amex, it's OK on the S & P 500 !
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
It doesn't matter what other symbol you want to reference. The PCF Language can only reference the symbol being used and can't reference any other symbols. You can't mix multiple symbols in the same PCF and the symbol which can be used in the PCF is fixed.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 9/30/2011
Posts: 788
|
So it's OK to change the formula for the two-day period instead of five !
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Assuming everything else remains the same, the two day version would be the following.
1000000 * (LOG(C0) - LOG (C1)) - (-2760.42) > 0
That said, I suspect the (-2760.42) portion of the formula is based on the value of just the following portion of the formula for another symbol.
1000000 * (LOG(C0) - LOG (C1))
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 9/30/2011
Posts: 788
|
Formula Error: Expected ( At position 14
|
|
|
Guest-1 |