Rank: Advanced Member
Groups: Registered, Registered Users, Unverified Users
Joined: 9/18/2008(UTC)
Posts: 37
|
hi i need a help for a formula
i ve metastock 10.1
i would like to normalize in a indicator an index considered in a given period from -100 to 100 following to this formula
((P-MEDIA)/(MAX-MEDIA))*100
where:
P is a price close of my index ( per example =Security("C:\BULLBEAR\DATI\INDEX\gdax",C);
MEDIA = (Max+min)/2 ... max and min of the price in a considered time 200 days or less or more ( the max and the min of price in this period)
can you translate in metastock formula?
thank you
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Unverified Users
Joined: 9/13/2004(UTC)
Posts: 673
Location: Salt Lake City, UT
|
Not really sure on the normalizing part, but I think this would follow the formula you described. Also if you wanted to use the Close price for the HHV or LLV just substitute C in place of the H and L.
Indx:=Security("C:\Bullbear\Dati\Index\GDAX",C); HP:=HHV(H,200); LP:=LLV(L,200); Media:=(HP+LP)/2; ((Indx-Media)/(HP-Media))*100
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Unverified Users
Joined: 9/18/2008(UTC)
Posts: 37
|
|
|
|
|
|
|
| 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.
