Normal Distribution Function

Optuma Forums Optuma Scripting Normal Distribution Function

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #65495
    Thomas
    • Topics: 104
    • Replies: 131
    • Posts: 235

    Hi,

    One short question: “Is in Optuma the Excel function “NORMSDIST” available?”

    For example: NORMSDIST(-0.5333-(0.633*A1)).

    The values -0.5333 and -0.633 are constants.

    Thanks,
    Thomas

    #65497
    Mathew
    • Topics: 40
    • Replies: 1,998
    • Posts: 2,038

    Hi Thomas,

    No, we don’t have that. I’m curious as to how you would use that in Optuma. Do you see it having value as a time series data set?

    All the best

    Mathew

    #65503
    Thomas
    • Topics: 104
    • Replies: 131
    • Posts: 235

    Hi Mathew,

    thanks for your replay. The reason why I am interested in this function is an article from the Fed of New York about how to calculate the probability of a recession. See page three in “The Yield Curve as a Leading Indicator: Some Practical Issues”.

    Here are the links:
    https://www.newyorkfed.org/research/capital_markets/ycfaq.html#/
    https://www.newyorkfed.org/research/current_issues/ci12-5.html

    At the moment I make the calculations in Excel and create a csv file to display the data in Optuma. I have no problem with that but thought perhaps it is possible to do the calculations directly in Optuma.

    Here is a chart about how I use the recession probability:
    S&P 500 - Recession Probability

    Best wishes,
    Thomas

    #65509
    Mathew
    • Topics: 40
    • Replies: 1,998
    • Posts: 2,038

    Hi Thomas,

    I’ll have a read and see what we can do for Optuma 2.1.

    In the mean time have you seen this https://twitter.com/mathewverdouw/status/1322400468530683906

    All the best

    Mathew

Viewing 4 posts - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.

Pin It on Pinterest