Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 1/22/2011(UTC)
Posts: 34
Thanks: 1 times
Was thanked: 1 time(s) in 1 post(s)
|
Hi everyone,
I would like to take a stock and calculate its performance increase/decrease as a percentage over the last 20 days.
For example say StockA is trading at $1.00
And 20 days later it is now trading at $1.10
That is a 10% increase. How do I a write this as a formula for use with the MS explorer.
Essentially I want to run this over a large basket of stocks so i can rank them accordingly.
Thank you.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 1/22/2011(UTC)
Posts: 34
Thanks: 1 times
Was thanked: 1 time(s) in 1 post(s)
|
Actually i may have just worked it out. I think it looks ok.
100*((C)- Ref(C,-19))/(Ref(C,-19))
|
|
|
|
|
|
Rank: Advanced Member
Groups: Moderators, Registered, Registered Users, Subscribers
Joined: 10/8/2010(UTC)
Posts: 1,960
Thanks: 92 times
Was thanked: 155 time(s) in 150 post(s)
|
GameTime wrote:Actually i may have just worked it out. I think it looks ok.
100*((C)- Ref(C,-19))/(Ref(C,-19))
That should work, along with the RoC function. You can edit the Equis - Performance Daily exploration to see an example of this.
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
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.
