All the resources are available online both on and off campus with the exception of Datastream which can be accessed from specific terminals on campus only.
All the resources are available online both on and off campus with the exception of Datastream which can accessed from specific terminals on campus only.
Most industry databases use Standard Industrial Classification (SIC) codes to organise their data.
The classification provides a framework for the collection, tabulation, presentation and analysis of data, and its use promotes uniformity.
In addition, it can be used for administrative purposes and by non-government bodies as a convenient way of classifying industrial activities into a common structure. (Source: ONS http://ons.gov.uk/ons/guide-method/classifications/current-standard-classifications/standard-industrial-classification/index.html )
The code ESNP – Provides economic statistics by country
Economic indicators – example Spain unemployment rate
Type ECST into command bar. Under Functions choose ECST World Economic Statistics.
Choose a country (in this case type and select Spain) in the amber- coloured field.
Choose Labor Market. In the centre of the screen find datasets available on this subject.
Click on any dataset name for more detailed data.
Click on the Graph icon to the right of any dataset(s) to create a chart.
Change date range etc. as required.
Right click chart, choose Copy/export options,
Copy data to clipboard.
Paste data into Excel.
Alternative: create chart as above, choose 7 Workbench above the chart.
Change date range etc.
Use red tab 2 Export to export chart or data.
Exchange rates – example £ - €
Type GBPEUR into command line. Under Securities, choose GPBEUR Curncy.
Choose GP Historical Line Chart. Change date and frequency (= period) as required. Right click chart, choose Copy/export options, Copy data to clipboard. Paste data into Excel.
Tip: to find a currency code use FXTF – FX Ticker Finder - and browse by region. Or type a country – example Brazil - into command line. Under Securities you will see BRL Curncy. This means the code for the Brazilian Real is BRL. You can now use this to search for any Real exchange rates – for example GBRBRL, USDBRL, BRLEUR...