Looking for help in calculating Sharpe

Hi all, I'm an intern at a fund and I'm trying to calculate the sharpe ratio for a hypothetical portfolio consisting of 3 different ETFs. I'm using excel and coming up with a sharpe of 0.06, which seems extremely low - most likely due to incorrect calculations or using wrong numbers. Would anyone be able to help me with this?

Thanks in advance!

Here is how I did it (formulas) - I am unable to post links. 1. Cumulative return of ETF: =(latest price (July 2020)- initial price (Jan 2015))/initial price (Jan 2015) 2. Annualized return of one ETF: =(1 + cumulative return)^(12/61)-1 [61 is the # months of data used] 3. Overall portfolio annualized return - I first found the weighted annualized return: =weight x annualized return then I sum it together to find portfolio return: =sum(weighted annualized return) 4. Standard deviation, using daily return (=(today's price - yesterday's price)/yesterday's price), then to find monthly returns: =STDEVA(returns column) 5. Correlation: =CORREL(price column of ETF A, price column of ETF B) 6. I found the formula for a three-asset portfolio standard deviation online, which consists of 2 parts: First part: Sum of weights squared multiplied by standard deviations of each ETF squared Second part: Sum of 2 x (weight of A) x (weight of B) x (correlation between A and B) x (Std dev of A) x (Std dev of B) Taking the square root of the sum of both parts gives the standard deviation. 7. Sharpe Ratio: (annualized return - risk free rate (0.13))/annualized standard deviation

1 Comments
 
Most Helpful

Non voluptas quaerat dolorum voluptatem voluptatem consectetur. Magni cumque tenetur accusantium illo beatae. Libero provident similique sed doloribus.

Et itaque debitis id quisquam commodi praesentium. Sed doloribus maiores sed minus id provident. Facere illo similique ipsa tempore.

Aut necessitatibus velit illum et quae. Magni ipsa sed architecto voluptatum.

Quia itaque aut cum et fuga. Ut assumenda labore praesentium aut odio ipsa voluptatibus. Itaque omnis provident deleniti laudantium. Ut et eius earum quos ex sint debitis aut. Ullam optio amet molestias neque libero totam. Expedita earum quos quidem dignissimos consequatur voluptatem.

Career Advancement Opportunities

July 2026 Hedge Fund

  • Point72 99.0%
  • D.E. Shaw 98.1%
  • Citadel Investment Group 97.1%
  • AQR Capital Management 96.2%
  • Magnetar Capital 95.2%

Overall Employee Satisfaction

July 2026 Hedge Fund

  • Magnetar Capital 99.0%
  • D.E. Shaw 98.0%
  • Blackstone Group 97.1%
  • Citadel Investment Group 96.1%
  • Millennium Partners 95.1%

Professional Growth Opportunities

July 2026 Hedge Fund

  • AQR Capital Management 99.0%
  • Point72 98.1%
  • D.E. Shaw 97.1%
  • Citadel Investment Group 96.2%
  • Magnetar Capital 95.2%

Total Avg Compensation

July 2026 Hedge Fund

  • Portfolio Manager (9) $1,648
  • Vice President (27) $464
  • Director/MD (12) $423
  • NA (9) $320
  • Engineer/Quant (86) $288
  • 3rd+ Year Associate (26) $284
  • Manager (4) $282
  • 2nd Year Associate (32) $253
  • 1st Year Associate (77) $191
  • Analysts (242) $181
  • Intern/Summer Associate (29) $145
  • Junior Trader (5) $102
  • Intern/Summer Analyst (282) $96
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
BankonBanking's picture
BankonBanking
99.0
3
Secyh62's picture
Secyh62
99.0
4
kanon's picture
kanon
99.0
5
dosk17's picture
dosk17
98.9
6
Betsy Massar's picture
Betsy Massar
98.9
7
GameTheory's picture
GameTheory
98.9
8
CompBanker's picture
CompBanker
98.9
9
DrApeman's picture
DrApeman
98.9
10
Mimbs's picture
Mimbs
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”