Sharpe Ratio Calculation

patina · Post by **patina** » Tue Sep 08, 2020 11:00 am

Hi,

I'm looking to retrospectively calculate the sharpe on a number of trades I have placed.

I trade a portfolio weekly, but in each week the individual elements are not traded at the same time.

Enclosed is an example of these trades.

I've been recommended to look at the CFA calculation of sharpe - does anyone know how I can best look at this?

Many thanks in advance[url=/User%20Files/14739/Trading%20Example.xls]Attached File: Trading Example.xls[/url]

Patrik · Post by **Patrik** » Fri Sep 18, 2020 4:33 pm

When and how often you trade has nothing to do with evaluating a realized sharpe. You just need consistent M2M of your portfolio at concurrent snapshots in time (of whatever frequency you want to use for estimating sharpe).

The data you have in your sheet is worthless in terms of the question. You need daily/weekly/monthly (whatever frequency you intend to use) M2M values of your portfolio.