Worden Discussion Forum

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

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

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

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)

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

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

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)

diceman

Posted : Sunday, January 14, 2007 3:25:31 PM

Registered User
Joined: 1/28/2005
Posts: 6,049

That worked.

Thanks bustermu.

diceman

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.