Skip to Main Content

Quantum databases

Financial and Company Information

Quantum

Hanken Financial Databases

Hanken students and staff have access to financial databases. The databases are only available to Hanken staff and students!

In this LibGuide, you will find out which databases are available and how to access them. Since all databases use English as their working language, this guide will also be in English to avoid any confusion regarding the databases' special features.

Access: In the database tabs ↗ above, you will find the name of each database and how to access them. Some are only available in the Quantum computer room (Helsinki and Vaasa have their own computer rooms), while others can be accessed remotely with a personal account.

Data: The database descriptions also indicate what type of data is available in each database. If you need databases or datasets beyond what Hanken offers, no acquisitions will be made except at the end of the year, and even then only for research projects. No additional databases or datasets will be acquired for individual Hanken students.

Hankens finansiella databaser

Hankens studerande och personal har tillgång till finansialla databaser. Databaserna är endast tillgängliga för Hankens personal och studerande!

I denna Libguide får du reda på vilka databaser är tillgängliga och hur du kommer åt dem. Eftersom alla databaser har som arbetspråk engelska kommer denna guide också att vara på engelska så att det inte blir några oklarheter för databasernas special funktioner.

Tillgång: I databas flikarna ↗ ovan hittar du namnet av databasen och hur du får tillgång till dem. Vissa är endast tillgängliga i Quantum datasalen (Helsingfors och Vasa har sina egna datasalar) medan andra kommer du åt på distans med personligt konto.

Data: I databasbeskrivningen står det också vilken sorts data som finns i de olika databaserna. Om du har behov av databaser eller datasets utöver det som Hanken erbjuder så kommer inga anskaffningar att göras förutom i slutet av året och även då endast för forskningsprojekt. Inga extra databaser eller datasets skaffas för enskilda Hanken studerande.

Bloomberg

Data in Bloomberg and how to access it

Note: Downloading data from Bloomberg is subject to limitations. If you need to retrieve large datasets, contact the quantum help-desk, we can help you identify the best sources and methods! Use of Hanken databases is restricted to academic and non-commercial research purposes only. Access to licensed databases and copyrighted material through these systems is authorized exclusively for internal or academic research.

Types of financial data found:

  • equities
  • stock market indices
  • fixed income
  • commodities and FX
  • derivatives, economics
  • company data, news and research. 

Bloomberg terminal functions accessed by typing a function code and pressing <GO>. Examples: 

 

Terminal Functions

EQS <GO> Equity Screening  WEI <GO> World Equity Indices  FSRC<GO> Fund Screening 
SRCH<GO> Fixed Income Search  PORT<GO> Portfolio and Risk Analytics  PE<GO> Private Equity Overview 
MA<GO> Mergers and Acquisitions  TREN<GO> News Trends  ANR <GO> Analyst Recommendations 
FA <GO> Financial analysis for a company  HP<GO> Historical Price Table  BETA <GO> Beta analysis of a stock 
ECAN<GO> World Macroeconomics  ECST<GO> Economic Statistics  CO <GO> Commodities Market Monitor 
COMDTY<GO> Commodities Overview Menu   

 

Bloomberg Excel Add-In 

Note: The data download limits are affected by the Excel add-in! Avoid refereshing data in the Excel as that counts towards the limit.

You must be logged into the Bloomberg terminal to use the Excel Add-in. Open Microsoft Excel, Select the Spreadsheet Builder from the Bloomberg Tab. 

BDP  (Bloomberg Data Point) - current data for a single security 

BDH (Bloomberg Data History) - historical time series 

BDS (Bloomberg Data Set) - bulk reference data

Bloomberg Terminal Access

The Bloomberg terminals are available in Helsinki and Vaasa. Onsite use only, remote access is not possible. Only specfic computers have access to Bloomberg and cannot be accessed outside these computers!

First Time users: Click on the Bloomberg Icon on your computer desktop. Click on the blue link <Enter> or <GO> to begin and select Create a New Login. Register with your Hanken email and mobile number (required for verification). 

Tips for Students 

  • Get certified: Complete the Bloomberg Academy Certification (free for students) to strengthen your CV 

Capital IQ PRO

Data in Capital IQ PRO and how to access it

Note: Use of Hanken databases is restricted to academic and non-commercial research purposes only. Access to licensed databases and copyrighted material through these systems is authorized exclusively for internal or academic research.

Capital IQ PRO does not have data limits.

Types of financial data found:

  • Public and Private companies profile and financials 
  • Stock Market Indices 
  • Pricing and Market Data 
  • Fixed income 
  • ESG Scores and Metrics 
  • Ownership 
  • Mergers and Acquisitions (MA)
  • S&P Global Ratings 
  • Initial Public Offering (IPOs)
  • Investment Firms/Funds 
  • Capital Transactions 

Excel Add-In 

Capital IQ Pro Excel Add-In allows bulk downloading of:

  • Company financial statements

  • Time-series market data

Availability:

  • Installed in the Quantum Room in Helsinki and Vaasa

  • For remote installation:
    👉 Download here https://www.capitaliq.spglobal.com/apiservices/office-tools-service/download?lang=&platform=x64

Capital IQ PRO Access Instructions 

First time users: Registration is required, use your Hanken email to sign up. 

 👉 Register here https://www.capitaliq.com/CIQDotNet/Registration/signup.aspx

👉 Capital IQ Pro Login https://www.capitaliq.com/ciqdotnet/Login-okta.aspx

FactSet 

Note: Use of Hanken databases is restricted to academic and non-commercial research purposes only. Access to licensed databases and copyrighted material through these systems is authorized exclusively for internal or academic research.

Factset has no datalimits.

Types of financial data found:

  • Public and Private company profiles and financials 
  • Prices and Offerings 
  • Fixed Income 
  • Stock Market Indices
  • Initial Public Offering (IPOs) 
  • Private Equity/Venture Capital 
  • Commodities 
  • Mergers and Acquisitions (MA) 
  • Industry and Sector Analysis 

FactSet Excel Add-In

The FactSet Excel Add-In allows users to:

  • Retrieve real time and historical data directly in Excel

  • Build time-series models

  • Automate portfolio analysis

  • Create customizable templates

👉 The FactSet Excel Add-In can be accessed via the FactSet Workstation or downloaded from the platform’s support pages.

Access Instructions

  • Installed in: Quantum Room (Helsinki and Vaasa)

  • First-time users: Registration is required. 👉Register here. Create an account using your Hanken email. In order to register look up Svenska Handelshogskolan Finland in institutions and use your Hanken e-mail in the form of name.lastname@student.hanken.fi when you are registering the account. Also include an expirationdate when your master's thesis should be completed. 

  • Log in: 👉 FactSet Login

  • Remote access: 👉 FactSet Download

Tips for Students 

  • Register early: Account set up may take up to a 14 days!
  • Use the Screener tool to quickly filter companies by financial, geography or industry 
  • Get certified: Complete the FactSet Core Certification (free for students) to strengthen your CV 

Orbis (Bureau van Dijk / Moody’s Analytics)

Note: Use of Hanken databases is restricted to academic and non-commercial research purposes only. Access to licensed databases and copyrighted material through these systems is authorized exclusively for internal or academic research 

Types of financial data found:

  • Global public and private company profiles 
  • Comprehensive coverage of private company information worldwide 
  • Cross country comparisons of companies (both listed and private) 
  • Ownership structures (subsidiary and parent relationships) 
  • Directors and Executives 
  • Standardized financials 
  • Stock Data 

Access Instructions

  • Available in: Quantum Room (Helsinki and Vaasa)

  • Remote access through your Hanken ID:
    👉 Log in to Orbis

Wharton Research Data Services (WRDS) 

Note: Use of Hanken databases is restricted to academic and non-commercial research purposes only. Access to licensed databases and copyrighted material through these systems is authorized exclusively for internal or academic research 

There are no datalimits in WRDS.

Types of financial data and datasets found in WRDS:

COMPUSTAT - provides standardized financial statement and market data for over 80,00 active and inactive publicly traded companies across North America and worldwide. 

  • Financial  ratios (Firm and Industry levels)
  • Fundamentals Annual, Quarterly 
  • Security Daily, Monthly
  • Index Daily, Monthly Prices
  • Executive Compensation 
  • Bank Fundamentals Annually, Quarterly 

CRSP - The Center for Research and Security Prices (CRSP)  provides comprehensive security price, return and volume data for the NYSE, AMEX and Nasdaq markets along with datasets on stock indices, portfolio benchmarks, treasury securities, risk free rates, mutual funds and real estate. 

  • Daily Stock File 
  • Monthly Stock File 
  • Stock Market Indexes 
  • US Daily Event Study 
  • Mutual Funds (Daily, Monthly Returns, Fund Dividends, Portfolio Holdings) 

BoardEx provides detailed information on 1.7 million corporate executives and board members across more than 2.2 million organizations. 

  • Board and Director Announcements
  • Board and Director Committees 
  • Annual Option Based Compensation 
  • Annual Remuneration 
  • Individual Profile Education 

Beta Suite is a web-based application that calculates stock exposures to multiple risk factors through rolling regressions at daily, weekly or monthly frequencies

WRDS Access Instructions  

Hanken students can access a WRDS account by registering at 👉 Register Here https://wrds-www.wharton.upenn.edu/

To register:

  1. Select Register for a WRDS Account.

  2. Choose Hanken School of Economics as your institution

  3. Indicate your affiliation (e.g., faculty, PhD student, Master’s student)

  4. Complete the registration form using your Hanken email address

  5. The approval is manual so the activation of the account depends on working hours. If you register on weekends the account will be activated on the next working day.

  6. Activate your 2FA for WRDS.

After your request is approved, you will receive an email with login instructions. 

Tips for Students