Find Jobs
Hire Freelancers

Really easy project! Create one excel add-in using XLL+ in Visual Studio Platform with Code Provided

$30-45 USD

进行中
已发布将近 11 年前

$30-45 USD

货到付款
Code are provided for problem a-c as the attachments, XLL+ will be needed. (Comparing binomial and trinomial option pricing) This problem asks you to create one Excel add-in which has functions for the Black-Scholes formula, binomial option pricing and trinomial option pricing. You can use the C code you created in the solutions to previous homework assignments or the code provided in the solutions or lecture files. The three Excel functions created in this problem should be placed in a single Excel add- in called xllp bs.xll. Make sure that the .xll is compiled in Release mode. The XLL+ source code should be in a file named xllp [login to view URL] and the non-XLL+ source code (e.g., which contains the option pricing and supporting routines) should be in a separate file bs [login to view URL] with corresponding header file bs routines.h. You might also want to have a separate file containing NR routines nr [login to view URL] and corresponding header file nr routines.h. (a) Use XLL+ to create an Excel function bs call(S, σ, δ, r , T, K) which returns the Black-Scholes price of a European call option. Test the function with the parameters: S = 100, σ = 0.6, δ = 0.01, r = 0.05, T = 3, and K = 102. (b) Use XLL+ to create an Excel function binomial call(S, σ, δ, r , T, K, n) which returns the binomial approximation to the price of a European call option using n time steps and the CPU time in seconds. The function binomial call is an Excel array function because it returns two results in an array. The results should appear in a column. Test the function with the same parameters as in (a) together with n = 100. (c) Use XLL+ to create an Excel function trinomial call(S, σ, δ, r , T, K, λ, n) which returns the trinomial approximation to the price of a European call option using the trinomial stretch parameter λ and n time steps and also returns the CPU time in seconds. The two results should be returned in a column array. Test the function with the same parameters as in (a) together with λ = √3/2 and n = 100. (d) (Extra credit) This part asks you to create a graph in Excel of average absolute error versus average CPU time. The graph should contain two series, one corresponding to the binomial method and the other corresponding to the trinomial method. Each series of results should correspond to n = 2000, 4000, 8000, and 16000 time steps. For each value of n, price European call options using the binomial method, with the same parameters as in (a), but for the eleven strikes 90, 92, . . . , 110. For each strike compute the absolute value of the error (where the error is the binomial price compared to the Black-Scholes price), and then average the results to compute the average absolute error. Also average the CPU time over the eleven options priced. Then repeat for each of the four values of n, giving four values of average absolute error and average CPU time for the binomial method. Repeat the process for the trinomial method. Plot the resulting two series of binomial and trinomial results of the average absolute error versus average CPU time with the axes both in logarithmic scale. Hint: Set up the spreadsheet and graph for smaller values of n, e.g, n = 200, 400, 800 and 1600. When this is working properly, change the values of n to the larger set.
项目 ID: 4384067

关于此项目

1条提案
远程项目
活跃11 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
Hey, we worked together on a previous project. I know the price is a higher than your posted range, but it's just the realistic minimum that I'm comfortable doing projects for after all the site's commission, fees, and then transfer fees. If it's too high, that's understandable, and I hope we'll work together on a future project.
$55 USD 在2天之内
5.0 (1条评论)
1.5
1.5
1威客以均价$45 USD来参与此工作竞标
用户头像
Ready to initiate the project and willing to deliver the perfect output you desire. Details on PM
$45 USD 在1天之内
5.0 (1条评论)
1.8
1.8

关于客户

UNITED STATES的国旗
New York, United States
5.0
2
付款方式已验证
会员自3月 24, 2013起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。