| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 5/5/2008
Posts: 15
|
How would I customize my MA according to a certain price. For ex.- I want all stocks where the 18day MA is crossing above the 40day Ma and going up in a price range from $25- $50.
Thank you,
DG
|
|
Worden Trainer
Joined: 4/26/2007
Posts: 508
|
DenaGela,
Let me make sure I understand. Do you want to identify stocks that have an 18(day) MA crossing up through the 40(day) MA only if the Price of the stock is 'going up' and falls within a price range of $25-$50?
This shouldn't be hard to accomplish, but we'll need to know specifically what you're asking.
Thanks,
Julia
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
DenaGela,
You would test for the Moving Average being in the desired range, but the exact formula will depend on if the Moving Averages are Simple or Exponential. Please try one of the following Personal Criteria Formulas:
Simple Moving Averages:
AVGC18 > AVGC40 AND AVGC18.1 <= AVGC40.1 AND AVGC18 > AVGC18.1 AND 25 <= AVGC18 AND AVGC18 <= 50
Exponential Moving Averages:
XAVGC18 > XAVGC40 AND XAVGC18.1 <= XAVGC40.1 AND XAVGC18 > XAVGC18.1 AND 25 <= XAVGC18 AND XAVGC18 <= 50
You may wish to review the following:
PCF Formula Descriptions
How to create a Personal Criteria Forumula (PCF)
Moving Average PCF Templates
Things to check if your moving averages don't "seem right" or "seem to match"
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 5/5/2008
Posts: 15
|
I would like all stocks in the $25- $50 range where those stocks have their 18 dayMA crossing their 40 day MA and the 18 day MA is above the 40 day MA
Thanks,
DG
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
DenaGela,
If you do not actually have a requirement for the 18-Period Moving Average to be increasing and you want Price (as opposed to the Moving Average) to be between $25 and $50, you may wish to try one of the following Personal Criteria Formulas instead:
Simple Moving Averages:
AVGC18 > AVGC40 AND AVGC18.1 <= AVGC40.1 AND 25 <= C AND C <= 50
Exponential Moving Averages:
XAVGC18 > XAVGC40 AND XAVGC18.1 <= XAVGC40.1 AND 25 <= C AND C <= 50
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 5/5/2008
Posts: 15
|
Why when I put the formula in ( I have with my other formulas also) do I still get all the stocks at all price ranges. This is what I did. Please let me know if I am making a mistake
AVGC18 > AVGC40 AND AVGC18.1 <= AVGC40.1 AND AVGC18 > AVGC18.1 AND 25 <= AVGC18 AND AVGC18 <=50
THANKS
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
DenaGela,
A Personal Criteria Formula just returns a numeric or Boolean result. It doesn't do anything to your Watchlist by itself. You will generally use a PCF as a sort or as an EasyScan Condition.
When used as a sort, it re-arranges the Active Watchlist in either Ascending or Descending order (depending on which is selected).
Create your own stock rankings using WatchLists and Sort conditions
When used as an EasyScan Condition, it will limit the resulting EasyScan to those where a Boolean PCF returns True or where a value of a value based PCF falls within the range set in the EasyScan Rangefinder for that EasyScan Condition.
Using EasyScan to find stocks that meet your own criteria
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 5/5/2008
Posts: 15
|
None of the formulas are working
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
If your Personal Criteria Formulas are updated but are not returning the correct results when added to an EasyScan, please contact technical support (you will want to mention this forum topic when you contact them so they have the proper background to understand your issue).
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
|
|
|
Guest-1 |