Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Worden Discussion Forum » Customer Training & Support » Ask a Trainer - TC2000 version 7 » C >= .85 * MAXH252

C >= .85 * MAXH252 Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
m42000
Posted : Saturday, January 5, 2008 3:00:47 PM
Registered User
Joined: 12/21/2007
Posts: 18

What is the syntax for me to find out the stocks on 08/22/2006? for the above formula.  I tried
C >= .85*MAXH252 '08/22/2006' and I getting an error message.
Thanks
Back to top
amberpax
Posted : Saturday, January 5, 2008 3:27:27 PM
Registered User
Joined: 12/30/2004
Posts: 369
 m42000

With this all I get is "False", which is not an error. It just indicates that it is false for that particular security.
When you update your pcf, make sure that you have  "include criteria which require more than 250 days of history" checked.

101.13 >= 0.85 * 121.46 8.00 / 22.00 / 2006.00

-amberpax
Back to top
m42000
Posted : Saturday, January 5, 2008 4:31:10 PM
Registered User
Joined: 12/21/2007
Posts: 18

My problem were the quotation marks  for the dates.  But I am still not getting what I am looking for. 
For example, TNH was 20.44 on that date, but I am getting Fridays data.
Back to top
Winnie
Posted : Saturday, January 5, 2008 5:04:17 PM
Registered User
Joined: 10/7/2004
Posts: 1,006

Please try this, a dot . after the 252 and 06

C >= .85 * MAXH252.'08/22/06'
 
Winnie
Back to top
m42000
Posted : Saturday, January 5, 2008 5:48:40 PM
Registered User
Joined: 12/21/2007
Posts: 18
 Winne:
Thank you for the formula, when I test I get 149.71 >= .85*34.05, which I do not understand.

I should get .85*20.44 = 17.374

What I want is to get all stocks (say in the S&P 500) on 08/22/2006  where C >= .85*MAXH252

Thanks.
Back to top
m42000
Posted : Saturday, January 5, 2008 5:58:28 PM
Registered User
Joined: 12/21/2007
Posts: 18
 Winnie, 
Just to clarify, the 52 week high on 8/22/2006 for TNH was 20.44. Looking at my data this stock would not qualify, but none the less, the test should work.
Thanks.
Back to top
Winnie
Posted : Sunday, January 6, 2008 9:58:15 AM
Registered User
Joined: 10/7/2004
Posts: 1,006
m42000,
 
Lets break down the PCF formula you requested:
C >= .85 * MAXH252.'08/22/06'
 
For the Symbol TNH, close Jan 4, 2008
C = 149.71
C’08/22/06’ = 19.68
H’08/22/06’ = 20.20
MAXH252 = 159.46
MAXH252 * .85 = 135.54
MAXH252.’08/22/06’ = 34.05
85 * MAXH252.'08/22/06' = 28.94
 
The PCF 85% of MAXH 252.’08/22/06’ goes  back from Aug 22, 2006 to somewhere around Aug 2005 which had a MAXH of 28.94
 
Therefore the Boolean PCF is true, Today’s Price C is > .85 * MAXH252.’08/22/06’
 
If you want to search for different criteria please explain, should my clarification not be correct, one of the trainers or bustermu can help.
 
 
Some Notes for Date Syntax:
All Dates need a single quotation mark ‘5/3/06’ and can be used in combination with any PCF such as Price ( C ), Volume ( V ), SMA ( AVGC ), Average Volume ( AVGV ). 
Note the period or dot  .  location after every number.  As far as the Days Ago Parameter, you can use number of days or calendar dates interchangeably. Always confirm that the date you wish to use in this parameter is a market day.
Some examples, if you want the SMA10 of price on December 31, 2005, AVGC10.'12/31/05' , you simply add a period  .  after the SMA10 and add the date notation.
If the expression does not need a period prior to the number of days ago ie. C, then don't use a period before the date C'12/31/04'  Note: Be careful of any brackets
 
C’8/15/06’                                              Returns Close on 8/15/06
C’3/18/06'                                              Returns Close on 3/18/06
V’8/15/06’                                              Returns Volume on 8/15/06
AVGC20.’8/15/06’                                  Returns SMA20 on 8/15/06, a dot . after the AVGC20
AVGC10.'12/31/04'                                 Returns SMA10 on 12/31/04, a dot . after the AVGC10
AVGV90.’8/7/06’                                    Returns AVGV90 on 8/7/06, a dot . after the AVGV90
AVGV30.’2/28/06’                                  Returns AVGV30 on 2/28/06
C - C'06/30/06' / C'06/30/06' *100            Returns Price % Change from 6/30/06 to Today
C - C'1/3/06' / C'1/3/06' *100                    Returns Price % Change from 1/3/06 to Today
C’6/1/06’ - C'1/3/06' / C'1/3/06' *100         Returns Price % Change from 1/3/06 to 6/1/06
C’8/7/06'-C'7/31/06' / C'7/31/06' *100        Returns Price % Change from 7/31/06 to 8/7/06
100*(C’6/1/06’) / (C’1/3/06’) -100              Returns Price % Change from 1/3/06 to 6/1/06
100*(C’6/30/06’) / (C’12/30/05’) -100         Returns Price % Change from 12/30/05 to 6/30/06
C'6/1/06' - C'1/3/06'                                 Returns Price Net Change from 1/3/06 to 6/1/06
C’3/31/06 - C'1/3/06' > 0                         Returns 1st Quarter 06 as positive
C'7/31/06' > AVGC20.'7/31/06'                 Returns Price above SMA20 on 7/31/06
 
Returns % Decline from 11/14/05 to 5/12/06 (MINL for 123 days between the two dates)
100 * MINL123.'5/12/06' / C'11/14/05' - 100
 
Returns % Increase from 11/14/05 to 5/12/06 (MAXH for 123 days between the two dates)
100 * MAXH123.'5/12/06' / C'11/14/05' - 100
 
Hope this helps
Winnie
Back to top
bustermu
Posted : Sunday, January 6, 2008 1:50:42 PM
Registered User
Joined: 1/1/2005
Posts: 2,645
 m42000,

The PCF:

C'08/22/06' >= 0.85*MAXH252.'08/22/06'

is likely what you are after.

Thanks,
Jim Murphy
Back to top
Winnie
Posted : Sunday, January 6, 2008 2:07:13 PM
Registered User
Joined: 10/7/2004
Posts: 1,006
bustermu,
 
Thanks for stepping in, we can always can count on you. I want to get the new users to think for themselves by giving them examples so they can see the light go on.  Sometimes the questions are not clear and the trainers don’t have the time to give them all the variables or what the user really wants.
 
I have learned so much from you through these posts and there is so much more to learn but it’s nice to share this information with the new users who want to learn TeleChart.
 
Happy New year
 
Thanks
Winnie
Back to top
m42000
Posted : Sunday, January 6, 2008 4:41:16 PM
Registered User
Joined: 12/21/2007
Posts: 18
 Thank you to both of you. You have been very helpful.
William
Back to top
m42000
Posted : Wednesday, January 9, 2008 9:10:38 PM
Registered User
Joined: 12/21/2007
Posts: 18

Hi:

When I scan, the number of symbols keep going up from day to day for my PCF?. Not so much, but two or three. That concerns me.

C'08/22/06' >= 0.85*MAXH252.'08/22/06'

 
Back to top
m42000
Posted : Wednesday, January 9, 2008 11:56:59 PM
Registered User
Joined: 12/21/2007
Posts: 18

Is there a way  to export the closing prices ONLY for all stocks that I get using PCF:
C'08/22/06'>=0.85*MAX252.'08/22/06' ? I want to check if my PCF and SCAN are working properly. 
Thanks.
Back to top
Bruce_L
Posted : Thursday, January 10, 2008 8:52:34 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
 m42000,
If you use the Personal Criteria Formula as an EasyScan Condition, you can copy all of the symbols in the EasyScan to a Personal Watchlist. You can then export the symbols in the Personal Watchlist as a text file. You may wish to review the following:

Using EasyScan to find stocks that meet your own criteria
How to create your own Personal WatchList
Exporting data to text format - comma, space or tab delimited
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Back to top
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.