Закрыт

Convert VBA formula provided for Delta to solve for strike using the explanation provided.

Hello, I am posting this to try and figure out the correct way to solve and write the VBA function in the excel sheet provided, with the explanation provided in order to solve for the strike rather than the delta.

delta - volatility to strike conversion, rather than the volatility - strike to delta conversion that you see in the sheet attached.

The following is an explanation I found online, in which the first 3 formulas match the VBA function I already have for finding Delta.

"It's just a matter of backing it out of the formula for delta:

delta(call) = exp(-rf*Time) * pnorm(d1v)

delta(put) = exp(-rf*Time) * pnorm(d1v) - 1

d1 = (log(spot/strike)+(rf+(sigma^2)/2)*Time)/(sigma*sqrt(Time))

so, solve for d1 first:

d1(call) = qnorm(delta/exp(-rf*Time))

d1(put) = qnorm(delta/exp(-rf*Time) + 1)

and then solve for the strike:

strike = exp( d1 - (rf+(sigma^2)/2)*Time)/(sigma*sqrt(Time) )

Here is a link to the full problem and answer:

[login to view URL]

I have made an attempt myself but I am going to leave that out this time as it is probably just confusing.

If you need further info please do ask

Навыки: Excel, Visual Basic, Calculus, Математика, Excel VBA

Показать больше: convert vba dll, convert vba excel vb6, convert vba php code, home based excel jobs, freelance excel work hourly rate, freelance excel spreadsheet design, macros for financial reporting, excel spreadsheet jobs from home, financial analysis and modeling using excel and vba pdf, get paid to make excel spreadsheets, black-scholes formula, convert vba project php, convert vba html, convert vba vbnet software, sample examples formula field crystal report using, convert vba standalone program, can convert vba vbnet, convert vba project exe

О работодателе:
( 0 отзыв(-а, -ов) ) London, United Kingdom

ID проекта: #26339642

11 фрилансеров(-а) готовы выполнить эту работу в среднем за £19

khushh07

Hello Greetings to you!! I am an excel(Macro)/Visual Basic expert and interested to work with your project. I have checked your requirements and that makes complete sense to me. I assure you of a high-quality job. Plea Больше

£20 GBP за 1 день
(292 отзывов(-а))
7.1
mtdevil369

Hi, Greetings! ✅checked your project details :Convert VBA formula provided for Delta to solve for strike using the explanation provided. ✅Completed Time : 24 hours or your requirement deadline . I would like to work o Больше

£15 GBP за 1 день
(269 отзывов(-а))
6.7
narsim3128

NOTE : I HAVE EXPERTISE IN EXCEL AND VBA. I CAN COMPLETE THIS TASK IN QUICK TIME. With respect to this project I would like to present myself as a candidate for your consideration. I have more than 12 years of IT expe Больше

£50 GBP за 3 дней(-я)
(49 отзывов(-а))
5.8
VbaStudio

Hello. I'm a specialist in Excel formulas and macros. I know how to do to translate the formulas you already have to Excel formulas.

£20 GBP за 1 день
(6 отзывов(-а))
3.4
SafriTI

Dear client. Here is data processing manager. I have just read your requirement at carefully. I'm an expert of data processing by using many Excel macros such as DAX, pivotTable managing and excel VBA. I have developed Больше

£10 GBP за 1 день
(9 отзывов(-а))
3.2
dtrighatia

Hey! I am a scholar from IIM-Calcutta and IIT-Delhi, two of the most prestigious business and engineering schools in India. I am very well versed in Excel/Macros/Pivot Tables/VBA use them on a daily basis. I have 4 yea Больше

£20 GBP за 1 день
(6 отзывов(-а))
3.0
arifbilal75

Greetings! I’m very much interested to your project description about---vba I have a degree in Electrical Engineering over 5 years of experience, therefore, I can easily do this job. You can message me to discuss the d Больше

£10 GBP за 1 день
(5 отзывов(-а))
2.1
WycOj

Dear client, I can help you with your project of data entry in excel, VBA, excel macros, VB, building an excel file, word, database and Microsoft office at large since that is my area of expertise within your minimal b Больше

£15 GBP за 7 дней(-я)
(1 отзыв)
1.1
tabrez5march

I understand about your project , and I will do this project for you I am expertise in php,java script,html,excel,wordpress,cobra and logo and graphic designing and format converting,video and audio converting ,vis Больше

£19 GBP за 2 дней(-я)
(0 отзывов(-а))
0.0
mp883

Hi. This is the Black Scholes Model. I have a Master in Financial Engineering from Imperial College London so familiar with it. I work as an Access/Excel VBA RAD developer for an Investment Bank in London where I am co Больше

£10 GBP за 1 день
(1 отзыв)
0.0
muralivedula

I work for ITC Limited and my main Iitb is to build tools or analyse the data coming from 20 different factories. Vba & Macros is one of the tools O use along with Tableau & R. We can sit on a weekend and sort out the Больше

£16 GBP за 1 день
(0 отзывов(-а))
0.0