SERVING THE QUANTITATIVE FINANCE COMMUNITY

 
User avatar
hrad
Topic Author
Posts: 29
Joined: February 3rd, 2012, 2:01 pm

Pricing Options Using Copulas

August 15th, 2020, 11:26 pm

Hi all,

I have a implied black scholes volatility surfaces for European style options on futures. I need to be able to price basket options and spread options.

As far as I understand I can derive a cumulative distribution function for each underlying futures contract by pricing very tight put spreads or call spreads using my implied volatility surfaces ie replicating digital options. I have read that I can impose a dependence structure on these CDF’s to be able to price basket and spread options consistently with the vanilla options. Honestly the maths is a bit too intense for me to fully get my mind around. I’ve bought 3 books now, Dong Qu’s ‘Manufacturing and Managing Customer-Driven Derivatives’, and Umberto Cherubinis ‘Copula Methods in Finance’ and ‘Dynamic Copula Methods in Finance’. I understand the maths enough that I get the concept, I love the concept, I desperately want to implement it, but even after all the reading I genuinely don’t even know where to begin to make it happen.

If someone can help me by showing me in excel or pointing me in the right direction of how to implement in excel (long story but it needs to be excel) it would be so amazing.
ABOUT WILMOTT

PW by JB

Wilmott.com has been "Serving the Quantitative Finance Community" since 2001. Continued...


Twitter LinkedIn Instagram

JOBS BOARD

JOBS BOARD

Looking for a quant job, risk, algo trading,...? Browse jobs here...


GZIP: On