Please convert the formula described in to an excel function in VBA that will produce a strike price given the delta and volatility input:
Please see the paper attached describing this process mathematically on page 10 formula (19)
I have also attached an image of the formula in question which if inputting the parameters required will produce the strike associated with that delta
The approximate answer should be around 1891
once the function is working I will use it to calculate the strike for any given delta as input 0.1, 0.25, 0.5 and so on.
Hi I read your project carefully. Im an expert in EXCEL VBA. I'm ready to start right now. I can let you show the sample file what i did before. Please contact with me and discuss in details. THANKS, REGARDS
Bu iş için 17 freelancer ortalamada £18 teklif veriyor
Hi, I have reviewed your requirement and I worked on numerous similar projects in the past and always impressed the clients with my excellent solutions. You can refer my freelancer profile for reviews and completed t Daha Fazla
Hello sir, I have seen your attachments carefully and understand it clearly. I have done this type of projects before. I can converting delta and volatility to strike price by maintaining 100% accuracy of your data abs Daha Fazla
Hi i am an certified senior excel vba devoloper. For Professional works -Hire me. As 10+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can prov Daha Fazla
Hi Sir I am interrested in this project. My name is Faiz and im a statistician and a professional data scientist, a combination that provides me with the full suite of tools to do data analysis, data modelling and dat Daha Fazla
Hi there, I am an expert in this . I have gone through the project description and can help you on this project. Thanks, Jayant
****** I will start right away***** Hello , I have in VBA previously I know your issue and I assure you that I will fix it . It only requires couple of function then it will be working perfectly. hope to have a cha Daha Fazla
Hi Dear! I have read you project descriptions carefully. I am not hesitated to tell that I have 5+ year experience of Ms Excel works. I am Expert in VBA programing and Micros. I can do it very quickly. I work in Govt. Daha Fazla
Dears, Good Day, I check the files and the formula at VBS ( =DeltaStrike(D6;D10;D11;D7;D8;D9) ), I can finish it today but I need to communicate with you for more details.