MarketXLS Blog

Penny stocks under 10 cents mostly trade over the counter with thin volume, wide spreads, and high manipulation risk. What to check before buying and how to track them in Excel.

A technical stock screener filters stocks by price, volume and indicator rules such as moving averages and RSI. How to set criteria and review results.

Put option strategies showing long put, put spread, and protective put with payoff diagrams

Heikin Ashi candles average price data to smooth noise and make trends easier to read. Learn the formulas and how traders use them for trend direction and reversals.

The main fixed income options are government bonds and corporate bonds. How they differ in yield and risk, and what duration, credit risk, and the yield curve mean.

Achieving High Yields with Penny Stocks and Dividends If youre an investor looking for higher yields than what the major markets offer, penny stocks may be just what youre looking for. Penny stocks, while they come with a risk and volatility, offer investors the potential for higher returns. Combined with dividend payouts, these small stocks */ -->

A straddle buys a call and put at the same strike; a strangle buys an out-of-the-money call and put at different strikes. Both profit from a large move in either direction.

An option price is intrinsic value plus time value, driven by stock price, strike, time, volatility, rates and dividends. Black-Scholes, binomial models and Greeks.

How traders approach SPY options: common strategies, the role of scanning and risk management, and how to analyze SPY option data in Excel with MarketXLS.

The bid is the highest price a buyer will pay for an option; the ask is the lowest price a seller will accept. How the bid-ask spread affects your cost.

Pull a live option chain into Excel with =QM_GetOptionChain("AAPL") and read each column: strike, premium, implied volatility, delta, and expiration.

Get live option prices in Excel with MarketXLS: pull a full option chain or a single contract, plus what drives option prices and how to model P/L.

How to analyze a stock trend with historical prices: moving averages, support and resistance, and volatility, with the Excel formulas to do it.

How a dividend stock screener works, which criteria to use (yield, payout ratio, valuation), and how to build one in Excel with MarketXLS.

Options swing trading holds call or put positions for a few days to a few weeks to capture a price swing. The basics: technical entries, risk limits, and profit targets.

In-the-money options have intrinsic value: calls with strikes below the stock price, puts with strikes above. How ITM options behave, their uses, and risks.