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 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.
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:
Bloomberg terminal functions accessed by typing a function code and pressing <GO>. Examples:
| 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 |
|
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. (See instructions on how to download the Add-in below ↓). 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
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).
You may need to install the Bloomberg add-in on Excel.
1. Log in to Bloomberg computer (make certain you already have the Terminal account) and go into Search/Start and choose All >
2. Go to the Bloomberg file and choose Install Office Add-ins
3. Install the Add-in.
4. Login with your Terminal Account in the Bloomberg app and the Add-in Excel should give you access to the Spreadsheet Builder.
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:
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
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
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:
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.
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
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:
Available in: Quantum Room (Helsinki and Vaasa)
Remote access through your Hanken ID:
👉 Log in to Orbis
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.
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.
BoardEx provides detailed information on 1.7 million corporate executives and board members across more than 2.2 million organizations.
Beta Suite is a web-based application that calculates stock exposures to multiple risk factors through rolling regressions at daily, weekly or monthly frequencies
Hanken students can access a WRDS account by registering at 👉 Register Here https://wrds-www.wharton.upenn.edu/
To register:
Select Register for a WRDS Account.
Choose Hanken School of Economics as your institution
Indicate your affiliation (e.g., faculty, PhD student, Master’s student)
Complete the registration form using your Hanken email address
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.
Activate your 2FA for WRDS.
After your request is approved, you will receive an email with login instructions.