Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Worden Discussion Forum » Customer Training & Support » Ask a Trainer - TC2000 version 7 » PCF for YTD price change

PCF for YTD price change Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
Kirkj21
Posted : Sunday, January 14, 2007 12:33:27 AM
Registered User
Joined: 8/19/2006
Posts: 11
 Gentlemen, is there a PCF for YTD price change? I know I can look at YTD performance by pressing the C key twice and then draging from the beggining of the year but I cam trying to make a pcf so one of my columns will display it.

Thank You

Kirk Jensen
Back to top
diceman
Posted : Sunday, January 14, 2007 9:36:07 AM
Registered User
Joined: 1/28/2005
Posts: 6,049
 Try this:

100 * (C / C཈/29/06' - 1)

Thanks
diceman
Back to top
diceman
Posted : Sunday, January 14, 2007 9:39:22 AM
Registered User
Joined: 1/28/2005
Posts: 6,049
 Dont know what the "square is"
(before the 29)

Should be:

100 * (C / C཈/29/06' - 1)

Thanks
diceman
Back to top
diceman
Posted : Sunday, January 14, 2007 9:40:07 AM
Registered User
Joined: 1/28/2005
Posts: 6,049
 100 * (C / C཈/30/05' - 1)
Back to top
diceman
Posted : Sunday, January 14, 2007 9:44:28 AM
Registered User
Joined: 1/28/2005
Posts: 6,049
 I got this from this post:

http://www.worden.com/training/default.aspx?g=posts&t=11738

Change the calc date to:

12/29/06

For some reason when I copy the equation
it puts a square in the equation
where the 12 should be.

Thanks
diceman
Back to top
bustermu
Posted : Sunday, January 14, 2007 11:25:22 AM
Registered User
Joined: 1/1/2005
Posts: 2,645
 diceman,

'12

will appear as you type it provided you do not click "preview" before you click "post". (I hope.)

If there is another explanation, please delete this post.

Thanks,
Jim Murphy
Back to top
diceman
Posted : Sunday, January 14, 2007 3:24:39 PM
Registered User
Joined: 1/28/2005
Posts: 6,049
 100 * (C / C'12/29/06' - 1)
Back to top
diceman
Posted : Sunday, January 14, 2007 3:25:31 PM
Registered User
Joined: 1/28/2005
Posts: 6,049
 That worked.

Thanks bustermu.

diceman
Back to top
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.