MarketXLS Blog

Market data, investing ideas, and practical Excel guides.

Browse series
Investing vs Trading - investment strategy framework and analysis in Excel with MarketXLS

Investing vs trading: investing holds assets for years to build wealth; trading buys and sells over days or weeks to profit from price moves, with more risk.

Portfolio & Investment Strategies
Exploring Fibonacci Trading Strategies - technical indicators and chart patterns in Excel with MarketXLS

Fibonacci retracement levels (23.6%, 38.2%, 50%, 61.8%) mark where a trending price may pull back before resuming. How to calculate and use them.

Stock Analysis
How to Create a Winning Option Strategy - options strategy analysis and payoff diagram in Excel with MarketXLS

An option strategy needs four parts: the right analysis tools, a defined strategy such as a spread or straddle, diversification, and position-level risk limits.

Options Trading
Investing Wisely With Greek Options - options strategy analysis and payoff diagram in Excel with MarketXLS

Investing Wisely With Greek Options Greeks in option trading are popularly known as parameters that define the behavior of options or derivatives. Knowing about these parameters is essential for making wise decisions regarding investments. In this article, we will discuss the importance of Options Greeks, different risk management techniques to get maximum returns and finally, */ -->

Options Trading
Setting Up MACD for Expert Analysis - technical indicators and chart patterns in Excel with MarketXLS

MACD is the 12-day EMA minus the 26-day EMA, with a 9-day EMA signal line. How to set it up, read crossovers and the histogram, and calculate it in Excel.

Stock Analysis
How Iron Condor and Strangle Options Differ

An iron condor is a four-leg, defined-risk credit trade; a strangle is a two-leg trade with undefined risk when sold. How the two differ in structure, volatility view, risk, and payoff.

Options Trading
Overview of Synthetic Strangle Investing - investment strategy framework and analysis in Excel with MarketXLS

A synthetic strangle copies a long strangle using stock plus two puts. How it is built, its profit and loss, its Greeks (long vega, short theta), and the risks.

Portfolio & Investment Strategies
The Factors Impacting Option Prices - options strategy analysis and payoff diagram in Excel with MarketXLS

Option prices depend on the stock price, strike, time to expiration, implied volatility, interest rates, and dividends. How each one moves call and put premiums.

Options Trading
Benefits of Being Delta Positive - options strategy analysis and payoff diagram in Excel with MarketXLS

Being delta positive means an options position gains when the stock rises. Learn how position delta works and which strategies (long calls, bull spreads, covered calls) are delta positive.

Options Trading
The Basics of Put Call Forward Parity - options strategy analysis and payoff diagram in Excel with MarketXLS

The Basics of Put Call Forward Parity Put-call forward parity states that for European options with the same underlying, strike, and expiration, the call price minus the put price equals the present...

Options Trading
YieldBased Options: What You Need to Know - options strategy analysis and payoff diagram in Excel with MarketXLS

Yield enhancement with options means selling options, such as covered calls and cash-secured puts, to earn premium. How it works, what it costs, and the risks.

Options Trading

Explore our 94 blog series

Browse articles by topic, arranged in reading order.

Browse the series directoryBrowse all article categories
Show all 94 series

The Professional Investment Platform Inside Excel

Live market data, stock screening, options analytics and portfolio management inside Excel.