Rank: Newbie
Groups: Registered, Registered Users, Subscribers
Joined: 8/13/2013(UTC)
Posts: 2
Location: Bergen, Norway
|
Hi everyone,
I'm new to metastock and I'm trying to set up an new exploration.
As part of this I'm trying to calculate 1 year performance for an instrument using Ref(OPEN,-365).
I was expecting to get the open 365 days ago, but it seems to pick an almost random open 6-14 months back. I've tried to load everything from minimal, 365 and up to 1000 without any effect.
My formula for calucating the 1 year performance is: (CLOSE-Ref(OPEN,-365))/Ref(OPEN,-365)*100
Can anyone of the experienced metastock users please guide me in the right direction to solve this?
Regards, Helge Hannisdal
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 3/6/2010(UTC)
Posts: 113
Location: London
|
Do remember that there are approximately 252 trading days a year, due to weekends.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 7/25/2005(UTC)
Posts: 1,042
Was thanked: 57 time(s) in 54 post(s)
|
Hi Helge
I've sent you a couple of private messages and received no response as yet. Can I assume that you've lost interest in the project or is it that you've not received my messages?
Roy
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users, Subscribers
Joined: 8/13/2013(UTC)
Posts: 2
Location: Bergen, Norway
|
Hi,
Thanks for responding, i got your message!
I had e-mail notifications turned off, so i did not see the response here of the private message before now.
252 days works ok, but ill defintly also try the more advanced approach mentioned in the message.
|
|
|
|
|
|
| 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.
