| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 6/15/2015
Posts: 49
|
Hello,
I'm trying to make two columns in my watchlist.
Week To Date Percent Change
Month To Date Percent Change
I see that there is a YTD % Change, but I can't find the others.
Thank you
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
The formula is the same. It is a 1 period price percent change.
100 * (C / C1 - 1)
You just set the time frame of price percent change today to dail, the time frame of week to date to weekly. the time frame of the month to date to monthly, the time frame of the quarterly to date to quarterly. and the time frame of the year to date to yearly.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 6/15/2015
Posts: 49
|
Thanks, Bruce. So to confirm, if I wanted to chose MTD, I'm writing the formula as follows.
100 * (C / C1 - 20)
|
|
Administration
Joined: 9/30/2004
Posts: 9,187
|
No, just change the time frame on the column to "Monthly". You don't need to edit the formula.
|
|
|
Guest-1 |