← 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

Market data in your Excel sheets

1 billion usable data points on stocks, options, ETFs, and fundamentals, with simple Excel formulas.

See plans
How does MarketXLS work?
▶
How does MarketXLS work? Watch Demo

Similar Templates

No similar templates found