Compare Stock Returns with Google Sheets

4.3
421 个评分
提供方
Coursera Project Network
10,793 人已注册
在此指导项目中,您将:

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

Clock3 hours
Beginner初级
Cloud无需下载
Video分屏视频
Comment Dots英语(English)
Laptop仅限桌面

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.

您要培养的技能

Financial Data AnalysisCapital MarketQuantitative Analysis

分步进行学习

在与您的工作区一起在分屏中播放的视频中,您的授课教师将指导您完成每个步骤:

  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

指导项目工作原理

您的工作空间就是浏览器中的云桌面,无需下载

在分屏视频中,您的授课教师会为您提供分步指导

审阅

来自COMPARE STOCK RETURNS WITH GOOGLE SHEETS的热门评论

查看所有评论

常见问题

常见问题

还有其他问题吗?请访问 学生帮助中心