| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 6/9/2006
Posts: 32
|
Can you help me add to my price % change today formula? Each day I update my system and manually create a price % change today percentage that I use in my decision making.
I use 100*(C-C1)/C1 Then I do the following
- Click sort tab 6 (price% change today), click home key
- I now have a list of around 1500 stocks from say +50% down to -18%
- I now space bar down from +50 down through 5,4,3,2,111111 to the last 1 before 0
- When I click on it, it typically says 851 of 1500 That's the percentage I want 56.7%
Do you know of a way to add this to my simple formula
Thanks in advance
|
|
Registered User
Joined: 1/28/2005
Posts: 6,049
|
Are you interested in stocks >0% for the day, because thats what you want to trade or
are you interested in the count because its a measure of how bullish the day was?
For example: A day where 453 stocks in the SP500 were >0% is more bullish than
a day where 237 stocks were >0%.
Thanks
diceman
|
|
Registered User
Joined: 6/9/2006
Posts: 32
|
I am interested in the count it is a measure of how bulish the day was
|
|
Registered User
Joined: 6/9/2006
Posts: 32
|
Actually I am interested in the % to use as a measure of the strength of the list being measured
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
pit111,
You could use the following Personal Criteria Formula as an EasyScan Condition:
C > C1
The number of items in the EasyScan will be the numerator of your equation. The denominator will be the number of items in the WatchList to Scan for the EasyScan.
I do not know of a way to get these numbers or do the calculations automatically in the current version of TeleChart. You will need to look up these numbers and do the math to get the percent result you are looking for manually.
How to create a Personal Criteria Forumula (PCF)
Using EasyScan to find stocks that meet your own criteria
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: 6/9/2006
Posts: 32
|
Thanks for trying
|
|
Registered User
Joined: 6/9/2006
Posts: 32
|
In looking for the denominator - if it was a the same watchlist every time, would that make a difference?
Example if it was the S&P 500
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
If it is the same WatchList, you should just be able to keep using the same number from day to day (although the membership of the S&P 500 does change slowly over time so you would to occassionally check to make sure your number is still correct).
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 6/9/2006
Posts: 32
|
Thanks Bruce
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |