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

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.