|
PureBytes Links
Trading Reference Links
|
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/
|