|
PureBytes Links
Trading Reference Links
|
>>My problem is how to place me into an absolute reference to a
candlestick. In an Excel worksheet, I can name a cell like A23 or
$A$23,<<
{Event Counter Counts events from right edge}
EventDefinition:=Some event that must resolve to true or false.
EventCounter:=((1+LastValue(Cum(Event))-Cum(Event))*Event);
EventCounter;
If you set EventCounter to the instance you want, and plot that using
the Histogram style, you should get a single line at that instance.
If you wish to count Bars from the right use EventDefinition=1;
Note that each time there is a new event (instance) the loaction of
the lines change. However, the bars of an Exploration are not dynamic
so it shouldn't be an issue.
If you want to have a truly absolute reference, you will have to have
the event be a valid date.
Hope that helps.
Ron
--- In equismetastock@xxxxxxxxxxxxxxx, "wi1996" <wi1996@xxx> wrote:
>
> I want to develop an explorer with MS and I have many troubles with
> my formula. In short, I want the following:
>
> Working with week candlesticks, I want to start in a week placed,
> lets say, ten weeks ago, or another number of weeks ago.
Afterwards,
> I will count how many consecutives weeks, that stock have been
> growing up before to have a week were the close was less than the
> last week opening (the stock have failed: this week with close >
last
> week close)
>
> The filter will show me in column A the number of consecutive weeks
> that stock have been growing up from the origin week till the stock
> failed.
>
> Column A
>
> 5 (This means this stock was growing up till week 5. After the
> stock failed in week 6 )
> 6 (This means this stock was growing up till week 6. After the
> stock failed in week 7)
> 7 (This means this stock was growing up till week 7. After the
> stock failed in week 8)
>
> If we work with the week origin, in example, 10 weeks ago, it is
very
> easy for me to check if that stock have been growing 10 consecutive
> weeks:
>
> Sum(C-Ref(C,-1)>0,10) = 10
>
> If the stock meets this condition it means that it has been growing
> for 10 consecutive weeks. Easy!
>
> However, if this condition is not meet, I should go one week back
> from week 10 and check again the condition:
>
> Sum(C-Ref(C,-1)>0,9) = 9
>
> In the next step I should go back 2 weeks from week 10 and check:
>
> Sum(C-Ref(C,-1)>0,8) = 8
>
> ??And so on??
>
> After that, I can make condition like
>
> If (Sum(C-Ref(C,-1)>0,10) = 10,
> {if this condition meets the filter write 9} 9,
> {if this condition doesn't meet check the next condition} If (Sum(C-
> Ref(C,-1)>0,9) = 9, 9, If (Sum(C-Ref(C,-1)>0???.. and so on??
>
> My problem is how to place me into an absolute reference to a
> candlestick. In an Excel worksheet, I can name a cell like A23 or
> $A$23, but in Metastock, how can I solve this problem? Which is the
> best solution? Maybe should I use a counter? How?
>
> Sorry for my awful English but I'm from Spain. If I should clear
> something to you, just let me know. Many thanks in advance!
>
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/equismetastock/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/equismetastock/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:equismetastock-digest@xxxxxxxxxxxxxxx
mailto:equismetastock-fullfeatured@xxxxxxxxxxxxxxx
<*> To unsubscribe from this group, send an email to:
equismetastock-unsubscribe@xxxxxxxxxxxxxxx
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
|