MarketXLS Blog

Manage options income risk with four rules: size each trade at 1-2% of capital, use defined-risk spreads, diversify underlyings, and set an exit before entering.

Get Thinkorswim option chain data into Excel three ways: Scan tab export (static), RTD link (live, Windows only), or MarketXLS QM_GetOptionChain without ToS running.

Selling weekly put options for income explained with strike selection, risk management, Greeks analysis, and step-by-step Excel tracking using MarketXLS option chain and pricing formulas.

The wheel strategy sells cash-secured puts until assigned, then sells covered calls on the shares until they are called away, and repeats. Steps, scenarios, and a worked example.

Options trading Excel spreadsheets give traders real-time option chains, Greeks tracking, P&L analysis, and strategy modeling directly in their familiar Excel environment.

Option writing turns stock holdings into income: sell covered calls on shares you own or cash-secured puts on shares you want to buy, and keep the premium.

Five options trading tips for beginners: use a low-commission broker, focus on risk, stick to liquid stocks, avoid complex products, and use limited-risk strategies.

Implied volatility surface analysis reveals how IV varies across strikes and expirations, helping options traders identify mispriced contracts. Learn to build one in Excel.

Export your Yahoo Finance portfolio to Excel as a CSV, then turn the symbols and weights into a portfolio analytics dashboard with MarketXLS portfolio functions.

Stocks vs stock CFDs: buying a stock gives you ownership; a CFD is a leveraged contract with a broker on the price change. Compare shorting, leverage, costs and risks.

MarketXLS 9.2 (September 2020) added portfolio analytics functions that take a holdings-and-weights range as input, Benzinga news functions, and new templates.

Option premium is the price paid for an options contract, determined by intrinsic value, time value, volatility, and other factors. Learn how to calculate, analyze, and track option premiums using Excel and MarketXLS formulas.

To build an efficient frontier in Excel, you calculate each asset's average monthly return, the covariance matrix of those returns, and then solve for the portfolio weights that give the lowest...

How the binomial option pricing model values an option with an up/down price tree, how it differs from Black-Scholes, and a worked Excel example.

Stock volatility calculator methods explained for Excel. Learn historical vs implied volatility, annualizing returns, VIX analysis, and how to calculate volatility using MarketXLS functions.

MarketXLS 9.1 (June 2020) added a function Search and Help button, ETF holdings functions, historical volatility functions, and streaming improvements.