Devam Ediyor

Write a function in VBA based on the included formula for converting delta and volatility to strike price

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.

Beceriler: Excel, Visual Basic, Veri İşleme, Matematik, Finans

Daha fazlasını gör: write simple text based game code, write function vbnet, write function takes positive integer returns leading digit, write function net, excel optimization function vba, excel column entry proper function vba macro samples, print function vba, access 2007 vba write function, write function will return larger integers, converting delta celsius farenheit, write oracle query based day, converting delta fahranheit celsius, formula converting utm latitude longitude, write function 2005, vba unicode macro write function, write function definition using array based implementation, write function using array based implementation

İşveren Hakkında:
( 0 değerlendirme ) London, United Kingdom

Proje NO: #26336210

Seçilen:

yuling6631

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

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% GBP
(17 Değerlendirme)
3.4

Bu iş için 17 freelancer ortalamada £18 teklif veriyor

kevivu

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(76 Değerlendirme)
5.9
AnowarRatul

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(123 Değerlendirme)
5.5
merinsinha

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(33 Değerlendirme)
4.2
mowachira77

Hi there, I am an expert in excel VBA, excel formulas, data processing as well as mathematics and finance. I am interested in writing a function that will be used to complete your task. In this regard, I am available Daha Fazla

£15 GBP in 7 gün içinde
(20 Değerlendirme)
4.0
faiiz

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(7 Değerlendirme)
3.1
Jayant222

Hi there, I am an expert in this . I have gone through the project description and can help you on this project. Thanks, Jayant

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(5 Değerlendirme)
2.1
grownup

****** 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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(3 Değerlendirme)
1.3
JSComputerTech

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(0 Değerlendirme)
0.0
mishraabhishek44

I am perfect data entry you give any work of data entry .

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(0 Değerlendirme)
0.0
vsahilnagpal

Hello. I am working as a full-time freelancer. I believe in customer satisfaction, quality work and i'll complete the given task on time. The services I provide : 1. MS Word 2. MS Power Point 3. MS Excel 4. PDF to Wo Daha Fazla

£15 GBP in 7 gün içinde
(0 Değerlendirme)
0.0
MsKeshalla

Hi, This is Keshalla from Malaysia. I am writing in response to your advertisement on Data entry. After reviewing the requirements of the job description, I feel that I am a suitable match for the job. I am an expert Daha Fazla

£15 GBP in 7 gün içinde
(0 Değerlendirme)
0.0
anandpatel2244

i will give you best work. Thank you.

£16 GBP in 5 gün içinde
(0 Değerlendirme)
0.0
zeyadabed2006

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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(0 Değerlendirme)
0.0
SumitGoyal1973

I have knowledge of derivative products. I will be able to complete this and do proper testing with different data.

£15 GBP in 3 gün içinde
(0 Değerlendirme)
0.0
durgeshgupta715

Work done in given period of time

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(0 Değerlendirme)
0.0
makkenavija

Will do

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(0 Değerlendirme)
0.0