logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
JimW-DFW  
#1 Posted : Monday, July 28, 2008 2:03:12 PM(UTC)
JimW-DFW

Rank: Newbie

Groups: Registered, Registered Users
Joined: 7/28/2008(UTC)
Posts: 4

Would like to build a custom index with ten stocks (Ex: 10 different coal companies) and some will be on the NYSE and some will not. Does anyone have an example formula they could share?
Justin  
#2 Posted : Tuesday, July 29, 2008 8:56:11 AM(UTC)
Justin

Rank: Advanced Member

Groups: Registered, Registered Users, Unverified Users
Joined: 9/13/2004(UTC)
Posts: 673
Location: Salt Lake City, UT

You can use the Security function to accomplish this, i.e.:

(Security("C:\MetaStock Data\Stocks\IBM",C)+Security("C:\MetaStock Data\Stocks\MSFT",C)+Security("C:\MetaStock Data\Stocks\AMZN",C)+Security("C:\MetaStock Data\Stocks\GOOG",C)+Security("C:\MetaStock Data\Stocks\CSCO",C)) / 5

There is an add-on called FIRE which is a much better tool for this than doing it through the formula language. More information can be found at:

https://www.metastock.com/products/thirdparty/?3pc-add-fire
JimW-DFW  
#3 Posted : Tuesday, July 29, 2008 12:00:29 PM(UTC)
JimW-DFW

Rank: Newbie

Groups: Registered, Registered Users
Joined: 7/28/2008(UTC)
Posts: 4

Thanks. will checkit out.
Richard Dale  
#4 Posted : Tuesday, July 29, 2008 4:27:27 PM(UTC)
Richard Dale

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 4/5/2006(UTC)
Posts: 129
Location: Norgate Data

You should be aware that constructing an index in this fashion means that it is price weighted, and that any corporate actions in any of the companies concerned (such as a 2:1 stock split in one of the constituent stocks) will cause the index to change dramatically (effectively it will halve that company's weighting).

This is why most indexes are constructed using a market cap weighting. Indeed many indexes now use a variation of this - free float market cap.

Unfortunately the "MetaStock" data format has barely changed since the 1980's (when the file format was called Computrac) and has no way of storing any additional fields such as shares on issue/market cap, so be aware of the limitations of producing such an index without market cap values.

Cheers,
Richard.

Cheers, Richard Norgate Data
Users browsing this topic
Guest (Hidden)
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.