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, June 18, 2005 10:24:12 PM(UTC)
kanellop

Rank: Advanced Member

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

Dear Patrick(Especially) and everyome else, I want to ask the Folllowing: When put someone a Chart with all the Data Array of a Stock into their Computer Screen and decide to put a self created Formula from the Expert Advisor, have some Results into the Chart that had Choose. Exist opportunity to calculate all the Results in that Chart to a Total Number? Example: In the Expert Advisor and into the Expert Editor and in the Trends Area i put: In the Bullish: Cross(Mov(C,15,E), Mov(C,200,E)) AND V > 1000 In the Bearish: Cross(Mov(C,200,E), Mov(C,15,E)) AND V > 1000 I want to calculate all the Periods that happen the above criteria into my Chart in one Number. Also i want, after to happen this, to create that, into my Explorer too, for to calculate that Total Number for each Security will all the Data Array that have each Security, and after to Add all that Total Numbers, to 1 Number for Statistical Reasons. Do you believe that exist Solution for this Problem? George K.
Patrick  
#2 Posted : Sunday, June 19, 2005 3:37:28 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)
George it is a lot of work to do something like that ... If I understood you question properly that is ... :D I have answered many times, similar questions. Again you will have to use the security function ( Do a search for security function on the forum or check in your manual). Now here is sample of what you need to do : S1:=Security("IBM",C); V1:=Security("IBM",V); S2:=Security("MSFT",C); V2:=Security("MSFT",V); S3:=Security("C",C); V3:=Security("C",V); .... (Cross(Mov(S1,15,E), Mov(S1,200,E)) AND V1 > 1000) + (Cross(Mov(S2,15,E), Mov(S2,200,E)) AND V2 > 1000) + (Cross(Mov(S3,15,E), Mov(S3,200,E)) AND V3 > 1000) + ... That is only for the bearsih side Hope this helps. Patrick :mrgreen:
kanellop  
#3 Posted : Sunday, June 19, 2005 4:57:50 PM(UTC)
kanellop

Rank: Advanced Member

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

Dear Patrick, I believe that know well the Security Function. But in this Case is not work! Why happen that? In your First part of answer you write: S1:=Security("IBM",C); V1:=Security("IBM",V); S2:=Security("MSFT",C); V2:=Security("MSFT",V); S3:=Security("C",C); V3:=Security("C",V); But after here exist the Problems. The Part of, (Cross(Mov(S1,15,E), Mov(S1,200,E)) AND V1 > 1000) + (Cross(Mov(S2,15,E), Mov(S2,200,E)) AND V2 > 1000) + (Cross(Mov(S3,15,E), Mov(S3,200,E)) AND V3 > 1000) + have not the Function ; for work each other. I was try to put all that first, to Indicator Builder without success. Also this Formula is correct to put it into the Indicator Builder because i need it, for to work to my Expert Advisor and The Explorer? George K.
Patrick  
#4 Posted : Monday, June 20, 2005 5:56:48 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)
I did not understand your reply to be honest .... :oops: I believe the problem is that you are using the formula/idea above in the wrong place. Make sure you implement my suggestion as a "COMMENTARY" not a signal or a trend or whatever ... :wink: Patrick :mrgreen:
kanellop  
#5 Posted : Monday, June 20, 2005 6:16:08 PM(UTC)
kanellop

Rank: Advanced Member

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

Dear Patrick, I quite believe that you have not understand my problem well. But i will try to repeat it again. I want to please you to go to your Metastock and to Expert Advisor. In the expert Editor put in the Field of Bullish the: Cross(Mov(C,15,E), Mov(C,200,E)) AND V > 1000 Also in the Field of Bearish the: Cross(Mov(C,200,E), Mov(C,15,E)) AND V > 1000 After go to Ribbon and choose Labels:Symbols and check the All Inner Windows. Click OK and OK Go to every Stock you want. Put a Stock into your Metastock Screen with all the Historical Data. After put this Expert Advisor into the Stock that you choose. You will see many Vertical Lines able to the criteria of this Expert Advisor. Here i will repeat my Question: I want to calculate all that Vertical Lines that happen when i put to the Stock Chart the above Expert Advisor, in one Number. Also i want, after to happen this, to create that, into my Explorer too, for to calculate that Total Number for each Security will all the Data Array that have each Security, and after to Add all that Total Numbers, to 1 Number for Statistical Reasons. Do you believe that exist Solution for this Problem? George Kanellopoulos.
Patrick  
#6 Posted : Monday, June 20, 2005 6:26:52 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)
Do you want to count each vertical lines? Then use the Cum function .... Bullish Cum(Cross(Mov(C,15,E), Mov(C,200,E)) AND V > 1000) bearish Cum(Cross(Mov(C,200,E), Mov(C,15,E)) AND V > 1000 )
kanellop  
#7 Posted : Monday, June 20, 2005 6:42:47 PM(UTC)
kanellop

Rank: Advanced Member

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

Dear Patrick, In your Message: "Do you want to count each vertical lines?" My answer is EXACTLY!!! Now i put the Cum() Function into the Expert Advisor both to Bullish and Bearish. But i can not find the Result with the Number!!! George K.
Patrick  
#8 Posted : Monday, June 20, 2005 6:44:42 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)
You can't use that in trend or signals because it will not result in a True or false value but rather a number ... So you should use that in an indicator, exploration column or in the expert commentary using the writeif function ... Patrick :mrgreen:
kanellop  
#9 Posted : Monday, June 20, 2005 6:56:18 PM(UTC)
kanellop

Rank: Advanced Member

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

Dear Patrick, I put the Cum() Function into a New Formula inot the Indicator Builder. The result i quiet believe that is amazing!!! Here is the Formula: Cum(Cross(Mov(C,15,E), Mov(C,200,E)) AND V > 1000) + Cum(Cross(Mov(C,200,E), Mov(C,15,E)) AND V > 1000) Do you agree with this Formula? By the way can you understand from what Country i am? George K.
Patrick  
#10 Posted : Monday, June 20, 2005 7:02:53 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)
I looked at your Email address :oops:, so you are from Grece right? :D The formula looks good: Cum(Cross(Mov(C,15,E), Mov(C,200,E)) AND V > 1000) + Cum(Cross(Mov(C,200,E), Mov(C,15,E)) AND V > 1000) I don't see any problems with it and you should be able to use that in your explorer. Patrick :mrgreen:
kanellop  
#11 Posted : Tuesday, June 21, 2005 7:30:47 PM(UTC)
kanellop

Rank: Advanced Member

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

Dear Patrick, Yes, i am from Greece.It is True! Now i want to note that in THE EXPLORER with that Formula that told you, the Result looks very good! But i want to ask you the Following. Exist a way to Add all Results from every Stock, in which make the Exploration in 1 Number? For the History if your answer is Negative, i want to tell that with a right mouse click in a Result of the Exploration, i choose Copy and after with a paste, i put the Results into the Excel and i add all the Results with the SUM Function, in 1 Number! But i ask that, only for curiosity! Be Well, Dear Patrick! Always!!! George K.
Patrick  
#12 Posted : Wednesday, July 13, 2005 4:36:56 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)
[quote=IBM",C); V1:=Security("IBM",V); S2:=Security("MSFT",C); V2:=Security("MSFT",V); S3:=Security("C",C); V3:=Security("C",V); .... (Cross(Mov(S1,15,E), Mov(S1,200,E)) AND V1 > 1000) + (Cross(Mov(S2,15,E), Mov(S2,200,E)) AND V2 > 1000) + (Cross(Mov(S3,15,E), Mov(S3,200,E)) AND V3 > 1000) + ... That is only for the bearsih side Hope this helps. Patrick Mr. Green
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.