Registered User
Joined: 5/28/2012
Posts: 12
|
I'm trying to develop a watchlist of major indices/ sectors of the market.
I'd like to make columns to show how these sectors have done over the past week, month, ytd, and year.
I only found the % chg ytd on the pre-built columns. I'd like to build ones for % change week, % change month, and % change year.
Does anyone know how to build columns to show that?
Thanks!
-Mike
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
If you mean Calender Week to Date, Month to Date and Year to Date, you can just use the same Indicator Formula for each one with the Time Frame set to Weekly, Monthly or Yearly as desired:
100 * (C / C1 - 1)
You could also use a Daily Time Frame with one of the following Indicator Formulas to approximate a Week, Month or Year. For Weekly you would use the following Indicator Formula with a Daily Time Frame:
100 * (C / C5 - 1)
For Monthly you would use the following Indicator Formula with a Daily Time Frame:
100 * (C / C21 - 1)
For Yearly ou would use the following Indicator Formula with a Daily Time Frame:
100 * (C / C252 - 1)
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
Registered User
Joined: 5/28/2012
Posts: 12
|
Thank you Bruce! I appreciate it.
-Mike
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|