PureBytes Links
Trading Reference Links
|
Hi Robert,
I think a lot of your questions can be answered by the 'Cum(1)'
function, which simply counts from 1 onwards. So if your formula
should only kick in if you have 300 data points, something like
Cum(1) >= 300
will only return true if that condition is met. You can parameterise
it easily, say
Cum(1) >= par1
To count the number of bars a given formula is available, say a moving
average, you can use something like
Cum(Mov(C,200,S)>0)
which will count the number of days this formula was above 0. So if
you work with things that can also take on negative values, you have
to adjust accordingly, but the idea is the same. This only starts
counting once the formula 'works', ie after the first 200 days are
available.
Hope this helps. If all else fails, use exponential averages, which
theoretically start working from day 1 (although I have a feeling MS
may treat it differently).
Regards
MG Ferreira
TsaTsa EOD Programmer and trading model builder
http://www.ferra4models.com
http://fun.ferra4models.com
--- In equismetastock@xxxxxxxxxxxxxxx, "robcpettit" <robcpettit@xxxx>
wrote:
>
>
> Thanks for your reply. Ok clarity. Im calculating the difference
> between the average and the dailly price. so if say i have 300 prices
> and use the 200 dma I would be able to calculate 100 differences. When
> I have these 100 values I want to add them all together. Fairly
> straight forward when I know excactly how many values I need to add.
> But on a dailly basis I will be adding new data so realistically I
> cant do this manually. Therefore I need a formula to say 'you have 100
> values' which Ill then use in a variable to do the rest. Also I want
> to very my moving averages so again impossible to do manually. I hope
> this is explained better.
> Regards Robert
------------------------ Yahoo! Groups Sponsor --------------------~-->
Has someone you know been affected by illness or disease?
Network for Good is THE place to support health awareness efforts!
http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/BefplB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/equismetastock/
<*> 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/
|