Datastream, Worldscope and Units
What are the units in Datastream for the accounting variables, e.g. total assets, net debt, EBITDA?
The 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:
- 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).
- 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:
- Previous Worldscope accounting data post
- Example Excel files – DS-WorldscopeUnits (.xlsx) or DS-WorldscopeUnits(.xlsm)