← Back to Templates

Put-Call Parity Arbitrage

Description

Put-Call Parity Arbitrage thumbnail

Put call parity says a call and a put at the same strike and expiration must price in a fixed relationship to the underlying and the discounted strike. This sheet computes both sides of that identity from current option asks and the stock's last price, so a gap wide enough to survive spreads and financing costs shows up as a number rather than a hunch.

Strike and expiration inputs generate the option symbols and the quotes are pulled on demand. Apparent gaps usually close once bid ask spreads, dividends and early exercise on American options are accounted for.

Template Screenshots

Put-Call Parity Arbitrage screenshot 1

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
How does MarketXLS work?
How does MarketXLS work? Watch Demo

Similar Templates

No similar templates found