Can Excel Calculate a Jensen Alpha?

Discussion in 'Microsoft Excel Worksheet Functions' started by Guest, Dec 7, 2005.

  1. Guest

    Guest Guest

    Is there a function, or way, in Excel to calculate a jensen alpha statistic?
     
    Guest, Dec 7, 2005
    #1
    1. Advertisements

  2. Guest

    Harlan Grove Guest

    MPT Guy wrote...
    >Is there a function, or way, in Excel to calculate a jensen alpha statistic?


    Sure. Given the following

    portfolio return (RP)
    market return (RM)
    risk-free return (RF)
    portfolio beta (BP)

    it's just

    =RP-RF-BP*(RM-RF)
     
    Harlan Grove, Dec 7, 2005
    #2
    1. Advertisements

  3. Guest

    tyrian

    Joined:
    Jun 28, 2011
    Likes Received:
    0
    tyrian, Dec 3, 2011
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. axw

    Spreadsheet says CALCULATE when there is nothing to calculate

    axw, Jun 14, 2004, in forum: Microsoft Excel Worksheet Functions
    Replies:
    3
    Views:
    615
    Bernie Deitrick
    Jun 14, 2004
  2. Guest

    in excel how do I show a number as an alpha eg 65 as sixty five?

    Guest, Mar 31, 2005, in forum: Microsoft Excel Worksheet Functions
    Replies:
    5
    Views:
    407
    Niek Otten
    Apr 1, 2005
  3. Guest

    change Excel column headings from numbers to alpha characters

    Guest, Sep 14, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    998
    Guest
    Sep 14, 2006
  4. AngelWorks

    1 column alpha list in excel to print to 2 columns

    AngelWorks, Apr 1, 2008, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    368
    Jim Cone
    Apr 1, 2008
  5. Dgadgetk

    if able, how do you sort Tabs in excel (alpha-numeric) ??

    Dgadgetk, Sep 25, 2008, in forum: Microsoft Excel Worksheet Functions
    Replies:
    3
    Views:
    11,681
    PBIndy
    Nov 10, 2008
  6. garch estimatio

    how can i estimate garch parameters(gamma,alpha and beta)in excel

    garch estimatio, Nov 3, 2008, in forum: Microsoft Excel Worksheet Functions
    Replies:
    0
    Views:
    2,506
    garch estimatio
    Nov 3, 2008
  7. Bob Sparks

    How do I sort alpha neumeric fields that have an alpha suffix?

    Bob Sparks, May 30, 2009, in forum: Microsoft Excel Worksheet Functions
    Replies:
    3
    Views:
    873
    Shane Devenshire
    May 31, 2009
  8. Angie

    How do i use sumproduct if my lookup table is alpha or alpha num?

    Angie, Jan 23, 2010, in forum: Microsoft Excel Worksheet Functions
    Replies:
    0
    Views:
    475
    Angie
    Jan 23, 2010
Loading...