Choosing More Accurate Binomial Tree Parameters For Valuing Equity Options

相似文件 换一批

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

Interesting paper recommended by Wilmott.
option31.pdf (559.18 KB)

2014-4-26 19:01:31 上传

There seems little point in beating about the bush - it's easy to improve the accuracy of the standard binomial models for valuing equity options and yet very few people know how. So banish your Cox, Ross & Rubinstein (or Jarrow & Rudd) models and replace them with the Leisen & Reimer model - just paste the accompanying VBA functions into a new module sheet.

Why you should use the LR binomial parametersMost academics when teaching options rely on the assertion that, merely by increasing the number of steps used in a binomial model, accuracy improves. What they omit to mention is that, apart from the special case when the strike price is equal to the current share price, both the CRR and JR binomial models do not converge uniformly but instead oscillate. Steps Time JR error CRR error LR error 9 1 -1.0317% 0.7997% -0.0283% 20 1 0.6110% 0.6838% -0.0057% 29 1 0.3458% -0.4628% -0.0031% 40 2 -0.2297% 0.3713% -0.0016% 49 1 0.3074% -0.0536% -0.0011% 60 1 0.0039% 0.1824% -0.0007% 69 1 0.1204% 0.0952% -0.0006% 80 1 0.1453% 0.0552% -0.0004% 89 1 -0.0611% 0.1336% -0.0004% 100 2 0.1519% -0.0378% -0.0003% 199 4 0.0697% 0.0352% -0.0001% 300 7 0.0477% 0.0499% -0.0001% 399 11 0.0379% 0.0231% -0.0001% 500 17 0.0238% -0.0309% 0.0000% 599 23 0.0006% 0.0184% 0.0000% 700 32 -0.0146% 0.0182% 0.0000% 799 41 0.0114% -0.0163% 0.0000% 900 50 0.0168% 0.0125% 0.0000% 999 62 0.0054% 0.0112% 0.0000% The above table shows both the time taken (in milliseconds on my pc, where the BS value takes 1 millisecond) and percentage error when using the exact binomial option pricing formula to value a European call option using three different choices of binomial parameters. It is clear that as we increase the number of binomial steps, the sign of the error with both the JR and CRR parameters changes. In contrast, the LR choice of parameters remove the oscillation and even more importantly reduce the size of the absolute error to relatively tiny levels, with even as few as 50 steps. Where does the accuracy of the LR tree come from? The LR tree has separate approximations for each of N(d1) and N(d2) terms, whereas traditional trees jointly approximate N(d1) and N(d2). Why is there no oscillation with the LR tree? The option values from the LR tree do not oscillate because the tree is centred on the exercise price. On the other hand, with traditional trees the addition of a single step can switch one of the end nodes from being out-of-the money to in-the-money and this changes the sign of the error. The VBA Code The Option Explicit line forces you to declare all variables (apart from input parameters) using Dim statements, while the Option Base 1 line ensures that VBA arrays are numbered starting from 1 (to conform with Excel). The Dim statement declares the variables with the default Variant type. The VBA functions, Sqr, Log and Exp, must be used in place of their Excel equivalents. Excel functions are used with the preface Application. (alternatively the newer WorksheetFunction. preface will do). Once written, the function can be called from the Function Wizard (in the User Defined category) just like any ordinary Excel functions. The first function, BinTreeParamVec, returns a vector with the necessary parameters (for multiplicative up and down moves and associated up probability) for each of the three models. The LR parameters require the PPNormInv function that returns the binomial approximation to the normal distribution. The second function, BinEuroOptionValue, uses the exact European call option pricing formula from Cox & Rubinstein, adapted here to allow for a continuous dividend yield. Notice that due to the limitations of the BinomDist function in Excel, my function is limited to having fewer than 1025 steps. Code see: http://www.wilmott.com/detail.cfm?articleID=113 Reference The Leisen & Reimer paper "Binomial Models for Option Valuation - Examining and Improving Convergence" is somewhat technical but those brave souls might wish to track it down in volume 3 (1996) of Applied Mathematical Finance, pages 319-346.

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏0 回帖

关键词：parameters Parameter paramete Binomial accurate academics standard replace people equity

wilmott magazine的文章怎么看啊，需要钱么？

cooper56 发表于 2014-4-27 00:20
wilmott magazine的文章怎么看啊，需要钱么？

http://www.wilmott.com/home.cfm

You can register on this website and they will send you notification via email to inform you they have some recent update in the article. Also the latest issue of the magazine is free I think.