Urgent help needed in ploting Date in Metastock Exploration

#1
Hello everybody
I am Deepak and would seek your help in creating an exploration indicator which tells the Low or High date in mm-dd-yyy format.

For eg if I run an exploration of 20 stocks I would want to know in the given year say 2015 which day-month-year did it make its 52 wk low.
I want to copy this data in excel and not plot it on a stock chart.

I have tried the MS indicator builder list under: tools-->The Explorer--->New
Year's Hi/Lo dates
AND
High/Low of Date Period
All the indicators under this list have been unable to provide me the desired details.

Hence please help I would be very thankful to you.

Deepak
 

rkkarnani

Well-Known Member
#2
Not much idea about this. If you get the results in exploration, I thin you can export to excel.
Also
Found this on Net.

MetaStock -> Tools -> The Explorer -> New
Copy and paste formula below.


==================
True 52-Week Highs
==================
---8<---------------------------

52-Week true Highs

*Input today's data date in filter section!*

Only stocks trading since 52 weeks ago are considered candidates for this exploration.
Rem out code {AND V>0} in filter section to explore for non-volume instruments, such as indices and Forex.

{ ©Copyright 2003 Jose Silva }


------------------

Column A: Close

CLOSE

------------------

Column B: % change

{ % change from previous Close }
Int((C/Ref(C,-1)-1)*1000+.5)/10

------------------

Column C: $'000

{ today's turnover in $'000 }
Int((MP()*V+500)/1000)

------------------

Filter:

{ Today's data date, user input section }

day:= 18; { today (1~31) }
mth:= 9; { current month (1~12) }
yr:= 2003; { current year, eg 2003 }

{ *********************************** }

active:=Year()>yr-1
OR (Year()=yr-1 AND (Month()>mth
OR Month()=mth AND DayOfMonth()>=day));
start:=active AND Alert(active=0,2);

DayOfMonth()=day
AND Month()=mth
AND Year()=yr
AND Highest(start)
AND C>Ref(HighestSince(1,start,C),-1)
AND V>0

---8<---------------------------
 
#3
Thank you Sir but it does not resolve my query


What I need is that when I run explorer I get the Low dates in a given year for a given stock in mmddyyyy or any date format that can be exported to excel.

Thanks anyway.
 

rkkarnani

Well-Known Member
#4
Thank you Sir but it does not resolve my query


What I need is that when I run explorer I get the Low dates in a given year for a given stock in mmddyyyy or any date format that can be exported to excel.

Thanks anyway.
What are you getting presently in your Explorer Reports?
 
#5
Hi
Using your exploration I got NA as all securities were rejected even after changing the date to 17-06-2016 as my data is up to date till then.
Now when I am using the custom indicator function FmlVar("High/Low of Date period",XXXX) I am either getting 1.000 or 0.000 or 2006 (since data is from 2006 onwards).

I need a date in a year for the lowest a share has gone.

for eg I set the period for expolration as 2015 daily and load 250 records (which is the total trading days) and take for eg 20Microns then when I run an exploration it should show
Close(52wk low) Date (date of the low)
24.95 240915

Please help I would be very grateful.

Regards

Deepak
 
Last edited:

Similar threads