Portfolio & Investment Strategies

Harnessing the Power of Heikin Ashi Trading An Ess - investment strategy framework and analysis in Excel with MarketXLS

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.

1/16/2023 • Ankur
How to Use ZScores to Analyze Data in Excel - portfolio optimization and risk metrics in Excel with MarketXLS

A Z score is (value minus mean) divided by standard deviation. Calculate it in Excel with STANDARDIZE, AVERAGE, and STDEV.S, and use it to spot outliers in stock data.

1/16/2023 • Ankur
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.

1/16/2023 • Anagh
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.

1/16/2023 • Ankur
Leveraging OShaughnessys Investing Strategy - investment strategy framework and analysis in Excel with MarketXLS

O’Shaughnessy’s investing strategy combines value, growth and momentum filters in a quantitative stock screen. How it works and how to run it in Excel.

1/16/2023 • Robin
Investing in Consumer Staples Sector - investment strategy framework and analysis in Excel with MarketXLS

Consumer staples (food, beverages, household and personal products, tobacco) sell in any economy, which makes the sector defensive. Pros, cons, and example stocks.

9/22/2021 • Anagh
Understanding Yield Curve (Trading Strategy & Yiel - investment strategy framework and analysis in Excel with MarketXLS

A yield curve plots bond yields against maturity. How normal, flat, and inverted curves differ, riding the yield curve, and yield curve control.

7/14/2021 • Shubham Shah
Pivot Point Trading strategy showing support and resistance levels calculated in Excel with MarketXLS

A pivot point is (prior high + low + close) / 3; support and resistance levels are derived from it. How to calculate standard, Woodie, Camarilla, and Fibonacci pivots in Excel.

7/4/2021 • Shubham Shah
Basic Materials Sector analysis and stock research in Excel with MarketXLS

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.

6/23/2021 • Ankur
Telecommunications sector analysis and stock comparison in Excel spreadsheet with MarketXLS

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

6/2/2021 • Shubham Shah
Investing In Special-Purpose Acquisition Company ( - investment strategy framework and analysis in Excel with MarketXLS

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.

5/31/2021 • Shubham Shah
Dividend Safety- Analyzing With - dividend yield tracking and income analysis in Excel with MarketXLS

Judge dividend safety with payout ratio, free cash flow payout, dividend coverage, dividend growth history, and the Altman Z-Score, using MarketXLS in Excel.

5/13/2021 • Robin
Dividend Growth (Gordon Growth Model) - dividend yield tracking and income analysis in Excel with MarketXLS

The Gordon Growth Model values a stock as next year's dividend divided by the required return minus the dividend growth rate: D1 / (k - g).

4/17/2021 • Shubham Shah
Weiss Blue-Chip Dividend Yield Screen - Tracking A - dividend yield tracking and income analysis in Excel with MarketXLS

The Weiss Blue-Chip Dividend Yield Screen filters for companies with 25 years of dividends, steady EPS and dividend growth, low debt, and a payout ratio under 50%.

4/12/2021 • Shubham Shah
Correlation matrix heatmap showing stock diversification analysis and portfolio risk measurement in Excel with MarketXLS

How to build and read a stock correlation matrix in Excel: pull prices, compute returns, use CORREL for each pair, and apply the results to diversification.

4/4/2021 • Shubham Shah
Charles Schwab portfolio data exported to Excel with MarketXLS analysis dashboard showing risk metrics and efficient frontier

Charles Schwab users can export positions to Excel as .csv or .xls and analyze them with MarketXLS formulas. Learn how to build risk dashboards, calculate efficient frontiers, and analyze holdings beyond Schwab's built-in tools.

3/28/2021 • Shubham Shah