MarketXLS Blog

Consumer discretionary (cyclical) stocks sell non-essential goods and services, so they tend to rise and fall with the economy. Indicators to watch, sector ETFs, and risks.

What ESG investing means, how rating agencies such as MSCI score companies, and ten stocks with high ESG ratings as of June 2021.

An albatross spread is a four-leg condor with wider strikes. A long albatross profits in a wide range; a short albatross profits from a big move either way.

Technical analysis studies past price and volume to judge where a stock may go next. A beginner guide to charts, candlesticks, trends, and support and resistance.

A put ratio spread buys one higher-strike put and sells two lower-strike puts. Max profit at the lower strike; large downside risk below the breakeven.

Telecommunications sector investing requires understanding key companies, 5G trends, dividends, and valuation metrics. Learn how to analyze telecom stocks in Excel with MarketXLS formulas.

MarketXLS version 9.3 (June 2021) added Guru Screen functions such as =gs_Lynch_Screen(), new templates, faster refresh-on-demand, and Options Scanner filters.

A SPAC is a shell company that raises money in an IPO, holds it in trust, and then merges with a private company. How SPACs work, their structure, and the risks.

A short guts sells an in-the-money call and an in-the-money put with the same expiry. Setup, maximum profit, unlimited risk, breakevens, and when it is used.

The long guts options strategy buys an in-the-money call and an in-the-money put on the same stock and expiration to profit from a large move either way.

Bull put spread strategy showing credit spread for bullish market with payoff diagram

Bull call spread strategy showing buy lower strike call, sell higher strike call with payoff diagram

A married put buys a put on a stock you own. Max loss is capped at stock price minus strike plus the premium; upside stays open, less the put cost.

Three ways for US investors to buy Canadian stocks: interlisted shares on US exchanges, Canada ETFs such as EWC, and direct TSX purchases. Data as of 2021.

Short guts sells an in-the-money call and put for a credit and profits if the stock stays in range; long guts buys both and profits from a large move. Break-evens and risks.

Ways for US investors to buy European stocks: ADRs, GDRs, ETFs, mutual funds and direct foreign accounts, plus notable names, ETFs and currency risk.