[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [amibroker] how are indexes calculated



PureBytes Links

Trading Reference Links

For price weighted averages of an index, I use an AddtoComposite, but capitalization averages require another field representing the number of shares held for each stock coming from another data base. This is done with a separate file that must be read in by AB.  
When I've done an equity curve to represent my holdings - weighted by number of shares, I had to go to the Osaka plug ins to be able to read an external file with the number of shares. Now I think you could use the built 
fget fput fopen fclose functions in Amibroker. 

Then it gets more complicated because you must test to make sure you're not dividing by zero, and handle fact that the number of shares are not constant over the range months or years that you are studying.  

JOE   
  ----- Original Message ----- 
  From: Andre Huwyler 
  To: amibroker@xxxxxxxxxxxxxxx 
  Sent: Wednesday, September 15, 2004 2:15 AM
  Subject: Re: [amibroker] how are indexes calculated


  There are two mainly used methods do calculate indices: a) capitalization-weighted method (e.g. CCMP, SPX) and b) price-weighted method (e.g. DJ Indu). See description of method for both below. Further, but less often used, is the float-adjusted capitalisation method, which does just that, adjust for the % of free-float of the companies. And last but not least, a lot of cap-weighted indices are separately calculated as equal-weighted, in order to extract some extra information.

  a). CAPITALIZATION-WEIGHTED
  A capitalization-weighted index measures the change in the market value of the index components.  In this type of index the sum of all the market values (market value = price x outstanding shares) divided by the index divisor equals the index value.
  Example:
                         outstanding
     stock       price      shares      market value
       A         10.00   x  50.00       =  500.00
       B          5.00   x  75.00       =  375.00
       C         15.00   x  10.00       =  150.00
                                          1025.00= total market value


  b) PRICE-WEIGHTED
  A price-weighted index is designed to measure the change in the prices of the component stocks.  In this type of index, price is the only underlying variable taken into account.  The index is derived by totaling the current prices of the stocks and dividing the sum by a divisor. We will use the example below throughout this text to explain how different indices are calculated and how to adjust the indices for different situations.
  Example:
     stock            price
       A              10.00
       B               5.00
       C              15.00
                      30.00=  sum of all prices

  Hope this helps.

  Regars,
  Andre



  murthysuresh <money@xxxxxxxxxxxxxx> wrote:
  I would like to know how indexes like compq are calculated. If i want 
  to setup a sector based index for eg

  Sector A may have tickers
  AA
  BB
  CC
  DD

  If i setup a index for A based on the closing price of 
  (AA+BB+CC+DD)/4. I may be wrong because the market contribution of 
  all four tickers may not be equal.

  Any ideas?


              
  ---------------------------------
  Do you Yahoo!?
  vote.yahoo.com - Register online to vote today!

  [Non-text portions of this message have been removed]



  Check AmiBroker web page at:
  http://www.amibroker.com/

  Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html 


        Yahoo! Groups Sponsor 
              ADVERTISEMENT
             
       
       


------------------------------------------------------------------------------
  Yahoo! Groups Links

    a.. To visit your group on the web, go to:
    http://groups.yahoo.com/group/amibroker/
      
    b.. To unsubscribe from this group, send an email to:
    amibroker-unsubscribe@xxxxxxxxxxxxxxx
      
    c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 



[Non-text portions of this message have been removed]



------------------------ Yahoo! Groups Sponsor --------------------~--> 
$9.95 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/GHeqlB/TM
--------------------------------------------------------------------~-> 

Check AmiBroker web page at:
http://www.amibroker.com/

Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html 
Yahoo! Groups Links

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

<*> 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/