Category: tutorials

  • How to calculate beta in Excel

    How to calculate beta in Excel

    In this tutorial, we’ll show you how to calculate beta in Excel. First, we explain the data you need before getting started. Then, we offer four different ways of computing betas in Excel (the first one is the fastest if you’re in a rush!). If you prefer a video tutorial, that is provided at the…

    Continue reading

  • Descriptive statistics for stock returns

    Descriptive statistics for stock returns

    Descriptive statistics offer a simple way of understanding distributions of stock returns. They give us an idea about a distribution’s centrality, dispersion, and other features. In this tutorial, we will show you how to generate descriptive statistics for stock returns using Excel’s data analysis tool. Using Excel to get descriptive statistics for stock returns What…

    Continue reading

  • Stock price data – How to download?

    Stock price data – How to download?

    In this tutorial, we will explain how to download stock price data from Yahoo! Finance. Yahoo! Finance is a great source for obtaining historical data on financial securities such as stocks, stock market indices (e.g., S&P 500, Dow Jones Industrial Average, FTSE 100), and ETFs. It has global coverage, and the data is free to download.…

    Continue reading