Take the 2-minute tour ×
Quantitative Finance Stack Exchange is a question and answer site for finance professionals and academics. It's 100% free, no registration required.

I need to use various data sources to cover all of my data, and I am concerned by the discrepancies in total returns. Data vendors were helpful, but their simple documentation did not help resolve why there can be differences for some months for some ISINs but not for other months. If you are familiar with these issues, please comment on the example data points below.

I am calculating calendar-month returns (in Swedish Kronen) via

  • TOT_RETURN_INDEX_GROSS_DVDS from Bloomberg (taking the ratio of consecutive month-end values),
  • RI of ThomsonReuters Datastream (again, a ratio),
  • FG_TOTAL_RETURNC of FactSet (directly),
  • Month End Return of Morningstar (directly),

I would love to see consistent returns, comparable to what MSCI bases their total return indices on. Which vendor corresponds to this?

I think all vendors promised to assume all reinvestments of dividends and capital distribution for this data (though for funds fees and costs might still change things). Meanwhile for

H&M stock (HENNES & MAURITZ B) in April 2000, I see

  • Bloomberg: -.0027076
  • ThomsonReuters: -.0023833
  • FactSet: -.00238335
  • Morningstar: .0104167

For an SEB Sverige fund, a difference shows up in June 2000: .0304632 from Bloomberg and .0494242 from Morningstar.

And the fact that sometimes Morningstar produces lower numbers, sometimes higher numbers, and for equities, not stocks, does not suggest a definitional issue about reinvesting or paying dividends, e.g.

For Ericssson stock (ERICSSON (LM) B): Nov 2000: BB: -.1390977; TR DS: -.1390979; FS: -.13909775; MS: -.0912699 but Sept 2001:BB: -.2431374; TR DS: -.2431377; FS: -.2431372; MS: -.2873786;
Oct 2001: BB: .1968915; TR DS: .1968912; FS: .1968913; MS: .2588556.

share|improve this question
2  
@kristine - I ask to be enlightened, not to argue: It was my impression that data requests were discouraged (the language itself seems to suggest a soft limit). Do you think all questions relating to data and data vendors should be closed? (And I'm willing to close my own question about data vendors, myself.) IMO, a database engineer doesn't necessarily know the business reasons for data discrepancies, and professional quants can benefit from clarity that people in-the-know can provide, where no documentation exists. Is it more that Money.SE would be more appropriate? –  Andrew Cheong Jul 19 '13 at 13:23
    
I also think that this is not a question for a data engineer as the understanding sought is for the business rationale for why the total returns my differ. It is not clear a priori that this might not be due to difference in the quantitative process, e.g. reinvestment at the beginning-of-day vs end-of-day. –  snth Jul 24 '13 at 7:36
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.