Home > Business Databases, News & Feedback > Datastream, Worldscope and Units

Datastream, Worldscope and Units

What are the units in Datastream for the accounting variables, e.g. total assets, net debt, EBITDA?

Thomson ReutersThe accounting variables in Datastream are from Worldscope and despite a long detailed Worldscope Data Definitions Guide there is no detail about units.  The answer from the Thomson Reuters helpdesk is as follows:

  • Most of the accounting data from Worldscope to Datastream is in thousands.
  • Per share data & number of employees are available in actual.

Note that this is specific to the Worldscope in Datastream:

  1.  The variable/datatype Market Value (MV) is in millions, while the similar Worldscope variable Market Capitalization (WC08001) is in thousands (and an annual rather than a daily figure).
  2. Using Thomson One Banker to get Worldscope data the default unit (scaling factor) is millions, though this can be changed or you can explicitly request the details by asking for WS.TotalAssets.ScalingFactor or WS.TotalAssets.ScalingFactorText (see Excel examples below).

Adding #U to a datatype will often give the units:

  • MV#U gives 1000000 as Market Value (MV) is in millions
  • P#U gives 0.01 for UK shares as these are quoted in pence, 1 for US shares/stocks as these are quoted in dollars

Thanks to Aberconway Library blog (Cardiff Business School) for this – Finding the scale of datatypes within Datastream (posted July 2012)

For more information see:

Advertisements
  1. 19 August 2011 at 9:33 am

    Thanks Mark, this is really useful as very often asked these questions at the enquiry desk! great to have something to refer to!

    Janette

  2. markgreenwood
    17 April 2013 at 11:50 am

    Using #U tip added – from Aberconway Library blog post – Finding the scale of datatypes within Datastream

  1. 11 April 2013 at 10:38 pm
  2. 17 April 2013 at 10:44 pm

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s