| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 3/12/2005
Posts: 7
|
Sir:
Would you send me the formula for using weekly data.
Not the 5th day from the prior week (ie, C-C5 or V-V5), but the full 5 days from the prior week's full 5 days.
Will I have to use C + C1+ C2 + C3 + C4 (or using volume: V + V1....)?
I was using my Personal Criteria Formulas (PCF), and I accidentally deleted my weekly equation.
( I'm sorry for not being acquainted with the protocols of this forum; the phone line modem I use is too slow to receive the WebMovie information on how to use forums. Also, I'm an individual investor (this is my job), and I don't have time to search on the forum for how to do a specific task.)
I put my Email address below, because I'm not sure I can find my way back to this area again. I've been a member since the early 90's so I am grateful for any forebearance the Worden Trainers show me....
Bryan Taplits
Cincinnati, OH
(email removed by moderator)
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Personal Criteria Formulas are always based on Daily data, but it is frequently possible to create Weekly PCFs using Daily data (or other Time Frames for that matter - Monthly would be based on multiples of 21 instead of multiples of 5). The technique for converting a formula from Daily to Weekly varies depending on the formula (keep in mind that Weeks in TeleChart are based on rolling 5-Trading Day Bars and that I do not know of a practical automated method of creating Calender Weeks or Months in TeleChart).
For the Open, multiply the days ago parameter by 5 and add 4 to get the weekly version.
O = O4
O1 = O9
O2 = O14
For the High, H is replaced by MAXH5 and if there is a days ago parameter in the daily version, multiply it by 5 and separate it from MAXH5 with a '.'.
H = MAXH5
H1 = MAXH5.5
H2 = MAXH5.10
The Low is treated very much like the High. L is replaced by MINL5 and if there is a days ago parameter in the daily version, multiply it by 5 and separate it from MINL5 with a '.'.
L = MINL5
L1 = MINL5.5
L2 = MINL5.10
The Close is probably the simplest. Just multiply the days ago parameter in the daily version by 5 to get the weekly version.
C = C
C1 = C5
C2 = C10
Volume is an interesting case. To get the actual Volume for a weekly bar (in Blocks of 100), you would need to multiply the Average Volume by 5. So V would be replaced by AVGV5 and if there is a days ago parameter in the daily version, multiply it by 5 and separate it from MINL5 with a '.' just like with the High and Low. But add *5 to the end of each weekly version whether or not there is a days ago parameter.
V = AVGV5*5
V1 = AVGV5.5*5
V2 = AVGV5.10*5
That said, if you are just comparing one Volume to another, there really isn't a reason to multiply it by 5 at all:
AVGV5*5 > AVGV5.5*5
Will return the same result as:
AVGV5 > AVGV5.5
Things can get a lot more complicated for weekly versions of some indicators. Weekly versions of both Simple and Exponential 6-Period Moving Averages follow as an example:
Weekly SMA6:
(C + C5 + C10 + C15 + C20 + C25) / 6
Weekly EMA6:
.285958411765876 * (C + 5 / 7 * (C5 + 5 / 7 * (C10 + 5 / 7 * (C15 + 5 / 7 * (C20 + 5 / 7 * (C25 + 5 / 7 * (C30 + 5 / 7 * (C35 + 5 / 7 * (C40 + 5 / 7 * (C45 + 5 / 7 * (C50 + 5 / 7 * (C55 + 5 / 7 * (C60 + 5 / 7 * (C65 + 5 / 7 * (C70 + 5 / 7 * (C75 + 5 / 7 * (C80 + 5 / 7 * (C85 + 5 / 7 * (C90 + 5 / 7 * (C95 + 5 / 7 * (C100)))))))))))))))))))))
In same cases, it is not possible to write a weekly version (a weekly TSV for example).
Indicators on the Chart are based on Bars (with all of the settings being in Periods, not Days), so if you adjust the Time Frame, it will automatically adjust all of the Indicators to match. You may wish to review the following:
How to create a Personal Criteria Forumula (PCF)
Plotting Custom Indicators with Examples
PCF Formula Descriptions
Cascades of Moving Averages
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 3/12/2005
Posts: 7
|
Thanks, Bruce, for the speedy reply.
It will take me some time to digest the logic in the formulas.
The way you converted volume to weekly is ingenious (I'd never before considered using AVG for this). As a matter of fact, it puzzles me why you the same logic isn't used with C (closes); although, I realize it won't be an exact match with weekly, like volume it will be close.
Also, I'm not sure I understand the MAX PCF as you stated it. As I understood it in what I've read in the PCF explanation in Worden help on my computer (I haven't read the links you sent me; perhaps, the info will be in there). The Max tells you the highest high (or close, or low) for a certain period. For instance, MAXH5 would mean the highest high in the last 5 periods.
But what does the number after the . mean? You say, "...it is a day's ago parameter"-but what exactly does that mean. That MAXH5.2 means the highest high in the last 3 days (5-2) or does it mean the highest high in the last 2 days (The ".2" indicating the last 2 days)?
Both of these interpetations, as I view it, can be read as "days ago parameters"
Anyway, you have a nice weekend, and many thanks again.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
The reason you would not use AVGC5 for the Weekly Close is that the Close of the Week is just the Close of the last day of the Week and not the average of all of the Closes of the Week.
Only one of the parameters can be interpreted as a days ago parameter.
MAXH5.2 is the Highest High of the 5-Bars (Trading Days in a Personal Criteria Formula) ending 2-Bars ago.
The 5 is the Period over which the Maximum High is being calculated while the 2 is the number of Bars Ago that the Period ends.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |