logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
kanellop  
#1 Posted : Saturday, October 15, 2005 11:53:02 AM(UTC)
kanellop

Forum Rank:: Advanced Member

Groups: Registered, Registered Users
Joined: 6/3/2005(UTC)
Posts: 181

Especially Attention of Jose. Dear Jose, I want to please you to do something for me. To tell me, if you believe, that can create the following thing for the Explorer. Do you believe that exist opportunity to the Explorer to exist something like: Suppose that you Start to make an Exploration, then the result to save it into your Hard Disc with a Name automatically, then the Explorer to make New Exploration based to the File that exist in your Hard Disc based in Previous Exploration Result, then the new result to save it into your Hard Disc with a New Name automatically, etc. This thing will save me a lot of Hour, because does not need to be in presence near My Metastock for to to do the above things manually. Do you have opinion on that? Also that thing is possible to creating, using only Metastock Formulas? #-o George Kanellopoulos.
Jose  
#2 Posted : Saturday, October 15, 2005 2:13:55 PM(UTC)
Jose

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 1/19/2005(UTC)
Posts: 1,065
Location: Koh Pha-Ngan, Earth

Was thanked: 2 time(s) in 2 post(s)
George, it's my view that it would be best if you could amalgamate all exploration iterations into one single MetaStock formula. Any help with this would only be possible if you post your exploration filter code here. jose '-)
kanellop  
#3 Posted : Saturday, October 15, 2005 7:05:50 PM(UTC)
kanellop

Forum Rank:: Advanced Member

Groups: Registered, Registered Users
Joined: 6/3/2005(UTC)
Posts: 181

Dear Jose, YOU BRING ME LUCK!!! I quiet believe that you give me Solution to my Problem in Nano-Seconds!!! I want to say that i thinking more your answer and i believe that your Way is very good way for Solution! First i want to say for Help, that i make the Explorations in the U.S.A Markets. My Fundamental, my beginning Exploration include all the Stocks that are in the U.S.A Exchanges separate with the ReutersDatalink System of Folders except the Stocks that are in the Sector Technology and in the Sub-Folder Software & Programming and in the Sector Healthcare and in the Sub-Folder Biotechnology & Drugs again with the ReutersDatalink System of Folders. Now, my Fundamental, my beginning Exploration is to clear which Stocks trade it the Current Day. For that i use in the Filter : { Date-cutoff - excludes inactive codes whose last active date was before 10/October/2005 } day:=10; { 1~31 Day of month cutoff } mth:=10; { 1~12 Month cutoff } y:=2005; { Year cutoff } { ***************************************** } { Date cutoff } cutoff:=Year()>y OR (Year()=y AND (Month()>mth OR Month()=mth AND DayOfMonth()>=day)); { Exploration filter } cutoff AND V>0 AND C > 7 Attention:Every Day i change the Day with the Current! After that i save in File in Metastock the Stocks with a Name. Now must stay and stay near my Computer Machine for to store the Result and to make the Second Exploration. In the Filter of the Second Exploration exist the: (Mov(V,5,S)-Mov(V,600,S))*100/Mov(V,600,S) < -50 Create File with the Results. With that Results i make the Number 3 New Exploration using the Filter: Cross(Mov(C,15,E), Mov(C,200,E)) AND V > 1000 AND C > 3 AND C < 12 Create File with the Results. With the Results of Number 1 Exploration i make New Exploration Number 4, with Filter: (Mov(V,5,S)-Mov(V,600,S))*100/Mov(V,600,S) > 50 Create File with the Results. With that Results i make the Number 5 New Exploration using the Filter: Cross(Mov(C,200,E), Mov(C,15,E)) AND V > 1000 AND C > 50 Create File with the Results. I think that you have in Mind to create the Filters again i mean to consolidate it, in less Explorations that i have now! George K.
Jose  
#4 Posted : Saturday, October 15, 2005 7:42:38 PM(UTC)
Jose

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 1/19/2005(UTC)
Posts: 1,065
Location: Koh Pha-Ngan, Earth

Was thanked: 2 time(s) in 2 post(s)
George, your exploration pairs 2/4 & 3/5 are incompatible - they cancel each other out. Anyway, below is what your combined exploration code would look like. Unfortunately the current combined exploration will filter out 100% of candidates. [code:1:5467337d5d]day:=10; { 1~31 Day of month cutoff } mth:=10; { 1~12 Month cutoff } y:=2005; { Year cutoff } { ***************************************** } { Date cutoff } cutoff:=Year()>y OR (Year()=y AND (Month()>mth OR Month()=mth AND DayOfMonth()>=day)); { Exploration filter 1 } cutoff {AND V>0 AND C>7} { redundant code } AND V>1000 AND C>3 AND C<12 { Exploration filter 2 } AND (Mov(V,5,S)-Mov(V,600,S))*100/Mov(V,600,S)<-50 { Exploration filter 4 } AND (Mov(V,5,S)-Mov(V,600,S))*100/Mov(V,600,S)>50 { Exploration filter 3 } AND Cross(Mov(C,15,E),Mov(C,200,E)) { Exploration filter 5 } AND Cross(Mov(C,200,E),Mov(C,15,E)) { AND V>1000 AND C>50} { redundant code } [/code:1:5467337d5d] jose '-)
kanellop  
#5 Posted : Saturday, October 15, 2005 8:16:41 PM(UTC)
kanellop

Forum Rank:: Advanced Member

Groups: Registered, Registered Users
Joined: 6/3/2005(UTC)
Posts: 181

Dear Jose, Thank you for your Help! I will study your Formula. I do not know if i will use it right now! My Thews are broken because exist some problems to my Metastock from my Hardware i believe. My Exploration Speed had be very slowly the recent period. My basic Effort this Period is to change all my Computer Machine with a New One with more Speed. But still i am not happy with the Processors Speed.They are very Slowly for my Needs.Also the RAM Memory is not going forward with big Steps. I had stop to make Explorations almost a Week ago. Now for the Formulas i want to say that the Number 1 Formula is the: { Date-cutoff - excludes inactive codes whose last active date was before 10/October/2005 } day:=10; { 1~31 Day of month cutoff } mth:=10; { 1~12 Month cutoff } y:=2005; { Year cutoff } { ***************************************** } { Date cutoff } cutoff:=Year()>y OR (Year()=y AND (Month()>mth OR Month()=mth AND DayOfMonth()>=day)); { Exploration filter } cutoff AND V>0 AND C > 7 The V>0 AND C> 7 i put it a Little Period ago. I do not believe that the, my exploration pairs 2/4 & 3/5 are incompatible - they cancel each other out. I think that must think about my Explorations to create it again together with different way. I will study your Formula. Dear Jose if you like right down also what Computer Machine do you have i mean: Processor Speed also with FSB RAM Memory and in what MHz working your Memory Hard Disc Speed George K.
Jose  
#6 Posted : Sunday, October 16, 2005 5:52:17 AM(UTC)
Jose

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 1/19/2005(UTC)
Posts: 1,065
Location: Koh Pha-Ngan, Earth

Was thanked: 2 time(s) in 2 post(s)
kanellop wrote:
I do not believe that the, my exploration pairs 2/4 & 3/5 are incompatible - they cancel each other out.
Hmmm... That does not make any sense at all George :nono: jose '-)
kanellop  
#7 Posted : Sunday, October 16, 2005 4:59:46 PM(UTC)
kanellop

Forum Rank:: Advanced Member

Groups: Registered, Registered Users
Joined: 6/3/2005(UTC)
Posts: 181

Dear Jose, I received your Message. Sorry, but i can not understand it so well. I will repeat you all the Job that make in better way. My Fundamental, my beginning Exploration is to clear which Stocks trade it the Current Day. My Number 1) Exploration had Filter: { Date-cutoff - excludes inactive codes whose last active date was before 10/October/2005 } day:=10; { 1~31 Day of month cutoff } mth:=10; { 1~12 Month cutoff } y:=2005; { Year cutoff } { ***************************************** } { Date cutoff } cutoff:=Year()>y OR (Year()=y AND (Month()>mth OR Month()=mth AND DayOfMonth()>=day)); { Exploration filter } cutoff AND V>0 AND C > 3 Attention:Every Day i change the Day with the Current! After that i save in File in Metastock the Stocks with a Name. Now must stay and stay near my Computer Machine for to store the Result and to make the Second Exploration. My Number 2) Exploration had Filter: (Mov(V,5,S)-Mov(V,600,S))*100/Mov(V,600,S) < -50 Create File with the Results. With that Results i make the Number 3) New Exploration using the Filter: Cross(Mov(C,15,E), Mov(C,200,E)) AND V > 1000 AND C > 3 AND C < 12 Create File with the Results. Number 1), Number 2) and Number 3) Explorations are working with them together as Number 1) Part.
Now, With the Results of Number 1) Exploration from the File that i had create, I make the New Exploration Number 4), with Filter: (Mov(V,5,S)-Mov(V,600,S))*100/Mov(V,600,S) > 50 Create File with the Results. With that Results i make the Number 5) New Exploration using the Filter: Cross(Mov(C,200,E), Mov(C,15,E)) AND V > 1000 AND C > 50 Number 1), Number 4) and Number 5) Explorations are working with them together as Number 2) Part. The Number 1) Part is different from the Number 2) Part. Create File with the Results. I think that you have in Mind to create the Filters again i mean to consolidate it, in less Explorations that i have now! I think that it is possible to consolidate the Number 1) Part in one Exploration. Also i think that it is possible to consolidate the Number 2) Part in one Exploration. Jose i want to ask you also if you believe that if consolidate the Explorations together it is possible to see someone in the Total Results of the Consolidate Exploration Number 1) Part, the results of Number 1) Exploration, Number 2) Exploration, Number 3) Exploration separate? George K.
Jose  
#8 Posted : Sunday, October 16, 2005 5:18:24 PM(UTC)
Jose

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 1/19/2005(UTC)
Posts: 1,065
Location: Koh Pha-Ngan, Earth

Was thanked: 2 time(s) in 2 post(s)
George wrote:
My Number 2) Exploration had Filter: (Mov(V,5,S)-Mov(V,600,S))*100/Mov(V,600,S) < -50
George wrote:
Now, with the Results of Number 1) Exploration from the File that i had create, I make the New Exploration Number 4), with Filter: (Mov(V,5,S)-Mov(V,600,S))*100/Mov(V,600,S) > 50 Create File with the Results
... And your results will be: all securities filtered out. (Mov(V,5,S)-Mov(V,600,S))*100/Mov(V,600,S)<-50 AND (Mov(V,5,S)-Mov(V,600,S))*100/Mov(V,600,S)>50 simply cancel each other out. George, please check for errors introduced somewhere between the keyboard & seat. ;) jose '-)
kanellop  
#9 Posted : Sunday, October 16, 2005 6:25:05 PM(UTC)
kanellop

Forum Rank:: Advanced Member

Groups: Registered, Registered Users
Joined: 6/3/2005(UTC)
Posts: 181

Well, i do not believe that exist Errors in that Formulas. George K.
Patrick  
#10 Posted : Sunday, October 16, 2005 6:29:12 PM(UTC)
Patrick

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 9/8/2004(UTC)
Posts: 2,266

Was thanked: 1 time(s) in 1 post(s)
Well there is a huge error with the formula ... Please listen to Jose and read his post as many times as it is needed for you to understand why there is an error ... Patrick :mrgreen:
kanellop  
#11 Posted : Sunday, October 16, 2005 8:22:18 PM(UTC)
kanellop

Forum Rank:: Advanced Member

Groups: Registered, Registered Users
Joined: 6/3/2005(UTC)
Posts: 181

Well, everything is Fine! Except the Time that need for the Explorations! George K.
henry1224  
#12 Posted : Sunday, October 16, 2005 9:42:24 PM(UTC)
henry1224

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 10/29/2004(UTC)
Posts: 1,394
Location: Glastonbury, CT

Was thanked: 2 time(s) in 2 post(s)
In the filter section day:=10; { 1~31 Day of month cutoff } mth:=10; { 1~12 Month cutoff } y:=2005; { Year cutoff } { Date cutoff } cutoff:=Year()>y OR (Year()=y AND (Month()>mth OR Month()=mth AND DayOfMonth()>=day)); cutoff and V>1000 and (ColA=1 or ColB=1) Under ColA Mov(V,5,S)-Mov(V,600,S))*100/Mov(V,600,S)<-50 and Cross(Mov(C,15,E),Mov(C,200,E)) and C>3 and C<12 Under ColB Mov(V,5,S)-Mov(V,600,S))*100/Mov(V,600,S)>50 and Cross(Mov(C,200,E),Mov(C,15,E)) and C>50 All of the results from col A will equal 1 if colA is True All of the results from col B will equal 1 if colB is True
kanellop  
#13 Posted : Sunday, October 16, 2005 9:59:06 PM(UTC)
kanellop

Forum Rank:: Advanced Member

Groups: Registered, Registered Users
Joined: 6/3/2005(UTC)
Posts: 181

Dear Henry1224, Thank you for your Nice Help! I am grateful for the Time that you spent to found Solutions for Me! The same is apply of course, to Jose and Patrick! George K.
kanellop  
#14 Posted : Monday, October 17, 2005 5:27:26 PM(UTC)
kanellop

Forum Rank:: Advanced Member

Groups: Registered, Registered Users
Joined: 6/3/2005(UTC)
Posts: 181

Dear Jose if you like right down also what Computer Machine do you have i mean: Processor Speed also with FSB RAM Memory and in what MHz working your Memory Hard Disc Speed George K.
Jose  
#15 Posted : Monday, October 17, 2005 6:26:02 PM(UTC)
Jose

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 1/19/2005(UTC)
Posts: 1,065
Location: Koh Pha-Ngan, Earth

Was thanked: 2 time(s) in 2 post(s)
My PC on order: Dell Inspiron 9300 notebook 2.13 GHz CPU, 533MHz FSB 2GB DDR2 SDRAM @ 533MHz 100GB HDD @ 7200rpm Twin-finger, high-speed keyboard running @ 15 words/min jose '-)
kanellop  
#16 Posted : Monday, October 17, 2005 7:31:07 PM(UTC)
kanellop

Forum Rank:: Advanced Member

Groups: Registered, Registered Users
Joined: 6/3/2005(UTC)
Posts: 181

Dear Jose, Thank's. I think that you will buy a Good Machine! Possibly of the Best in the Lap Top Market! George K.
wabbit  
#17 Posted : Monday, October 17, 2005 10:31:08 PM(UTC)
wabbit

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)
Jose wrote:
My PC on order: Twin-finger, high-speed keyboard running @ 15 words/min
ROFLMAO :lol: wabbit :
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.