MarketXLS Blog

A short strangle sells an out-of-the-money call and put with the same expiry to collect premium when a stock stays in a range. Risk is unlimited.

Options trading income requires careful tracking of premiums collected, assignment events, and net P&L. Learn how to build a complete income tracker in Excel with real formulas.

High volume stocks are the most heavily traded shares. Why volume matters for liquidity and trends, how to read volume with price, and how to find them in Excel.

Penny stocks trade under $5, are thinly traded, and swing sharply. Why they are volatile, the main risks, and how to list and track their volatility in Excel with MarketXLS.

Portfolio risk management is essential for protecting your investments and achieving long-term financial goals. Learn how to measure, monitor, and manage portfolio risk using Excel and MarketXLS.

Trade Options on Robinhood with this complete beginner's guide covering approval levels, order types, strategies, Greeks, and how MarketXLS enhances your options analysis in Excel.

Options theta measures the daily time decay of an option's price. How theta works by moneyness, expiration, and volatility, plus MarketXLS formulas for Greeks analysis in Excel.

What are Long Call Options?A long call is buying a call option because you expect the underlying stock to rise above the strike price plus the premium before expiration.

SPY, the SPDR S&P 500 ETF Trust, launched in 1993 as the first US-listed ETF and tracks the S&P 500. How it works and why SPY options are so heavily traded (data as of Feb 2021).

A short call or short put means selling an option to collect premium. How each works, and a worked MSFT bear call spread with max profit, max loss, and breakeven.

Beneish M-Score guide covering all 8 variables for detecting earnings manipulation, the complete formula, step-by-step Excel calculation, and screening strategies using MarketXLS.

What is a long put option strategy? A long put is a bearish trade where you buy one put option and profit if the stock falls below the strike price minus the premium you paid.

Diagonal Spread options strategy explained — setup, Greeks impact, risk management, variations, and how to model diagonal spreads in Excel with MarketXLS formulas.

Options explained simply: how hedge funds use options to reduce risk, why the VIX matters, common volatility-based strategies, and Excel templates to track them.

Sortino ratio = (return minus minimum acceptable return) / downside deviation. The formula, a step-by-step Excel calculation, and how it compares with the Sharpe ratio.

Pharma penny stocks require thorough research and screening before investing. Learn how to analyze pharmaceutical small-cap stocks using MarketXLS formulas for fundamentals, revenue, and valuation.