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

Re: [amibroker] Adjusted ETF Data



PureBytes Links

Trading Reference Links

Thanks very much Richard, looking forward to see what you come up with.
 
Steve
----- Original Message -----
Sent: Monday, September 15, 2008 12:02 AM
Subject: RE: [amibroker] Adjusted ETF Data

Hi Steve,

 

Adjusting for dividends and capital events (splits etc.) provides a ?total return? chart. 

 

The reason that adjusting for dividends has suddenly become popular is because Yahoo does it that way by default.  However, institutional data sources have never been adjusted for dividends.  Indeed, all of the major indexes are not adjusted for dividends (DJIA, S&P 500, Wilshire 3000, FTSE 100, All Ords, Nikkei 225, DAX).

 

You could argue that dividends are just a normal part of business and don?t need to be adjusted for.  Similarly, if the CEO?s salary increases from $10M to $30M, this has an effective on the bottom line of the company, but you don?t adjust for that.  Other corporate activities such as spinoffs and stock splits represent significant changes to the capital structure of the company and, therefore are adjusted.

 

The other issue with adjusting for dividends is the difference in time between the ex date and the dividend payment date.  To be perfectly accurate, you would adjust on the ex date but credit your account on the payment date.  

 

With ETFs, there are multiple types of dividends (long term capital gains dividends, short term capital gains dividends, standard cash (income) dividends).  Each of these types  can represent a different taxation scenario, depending upon how you are trading/investing.  So you might wish to adjust some types of dividends differently to others.

 

We?re slowly working on an ETF service that will provide you all manner of features, and also allow you to check items such as NAV, cash and premium/discount too, but this will necessitate more fields than just OHLCV, so we?ll need a more sophisticated database solution (which is in the works).

 

Best regards,
Richard Dale.

Norgate Investor Services
- Premium quality Stock, Futures and Foreign Exchange Data for
  markets in Australia, Asia, Canada, Europe, UK & USA -
www.premiumdata.net

 

From: amibroker@xxxxxxxxxxxxxxx [mailto:amibroker@xxxxxxxxxxxxxxx] On Behalf Of Steve Dugas
Sent: Saturday, 13 September 2008 10:29 PM
To: Yahoo - AmiBroker
Subject: [amibroker] Adjusted ETF Data

 

Hi - Just out of curiousity, is there anyplace on planet earth where we can subscribe to ETF data that supplies OHLCV and has also been adjusted for cash distributions? I guess Richard Dale is our resident data expert - Richard, would this be a terribly hard thing for a data provider to offer? Are adjustments generally made by the wholesaler or the retailer? Why do providers sometimes adjusted for stock dividends but not cash dividends? Thanks very much for any info!

 

Steve

__._,_.___

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




Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___