Registered User
Joined: 12/26/2009
Posts: 50
|
Would like to know how I can add Historical volatility (50 days) to TC?
Thx
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Please try the following:
Select Chart Template | Add Indicator | Indicator.
- Visible: Checked
- Center Zero Line: Unchceked
- Plot using price scale: Unchecked
- Smoothing Average: 1
- Average Type: Doesn't matter (because the Smoothing Average is 1)
- Indicator Formula: 1600 * SQR((LOG(C / C1) ^ 2 + LOG(C1 / C2) ^ 2 + LOG(C2 / C3) ^ 2 + LOG(C3 / C4) ^ 2 + LOG(C4 / C5) ^ 2 + LOG(C5 / C6) ^ 2 + LOG(C6 / C7) ^ 2 + LOG(C7 / C8) ^ 2 + LOG(C8 / C9) ^ 2 + LOG(C9 / C10) ^ 2 + LOG(C10 / C11) ^ 2 + LOG(C11 / C12) ^ 2 + LOG(C12 / C13) ^ 2 + LOG(C13 / C14) ^ 2 + LOG(C14 / C15) ^ 2 + LOG(C15 / C16) ^ 2 + LOG(C16 / C17) ^ 2 + LOG(C17 / C18) ^ 2 + LOG(C18 / C19) ^ 2 + LOG(C19 / C20) ^ 2 + LOG(C20 / C21) ^ 2 + LOG(C21 / C22) ^ 2 + LOG(C22 / C23) ^ 2 + LOG(C23 / C24) ^ 2 + LOG(C24 / C25) ^ 2 + LOG(C25 / C26) ^ 2 + LOG(C26 / C27) ^ 2 + LOG(C27 / C28) ^ 2 + LOG(C28 / C29) ^ 2 + LOG(C29 / C30) ^ 2 + LOG(C30 / C31) ^ 2 + LOG(C31 / C32) ^ 2 + LOG(C32 / C33) ^ 2 + LOG(C33 / C34) ^ 2 + LOG(C34 / C35) ^ 2 + LOG(C35 / C36) ^ 2 + LOG(C36 / C37) ^ 2 + LOG(C37 / C38) ^ 2 + LOG(C38 / C39) ^ 2 + LOG(C39 / C40) ^ 2 + LOG(C40 / C41) ^ 2 + LOG(C41 / C42) ^ 2 + LOG(C42 / C43) ^ 2 + LOG(C43 / C44) ^ 2 + LOG(C44 / C45) ^ 2 + LOG(C45 / C46) ^ 2 + LOG(C46 / C47) ^ 2 + LOG(C47 / C48) ^ 2 + LOG(C48 / C49) ^ 2 + LOG(C49 / C50) ^ 2 - (LOG(C / C50) ^ 2) / 50) / 50)
You may wish to review the following:
Historical Volatility (HV)
Plotting Custom Indicators with Examples
How to create a Personal Criteria Forumula (PCF)
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
 Platinum Customer
Joined: 10/7/2004
Posts: 15
|
We are utilizing this historical volatility indicator. Now we monitor many equities with this indicator.
We have taken this PCF and have created a columni in our watchlist.
We woud like to have the values displayed as a percentage of the volatility in relation to te historical volatiity. Then we can scan and sort based on those equities in our watch list in relation to the highest current volatility as a percent to its historical volatility.
How do we do this?
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Percentages are always what percent one thing is as a percentage of some other thing.
The formula given in this topic is a 50 period historical volatility. If you want this to be the historical volatility, what specifically do you want to use as the "volatility"?
Normally this sort of thing is done using the historical volatility ratio which would divide a historical volatility indicator with a short period by a historical volatility indicator with a longer period. This is explored in the Historical Volatility (HV) topic with example formulas.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|