[amibroker] Re: help with weighted index

["brian_z321" <brian_z321@xxxxxxxxx>]

--- In amibroker@xxxxxxxxxxxxxxx, Waleed Khalil <waleedkhalil@xxx> 
wrote:

> Brian, finally i have made it , it works great.

Hello Waleed Khalil,

Thanks for the feedback.
Your code looks good.

I had just uploaded some example files when I saw your post.
They are superfluous now but I will leave them up for a while as they 
might help someone else.

CompareIndexToPortfolio folder.
WeightedIndex.doc
WeightedIndexes.xls

I downloaded a few bars as per carlacash26's code, ran the scan and 
exported all the data into Xcel.
The yellow cells are the equivalent of the composite calculated in 
Xcel from the raw data.
It matches the exported values for ~test.

CC26's modified code

////START OF CODE

weight =
IIf( Name() == "AA", 5,
IIf( Name() == "C", 4,
IIf( Name() == "CAT", 6,
IIf( Name() == "GE", 7,
0 ) ) ) );


AddToComposite( weight * O, "~test", "O" );
AddToComposite( weight * H, "~test", "H" );
AddToComposite( weight * L, "~test", "L" );
AddToComposite( weight * C, "~test", "C" );

Buy = 0;


PlotForeign("~test","test",colorBlack,styleCandle);

////END OF CODE

Brian_z



Please note that this group is for discussion between users only.

To get support from AmiBroker please send an e-mail directly to 
SUPPORT {at} amibroker.com

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

For other support material please check also:
http://www.amibroker.com/support.html
 
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/