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

Notification

Icon
Error

2 Pages12>
Options
Go to last post Go to first unread
DimC  
#1 Posted : Thursday, May 5, 2011 3:14:01 AM(UTC)
DimC

Rank: Member

Groups: Registered, Registered Users, Subscribers
Joined: 7/20/2010(UTC)
Posts: 24

Hello to everybody,
I would like to know the "way" to DETECT or FIND the HighestHigh Value (suppose Close price) of the strict and specific period between 17 and 5 Bars Ago.
Thank you, in advance for your kind support and sharing knowledge.
DimC
wabbit  
#2 Posted : Thursday, May 5, 2011 4:44:10 AM(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)
Use a 12 period HHV() function, then refer to a period 5 bars ago using the Ref() function.


wabbit [:D]

DimC  
#3 Posted : Thursday, May 5, 2011 4:49:49 AM(UTC)
DimC

Rank: Member

Groups: Registered, Registered Users, Subscribers
Joined: 7/20/2010(UTC)
Posts: 24

Thank You VERY VERY much...
Is that possible to give me an orientation to use "variables" instead of fixed period numbers ???
Thanks and Best Regards
DimC
wabbit  
#4 Posted : Thursday, May 5, 2011 5:04:59 AM(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)
HighestSince()

Read the MS User Manual and download the free Equis Formula Primer.



wabbit [:D]

DimC  
#5 Posted : Thursday, May 5, 2011 5:34:47 AM(UTC)
DimC

Rank: Member

Groups: Registered, Registered Users, Subscribers
Joined: 7/20/2010(UTC)
Posts: 24

Dear WABBIT, thank you again for your prompt reply.
I have read the manual, but my question is that i want to find the HHV (ex.Close) for a period of time which is defined by, let's say ---(starting...from) cross(Mov(c,3,S),Mov(c,5,S)) and (Ending period when) cross(Mov(c,5,S),Mov(c,3,S)) ----
Thank you again and waiting for your kind reply.
Best Regards
DimC
wabbit  
#6 Posted : Thursday, May 5, 2011 6:47:45 AM(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)
Use HighestSince() and back reference it using ValueWhen()

Code:

start:=cross(Mov(c,3,S),Mov(c,5,S));
end:=cross(Mov(c,5,S),Mov(c,3,S));

valuewhen(1,end,highestsince(1,start,c));


Please try the exercises in the free Equis Formula Primer...


wabbit [:D]

DimC  
#7 Posted : Thursday, May 5, 2011 7:05:11 AM(UTC)
DimC

Rank: Member

Groups: Registered, Registered Users, Subscribers
Joined: 7/20/2010(UTC)
Posts: 24

Really THANK you, your experience and ability is Great !!!
Thanks for your suggestion and Best Regards
DimC
DimC  
#8 Posted : Thursday, May 5, 2011 12:56:16 PM(UTC)
DimC

Rank: Member

Groups: Registered, Registered Users, Subscribers
Joined: 7/20/2010(UTC)
Posts: 24

Dear WABBIT, i have realised that the formula you gave me is not what i asked.
My question is that i want to find the HHV (ex.Close), on the Nth most recent occurence, from ALL the Bars which exist DURING all the period ---(starting...from) cross(Mov(c,3,S),Mov(c,5,S)) and (Ending period when) cross(Mov(c,5,S),Mov(c,3,S)) ----
Thank you again and waiting for your kind reply. Any additional help is welcome.
Best Regards
DimC
wabbit  
#9 Posted : Thursday, May 5, 2011 2:43:37 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)
Have a go yourself. wabbit [:D]
DimC  
#10 Posted : Thursday, May 5, 2011 3:13:50 PM(UTC)
DimC

Rank: Member

Groups: Registered, Registered Users, Subscribers
Joined: 7/20/2010(UTC)
Posts: 24

Dear Wabbit ..... My fantasy and knowledge does not reach to....
I can understand that is hard to answer every ........ question, but an indication or thinking could really Help !!!
Thanks any way....... for your positive or negative answer.
Best Regards
DimC
viking4020  
#11 Posted : Thursday, May 5, 2011 4:19:15 PM(UTC)
viking4020

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 10/16/2009(UTC)
Posts: 33
Location: Redcliffe, QLD Australia

Thanks: 4 times
Was thanked: 1 time(s) in 1 post(s)

Hi

I am new to this but I do enjoy how wabbit encourages would be chartists to "have a go". I have found by reading many forums that wabbit will help you as long as you are willing to first have an attempt at it yourself. If you want code written for you without any effort you can do this but it will cost you... and you learn nothing.

No doubt I will need help with something in the future but I will have a go myself. Please don't come down too hard on the messenger... wabbit is trying to help you.

VikingOz

DimC  
#12 Posted : Friday, May 6, 2011 4:41:15 AM(UTC)
DimC

Rank: Member

Groups: Registered, Registered Users, Subscribers
Joined: 7/20/2010(UTC)
Posts: 24

Dear Viking Oz,
Thank you for your comment and educational approach for wich i agree 100%, and i really mean it.
From the other hand, when somebody is asking for help or experience exchanging through this online community, the educational part of the contribution helps the main orientation. Believe me, i have nothing against Wabbit , which i really thank very very much, and i really appreciated his answers and also his contribution to the forum ...
I want to explain to you my position, it seems to be in the sea asking for help and somebody can give you a piece of wood, it is logic that you have to swim .... i am not blaiming any body that he didn't send the helicopter ..... The "wood" i am asking .... Now, regarding requested help for code which is NOT written ,not mentioned and from the description of the function which copy follows, does not result that can be obtained any HIGH or HIGHEST price from an isolated clearly determinated period from a previous fact (as requested ):

Function: Highest High Value [hhv()]

FUNCTION Calculates the highest value in the DATA ARRAY over the preceding PERIODS (PERIODS includes the current day).

Function: Highest Value [highest()]

FUNCTION Calculates the highest value in the DATA ARRAY since the first day loaded in the chart.

Function: Highest Since [highestsince()]

FUNCTION Returns the highest value of DATA ARRAY since the Nth most recent occurrence of EXPRESSION was true. This includes all data loaded in the chart.

As you can see, there is no possibility to use available functions and get such result. I admit that i am not experienced programmer but i can assure you that i have read the manual many times and for simple or complicated formulas , according my level of possibilities which i am testing, i am really trying hard ... before i disturb anybody. Maybe is something very easy for somebody else, ANYWAY any help and any idea are really welcome.

Thank you again for the possibility you gave me to clear everything.

Best Regards

DimC
wabbit  
#13 Posted : Friday, May 6, 2011 4:51:50 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)
I have written code for what I think you are asking for. If the code doesn't return the values you were expecting, then obviously I didn't understand the problem in the first place. Post an annotated chart showing what you expect for the results and your own attempt at the code and someone will give their time to help you. Don't use "say" examples, give specific information. Read the post on forum netiquette. wabbit [:D]
viking4020  
#14 Posted : Saturday, May 7, 2011 12:44:35 AM(UTC)
viking4020

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 10/16/2009(UTC)
Posts: 33
Location: Redcliffe, QLD Australia

Thanks: 4 times
Was thanked: 1 time(s) in 1 post(s)
Hi DimC Sometimes it helps to vent your spleen, and you certainly did that. You are obviously more knowledgeable than me in programming MS so I encourage to do what wabbit suggests and see what happens. It appears to me that wabbit has committed to help you. Viking Oz
DimC  
#15 Posted : Saturday, May 7, 2011 9:09:26 AM(UTC)
DimC

Rank: Member

Groups: Registered, Registered Users, Subscribers
Joined: 7/20/2010(UTC)
Posts: 24

Dear Wabbit,
Thank you for your interest and encouraging.
I need the instructions how to attach an image of the "chart".
Sorry to ask for such a question, but really cannot find the way....
Best Regards
DimC
wabbit  
#16 Posted : Sunday, May 8, 2011 2:22:10 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)
Upload the image to a server we can all see and provide a link in the post to that image.


wabbit [:D]

DimC  
#17 Posted : Monday, May 9, 2011 6:11:24 AM(UTC)
DimC

Rank: Member

Groups: Registered, Registered Users, Subscribers
Joined: 7/20/2010(UTC)
Posts: 24

Dear Wabbit,
Thank you for your continuous support. Following is the Chart image i am reffering to:
UserPostedImage

As you can see, there are signal lines for LONG Periods (green lines) and SHORT Periods (red lines) and i have numbered them from a certain point and after. We have to consider:1) that these signals have been produced from a personal formula study and for abbreviation reasons we can suppose that is for :
Long Signals: cross(Mov(C,3,E),Mov(C,5,E); and for Short Signals: cross(Mov(C,5,E),Mov(C,3,E);
2)We name the entire period that starts with the signal number and finishes when the new contrarian signal appears.
So i would like to be able :
a) to use the Lowest Low of Close price during period #1 even when i am in period #6 or period #7 or period #11 ???
b) to unify two consecutive periods, example: consider period #1 and period #2 as one period, out of them to be again able to use the Lowest Low of Close price in a later time, let's say period #10.

Thank you in advance for any help.
Best Regards
DimC


edited by wabbit: put image link in [ img ] tags
wabbit  
#18 Posted : Monday, May 9, 2011 8:00:59 AM(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)
DimC wrote:
As you can see, there are signal lines for LONG Periods (green lines) and SHORT Periods (red lines) and i have numbered them from a certain point and after.

How is your "certain point" defined?? What makes #1 different from #3, #F, #D and #B? If you don't give us the WHOLE story, then we cannot help. Read the forum netiquette post again. http://forum.equis.com/forums/thread/30031.aspx
DimC  
#19 Posted : Tuesday, May 10, 2011 3:16:09 AM(UTC)
DimC

Rank: Member

Groups: Registered, Registered Users, Subscribers
Joined: 7/20/2010(UTC)
Posts: 24

Dear Wabbit,
Thank you again for your attention and precision. As i am making a study, i have different ways of approach also. That means :

1)Referencing to these points and periods as the trade goes on. I mean that i do not name #1 but let's say when we are at #5 (no matter which bar) to call 2 or 4 previous periods.
2) Manualy defining #1 or whatever can be for everybody a starting point.
3) Store (????) these as a)points and b) as periods, in the computer and then be able to make your calculations.

Hope that is enough clear, if any confusion please let me know.
Waiting for any kind reply
Best Regards
DimC


wabbit  
#20 Posted : Tuesday, May 10, 2011 3:31:07 AM(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)
If you don't have a recipe, you cannot bake a cake. If you don't have definitions of when points are defined and definite lookback points and periods then you cannot program anything. Computers will only do what they are specifically programmed to do, and without a very specific set of instructions they will not produce the intended results. When you can write down your system/methodology on paper then you have the BASIS of something which might be programmable. Until that time, I don't think there is anything else to do here...


wabbit [:D]


Users browsing this topic
Guest (Hidden)
2 Pages12>
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.