[amibroker] Re: Whats wrong with this formula for Average Price Composite

["brian_z111" <brian_z111@xxxxxxxxx>]

Hello Drazen,

Have a look in the Information window ..... are the indexes in your Yahoo DB set to IsIndex? == Yes

If it is not categorised as an Index excluding from the scan won't help.

If it is categorised as an Index it will also be listed in the Index folder in the symbol tree hierachy.

You can manually set them in the Information 'cell' OR use the Category() functions to do this from a list.


--- In amibroker@xxxxxxxxxxxxxxx, "DStricek12" <dstricek12@xxx> wrote:
>
> Hello,
> 
> Im  building the average price composite of  whole US stocks  Yahoo database.
> Currently I have 5355  symbols in it.
> In Apply to filter I have excluded indexes and composites from scan.
> 
> After running  Average composite Scan, the average price result is 9599958 $ and clearly this  cannot be true.
> 
> The formula I m using is:
> 
> //  ****************************
> AddToComposite(Close, "~MyIndex", "X" ); 
> AddToComposite( 1, "~MyIndex", "I" );
> buy = 0; // required by scan mode
> 
> graph0 = Foreign( "~MyIndex", "C" )/Foreign( "~MyIndex", "I" );
> 
> //   ****************************
> 
> 
> 
> Any help would be appreciated.
> 
> Drazen
>




------------------------------------

**** IMPORTANT PLEASE READ ****
This group is for the discussion between users only.
This is *NOT* technical support channel.

TO GET TECHNICAL SUPPORT send an e-mail directly to 
SUPPORT {at} amibroker.com

TO SUBMIT SUGGESTIONS please use FEEDBACK CENTER at
http://www.amibroker.com/feedback/
(submissions sent via other channels won't be considered)

For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/amibroker/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/amibroker/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:amibroker-digest@xxxxxxxxxxxxxxx 
    mailto:amibroker-fullfeatured@xxxxxxxxxxxxxxx

<*> To unsubscribe from this group, send an email to:
    amibroker-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/