ITA Wealth Management

  • Home
  • Blog
  • Lifetime ITA Membership
  • Portfolios
    • Bethe Portfolio
    • Bohr Portfolio
    • Carson Portfolios
    • Dirac Portfolio
    • Einstein Portfolio
    • Franklin Portfolio
    • Galileo Portfolio
    • Gauss Portfolio
    • Huygens Portfolio
    • Kahneman-Tversky Portfolio
    • Kepler Portfolio
    • McClintock Portfolio
    • Millikan Portfolio
    • Pauling Portfolio
    • Rutherford Portfolio
    • Schrodinger Portfolio
  • Forum
  • Reset Password
  • Contact Me
  • ITA Feedback
  • About Me
You are here: Home / Critical Material / Sortino Ratio Example

Sortino Ratio Example

May 7, 2020 By Lowell Herr Leave a Comment

Eastern Shore of Virginia

If you have been keeping up with the Comments you read Robert Ryan’s desire to include a risk measurement for a portfolio.  This blog is designed to show you how this can be accomplished if you have a portfolio tracking program such as the Investment Account Manager (IAM).  In a later blog post I’ll take a poor performing portfolio (the Franklin is an example) and work through the Sortino Ratio and show it as an additional tab you can add to the Kipling workbook or spreadsheet.

The following example is one I pulled off the Internet.  I simplified the following table and eliminated the Sharpe Ratio calculation.  We are not interested in penalizing risk to the upside.  We desire upside volatility and that is the beauty of the Sortino Ratio calculation.  Here is the very important link that walks readers through the Sortino Ratio calculation.

Sortino Ratio Example Calculation

What you see below is my transferring what you see in the Sortino video into an Excel spreadsheet.  When I complete the Sortino Ratio calculations for the Franklin, I can send interested readers the spreadsheet.

When calculating the return for a particular period, I plan to do it by quarters.  For example, the Franklin was launched on 8/1/2019.  My first period will include data from 7/31/2019 through 9/30/2019.  Since the Franklin is such a new portfolio the Sortino Ratio will not be all that useful as I only have the 3rd and 4th quarters of 2019 and only one quarter of 2019.

So as to come up with more periods for calculation, I will use monthly periods for the calculation.  More on this in a later blog post.

All the necessary data is included in the IAM portfolio tracking software to make the Sortino Ratio calculation.  While I only keep monthly historical data in the IAM program, one can store more if more is useful.  One big advantage of the IAM software over the old TLH Spreadsheet is that one can specify periods of return with the IAM.  That was not possible with the now defunct TLH Spreadsheet.

I hope a few readers find this information useful and if so, leave a comment or question.  Be sure to watch the Sortino Ratio video as it is quite clear.

 

(Visited 132 times, 1 visits today)

Filed Under: Critical Material, Risk Management Tagged With: Risk Management

Leave a Reply Cancel reply

You must be logged in to post a comment.

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Recent Posts

  • Kepler Interim Look: 23 January 2021 January 23, 2021
  • Rutherford Portfolio Review (Tranche 3) – 22 January 2021 January 23, 2021
  • Millikan Portfolio Update: 22 January 2021 January 22, 2021
  • Maintaining Risk Ratios: Camtasia Video Available January 21, 2021
  • Pauling Portfolio Review: 21 January 2021 January 21, 2021
  • Einstein Portfolio Review: 20 January 2021 January 20, 2021
  • Galileo Portfolio Review: 19 January 2021 January 19, 2021

Recent Comments

  • HedgeHunter on Rutherford Portfolio Review (Tranche 3) – 22 January 2021
  • Lowell Herr on Kepler Interim Look: 23 January 2021
  • Steven Lefley on Kepler Interim Look: 23 January 2021
  • Lowell Herr on Kepler Interim Look: 23 January 2021
  • Jim Hotvedt on Kepler Interim Look: 23 January 2021
  • Jim Hotvedt on Rutherford Portfolio Review (Tranche 3) – 22 January 2021
  • HedgeHunter on Rutherford Portfolio Review (Tranche 2) – 15 January 2021
  • Lowell Herr on Maintaining Risk Ratios: Camtasia Video Available
  • Lowell Herr on Pauling Portfolio Review: 21 January 2021
  • Lowell Herr on Bohr Portfolio Interim Update: 17 January 2021
  • Jim Hotvedt on Size and Style Factor Breakdown of US Equity Markets
  • Lowell Herr on Size and Style Factor Breakdown of US Equity Markets
  • Lowell Herr on Bethe Portfolio Checkup: 16 January 2021
  • LiftLock on Bethe Portfolio Checkup: 16 January 2021
  • Lowell Herr on Bethe Portfolio Checkup: 16 January 2021

Tag Cloud

Aristotle Portfolio (79) Asset Allocation (21) Beginning Investors (86) Bethe Portfolio (63) Bohr Portfolio (102) Bullish Percent Indicators (314) Carson Portfolios (23) Copernicus Portfolio (35) Critical Material (143) Curie Portfolio (21) Dual Momentum (88) Einstein Portfolio (95) Euclid Portfolio (78) Feynman Study (25) Franklin Portfolio (23) Galileo Portfolio (90) Gauss Portfolio (107) Hawking Portfolio (207) Huygens Portfolio (92) ITA Portfolios (17) Kahneman-Tversky Portfolio (27) Kepler Portfolio (104) Maxwell Portfolio (33) McClintock Portfolio (21) Millikan Portfolio (47) Miscellaneous (49) Momentum (186) Music (40) Options (92) Pasteur Portfolio (25) Pauling Portfolio (55) Portfolio Construction (186) Portfolio Management (586) Portfolio Performance (652) Retirement Planning (21) Risk Management (62) Rutherford Portfolio (230) Schrodinger Portfolio (80) Short-Term Analysis (54) Spreadsheets (19) Stocks (40) Technical Indicators (21) Tranche Investing (70) Uncategorized (30) Weisskopf Portfolio (18)

Users Online

16 Users Online
Users: HedgeHunter, Martin Kelly, Tom Pulaski, 5 Guests, 8 Bots

Most Popular Posts

  • Dirac Portfolio Review – 31 December 2020 (265)
  • Understanding The New Kipling Spreadsheet (217)
  • Portfolio Construction For 2021 (170)
  • Asset Allocation Feature of the Kipling Spreadsheet (155)
  • What Is A Good Sortino Ratio? (133)
  • Sample Carson IRR Comparisons (113)
  • Kepler ETF Rankings (111)
  • Is The Dual Momentum System Broken? (103)
  • Seasonality: Sell in May and Go Away (91)
  • Bullish Percent Indicators: 27 November 2020 (87)

General Investment News

Portfolios coming up for review are:  Euclid, Bethe, and Carson Trio.  Non-scheduled portfolios may be reviewed.  If you are a new user, check the posts you missed. Links to Random Posts are found in the lower right-hand footer or just to the right of what you are now reading.  Most popular posts are found in the lower left-hand footer.

Contact me at itawealth@comcast.net if interested in a Lifetime Membership.  Current Platinum members will be grandfathered into a Lifetime Membership in the summer of 2021.

Random Posts

  • Hawking Portfolio Hedge for January 2016
  • Dual Momentum Recommendations Are Conservative: BIV, SHY, PCY, or Cash
  • Rutherford Portfolio Review (Tranche 4) – 16 March, 2018
  • Gauss Portfolio Review: Few Required Changes
  • Kahneman-Tversky Portfolio Review – 30 September 2020
  • Schrodinger Review: The Easy Passive Management Model
  • Einstein Portfolio Review: 2 November 2017
  • Gearing Up For Bohr Review
  • ITA Portfolio Performance Data Over Two Time Periods
  • Vernal Equinox: Welcome to Spring

Log in | Website Design by BOING