← Back to Templates

STOCK REPLACEMENT

Description

STOCK REPLACEMENT thumbnail

Replacing a stock position with a deep in the money call is the trade this workbook sizes. A high delta call moves nearly point for point with the shares while tying up a fraction of the capital, and the most that can be lost is the premium, though the contract carries time decay that the shares do not.

One year stock volatility appears next to the quotes because the premium paid for that substitution rises with it. Bid, ask and previous close for the chosen contract are pulled on demand beside the underlying's last price.

Template Screenshots

STOCK REPLACEMENT 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