| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 10/13/2005
Posts: 20
|
Hi,
I am trying to create a simple PCF which can filter stocks with a BOP value > 0 for last 5 days. I used
MIN(BOP1,5) > 0 but it does not give me the desired results. I also used MIN(BOP1,5) > 40 to filter the stocks with green BOP for last 5 days. May be I do not understand how to use the BOP function. Any help is very much appreciated . Thanks
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
There is currently an issue where Balance of Power does not work correctly with the MIN() or MAX() functions. Development is aware of the issue. For now, you would need to expand the formulas manually. For example a formula for BOP being above zero for the last 5-bars could be written as:
BOP > 0 AND BOP1.1 > 0 AND BOP1.2 > 0 AND BOP1.3 > 0 AND BOP1.4 > 0
While a formula for Green BOP for the last 5-Bars could be written as:
BOP > 30 AND BOP1.1 > 30 AND BOP1.2 > 30 AND BOP1.3 > 30 AND BOP1.4 > 30
How to create a Personal Criteria Forumula (PCF)
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/13/2005
Posts: 20
|
Hi Bruce,
It worked. Thanks for your quick response.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/13/2005
Posts: 20
|
Hi Bruce,
Could you also provide a pcf for the case where BOP being red for the last 5-bars? Thanks
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
A formula for Red BOP for the last 5-Bars could be written as:
BOP < (-30) AND BOP1.1 < (-30) AND BOP1.2 < (-30) AND BOP1.3 < (-30) AND BOP1.4 < (-30)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/13/2005
Posts: 20
|
Hi Bruce,
Thanks for your help. regards
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/13/2005
Posts: 20
|
Hi Bruce,
I am sorry to bother you again. I tried to use a simple formula
BOP > 0 AND BOP1.1 > 0 AND BOP1.2 > 0 AND BOP1.3 > 0 AND BOP1.4 > 0
as you mentioned for a easy scan and I see several stocks which are negative BOP (or simply red BOP) for last 5 bars. It doesn't look right to me. Other easy scans working OK and I am wondering if there is a problem with the BOP calculation.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Could you provide some example symbols where you think the formula is not producing the correct result? I cannot find any symbols where this is the case on my computer.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/13/2005
Posts: 20
|
Hi Bruce,
In my computer I created a simple easy scan starting with all us stocks (Volume > 1500). I used the above formula as a pcf and the result is that I am seeing so many stocks which have negative or red BOP. To name a few:
dsx
urre
llen
Now if I use the green BOP formula shown above these will show up too (which is not correct). Am I doing this correctly?
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
None of the symbols listed return True for the Personal Criteria Formula given and are not included in any EasyScans where I include that PCF as an EasyScan Condition.
Please try recreating both the Personal Criteria Formula and EasyScan and make sure that your PCFs are updated.
How to create a Personal Criteria Forumula (PCF)
Using EasyScan to find stocks that meet your own criteria
If this does not resolve the issue, please contact technical support.
All e-mail communication sent to support@worden.com during business hours (Monday through Friday 9AM-11PM and Saturday and Sunday 9AM-3PM ET) should be answered within 20 minutes of arrival.
For an even quicker response to tech support questions, we recommend calling our voice line at (919) 408-0542 (there is no phone support on Sundays, some Market Holidays or after 9PM ET on weekdays).
You can also contact us using Live Chat Support during business hours.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/13/2005
Posts: 20
|
Hi Bruce,
I contacted tech support and we found the problem. For some reason, my PCFs were not updating and once we fixed the problem they look OK. Thanks for pointing to right direction.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |