| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 12/17/2006
Posts: 69
|
Not sure if I can do this with Telechart but I thought I'd ask.
I want to create a calculated field for display in the watchlist that shows the average of 1/3/6/12 month returns. I would then want to sort based on this field.
Is this possible to do with Telechart?
Thanks in advance,
dmwr
|
|
Registered User
Joined: 1/28/2005
Posts: 6,049
|
You may be interested in this:
quick question
The strongest stocks in the strongest industry
Thanks
diceman
|
|
Registered User
Joined: 12/17/2006
Posts: 69
|
Very helpful - for reference, I used the following:
AVG(((C/C21*100)-100),((C/C63*100)-100),((C/C125*100)-100),((C/C250*100)-100))
Does this look right in terms of what I was trying to do?
Thanks!
|
|
Registered User
Joined: 1/28/2005
Posts: 6,049
|
This is your PCF?
You are trying to average them into one value?
You would have to use this format:
(1month%+3month%+6month%+1year%)/4
(you are creating an average by adding the
4 values and dividing by 4)
Thanks
diceman
|
|
Administration
Joined: 9/30/2004
Posts: 9,187
|
Try this:
((((C-C21)/C21) + ((C-C63)/C63) + ((C-C126)/C126) + ((C-C252)/C252))/4)*100
|
|
Registered User
Joined: 12/17/2006
Posts: 69
|
Cool - thanks for the feedback.
|
|
|
Guest-1 |