Formula for "Implied Volatility"

>> I am very interested in what you are doing. I have done (am doing) similar, and find it difficult ( a huge amount of >> work) but very educational. The benefit of the things we learn by these endeavors, will likely outweigh the >> original goal of the task.

Yes, I have done extremely complicated simulations for stocks but what I like and hear about options is the "non directional" which seems to open up new possibilities. The idéa is to start doing credit spread and iron condors backtests where the simulation will take in: IV, bid-ask spreads, volume, delta, theta, strike width, earnings, adjustments, stoploss, take profit, DTE, combinations of monthly options and weekly options, roll or not roll etc etc in as many different combinations as possible. I am thinking of in the million range combinations. Also make the optimization artficial month after month to find the "best" combinations in regards to predefined inputs as biggest profit and lowest draw downs where the optimization changes the trading month after month in the optimization.

Have you done anything like this?
 
Last edited:
Derrenoption said:
>> I am very interested in what you are doing. I have done (am doing) similar, and find it difficult ( a huge amount of >> work) but very educational. The benefit of the things we learn by these endeavors, will likely outweigh the >> original goal of the task.

Yes, I have done extremely complicated simulations for stocks but what I like and hear about options is the "non directional" which seems to open up new possibilities. The idéa is to start doing credit spread and iron condors backtests where the simulation will take in: IV, bid-ask spreads, volume, delta, theta, strike width, earnings, adjustments, stoploss, take profit, DTE, combinations of monthly options and weekly options, roll or not roll etc etc in as many different combinations as possible. I am thinking of in the million range combinations. Also make the optimization artficial month after month to find the "best" combinations in regards to predefined inputs as biggest profit and lowest draw downs where the optimization changes the trading month after month in the optimization.

Have you done anything like this?
More...
Wow! :thumbsup:

You are working on your PhD in finance, writing your PhD thesis and I am still struggling to write a junior high school term paper on economics. I feel so inadequate.:(:banghead::thumbsdown:

What you are doing cannot be done with EXCEL. Since I only know how to do my analysis on EXCEL, I better start to learn programming in C.:vomit::mad::wtf:

Best wishes.
 
Yes, I try to prepare for the task as much as I can, I can do it but it will take some time I beleive :)
But it will be very interesting to do. I don't think it is possible to do this in excel, it might be a little to complex but if you know much in excel you will soon learn how to program in C.
 
Derrenoption said:
Yes, I try to prepare for the task as much as I can, I can do it but it will take some time I beleive :)
But it will be very interesting to do. I don't think it is possible to do this in excel, it might be a little to complex but if you know much in excel you will soon learn how to program in C.
More...
I can do a lot in excel except iterations, i.e., do loops. If I can figure out a way to do a do loop in excel, I would be a very happy camper because it is usually very easy to import data from the internet in excel files and work on them.

If anyone here knows how, I appreciate your help.
 
Below is one method I used in VB, if this helps.
-------
Function ImpliedCallVolatility(UnderlyingPrice, ExercisePrice, Time, Interest, Target, Dividend)
High = 5
Low = 0
Do While (High - Low) > 0.0001
If CallOption(UnderlyingPrice, ExercisePrice, Time, Interest, (High + Low) / 2, Dividend) > Target Then
High = (High + Low) / 2
Else: Low = (High + Low) / 2
End If
Loop
ImpliedCallVolatility = (High + Low) / 2
End Function
-----------------
Function ImpliedPutVolatility(UnderlyingPrice, ExercisePrice, Time, Interest, Target, Dividend)
High = 5
Low = 0
Do While (High - Low) > 0.0001
If PutOption(UnderlyingPrice, ExercisePrice, Time, Interest, (High + Low) / 2, Dividend) > Target Then
High = (High + Low) / 2
Else: Low = (High + Low) / 2
End If
Loop
ImpliedPutVolatility = (High + Low) / 2
End Function
 
stepandfetchit said:
Below is one method I used in VB, if this helps.
-------
Function ImpliedCallVolatility(UnderlyingPrice, ExercisePrice, Time, Interest, Target, Dividend)
High = 5
Low = 0
Do While (High - Low) > 0.0001
If CallOption(UnderlyingPrice, ExercisePrice, Time, Interest, (High + Low) / 2, Dividend) > Target Then
High = (High + Low) / 2
Else: Low = (High + Low) / 2
End If
Loop
ImpliedCallVolatility = (High + Low) / 2
End Function
-----------------
Function ImpliedPutVolatility(UnderlyingPrice, ExercisePrice, Time, Interest, Target, Dividend)
High = 5
Low = 0
Do While (High - Low) > 0.0001
If PutOption(UnderlyingPrice, ExercisePrice, Time, Interest, (High + Low) / 2, Dividend) > Target Then
High = (High + Low) / 2
Else: Low = (High + Low) / 2
End If
Loop
ImpliedPutVolatility = (High + Low) / 2
End Function
More...
Thank you! You just save me many hours trying to understand and program such.

Regards,
 
You must log in or register to reply here.
Back
Top