Re: [amibroker] Re: Converting selectedbar and lastvalue to..., AmiBroker Email List Archive

Hi,

Ok let's look at this from a different perspective:

// variable-period Correlation
function CorrV( x, y, range )
{

avX = MA( x, range );
avY = MA( y, range );
avXY = MA( x * y, range );

ssqrX = Sum( x * x, range );
ssqrY = Sum( y * y, range );

VarX = Max( ssqrx/range - avX * avX, 0 );
VarY = Max( ssqry/range - avY * avY, 0 );

return Nz( ( avXY - avX * avY ) / sqrt( VarX * VarY ) );
}

// variable-period R squared
function RSquaredV( array, range )
{
return CorrV( BarIndex()+1, array, range ) ^ 2;
}

Periods = Param("HHV Period", 20, 1, 100, 1 );

// bars since HHV
barhh = HHVBars( High, Periods );

r2 = RSquaredV( C, Max( 1, barhh ) );

With the code above, I get a Rsquared from a HHV, which is good. But I'd like that to be backtestable only with a slope of a particular gradient, let's say 10-20 degrees. I know it would sound useless to be able to draw a line from each point to the HHV before (the chart would look like a spider web) and I don't want to draw the stuff. But I'd like to be able to calculate for each bar:

a) if it is close to a very good rsquared fit (let's say +0.50);
b) if the line that is drawn (or calculated, since there is no need to draw it) has a slope between 10 and 20 degrees.

How would you do that?

Thanks,

Louis

2008/9/12 gp_sydney <gp.investment@xxxxxxxxx>

I think the first question needs to be what is the result you are
expecting?

In that code you are passing arrays to functions that expect single
values, which is why the SelectedValue and LastValue functions would
have been there before.

LineArray draws a line between two points on the chart, and the
coordinates of those points need to be single values. What would you
expect to see by passing arrays as the coordinates?

Regards,
GP

--- In amibroker@xxxxxxxxxxxxxxx, "Louis P." <rockprog80@xxx> wrote:
>
> Hi,
>
> Here is what I tried to do:
>
> barhh1 = HHVBars( High, Periods ) ;
> bi1 = BarIndex() ;
> y11 = LinearReg( C, barhh1 ) ;
> y01 = LinRegIntercept( H, barhh1 ) ;
> sl1 = LineArray( bi1-barhh1+0, y01, bi1, y11, 0, True );
>
> Unfortunately it seems there is an error...
>
> What's the barindex for in that code, and if the problem is there,
how can I
> deal with it, considering that for the first 4 lines of that code it
began
> with "selectedvalue"?
>
> Thanks,
>
> Louis
>
>
>
> 2008/9/12 Barry Scarborough <razzbarry@xxx>

>
> > Ara said just use the variable. For instance C is an array and using
> > C will point to the last value, or the current bar, in the array. To
> > point to a bar prior to the current one use Ref(C, -n); where n is
> > the number of bars prior to the current one. Replace C with the array
> > you want to get the value for.
> >
> > Use LastValue when you need a value and not an array. An example is
> > in an IF statement. IF() cannot take an array and you have to get the
> > value. If you want the value of some previous value use LastValue(ref
> > (c,-n));
> >
> > If your results get confusing dump it to the interpretation window so
> > you can compare the values with what you expect them to be. Use
> > something like this:
> >
> > printf(numtostr(lastvalue(c), 1.2)); // current value of c
> > printf("\n" + numtostr(lastvalue(ref(c, -1)), 1.2)); // previous c
> >
> > Barry
> >
> >
> > --- In amibroker@xxxxxxxxxxxxxxx <amibroker%40yahoogroups.com>, "Ara

> > Kaloustian" <ara1@> wrote:
> > >
> > > just use the variable (without selectedvalue or lastvalue)
> > > ----- Original Message -----
> > > From: Louis P.
> > > To: amibroker@xxxxxxxxxxxxxxx <amibroker%40yahoogroups.com>
> > > Sent: Friday, September 12, 2008 2:47 PM
> > > Subject: [amibroker] Converting selectedbar and lastvalue to...
> > >
> > >
> > > Hi,
> > >
> > > I need to know how to convert code that is using selectedbar (it
> > gets the bar before where I am on the chart) and lastvalue (which
> > gets the bar at the end of the array) to a code that is checking each
> > and every bar for the pattern.
> > >
> > > Anyone know how to do that?
> > >
> > > Thanks,
> > >
> > > Louis
> > >
> >
> >
> >
>