Compare Stock Returns with Google Sheets

4.4
507 個評分
提供方
Coursera Project Network
14,911 人已註冊
在此免費指導項目中,您將:

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.

必備條件

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

您要培養的技能

  • Financial Data Analysis
  • Capital Market
  • Quantitative 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的熱門評論

查看所有評論

常見問題

常見問題

還有其他問題嗎?請訪問 學生幫助中心