Wednesday, February 29, 2012

Procedure for incorporating split / bonus into Amobroker database:


  1. Amibroker Database setup/cleanup for Split or Bonus for NSE stock

  2. Go to Amibroker >> >> database purify >>
  3. Enter the reference symbol. this may be the most actively traded stock in the excahange of your data. ( RELIANCE is probably the most suited. i use BHEL for NSE. )
  4. Check 'report possible splits'. to avoid confusion initially, uncheck all other options.
  5. Enter the detection threshhold % (you are permitted to enter between 30% & 90 % : a high value, may not show some of the splits. a low value may show some extra stocks also as splits. : i am comfortable with 50% setting)
  6. Select 'ALL symbols' & 'ALL quotes' when you are running ffor the first time.
  7. Press 'analize'
  8. The output will show the columns symbol, date & possible 'unadjusted split'. please understand that the split & the rato are only suggestions and to be conffffirmed by other sources.
  9. It is preferable to confirm the 'possible split' from other sources. i find this NSE link helpful for confirmation of a split for a stock from the announcements:
    http://www.nseindia.com/content/corporate/corpinfo.htm
  10. After the confirmation of a split & the RATIO, you may double click on the database purify window. this action will take you to the corresponding stock chart.
  11. Now go to Amibroker >> symbol >> split >> a window will open, where you will be shown the date & the ratio as predicted by amibroker. you may make changes as necessary & press the OK button.
  12. Please note that bonus & splits are considered as the same & shown as splits. the number indicated in the RATIO field is the number of shares EACH share will be split into. you can enter fractions also in this field, as required. sometimes, stocks are split & on the same date bonis shares are issued. The ratio to be entered = split ratio * bonus ratio. this bonus ratio has a different meaning & value than the conventional parlance in India. ( 1:1 bonus means that an additioanal share is issued for every share held. but in AB, the corresponding ratio will be 2:1, meaning that the earlier ONE share has become TWO.

Print this post

No comments: