| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 1/20/2005
Posts: 2
|
I inadvertently emailed Tech Support requesting PCF information for the purpose of converting the various Percent Changes found in TC2000 sorts for converting Percentages into Dollars & Cents. If there is a "canned" PCF or some way to assist me in my quest, I would certainly appreciate it. I am not PCF literate enough to devise the appropriate formula myself. Thank you for your courtesy. (removed by Moderator)
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Here is Net Change Today
C-C1
Here is Net Change 1-month
C-C21
Here is Net Change 26-weeks
C-C250
Get the idea?
- Craig
Here to Help!
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 4,308
|
Let's say you were looking at the 5 day price percent change. The underlying formula is:
(C-C5)/C5 * 100
To have the net change for 5 days (in dollars and cents, the formula is simply:
C-C5
For any net change period simply change the 5 to whatever period you want. You will create a new PCF, and use the above net change formula.
In case you need some help creating PCF's, here is a video that will help:
How to create a Personal Criteria Forumula (PCF)
- Doug
Teaching Online!
|
|
|
Guest-1 |