![]() |
|
| Discuss can anyone help me? at the MetaStock within the Traderji.com - Discussion forum for Stocks Commodities & Forex; hi guys Im new here btw, I'm now trying to make an explorer formula to ... |
|
|||||||
| Notices |
![]() |
|
|
Thread Tools |
| Sponsored Links |
|
#1
|
|||
|
|||
|
hi guys
Im new here btw, I'm now trying to make an explorer formula to filter out stock that is approaching (is not breaking, but 5% below its 9 months previous high) and volume is above 5 days average...can it be done?? I couldnt figure it out anyone?? thanks a million |
|
#2
|
|||
|
|||
|
Quote:
First collect "Roy's" monthly code & "Jose's" calender day counter from google search,otherwise if you use hhv function (for 9months approx 9*25)for 225days then the back reference date is fixed,which may not give you the desired result. Asish |
|
#3
|
|||
|
|||
|
Quote:
Try this (I'm assuming that there are 185 trading days in the last 9months...it is approximately 185 trading days excluding saturday,sundays and other occasional holidays....even then, it isn't quite probable that the high is at the first few bars, so there won't be much of a difference), Coloumn A: a:= C; b:= HHV(C,185); d:= .97*b; f:= .93*b; g:= V; i:= Mov(V,5,S); a > f AND a < d AND g > i Filter: ColA I have coded it in simple language to increase understanding. The result will give a "1" when the price is below 3% but above 7% from its 185 day high( i.e, from 93% to 97% of its 185 day high) and volume greater than 5day simple average. Oxymoron. |
|
#4
|
|||
|
|||
|
what if I need to check approaching 1 year high?
I just change the HHV in the formula is it? million thanks |
| Sponsored Links |
|
|
![]() |
| Bookmarks |
| Thread Tools | |
|
|
Indemnity, Disclaimer & Disclosure
Notice:
• By visiting Traderji.com you indicate your acceptance of our Forum
Rules Disclaimer & Disclosure and indemnify Traderji.com, its
associates and related parties of all claims howsoever resulting from
the usage of the forum.
• Disclaimer: Trading or investing in stocks & commodities
is a high risk activity. Any action you choose to take in the markets
is totally your own responsibility. Traderji.com will not be liable for
any, direct or indirect, consequential or incidental damages or loss arising out of the use of this information.
• Disclosure: The information in this forum is neither an offer to sell nor solicitation to buy any of the securities mentioned herein.
The writers may or may not be trading in the securities mentioned.
• All names or products mentioned are trademarks or registered trademarks of their respective owners.
General Content Disclaimer Notice:
In light of our policy of encouraging candid, open exchanges of views and the rapid distribution of information originating from many sources, Traderji.com cannot determine the accuracy of information that may be uploaded to the forum. Opinions, advice and all other information expressed by participants in discussions are those of the author. You rely on such information at your own risk. You are urged to seek professional advice for specific, individual situations and not rely solely on advice or opinions given in the discussions. Since Traderji.com is an open and free discussion forum, any comments made by members of this forum in their posts reflect their own views and not of the owner or administrator of Traderji.com. Thus the owner/administrator indemnify themselves of all claims whatsoever and will not be liable or responsible for any members comments/views in this forum Traderji.com. If you find any objectionable or offensive posts made by members of this forum which you would like to bring to our notice for removal then please Contact Us.