Discussions
»
Product and Service Development
»
Formula Assistance
»
SOMETHING ABOUT THE EXPERT ADVISOR AND THE EXPLORER.
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.
|
|
|
|
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:
|
|
|
|
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.
|
|
|
|
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:
|
|
|
|
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.
|
|
|
|
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 )
|
|
|
|
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.
|
|
|
|
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:
|
|
|
|
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.
|
|
|
|
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:
|
|
|
|
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.
|
|
|
|
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)
|
Discussions
»
Product and Service Development
»
Formula Assistance
»
SOMETHING ABOUT THE EXPERT ADVISOR AND THE EXPLORER.
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.