MarketXLS Blog

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.

Five low-priced 5G telecom stocks analyzed in December 2020 (Vodacom, MTN, MTS, Turkcell, KPN), with their 5G rollout status and prices at the time.

Tech penny stocks are technology shares trading under $5. What to check before buying (EPS, P/E, sales growth, price-to-sales) and the liquidity and regulatory risks.

Dividend-paying penny stocks (under $5) are rare. How to find them in Excel with the MarketXLS stocks-under-$5 list and =DividendYield(), and what risks to check.

Best options to buy research guide showing screening criteria for volume, IV, and spreads in Excel

LEAPS options are long-term options contracts with expiration dates over one year out. Learn what LEAPS are, top strategies like the poor man's covered call, and how to analyze them using MarketXLS Excel formulas.

Implied Volatility Screener helps options traders find contracts with the highest or lowest IV for premium selling and volatility strategies. Learn to build an IV screener in Excel with MarketXLS.

Five option strategies (bull call spread, bear put spread, iron condor, long call butterfly, protective collar) and how to check option liquidity first.

Penny stocks trade under $5 and are often illiquid. How to list stocks under $5 in Excel with MarketXLS and sort them by volume to find the most actively traded.

Delta neutral strategy showing portfolio balancing for volatility-focused trading with payoff diagrams

Short call options give sellers premium income in exchange for unlimited upside risk. Learn how to set up, track, manage, and roll short calls using MarketXLS in Excel.

Call Ratio Backspread is a bullish options strategy that offers unlimited upside profit potential with limited downside risk. Learn the complete setup, P&L scenarios, Greeks analysis, and how to build it in Excel.

VWAP Strategy uses the volume weighted average price to identify fair value, time entries, and improve execution in options trading. Learn to calculate VWAP and combine it with options strategies using MarketXLS.

A put ratio backspread sells one higher-strike put and buys two or more lower-strike puts. It profits most on a sharp drop and loses most at the long strike.

Call ratio spread strategy explained with setup, payoff diagrams, Greeks analysis, and risk management. Learn when to use this neutral options strategy and track it in Excel with MarketXLS.

Put ratio spread guide covering strategy setup, payoff diagram, max profit and loss calculations, Greeks analysis, risk management, and Excel implementation using MarketXLS options functions.