Difference between revisions of "Manuals/calci/PUTOPTION"

From ZCubes Wiki
Jump to navigation Jump to search
 
(One intermediate revision by the same user not shown)
Line 5: Line 5:
 
*<math>UnderlyingPrice</math> is the  spot price
 
*<math>UnderlyingPrice</math> is the  spot price
 
*<math> ExercisePrice</math> is the price at which an underlying security can be purchased or sold.
 
*<math> ExercisePrice</math> is the price at which an underlying security can be purchased or sold.
 
+
**PUTOPTION(), gives the values of Put Option function.
 
 
PUTOPTION() gives the values of Put Option function.
 
  
 
==Description==
 
==Description==
Line 25: Line 23:
 
==Examples==
 
==Examples==
  
 +
==Related Videos==
 +
 +
{{#ev:youtube|v=AfWRp1mExQw|280|center|Finance Function}}
  
 
==See Also==
 
==See Also==

Latest revision as of 15:15, 25 February 2019

PUTOPTION (UnderlyingPrice,ExercisePrice,Time,Interest,Volatility,Dividend)


where

  • is the spot price
  • is the price at which an underlying security can be purchased or sold.
    • PUTOPTION(), gives the values of Put Option function.

Description

PUTOPTION (UnderlyingPrice,ExercisePrice,Time,Interest,Volatility,Dividend)

  • is the The spot price of the underlying asset of a derivative.
  • is the price at which an underlying security can be purchased or sold.
  • is the period.
  • A put option is an option contract giving the owner the right, but not the obligation, to sell a specified amount of an underlying security at a specified price within a specified time.
  • This is the opposite of a call option, which gives the holder the right to buy shares.
  • A put option becomes more valuable as the price of the underlying stock depreciates relative to the strike price.The value of a put option decreases due to time decay, because the probability of the stock falling below the specified strike price decreases.
  • When an option loses its time value, the intrinsic value is left over, which is equivalent to the difference between the strike price less the stock price.
  • Out-of-the-money and at-the-money put options have an intrinsic value of zero because there would be no benefit of exercising the option.


Examples

Related Videos

Finance Function

See Also

References