|
1.
|
|
|
@FUNCTION=CUM_BIV_NORM_DIST
@SYNTAX=CUM_BIV_NORM_DIST(a,b,rho)
@DESCRIPTION=CUM_BIV_NORM_DIST calculates the cumulative bivariate normal distribution from parameters a, b & rho.
The return value is the probability that two random variables with correlation @rho are respectively each less than @a and @b.
@EXAMPLES=
@SEEALSO=NORMDIST,NORMSDIST,NORMSINV
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
|
@FUNCTION=CUM_BIV_NORM_DIST
@SYNTAX=CUM_BIV_NORM_DIST(a;b;ro)
@DESCRIPTION=CUM_BIV_NORM_DIST funtzioa: banaketa normal bibariatuakalkulatzen du a, b eta ro parametroetan oinarrituta.
@ro korrelazioko ausazko bi aldagai hurrenez hurren @a eta @bbaino txikiagoak izateko probabilitatea izango da emaitza-balioa.
@EXAMPLES=
@SEEALSO=NORMDIST,NORMSDIST,NORMSINV
|
|
Translated by
Iñaki Larrañaga Murgoitio
|
|
|
|
2.
|
|
|
@FUNCTION=OPT_BS
@SYNTAX=OPT_BS(call_put_flag,spot,strike,time,rate,volatility [,cost_of_carry])
@DESCRIPTION=OPT_BS uses the Black-Scholes model to calculate the price of a European option using call_put_flag, @call_put_flag, 'c' or 'p' struck at @strike on an asset with spot price @spot.
@time is the time to maturity of the option expressed in years.
@rate is the risk-free interest rate.
@volatility is the annualized volatility, in percent, of the asset for the period through to the exercise date.
@cost_of_carry is the leakage in value of the underlying asset, for common stocks, this would be the dividend yield.
* The returned value will be expressed in the same units as @strike and @spot.
@EXAMPLES=
@SEEALSO=OPT_BS_DELTA, OPT_BS_RHO, OPT_BS_THETA, OPT_BS_VEGA, OPT_BS_GAMMA
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
represents a space character.
Enter a space in the equivalent position in the translation.
|
|
|
|
@FUNCTION=OPT_BS
@SYNTAX=OPT_BS(call_put_marka;spot;strike;denbora;tasa;hegazkortasuna [,exekuzio-kostua])
@DESCRIPTION=OPT_BS funtzioak Black-Scholes eredua erabiltzen du Europako aukera baten prezioa kalkulatzeko, @strike prezioan ezarrita baliatuz call_put_marka, @call_put_marka, 'c' edo 'p' @spot spot prezio bateko aktiboan.
@denbora: aukeraren mugaeguna, urtetan adierazita.
@tasa: arriskurik gabeko interes-tasa.
@hegazkortasuna: aktiboaren hegazkortasun urtekotua (ehunekotan), edo ekitaldian igarotako epea.
@exekuzio-kostua: mendeko aktiboaren balio-galera da; akzio arruntetan dibidenduaren etekina izango litzateke.
* Itzulitako balioa @strike eta @spot elementuen unitate berean adieraziko da.
@EXAMPLES=
@SEEALSO=OPT_BS_DELTA, OPT_BS_RHO, OPT_BS_THETA, OPT_BS_VEGA, OPT_BS_GAMMA
|
|
Translated by
Iñaki Larrañaga Murgoitio
|
|
|
|
3.
|
|
|
@FUNCTION=OPT_BS_DELTA
@SYNTAX=OPT_BS_DELTA(call_put_flag,spot,strike,time,rate,volatility[,cost_of_carry])
@DESCRIPTION=OPT_BS_DELTA uses the Black-Scholes model to calculate the 'delta' of a European option with call_put_flag, @call_put_flag, 'c' or 'p' struck at @strike on an asset with spot price @spot.
Where @time is the time to maturity of the option expressed in years.
@rate is the risk-free interest rate.
@volatility is the annualized volatility, in percent, of the asset for the period through to the exercise date.
@cost_of_carry is the leakage in value of the underlying asset, for common stocks, this would be the dividend yield.
* The returned value will be expressed in the same units as @strike and @spot.
@EXAMPLES=
@SEEALSO=OPT_BS, OPT_BS_RHO, OPT_BS_THETA, OPT_BS_VEGA, OPT_BS_GAMMA
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
represents a space character.
Enter a space in the equivalent position in the translation.
|
|
|
|
@FUNCTION=OPT_BS DELTA
@SYNTAX=OPT_BS DELTA(call_put_marka;spot,strike;denbora;tasa;hegazkortasuna [,exekuzio-kostua])
@DESCRIPTION=OPT_BS funtzioak Black-Scholes eredua erabiltzen du Europako aukera baten 'delta' kalkulatzeko, @strike prezioan ezarrita baliatuz call_put_marka, @call_put_marka, 'c' edo 'p' @spot spot prezio bateko aktiboan.
@denbora: aukeraren mugaeguna, urtetan adierazita.
@tasa: arriskurik gabeko interes-tasa.
@hegazkortasuna: aktiboaren hegazkortasun urtekotua (ehunekotan), edo ekitaldian igarotako epea.
@exekuzio-kostua: mendeko aktiboaren balio-galera da; akzio arruntetan dibidenduaren etekina izango litzateke.
* Itzulitako balioa @strike eta @spot elementuen unitate berean adieraziko da.
@EXAMPLES=
@SEEALSO=OPT_BS, OPT_BS_RHO, OPT_BS_THETA, OPT_BS_VEGA, OPT_BS_GAMMA
|
|
Translated by
Iñaki Larrañaga Murgoitio
|
|
|
|
4.
|
|
|
@FUNCTION=OPT_BS_GAMMA
@SYNTAX=OPT_BS_GAMMA(spot,strike,time,rate,volatility[,cost_of_carry])
@DESCRIPTION=OPT_BS_GAMMA uses the Black-Scholes model to calculate the 'gamma' of a European option struck at @strike on an asset with spot price @spot.
(The gamma of an option is the second derivative of its price with respect to the price of the underlying asset, and is the same for calls and puts.)
@time is the time to maturity of the option expressed in years.
@rate is the risk-free interest rate to the exercise date, in percent.
@volatility is the annualized volatility, in percent, of the asset for the period through to the exercise date.
@cost_of_carry is the leakage in value of the underlying asset, for common stocks, this would be the dividend yield.
* The returned value will be expressed as the rate of change of delta per unit change in @spot.
@EXAMPLES=
@SEEALSO=OPT_BS, OPT_BS_DELTA, OPT_BS_RHO, OPT_BS_THETA, OPT_BS_VEGA
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
|
@FUNCTION=OPT_BS_GAMMA
@SYNTAX=OPT_BS_GAMMA(spot;strike;denbora;tasa;hegazkortasuna[;exekuzio-kostua])
@DESCRIPTION=OPT_BS_GAMMA funtzioak Black-Scholes eredua erabiltzen du Europako aukera baten 'gamma' kalkulatzeko, @strike prezioan ezarrita baliatuz call_put_marka, @call_put_marka, 'c' edo 'p' @spot spot prezio bateko aktiboan.
(Aukera baten gamma bere prezioaren bigarren deribatua da, mendeko aktiboaren prezioarekiko, eta berdina izaten da call eta put-entzat.)
@denbora: aukeraren mugaeguna, urtetan adierazita.
@tasa: arriskurik gabeko interes-tasa.
@hegazkortasuna: aktiboaren hegazkortasun urtekotua (ehunekotan), edo ekitaldian igarotako denbora.
@exekuzio-kostua: mendeko aktiboaren balio-galera da; akzio arruntetan dibidenduaren etekina izango litzateke.
* Itzulitako balioa honela adieraziko da: deltaren aldaketa-tasa, @spot-eko aldaketa-unitateko.
@EXAMPLES=
@SEEALSO=OPT_BS, OPT_BS_DELTA, OPT_BS_RHO, OPT_BS_THETA, OPT_BS_VEGA
|
|
Translated by
Iñaki Larrañaga Murgoitio
|
|
|
|
5.
|
|
|
@FUNCTION=OPT_BS_THETA
@SYNTAX=OPT_BS_THETA(call_put_flag,spot,strike,time,rate,volatility[,cost_of_carry])
@DESCRIPTION=OPT_BS_THETA uses the Black-Scholes model to calculate the 'theta' of a European option with call_put_flag, @call_put_flag struck at @strike on an asset with spot price @spot.
(The theta of an option is the rate of change of its price with respect to time to expiry.)
@time is the time to maturity of the option expressed in years
and @rate is the risk-free interest rate to the exercise date, in percent.
@volatility is the annualized volatility, in percent, of the asset for the period through to the exercise date.
@cost_of_carry is the leakage in value of the underlying asset, for common stocks, this would be the dividend yield.
* The returned value will be expressed as minus the rate of change of option value, per 365.25 days.
@EXAMPLES=
@SEEALSO=OPT_BS, OPT_BS_DELTA, OPT_BS_RHO, OPT_BS_VEGA, OPT_BS_GAMMA
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
|
@FUNCTION=OPT_BS_THETA
@SYNTAX=OPT_BS_THETA(call_put_marka;spot;strike;denbora;tasa;hegazkortasuna[,exekuzio-kostua])
@DESCRIPTION=OPT_BS_THETA: Black-Scholes eredua erabiltzen du Europako aukera baten 'theta' kalkulatzeko call_put_markarekin, @call_put_marka @strike prezioan ezarrita @spot spot prezioko aktibo batean.
(Aukera baten theta bere prezioaren aldaketa-tasa da, mugaegunari dagokionez.)
@denbora: aukeraren mugaeguna, urtetan adierazita
@tasa: arriskurik gabeko interes-tasa.
@hegazkortasuna: aktiboaren hegazkortasun urtekotua (ehunekotan), edo
ekitaldian igarotako denbora.
@exekuzio-kostua: mendeko aktiboaren balio-galera da; akzio arruntetan dibidenduaren etekina izango litzateke.
* Itzulitako balioa honela adieraziko da: minus balioaren aldaketa-tasa, 365,25 egunekoa hain zuzen.
@EXAMPLES=
@SEEALSO=OPT_BS, OPT_BS_DELTA, OPT_BS_RHO, OPT_BS_VEGA, OPT_BS_GAMMA
|
|
Translated by
Iñaki Larrañaga Murgoitio
|
|
|
|
6.
|
|
|
@FUNCTION=OPT_BS_VEGA
@SYNTAX=OPT_BS_VEGA(spot,strike,time,rate,volatility[,cost_of_carry])
@DESCRIPTION=OPT_BS_VEGA uses the Black-Scholes model to calculate the 'vega' of a European option struck at @strike on an asset with spot price @spot.
(The vega of an option is the rate of change of its price with respect to volatility, and is the same for calls and puts.)
@volatility is the annualized volatility, in percent, of the asset for the period through to the exercise date.
@time is the time to maturity of the option expressed in years.
@rate is the risk-free interest rate to the exercise date, in percent.
@cost_of_carry is the leakage in value of the underlying asset, for common stocks, this would be the dividend yield.
* The returned value will be expressed as the rate of change of option value, per 100% volatility.
@EXAMPLES=
@SEEALSO=OPT_BS, OPT_BS_DELTA, OPT_BS_RHO, OPT_BS_THETA, OPT_BS_GAMMA
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
represents a space character.
Enter a space in the equivalent position in the translation.
|
|
|
|
@FUNCTION=OPT_BS_VEGA
@SYNTAX=OPT_BS_VEGA(spot;strike;denbora;tasa;hegazkortasuna[;exekuzio-kostua])
@DESCRIPTION=OPT_BS_VEGA funtzioak Black-Scholes eredua erabiltzen du Europako aukera baten ‘vega’ kalkulatzeko, @strike-n ezarrita, @spot spot prezio bateko aktibo batekiko.
(Aukera baten VEGA bere prezioaren aldaketa-tasa da hegazkortasunarekiko, eta berdina izaten da call eta put-entzat.)
@hegazkortasuna: aktiboaren hegazkortasun urtekotua (ehunekotan), edo ekitaldian igarotako denbora.
@denbora: aukeraren mugaeguna, urtetan adierazita.
@tasa: arriskurik gabeko interes-tasa.
@exekuzio-kostua: mendeko aktiboaren balio-galera da; akzio arruntetan dibidenduaren etekina izango litzateke.
* Itzulitako balioa honela adieraziko da: aukera-balioaren aldaketa-tasa, % 100eko hegazkortasunarekiko.
@EXAMPLES=
@SEEALSO=OPT_BS, OPT_BS_DELTA, OPT_BS_RHO, OPT_BS_THETA, OPT_BS_GAMMA
|
|
Translated by
Iñaki Larrañaga Murgoitio
|
|
|
|
7.
|
|
|
@FUNCTION=OPT_BS_RHO
@SYNTAX=OPT_BS_RHO(call_put_flag,spot,strike,time,rate,volatility[,cost_of_carry])
@DESCRIPTION=OPT_BS_RHO uses the Black-Scholes model to calculate the 'rho' of a European option with call_put_flag, @call_put_flag struck at @strike on an asset with spot price @spot.
@call_put_flag is 'c' or 'p' to indicate whether the option is a call or a put.
(The rho of an option is the rate of change of its price with respect to the risk free interest rate.)
@time is the time to maturity of the option expressed in years.
@rate is the risk-free interest rate to the exercise date, in percent.
@cost_of_carry is the leakage in value of the underlying asset, for common stocks, this would be the dividend yield.
* The returned value will be expressed as the rate of change of option value, per 100% change in @rate.
@EXAMPLES=
@SEEALSO=OPT_BS, OPT_BS_DELTA, OPT_BS_THETA, OPT_BS_VEGA, OPT_BS_GAMMA
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
|
@FUNCTION=OPT_BS_RHO
@SYNTAX=OPT_BS_RHO(call_put_marka;spot;strike;denbora;tasa;hegazkortasuna[,exekuzio-kostua])
@DESCRIPTION=OPT_BS_RHO: Black-Scholes eredua erabiltzen du Europako aukera baten 'ro' kalkulatzeko call_put_markarekin, @call_put_marka @strike prezio batean ezarrita @spot spot prezioko aktibo batean.
@call_put_marka:'c' edo 'p' da, aukera call edo put bat den adierazteko.
(Aukera baten 'ro' bere prezioaren aldaketa-tasa da, arriskurik gabeko interes-tasari dagokionez.)
@denbora: aukeraren mugaeguna, urtetan adierazita.
@tasa: arriskurik gabeko interes-tasa.
@exekuzio-kostua: mendeko aktiboaren balio-galera da; akzio arruntetan dibidenduaren etekina izango litzateke.
*Itzulitako balioa honela adieraziko da: aukera-balioaren aldaketa-tasa,% 100eko hegazkortasunarekiko.
@EXAMPLES=
@SEEALSO=OPT_BS, OPT_BS_DELTA, OPT_BS_THETA, OPT_BS_VEGA, OPT_BS_GAMMA
|
|
Translated by
Iñaki Larrañaga Murgoitio
|
|
|
|
8.
|
|
|
@FUNCTION=OPT_BS_CARRYCOST
@SYNTAX=OPT_BS_CARRYCOST(call_put_flag,spot,strike,time,rate,volatility[,cost_of_carry])
@DESCRIPTION=OPT_BS_CARRYCOST uses the Black-Scholes model to calculate the 'elasticity' of a European option struck at @strike on an asset with spot price @spot.
@call_put_flag is 'c' or 'p' to indicate whether the option is a call or a put.
(The elasticity of an option is the rate of change of its price with respect to its cost of carry.)
@volatility is the annualized volatility, in percent, of the asset for the period through to the exercise date. @time is the time to maturity of the option expressed in years.
@rate is the risk-free interest rate to the exercise date, in percent.
@cost_of_carry is the leakage in value of the underlying asset, for common stocks, this would be the dividend yield.
* The returned value will be expressed as the rate of change of option value, per 100% volatility.
@EXAMPLES=
@SEEALSO=OPT_BS, OPT_BS_DELTA, OPT_BS_RHO, OPT_BS_THETA, OPT_BS_GAMMA
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
|
@FUNCTION=OPT_BS_CARRYCOST
@SYNTAX=OPT_BS_CARRYCOST(call_put_marka;spot;strike;denbora;tasa;hegazkortasuna[;exekuzio-kostua])
@DESCRIPTION=OPT_BS_CARRYCOST: Black-Scholes eredua erabiltzen du Europako aukera baten elastikotasuna kalkulatzeko @strike prezioan ezarrita @spot spot prezioko aktibo batean.
@call_put_marka: 'c' edo 'p', aukera call edo put den adierazteko.
(Aukera baten elastikotasuna: bere prezioaren aldaketa-tasa, bere exekuzio-prezioari dagokionez.)
@hegazkortasuna: aktiboaren hegazkortasun urtekotua (ehunekotan), edo ekitaldian igarotako denbora.
@tasa: arriskurik gabeko interes-tasa.
@exekuzio-kostua: mendeko aktiboaren balio-galera da; akzio arruntetan dibidenduaren etekina izango litzateke.
*Itzulitako balioa honela adieraziko da: aukera-balioaren aldaketa-tasa,% 100eko hegazkortasunarekiko.
@EXAMPLES=
@SEEALSO=OPT_BS, OPT_BS_DELTA, OPT_BS_RHO, OPT_BS_THETA, OPT_BS_GAMMA
|
|
Translated by
Iñaki Larrañaga Murgoitio
|
|
|
|
9.
|
|
|
@FUNCTION=OPT_GARMAN_KOHLHAGEN
@SYNTAX=OPT_GARMAN_KOHLHAGEN(call_put_flag,spot,strike,time,domestic_rate,foreign_rate,volatility[,cost_of_carry])
@DESCRIPTION=OPT_GARMAN_KOHLHAGEN values the theoretical price of a European currency option struck at @strike on an asset with spot price @spot.
@call_put_flag is 'c' or 'p' to indicate whether the option is a call or a put.
@volatility is the annualized volatility, in percent, of the asset for the period through to the exercise date.
@time the number of days to exercise.
@domestic_rate is the domestic risk-free interest rate to the exercise date.
@foreign_rate is the foreign risk-free interest rate to the exercise date, in percent.
@cost_of_carry is the leakage in value of the underlying asset, for common stocks, this would be the dividend yield.
* The returned value will be expressed as the rate of change of option value, per 100% volatility.
@EXAMPLES=
@SEEALSO=OPT_BS, OPT_BS_DELTA, OPT_BS_RHO, OPT_BS_THETA, OPT_BS_GAMMA
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
represents a space character.
Enter a space in the equivalent position in the translation.
|
|
|
|
@FUNCTION=OPT_GARMAN_KOHLHAGEN
@SYNTAX=OPT_GARMAN_KOHLHAGEN(call_put_marka;spot;strike;denbora;tasa_nazionala;atzerriko_tasa;hegazkortasuna[;exekuzio-kostua])
@DESCRIPTION=OPT_GARMAN_KOHLHAGEN: Europako moneta-aukera baten prezio teorikoa baloratzen du @strike prezioan ezarrita @spot spot preziokoaukera batean.
@call_put_marka: 'c' edo 'p', aukera call edo put den adierazteko.
@hegazkortasuna: aktiboaren hegazkortasun urtekotua (ehunekotan), edo ekitaldian igarotako denbora.
@denbora: aukeraren mugaeguna, urtetan adierazita.
@tasa_nazionala: ekitaldiko eguneko arriskurik gabeko interes-tasa nazionala.
@atzerriko_tasa: ekitaldiko eguneko arriskurik gabeko atzerriko tasa, ehunekotan.
@exekuzio-kostua: mendeko aktiboaren balio-galera da; akzio arruntetan dibidenduaren etekina izango litzateke.
*Itzulitako balioa honela adieraziko da: aukera-balioaren aldaketa-tasa,% 100eko hegazkortasunarekiko.
@EXAMPLES=
@SEEALSO=OPT_BS, OPT_BS_DELTA, OPT_BS_RHO, OPT_BS_THETA, OPT_BS_GAMMA
|
|
Translated by
Iñaki Larrañaga Murgoitio
|
|
|
|
10.
|
|
|
@FUNCTION=OPT_FRENCH
@SYNTAX=OPT_FRENCH(call_put_flag,spot,strike,time,t2,rate,volatility[,cost_of_carry])
@DESCRIPTION=OPT_FRENCH values the theoretical price of a European option adjusted for trading day volatility, struck at @strike on an asset with spot price @spot.
@call_put_flag is 'c' or 'p' to indicate whether the option is a call or a put.
@volatility is the annualized volatility, in percent, of the asset for the period through to the exercise date.
@time the number of calendar days to exercise divided by calendar days in the year.
@t2 is the number of trading days to exercise divided by trading days in the year.
@rate is the risk-free interest rate.
@cost_of_carry is the leakage in value of the underlying asset, to the exercise date, in percent.
For common stocks, this would be the dividend yield.
@EXAMPLES=
@SEEALSO=OPT_BS, OPT_BS_DELTA, OPT_BS_RHO, OPT_BS_THETA, OPT_BS_GAMMA
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
represents a space character.
Enter a space in the equivalent position in the translation.
|
|
|
|
@FUNCTION=OPT_FRENCH
@SYNTAX=OPT_FRENCH(call_put_marka;spot;strike;denbora;t2;tasa;hegazkortasuna[;exekuzio-kostua])
@DESCRIPTION=OPT_FRENCH: Europako aukera baten prezioa baloratzen du, transakzio eguneko hegazkortasunaren arabera doituta, @strike prezio batean ezarrita @spot spot prezio bateko aktibo batean.
@call_put_marka: 'c' edo 'p', aukera call edo put den adierazteko.
@hegazkortasuna: aktiboaren hegazkortasun urtekotua (ehunekotan), edo ekitaldian igarotako denbora.
@denbora: ekitaldiko egunkari-egunak, zati urteko egunkari-egunak.
@t2: ekitaldiko merkatu-egunak, zati urteko merkatu-egunak.
@tasa: arriskurik gabeko interes-tasa.
@exekuzio-kostua: mendeko aktiboaren balio-galera da; akzio arruntetan dibidenduaren etekina izango litzateke.
@EXAMPLES=
@SEEALSO=OPT_BS, OPT_BS_DELTA, OPT_BS_RHO, OPT_BS_THETA, OPT_BS_GAMMA
|
|
Translated by
Iñaki Larrañaga Murgoitio
|
|
|