Option prices in your own worksheet.
OptionConnect puts bid, ask, implied volatility and the Greeks for US-listed options into Excel. You pick the contract in a side panel, and the add-in writes the formulas for you.
In preparation for Microsoft Marketplace| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Ticker | Expiry | Strike | Type | Bid | Ask | Mid | Delta | IV | Status | Updated |
| 2 | TLT | 2026-11-20 | 88 | PUT | 1.42 | 1.45 | 1.435 | -0.41 | 14.2% | Market open | 16:42:10 |
| 3 | AAPL | 2026-12-18 | 250 | CALL | 9.80 | 9.95 | 9.875 | 0.52 | 27.5% | Market open | 16:42:10 |
| 4 | SPY | 2027-01-15 | 600 | PUT | 7.10 | 7.16 | 7.13 | -0.24 | 16.8% | Market open | 16:42:11 |
| 5 | |||||||||||
| 6 | |||||||||||
| 7 | |||||||||||
| 8 | |||||||||||
| 9 | |||||||||||
| 10 | |||||||||||
| 11 |
Illustration with example values. These are not live prices.
A watchlist that fills itself in.
Built for people who already keep their trading notes and statistics in Excel and are tired of typing prices by hand.
Pick contracts by clicking
Type a ticker. The panel lists the available expiry dates and strikes and preselects the strike closest to the current price.
Prices that refresh
Choose a refresh interval of 5, 15, 30 or 60 minutes, or refresh only when you click. One setting applies to every OptionConnect formula.
Implied volatility and Greeks
Delta, gamma, theta and vega are calculated for each contract, together with implied volatility.
Clear when the market is closed
The Status column shows whether the US market is open. When it is closed, you see the last available values and the column tells you which ones they are.
Add columns later
Tick another column in the panel and it is added to the whole list, with its header.
Your workbook stays with you
The add-in sends only the contract you ask about: ticker, expiry, strike and call or put. Nothing else from your file leaves your computer.
From ticker to row in three steps.
-
Open the panel
Click the OptionConnect button on Excel's Home tab. The panel opens on the right side of your worksheet.
-
Choose the contract
Enter the ticker, then pick expiry, strike, and call or put. Tick the columns you want, such as Bid, Ask, Delta and IV.
-
Insert into the sheet
Select a cell and click Insert. OptionConnect writes one row with live formulas. Each further contract goes on the next row.
Fifteen values per contract.
Every value is an ordinary Excel formula, so you can use it in your own calculations, charts and conditional formatting.
If you prefer to type formulas yourself, there are three functions:
Excel in some languages, for example German and Norwegian, separates the arguments with a semicolon instead of a comma. The panel writes the right form for your Excel automatically.
| Column | What it shows |
|---|---|
| Bid, Ask | Best buying and selling price |
| Mid | Halfway between bid and ask |
| Last | Last traded price |
| Delta, Gamma | Sensitivity to the price of the underlying |
| Theta | Loss of value per day |
| Vega | Sensitivity to volatility |
| IV | Implied volatility |
| Volume | Contracts traded today |
| Open interest | Contracts outstanding |
| Underlying | Price of the underlying share or fund |
| Days to expiry | Calendar days left |
| Status | Market open, or closed (last session or last trade) |
| Updated | Time of the last refresh |
One add-in, one simple price.
Every plan includes all features. Try it free for 14 days first.
Monthly
USD 15 per month
Cancel at any time. The licence stays valid until the end of the month you paid for.
Yearly
USD 129 per year
About USD 10.75 a month, about 28% less than paying monthly.
Founding member
USD 99 per year
For our first 100 yearly customers. You keep this price for as long as your subscription renews without a break.
- Prices in US dollars, plus VAT or sales tax where applicable. The tax for your country is calculated and shown at checkout, before you pay.
- One licence is for one person, on up to 2 of that person's computers.
- Market data from your own broker or data provider may have its own cost, set by that provider.
- OptionConnect is not on sale yet. The prices apply from the launch.
What you need.
- Microsoft Excel in a version that supports Office Add-ins, such as Excel for Microsoft 365.
- An internet connection while the prices refresh.
- A licence after the free 14-day trial. See Pricing.
Read this before you use the add-in and its data.
Prices may be delayed by 15 minutes or more, and they can be incomplete or wrong.
We do not check the data. OptionConnect uses established market data providers and shows their data as it arrives. ACPN Consulting does not verify or validate it. The providers will be named here before the launch.
OptionConnect is an information tool. It gives no investment advice and makes no recommendations. Trading options carries a high risk of loss.
You use the add-in and its data at your own risk. As far as the law allows, ACPN Consulting GmbH accepts no liability for losses or damage that result from using OptionConnect or from relying on the data it shows. The details are set out in the Terms of Use.
Want to know when it is available?
Send us a short email and we will tell you when OptionConnect is listed on Microsoft Marketplace.