|
PureBytes Links
Trading Reference Links
|
>From playing with Lookup and VLookup, it appears that Excel wants the lookup
column sorted, which may not be feasible for you.
> -----Original Message-----
> From: owner-metastock@xxxxxxxxxxxxx
> [mailto:owner-metastock@xxxxxxxxxxxxx]On Behalf Of John Adair
> Sent: Sunday, November 26, 2000 11:01 AM
> To: metastock@xxxxxxxxxxxxx
> Subject: RE: Automate v4.5
>
>
> I referr to only my personal evaluation of a stock
> . Nothing commercial. I have read the functions in excel and
> none of them
> seem to be able to
> Here is an exxample I fear the se columns may not be straight
> on your screen
>
> A B C D E
> F
>
> 0 11/22/00 33.125 33.25 32.8125 33.0625
> 1 11/21/00 33.125 33.1875 33 33.0625
> -2 11/20/00 32.5625 33.3125 32.5625 33.25
> -3 11/17/00 33.0625 33.1875 32.8125 32.8125
> -4 11/16/00 32.25 33.125 32.25 33.0625
> -5 11/15/00 33.3125 33.3125 32.9375 33.125
> -6 11/14/00 32.8125 33.3125 32.8125 33.3125
> -7 11/13/00 32.625 33.3125 32.5 33.0625
> -8 11/10/00 32.875 32.9375 32.75 32.875
>
> I find the highest # in column(32.875) with the max funcntion
> but I want to
> know the date in column B on which this occurred. I cant
> find a function
> to do this.
>
> -----Original Message-----
> From: owner-metastock@xxxxxxxxxxxxx
> [mailto:owner-metastock@xxxxxxxxxxxxx]On Behalf Of Brian
> Sent: Saturday, November 25, 2000 5:57 PM
> To: metastock@xxxxxxxxxxxxx
> Subject: Re: Automate v4.5
>
>
> > There are about 140 TA functions for Excel available now
>
> Are you talking about a commercial product with 140 Excel TA functions
> or somewhere else?
>
> Thanx,
> Brian
>
>
|