Compare Stock Returns with Google Sheets

472 calificaciones
ofrecido por
Coursera Project Network
13,340 ya inscrito
En este Proyecto guiado gratis, tú:

Calculate stock returns using stock price historical data

Calculate the average return of a stock and its volatility

Use Sharpe and Sortino Ratios to calculate risk-adjusted stock performance

Use Sharpe and Sortino Ratios to compare performances of different stocks

Demuestra esta experiencia práctica en una entrevista

Clock3 hours
BeginnerIdeal para principiantes
CloudNo se necesita descarga
VideoVideo de pantalla dividida
Comment DotsInglés (English)
LaptopSolo escritorio

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.


Familiarity with Google Sheets (basic formulas as SUM, IF, AVERAGE), Familiarity with normal distributions

Habilidades que desarrollarás

Financial Data AnalysisCapital MarketQuantitative Analysis

Aprende paso a paso

En un video que se reproduce en una pantalla dividida con tu área de trabajo, tu instructor te guiará en cada paso:

  1. Preparing the data

  2. Calculating mean returns and variance

  3. Calculating Sharpe Ratio

  4. Calculating Sortino Ratio

  5. Visualizing the outcomes and drawing conclusions

Cómo funcionan los proyectos guiados

Tu espacio de trabajo es un escritorio virtual directamente en tu navegador, no requiere descarga.

En un video de pantalla dividida, tu instructor te guía paso a paso




Ver todas las reseñas

Preguntas Frecuentes

Preguntas Frecuentes

¿Tienes más preguntas? Visita el Centro de Ayuda al Alumno.