Dear Happysingh,

Hello from Athens City, Greece!

I hope to be fine there in India!

Well, i see your Problem.

I believe that i have find a Solution.

In the Indicator Builder of our loved Program Metastock, i have create a New Formula.

You give it any Name, i have give it the Name 2006 INDIA.

Here it is the Code into that Formula:

Day1 := 17;
Month1 := 10;
Year1 := 2005;

100 * (CLOSE - ValueWhen(1,DayOfMonth() = Day1 AND Month() = Month1 AND Year() = Year1, CLOSE))/ ValueWhen(1,DayOfMonth() = Day1 AND Month() = Month1 AND Year() = Year1,CLOSE)

You can modify the Numbers in the:

Day1 (Now have the 17)

Month1 (Now have the 10)

Year1 (Now have the 2005)

That Formula show you the Percentage change from 17/10/2005 until Today, the Current Day.

I will give you and another Example.

New Code:

Day1 := 10;
Month1 := 01;
Year1 := 2005;

100 * (CLOSE - ValueWhen(1,DayOfMonth() = Day1 AND Month() = Month1 AND Year() = Year1, CLOSE))/ ValueWhen(1,DayOfMonth() = Day1 AND Month() = Month1 AND Year() = Year1,CLOSE)

Day1 (Now have the 10)

Month1 (Now have the 01)

Year1 (Now have the 2005)

That means that you show you again, the Percentage change from 10/01/2005 until Today, the Current Day.

Now, you go to your Explorer.

There, in a Column like the A or B or C, etc., you can put the above Code.

In the Filter you can put nothing for to see all the Prices in the Stocks that you choose or the above Code for example like:

Day1 := 17;
Month1 := 10;
Year1 := 2005;

100 * (CLOSE - ValueWhen(1,DayOfMonth() = Day1 AND Month() = Month1 AND Year() = Year1, CLOSE))/ ValueWhen(1,DayOfMonth() = Day1 AND Month() = Month1 AND Year() = Year1,CLOSE) > 25

which means that the Day that you will choose, until the Current Day (Today), (Metastock System) find me Stocks with that Criteria.

If you have not Result at all that means:

Does not exist a Stock to meet that Criteria.

The Day you choose, is a Holiday or Weekend.

In your Explorer you have to choose Periods same or above the Days that you want to make that Exploration until the Current Day (Today).

If you want to choose to make an Exploration fron 17/10/2005 until Today you must choose in the SubTool Options... , Periods at least 300 for example.

I hope to understand all that!

Kind Regards,

George Kanellopoulos.

hey happy .... i'm happy too, to see people posting code requests again..... things had become kinda slow.... questions help us all....

unfortunately the input function does not work well with explorations.... here's a couple other thoughts on valuewhen's.... the first gives ya a rough idea and the second condenses it down to 1 statement.... both will plot as indicators or course.... the dates, in blue, can be manualy reset in the mmddyyyy format..... each should give the difference in closing price between two dates.....h

happy1

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

a:= (Month()*1000000 + DayOfMonth()*10000+ Year())=1032006; {change day to suit}
aa:=ValueWhen(1,a,C);

b:= (Month()*1000000 + DayOfMonth()*10000+ Year())=5032006; {change day to suit}
bb:=ValueWhen(1,b,C);

bb-aa

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

happy2 (condensed one liner of above, may 22,2006 to oct 12, 2006)

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

ValueWhen(1,(Month()*1000000 + DayOfMonth()*10000+ Year())=10122006,C) - ValueWhen(1,(Month()*1000000 + DayOfMonth()*10000+ Year())=5222006,C); {change day to suit}

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

Dear George Kanellopoulos.

Hi from Delhi, India!

I wish you all success and good luck in your life.

Well, i saw your solution.

And I have got the solution in it. Along with that I got to learn one more function that is value when.

I will be glad, If anytime I can be useful to you.

Thanks & regards.

Navneet Singhal (Happysingh)

WWW.COOLGUYNAVNEET.BLOGSPOT.COM