MarketXLS Blog

The term small-cap usually refers to firms with small market capitalization, ranging from $300million to $2 billion.

Married put strategy explained with setup, cost analysis, and real MarketXLS formulas. Learn how to protect stock positions using puts, compare with protective puts, and manage risk in Excel.

Introduction The industrial goods sector is a category of companies that make or sell machinery, supplies, or equipment used in manufacturing and construction.

Overvalued stocks trade above their intrinsic value and can expose investors to significant downside risk. Learn how to identify overvalued stocks using valuation metrics, screening methods, and MarketXLS Excel formulas.

It is clear from its name; Stock Replacement is a strategy that effectively recreates the position of owning stocks by using other financial instruments.

Basic Materials Sector includes companies involved in mining, chemicals, forestry, and construction materials. Learn how to analyze basic materials stocks, top ETFs, and use MarketXLS to research this cyclical sector.

Introduction Options are an important derivative class, which allow traders to take positions and generate profits with a limited amount of risk.

Technical Indicators’ analysis is the study of historical data to estimate futuristic trends and fluctuations in the prices of stocks. It is used to determine the entry and exit points in the market.

Technical Analysis Chart Patterns provide visual signals of potential price movements — and Excel gives you the tools to identify, validate, and backtest these patterns using real market data.

Introduction Consumer discretionary is an expression for services and goods that are non-essential items.

Introduction Environmental, social and corporate governance (ESG) matters have never been more important to investors and, by extension, the minds leading the economy’s publicly traded corporations.

An albatross spread is an advanced options trading strategy used to obtain profits when the stock price is stable or inactive and when the price stays within the chosen price range.

Introduction You might have come across the term technical analysis countless number of times. This word fascinates most of us but very few of us actually know what technical analysis is.

The Put Ratio Spread is a neutral strategy in options trading adopted by traders. The strategy involves buying a select number of put options of a particular stock and expiration date at a higher...

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

Key Updates in this Release ###1\. New Guru Screens Functions In this release, we have added many advanced Guru Screen functions.