WWW findb.aalto.fi aalto.fi

Links

Have you ever wondered how to use VBA in Excel? Here's a quick example of changing data from a wide format to a long format, which is suitable for importing into other statistical software.

IDRE @ UCLA (Institute for Digital Research and Education) - Great resource for data manipulation and econometrics in different software packages.

If you are interested in the programming side of market making and arbitrage then watch this video by Jane Street.

The Thomson ONE "Screening & Analysis"-"Company Screener" can be used to build a more complete list of publicly listed companies over time by using only two criteria in the search: isNa(tf.PrivateIndicator) and IsInList(tf.CountryCode, "FIN"). See a screenshot of the criteria.

Everyone who thinks that the basics of finance course (or any other course) was too simple may update their skills with this document: Finance theory and applications (in finnish). It's pretty much the same material but presented "thoroughly".

The presentation suite think-cell is available on demand from the Finance department. Try it to make professionally looking presentations e.g., for your course assignments and bachelor's and master's thesis.

An alternative approach to retrieving data from SDC (PDF)

Further resources for researchers at Aalto are available through the library.

Links to interesting pages and papers

Links to research journals

Research by Aalto Finance people

Bachelor's Finance courses at Aalto

Master's Finance courses at Aalto

PhD in Finance at Aalto

Research method articles

Links to econometrics (math, statistics) software

Some tips on generating LaTeX documents

Master's thesis from previous years.

Contact person

Mikko Niemenmaa
mikko.niemenmaa@aalto.fi

Video tutorials

Quick tutorial on how to retrieve time series data with Datastream:

Quick tutorial on how to retrieve data with SDC Platinum:

More tutorial videos

Additional Youtube channels with video tutorials related to using data sources:

More video tutorials on using Datastream: Search Youtube for Datastream.

More video tutorials on using Thomson ONE: Search Youtube for Thomson ONE.

More video tutorials on using SDC Platinum: Search Youtube for SDC Platinum.

Finance and other lecture videos

Processing data

More video tutorials on using R: Search Youtube. Also try with r and using r.

More video tutorials on using RStudio: Search Youtube.

More video tutorials on using STATA: Search Youtube.

More video tutorials on using gretl: Search Youtube.

More video tutorials on using SAS: Search Youtube.

More video tutorials on using Matlab: Search Youtube.

More video tutorials on using SPSS: Search Youtube.

More video tutorials on using Excel: Search Youtube.

More information

Read blogs about how to use some of the data sources: