YoVDO

Compare Stock Returns with Google Sheets

Offered By: Coursera Project Network via Coursera

Tags

Business Software Courses Risk Management Courses Google Sheets Courses Quantitative Analysis Courses Financial Analysis Courses Sharpe Ratio Courses

Course Description

Overview

In this 1-hour long project-based course, you will learn how to compare the performance of different securities using financial statistics (normal distributions) and the Google Sheets toolkit to decide which one performed the best in terms of risk-to-return (risk-to-reward) metrics. This will teach you how basic risk management using quantitative analysis is done and is applied in calculating mean returns of the stock, variance, standard deviation, the Sharpe ratio, and Sortino Ratio. Note: This course works best for learners who are based in the North America region. We're currently working on providing the same experience in other regions. This course's content is not intended to be investment advice and does not constitute an offer to perform any operations in the regulated or unregulated financial market.

Syllabus

  • Compare Stock Returns with Google Sheets
    • By the end of the project, you will be able to compare the performance of different securities using financial statistics (normal distributions) and the Google Sheets toolkit to decide which one performed the best in terms of risk-to-return (risk-to-reward) metrics. This will teach you how basic risk management using quantitative analysis is done and is applied in calculating mean returns of the stock, variance, standard deviation, the Sharpe ratio and Sortino Ratio.

Taught by

Bekhruzbek Ochilov

Related Courses

Creating Accounting Statements Using Accounting Fundamentals
Coursera Project Network via Coursera
Análisis de Variación con Google Sheets
Coursera Project Network via Coursera
Analysis of Variance with ANOVA in Google Sheets
Coursera Project Network via Coursera
Analyze Data using Pivot Tables, Crosstabs in Google Sheets
Coursera Project Network via Coursera
Analyze NPS Survey Data in Google Sheets
Coursera Project Network via Coursera