Discussions
»
Product and Service Development
»
Formula Assistance
»
How to display MACD() for Day-1 when using Explorer?
Rank: Newbie
Groups: Registered, Registered Users
Joined: 5/13/2007(UTC)
Posts: 3
|
Hi,
I am new to Metastock and I am trying to understand Explorer. One of the things I wanted to do was to filter securities by MACD() values for latest day and day-1. But I cannot any way how to calculate it. All i get is MACD() for 'today'.
Any ideas you could share?
Dragonik.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
Dragonik,
Welcome to the Forum.
Have a look in your MS Users Manual for the Ref() function. It will do what you require.
NOTE : Unless you want to get really technical, the Ref() function will not return the value on the previous DAY, it will return the value of the previous BAR. If the equity trades every day and you're looking at a daily chart, then yes, the Ref() will return the value of the previous day, but if it is a thinly traded equity the previous bar might be representing the last trading day that might have happened days/weeks/months/years ago.
Hope this helps.
wabbit [:D]
P.S. You might also like to look p the ROC() or "rate of change" function too.
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users
Joined: 5/13/2007(UTC)
Posts: 3
|
Hi Wabbit,
that was quick !!!. Thank you a lot. It works. I tried with data array prev but did not get anything but Ref() works.
bye.
Dragonik.
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Discussions
»
Product and Service Development
»
Formula Assistance
»
How to display MACD() for Day-1 when using Explorer?
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.
