| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 11/7/2007
Posts: 8
|
Does AVGC20 include C? or AVGV20 include V? that is:
is AVGV20 =
(V+V1+V2+...+V19)/20 or
(V1+V2+V3+...+V20)/20?
So if AVGV20 is the first formula, AVGV20.1 is the second. Or if AVGV20 is the second one, AVGV20.1 is
(V2+V3+V4+...+V21)/20, right?
Also, when does Telechart reset the date? i.e. C becomes C1, at midnight EST? or when market opens at 9:30am EST or some other time?
Thanks a lot!
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
C is the Close of the most currently downloaded Bar at the time the formula was updated.
V is the Volume of the most currently downloaded Bar at the time the formula was updated.
AVGC20 is the 20-Period Simple Moving Average including the most currently downloaded Bar (including C) at the time the formula was updated.
So AVGV20 is the first formula and AVGV20.1 is the second formula.
If you haven't downloaded for five weeks, then C would be the Close from five weeks Ago. If you have downloaded today and received data for today, then C is today.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 11/7/2007
Posts: 8
|
Thank you guys very much!
So if I update/download today before market opens, say around 9am, C is still the close from yesterday, right?
Again, thanks a lot!
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Yes, if you download before data is available for today, then C is still the value for yesterday (well it could be earlier if yesterday was a weekend or Market Holiday).
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 2/24/2005
Posts: 58
|
Hello Bruce. I have the following 4 PCFs that i combined to create an EasyScan.
AVGV5 >= 15000
(the name i gave it is: VOL AVG 5 of 1.5 Million)
C >= 8 AND C <= 60
(the name i gave it is: $8-$60)
MINV5 > 10000
(the name i gave it is: Min Vol Past 5 DAys of 1 Million)
((((H - L) + (H1 - L1) + (H2 - L2) + (H3 - L3) + (H4 - L4) + (H5 - L5) + (H6 - L6) + (H7 - L7) + (H8 - L8) + (H9 - L9) + (H10 - L10) + (H11 - L11) + (H12 - L12) + (H13 - L13)) / 14)) / C
(the name i gave it is: ATR 14 / Price)
Here is the Criteria of the EasyScan:
Watchlist: All Stocks
VOL AVG 5 of 1.5 Million (True)
$8-$60 (True)
Min Vol Past 5 DAys of 1 Million (True)
ATR 14 / Price (List Rank 90 to 99).
Similar to what Gyang was asking, is there any way to update my PCFs or EasyScan to only run the scan for End of Day data? I am currently using 5 minute charts (do i need to change the time frame?)
When i run the EasyScan at 9 AM EST, i can get anywhere from 1 to 15 stocks. But if i run the scan again around 12 PM EST on the same day, i get a different list (like you already posted, i'm assuming TeleChart is taking intraday data into consideration). I was wondering if there was any way to run the EasyScan at any point during the day (i.e. today) and still get results that use yesterday's closing data.
thanks in advance!
Will
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
If you want to use yesterday's values, write the formulas to use yesterday's values.
PCF Formula Descriptions
AVGCV5 >= 15000
Becomes:
AVGV5.1 >= 15000
C >= 8 AND C <= 60
Becomes:
C1 >= 8 AND C1 <= 60
MINV5 > 10000
Becomes:
MINV5.1 > 10000
((((H - L) + (H1 - L1) + (H2 - L2) + (H3 - L3) + (H4 - L4) + (H5 - L5) + (H6 - L6) + (H7 - L7) + (H8 - L8) + (H9 - L9) + (H10 - L10) + (H11 - L11) + (H12 - L12) + (H13 - L13)) / 14)) / C
Becomes:
(AVGH14.1 - AVGL14.1) / C1
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 2/24/2005
Posts: 58
|
So Simple...yet Awesome advice!
thanks a Million Bruce!
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |