Put-Call Parity in Options Trading Explained Using Excel

Sdílet
Vložit
  • čas přidán 31. 05. 2024
  • Dive into the essentials of options trading with our comprehensive video on Put-Call Parity explained using Excel. Uncover the intricacies of the Black Scholes Option Pricing Model and its inputs, a cornerstone for understanding market strategies. Gain a thorough grasp of the Put-Call Parity formula and its significance in identifying arbitrage opportunities when mispricing occurs. Learn how to leverage Excel to compare the payoff structures of different portfolios, enhancing your trading acumen and decision-making in the dynamic world of options.
    💾 Purchase the file created in this video here: ryanoconnellfinance.com/produ...
    🎓 Tutor With Me: 1-On-1 Video Call Sessions Available
    ► Join me for personalized finance tutoring tailored to your goals: ryanoconnellfinance.com/finance-tutoring/
    👨‍💼 My Freelance Financial Modeling Services:
    ► Custom financial modeling solutions tailored for your needs: ryanoconnellfinance.com/freelance-finance-services/
    📚 CFA Exam Prep Discount - AnalystPrep:
    ► Get 20% off CFA Level 1, 2, and 3 complete courses with promo code "RYAN20". Explore here: analystprep.com/shop/all-3-levels-of-the-cfa-exam-complete-course-by-analystprep/?ref=mgmymmr
    📘 FRM Exam Prep Discount - AnalystPrep:
    ► Get 20% off FRM Part 1 and Part 2 complete courses with promo code "RYAN20". Explore here: analystprep.com/shop/frm-part-1-and-part-2-complete-course-by-analystprep/?ref=mgmymmr
    Chapters:
    0:00 - Intro to "Put-Call Parity Explained"
    0:30 - Inputs for Black Scholes Option Pricing Model
    1:15 - Put-Call Parity Formula
    3:29 - Arbitrage Opportunities with Mispricing
    5:24 - Payoff Structures of Both Portfolios
    Disclosure: This is not financial advice and should not be taken as such. The information contained in this video is an opinion. Some of the information could be wrong. This channel is owned and operated by Portfolio Constructs LLC. Some of the links above are affiliate links, meaning, at no additional cost to you, I will earn a commission if you click through and make a purchase.

Komentáře • 36

  • @RyanOConnellCFA
    @RyanOConnellCFA  Před 6 měsíci +1

    💾 Purchase the file created in this video here: ryanoconnellfinance.com/product/black-scholes-put-call-parity-calculator/
    🎓 Tutor With Me: 1-On-1 Video Call Sessions Available
    ► Join me for personalized finance tutoring tailored to your goals: ryanoconnellfinance.com/finance-tutoring/

  • @weeeek1933
    @weeeek1933 Před 5 měsíci +6

    This channel is golden lol, just discovered you will your videos on markowitz's portffolio frontier and this stuff on derivaties is great, thanks man

    • @RyanOConnellCFA
      @RyanOConnellCFA  Před 5 měsíci

      Welcome aboard! I'm glad to hear you enjoyed them, it's my pleasure

  • @GOjoe1970
    @GOjoe1970 Před 2 měsíci +2

    Love the content you put out. I was wondering if you would possibly do one on the Bjerksund-Stensland Option Pricing Model? Very interested in how that would be performed on Excel.

    • @RyanOConnellCFA
      @RyanOConnellCFA  Před měsícem +1

      Thanks for the suggestion and I can look into this topic in the future!

  • @tsunningwah3471
    @tsunningwah3471 Před 6 měsíci +1

    you video is awesome cuz my professor keep using algebra instead of real number which is easier to conceptualise

    • @RyanOConnellCFA
      @RyanOConnellCFA  Před 6 měsíci

      Thank you! Sometimes real world examples really help to get a concept down

  • @joelcollard2151
    @joelcollard2151 Před 2 měsíci

    Awesome video. One questions, in the second half of the video, why do you use the strike price to calculate the cash payoff instead of the discounted strike price? This deviates from the original put call parity formula so I did not follow this. Thanks in advance.

  • @tsunningwah3471
    @tsunningwah3471 Před 6 měsíci +1

    good! comment before watching

  • @fahadalgaeed8478
    @fahadalgaeed8478 Před 6 měsíci +1

    Best channel on youtub

    • @RyanOConnellCFA
      @RyanOConnellCFA  Před 6 měsíci +1

      Thank you man, this may be the best feedback I've gotten

  • @tsunningwah3471
    @tsunningwah3471 Před 6 měsíci +1

    come back to revise for my final next month!

  • @pablomoure2963
    @pablomoure2963 Před 6 měsíci +1

    Howdy man ¡ Would you considered making a video regarding the SBM (FRTB SA) ? I think it would be quite interesting if you could explain how to calculate delta vega and curvature of the trading book. Thank you in advance

    • @RyanOConnellCFA
      @RyanOConnellCFA  Před 6 měsíci

      Hey Pablo, I can look into this topic in the future!

  • @syetolognasyete3423
    @syetolognasyete3423 Před 6 měsíci +1

    Thank you from Russia!

  • @petersignore9547
    @petersignore9547 Před měsícem

    In this scenario, since the calls value is more than the put, if you were to long Port A and short Port B there is theta decay risk, not zero risk.

  • @rojarani-sh3yl
    @rojarani-sh3yl Před 4 měsíci +1

    @ryan how we can enter 1 week expiration time

    • @RyanOConnellCFA
      @RyanOConnellCFA  Před 4 měsíci

      For time (t) you can enter =7/365
      7 being the number of days in a week and 365 being the number of days in a year

  • @tsunningwah3471
    @tsunningwah3471 Před 6 měsíci +1

    hi sir! my professor said the Ke^-rt is a future. But it is a bond in this video. I am confused..

    • @RyanOConnellCFA
      @RyanOConnellCFA  Před 6 měsíci

      K*e^-rt is just a zero coupon bond discounted at the risk free rate (r) for a certain amount of time (t), where K is equal to the notional value of the bond. It assumes continuous compounding of interest (that is where e comes in)

    • @tsunningwah3471
      @tsunningwah3471 Před 6 měsíci +1

      @@RyanOConnellCFA thanks ryan!

    • @RyanOConnellCFA
      @RyanOConnellCFA  Před 6 měsíci

      @@tsunningwah3471 My pleasure!

  • @victoricus1
    @victoricus1 Před 6 měsíci +2

    hello! but in reality, does this mispricing ever occur? and how often?

    • @RyanOConnellCFA
      @RyanOConnellCFA  Před 6 měsíci +3

      Any mispricing like this shouldn't exist for more than a fraction of a second before high frequency traders secure the arbitrage and force put-call pricing back into parity

    • @bp56789
      @bp56789 Před 6 měsíci +2

      I'm not an expert, but I imagine it will occur whenever someone does a price-changing purchase without a corresponding parity purchase on the other side (i.e. inefficient execution of purchasing a particular risk exposure).

    • @victoricus1
      @victoricus1 Před 6 měsíci +1

      @@RyanOConnellCFA thank you! so, it's a purely theoretical thingy used to derive call price from put price and vice versa?

    • @victoricus1
      @victoricus1 Před 6 měsíci

      @@bp56789 cheers matey

    • @RyanOConnellCFA
      @RyanOConnellCFA  Před 6 měsíci +1

      @@victoricus1 It is both theoretical and practical I'd say. Put-call parity isn't used to determine the price of calls and puts, (that would be option pricing models like Black Scholes and Binomial Option Pricing Model). It is more so used to point out a relationship that must hold true or arbitrage profits can be earned immediately