Hi,

I'd like to understand how to use the GV function...

I tried several formulas to implemente, for example, a basic EMA.

With PREV, I've this basic:

alph:=2/(20+1);
mme:=If(Cum(1)=1,C,PREV*(1-alph)+C*alph);
mme

But I didn't find anything well with the GV functions!!!

I tried things like that:

alph:=2/(20+1);
mme:=extfml("gv.setvar","mme",if(cum(1)=1,
ExtFml("Gv.SetVar","mme",C),
ref(ExtFml("Gv.GetVar","mme"),-1)*(1-alph)+C*alph));
mme

Is there a way to do that?

Thanks

fred

Thanks Roy,

In fact, I'm limited with MS for self-reference formula.

For example, I've this code:

if tendance[ 1 ] = 1 then
extreme = max( extreme[ 1 ], high )

if tmpSAR[1] > low then
tendance = -1
facteur = 0.02
tmpSAR = extreme
extreme = low
else
if extreme > extreme[1] and facteur <0.2 then
facteur = min( 0.2, facteur + 0.02 )
endif
tmpSAR = tmpSAR[1]+facteur*(extreme-tmpSAR[1])
tmpSAR = min(tmpSAR,min(low,low[1]))
endif
elsif tendance[1] = -1 then
extreme = min( extreme[ 1 ], low )

if tmpSAR[1] <high then
tendance = 1
facteur = 0.02
tmpSAR = extreme
extreme = high
else
if extreme < extreme[1] and facteur <0.2 then
facteur = min( 0.2, facteur + 0.02 )
endif
tmpSAR = tmpSAR[1]+facteur*(extreme-tmpSAR[1])
tmpSAR = max(tmpSAR,max(high,high[1]))
endif
else
facteur = 0.02
tmpSAR = low
extreme = high
tendance = 1
endif

tmpSAR[1]

It's a modified parabolic, but it's just for example... As you can see, there are several self-references ( extreme, tmpSAR), and it seems impossible to implement this with MS language.

I can translate this in VisualBasic to use it in Excel, but I'm not able to do the same with MS.

At first sight, I thought that GV.DLL was a way to implement self-referencement, but as you said, there is a problem with repeating initilalisation of a GV variable.

Is there a way to implement this sample in MS?

fred