Currency Exchange Rates

The database provides detailed historical data such as share prices, market capitalisations, dividends, etc. for approximately 75,000 stocks worldwide, including both industrialised and emerging markets.
It provides access to over 400,000 international macroeconomic time series with indicators for 215 countries, exchange rates for 45 countries and over 2,000 interest rates. The data is divided into the following categories:

• Equities, including:
  • Asset4 ESG environmental, social, governance research data
  • IBES analyst estimates
  • Worldscope company fundamental data items and  financial ratios
• equity indices
• constituent lists
• bonds
• bond indices
• interest & exchange rates
• economics - international macroeconomics
• unit and investment trusts
• commodities
• futures & options
• warrants

Sources include stock exchanges, government institutions (central banks, etc.) and international organisations such as the OECD and IMF.

Depending on the licence, the following modules are included:

• Worldscope
• Bond Service
• Economic Service
• Equity Service
• Futures Service

Keywords: Stock Prices / Markets , Currency Exchange Rates

To access Datasream oder LSEG Workspace lease contact us.

Learning Centre:

• https://www.lseg.com/en/training/learning-centre

Issues with the Datastream Excel Add-in on Mac: Alternative access via LSEG Web Access is recommended.

• Search for Datastream Chart Studio or DSCHART in the main search field.
• Hover the mouse pointer over the arrow next to the name of any data series.
• In the popup menu, select the option “Find New Series” to access the Datastream Navigator.
• In the Datastream Navigator, enter search terms or start browsing data categories.

Issues with Datastream Excel Add-in when using a VPN client:

• When using a VPN client, error messages may occur when retrieving data via the Datastream Excel Add-in
• In this case, deactivate the VPN client

Questions or issues? Contact us:

WiSo Data Library Team

+49-221-470-3511
lica-datawiso.uni-koeln.de

LSEG Workspace contains information on commodities, equities, fixed income securities and hedge funds, foreign exchange and money markets, and wealth management.

Various services are available via the Workspace platform, in particular the Datastream database.

The database

• contains tools for navigating news, including videos of live and on-demand equity news broadcasts.
• offers key market data, charts, time series analysis and streaming news from Reuters and other financial institutions and market research companies for price analysis and global indices of individual stocks.
• contains charts and fundamental data, proprietary data and analysis to provide actionable insights into the global stock market.

Keywords: Bonds and fixed Income , Company Info and Financial Statements , Currency Exchange Rates , Deriatives / Options , Indices and Factors , Stock Prices / Markets

Please contact us for access to LSEG Workspace and Datastream.

E-Mail to: lica-data@wiso.uni-koeln.de

Learning Centre:

• https://www.lseg.com/en/training/learning-centre

LSEG Workspace contains information on commodities, equities, fixed income securities and hedge funds, foreign exchange and money markets, and wealth management.

Various services are available via the Workspace platform, in particular the Datastream database.

The database

• contains tools for navigating news, including videos of live and on-demand equity news broadcasts.
• offers key market data, charts, time series analysis and streaming news from Reuters and other financial institutions and market research companies for price analysis and global indices of individual stocks.
• contains charts and fundamental data, proprietary data and analysis to provide actionable insights into the global stock market.

Keywords: Bonds and fixed Income , Company Info and Financial Statements , Currency Exchange Rates , Deriatives / Options , Indices and Factors , Stock Prices / Markets

Please contact us for access to Datastream and LSEG Workspace via e-mail: lica-data(at)wiso.uni-koeln(dot)de

Download der Application:

• https://www.lseg.com/en/data-analytics/products/workspace/download-workspace

LSEG web access:

• http://workspace.refinitiv.com/web/

Learning Centre:

• https://www.lseg.com/en/training/learning-centre

Issues with the Datastream Excel Add-in on Mac: Alternative access via LSEG Web Access is recommended.

• Search for Datastream Chart Studio or DSCHART in the main search field.
• Hover the mouse pointer over the arrow next to the name of any data series.
• In the popup menu, select the option “Find New Series” to access the Datastream Navigator.
• In the Datastream Navigator, enter search terms or start browsing data categories.

Issues with Datastream Excel Add-in when using a VPN client:

• When using a VPN client, error messages may occur when retrieving data via the Datastream Excel Add-in
• In this case, deactivate the VPN client

Questions or issues? Contact us:

WiSo Data Library Team

+49-221-470-3511
lica-datawiso.uni-koeln.de

Wharton Research Data Services (WRDS) is a web-based platform from the Wharton School of the University of Pennsylvania. It integrates data from numerous financial and economic databases into a single interface, allowing users to search, link, and store data uniformly, thereby facilitating comparability and combined data analysis.

Overbiew of data providers

The database offerings are divided into two categories: 

Databases included with the base WRDS subscription (included datasets & analytics):

• Bank Regulatory
• Blockholders
• CBOE
• DMEF
• Dow Jones
• Fama French
• FDIC
• Federal Reserve Bank Reports
• IRI
• OTC Markets
• Penn World Tables
• Philadelphia Stock Exchange
• SEC Disclosure of Order Execution
• TRACE

Databases accessible via WRDS with an additional licence purchased from the respective data provider (Additional Datasets & Analytics), e.g.

• Amadeus/Orbis
• Audit + Compliance
• COMPUSTAT
• CRSP
• Eventus
• I/B/E/S
• MFLinks
• Ownership
• Worldscope…

Keywords: Banks , Bonds and fixed Income , Company Info and Financial Statements , Currency Exchange Rates , Derivatives / Options , Indices and Factors , Stock Prices / Markets , Statistics, Economy

How do I get access into WRDS?

To apply for WRDS access, you must meet the following requirements:

• You are a member (student or employee) of the WiSo faculty.
• You have a valid Uni-Köln identifier (Uni-KIM).

1. Faculty internal application procedure

The following groups of people can apply for a WRDS account:

• Please fill out the appropriate registration form digitally,
• sign it (for student accounts, the signature of the supervising person is also absolutely necessary) and
• send it to lica-data(at)wiso.uni-koeln(dot)de.

Following this, you can create a personal account at WRDS as described below.

2. Personal registration on the WRDS platform

• Open in the web browser: https://wrds-www.wharton.upenn.edu/register/
• Fill out the online form and select "University of Cologne" in the subscriber field and select your appropriate account type in the User Type field.
• After registration, an email will be sent to the WRDS administrators who will then verify WiSo faculty affiliation.
• Once approved by the WRDS administrators, your personal WRDS account will be created and you will receive a confirmation email with information on how to proceed.

Important notice

If you already have a WRDS account - active or recently inactive - do not request another WRDS account. Use the account-transfer-form to automatically transfer the account or contact the WRDS Support.

• Regulations and explanation for access to WRDS
• Getting Started Guide
• Video Tutorials