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

Do AVG fuctions include today's values? Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
qyang
Posted : Wednesday, October 6, 2010 11:02:19 AM
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!
Bruce_L
Posted : Wednesday, October 6, 2010 11:07:17 AM


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
qyang
Posted : Wednesday, October 6, 2010 11:18:39 AM
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!
Bruce_L
Posted : Wednesday, October 6, 2010 11:19:58 AM


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
grimmer01
Posted : Wednesday, October 6, 2010 1:21:36 PM
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
Bruce_L
Posted : Wednesday, October 6, 2010 1:25:46 PM


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
grimmer01
Posted : Wednesday, October 6, 2010 1:34:38 PM
Registered User
Joined: 2/24/2005
Posts: 58
So Simple...yet Awesome advice!  

thanks a Million Bruce!
Bruce_L
Posted : Wednesday, October 6, 2010 1:37:16 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
You're welcome.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
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.