[EquisMetaStock Group] How do I generate a conditional clear signal for an average price?

["wwflhp" <wwfarr@xxxxxxxxx>]

Version Used 9.0

Date: 3-14-07

Subject: How do I generate a conditional clear signal for an average
price? 

I want to have a sell signal that is conditional on the average price
of pyramided buys.  That is, the sell signal is only generated if the
current closing price of a stock exceeds the average purchase price of
several pyramided fixed $ amount buy signals.  The problem is, how do
I clear the total invested and total shares owned sum variables to
zero only after the conditional sell signal is generated?  Specifically;

PurchaseAmount:=5000;

BuySignal:= Cross(C,Mov(C,20,E));

TotalInvested:= If(BuySignal,PREV+PurchaseAmount,PREV);

TotalShares:= If(BuySignal,PREV+(PurchaseAmount/C),PREV);

AvePrice:=TotalInvested/TotalShares;

SellCondition:=Cross(Mov(C,20,E),C);

SellSignal:=SellCondition AND (C>AvePrice);

How do I clear TotalInvested and TotalShares, to 0 only if sell signal
is true?

I tried adding many variations following the SellSignal including;

If(SellSignal,TotalInvested=0,Ref(TotalInvested,-1));

If(SellSignal,TotalShares=0,Ref(TotalShares,-1));

And I've also tried adding;

If(Ref(SellSignal,-1),TotalInvested=0,Ref(TotalInvested,-1));

If(Ref(SellSignal,-1),TotalShares=0,Ref(TotalShares,-1));

And I've tried adding;

If(Ref(SellSignal,-1),TotalInvested=0,
TotalInvested=Ref(TotalInvested,-1));

If(Ref(SellSignal,-1),TotalShares=0, TotalShares=Ref(TotalShares,-1));

And I've tried adding;

TotalInvested:= If(SellSignal,0,If(BuySignal,PREV+PurchaseAmount,PREV));

TotalShares:= If(SellSignal,0,If(BuySignal,PREV+(PurchaseAmount/C),PREV));

But I get strange results.  I can't get TotalInvested and TotalShares
to go to 0 after the SellSignal and to stay 0 until the next
BuySignal.  I have also created an array of past average prices, but I
can't figure out how to index back into the array.  I can't believe
that this is not a common question.  Aren't there other Sell signals
that are conditional on the average price of pyramided buys?  Thanks,
 Bill



------------------------ Yahoo! Groups Sponsor --------------------~--> 
Transfer from your equities account.  
Receive up to $1,000 from GFT. Click here to learn more.
http://us.click.yahoo.com/aZttyC/X_xQAA/cosFAA/BefplB/TM
--------------------------------------------------------------------~-> 

 
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/