OPT_PROB_INMONEY in Collabora Office: Terminal Price Intervals

=OPT_PROB_INMONEY(Spot; Volatility; Drift; Maturity;
                 LowerBarrier; UpperBarrier [; Strike [; PutCall]])

The official reference and exact helper describe a terminal-price probability. Spot and annual decimal Volatility must be positive, and Maturity is nonnegative years. Drift μ is annual proportional price drift. Zero disables a boundary. PutCall uses lowercase "c" or "p"; the source’s omitted choice defaults to call.

With no strike, the probability is for the terminal interval between enabled boundaries. For a call with strike K, its lower limit becomes the larger of K and the lower boundary. For a put, its upper limit becomes the smaller of K and an enabled upper boundary. The continuous model assigns zero probability to a single exact terminal point when volatility and maturity are positive, so open versus closed endpoints do not alter the ordinary examples here.

The optional strike is genuinely optional. The argument helper represents an omitted strike with an internal negative sentinel; this is not an invitation to use negative strike values as a public workbook convention. Omit it when you want the plain interval calculation.

Use =OPT_PROB_INMONEY(B2;B3;B4;B5;B6;B7;B8;"c"). The effective interval is 105 to 125. The lower boundary of 85 no longer determines the call’s lower threshold because the strike is larger.

Under dS/S=μdt+σdW, log(S at T / 100) has mean 0.03 and standard deviation 0.20. For positive limits L and U, the independent probability is:

Φ((ln(U/100)−0.03)/0.20) − Φ((ln(L/100)−0.03)/0.20)

Substituting L=105 and U=125 gives 0.295481396, or about 29.55%. This calculation uses a difference of lognormal CDF values. It is not a discounted cash amount and should not be labelled an option price.

Change the strike to 95 and use "p":

=OPT_PROB_INMONEY(100;0.2;0.05;1;85;125;95;"p")

The relevant terminal interval is now 85 to 95, giving independently expected probability 0.174324451. The call and put examples have different strikes, so their probabilities are not complements.

Omit both optional arguments:

=OPT_PROB_INMONEY(100;0.2;0.05;1;85;125)

Now the full 85 to 125 terminal interval applies, and the independently expected result is 0.665031792. It is larger than either restricted strike case. This provides a useful control for an accidentally shifted optional argument: a strike belongs in position seven, and the put/call text in position eight.

If only the strike is supplied, the inspected helper defaults to call. Explicit "c" is clearer in a reviewable financial-model worksheet. Do not pass an extra monitoring flag: this function has no continuous-versus-expiry argument.

A path can cross 125 during the year and finish at 110. That path is counted in the 105-to-125 terminal call region above. It would not survive a continuously monitored upper knock-out barrier at 125. Consequently this function cannot stand in for continuous no-touch probability or for the value of a knock-out call.

OPT_PROB_HIT addresses continuous crossing under the supplied drift. OPT_BARRIER adds a payoff and discounting under its specified rate/carry model. Even a correct probability does not determine a vanilla call value: the payoff varies with how far the terminal price exceeds the strike, not just whether it does.

For valuation comparisons, μ=r−rf is the model’s risk-neutral price drift. A historical estimate of drift is a different input assumption. Neither the function nor these examples fits parameters, measures confidence in estimates or predicts actual market returns. These are illustrative calculations, not investment recommendations.

The exact add-in entry point rejects nonpositive Spot or Volatility, negative Maturity, invalid optional argument representations and nonfinite helper outputs. Some impossible payoff regions are represented by zero inside the helper rather than by an input exception. Do not equate every zero result with an invalid formula.

Use orderly enabled boundaries and nonnegative explicit strikes for normal examples. Zero-time distribution limits, extreme tails, nonnumeric optionals and invalid boundary order are outside the independently checked cases. Exact displayed error text has not been observed in Collabora.

The decisive troubleshooting questions are: Is this an endpoint event? Which boundary or strike actually determines each side of the interval? Is volatility a decimal per square-root year, drift a decimal per year, and time in years? Answer those before treating extra reported decimals as greater model certainty.

This guide covers the new Collabora Office desktop for Linux, identified by Flathub source tag coda-26.04.4.3-1 and commit 81339d176148d0d5c81ff05d82540f58f8aaa117. The desktop release notes and Linux package manifest establish the product mapping. The manifest is a dated source observation from October 18, 2026, not verification of an installed binary.

Versioned vendor Help, exact-commit registrations and evaluator code were reviewed on October 18, 2026. All numerical outputs in this guide are independently calculated expectations, not native Collabora observations. No Collabora application was run and no application screenshot is presented. Source availability does not establish identical Classic, Online/CODE, Windows, macOS or mobile behavior. First introduction and retirement dates are not established; no deprecation claim is made.

Examples use English names and semicolon separators. Adapt separators to the workbook’s formula settings. The documented extension function is outside standard OpenFormula 1.3; workbook portability and file-format round trips require separate checks.