How do I find country information on Bloomberg?
Answer
The code ESNP on Bloomberg 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...