Portfolio & Investment Strategies

Investment tracker in Excel showing real-time portfolio dashboard with stock prices and gain/loss columns using MarketXLS

Build an investment tracker in Excel: one row per holding with shares, cost, =Last() price, market value, gain/loss, weight, and dividend income, using MarketXLS formulas.

7/31/2024 • Shubham Shah
The Art of Portfolio Rebalancing with - portfolio optimization and risk metrics in Excel with MarketXLS

Portfolio rebalancing moves a drifted portfolio back to its target weights. Learn when to rebalance and how to calculate the trades in Excel with MarketXLS.

5/15/2023 • Ankur
Boost Your Investment Returns with the ROIC Formul - investment strategy framework and analysis in Excel with MarketXLS

ROIC formula guide showing return on invested capital calculation and value creation interpretation

3/14/2023 • Anagh
Get Ahead with a Dividend Calendar Spreadsheet Str - dividend yield tracking and income analysis in Excel with MarketXLS

A dividend calendar spreadsheet lists ex-dividend, record, and pay dates with expected amounts for each holding, so you can plan income and reinvestment.

3/10/2023 • Robin
Streamline Your Dividend Tracking with a Spreadshe - dividend yield tracking and income analysis in Excel with MarketXLS

A dividend calendar spreadsheet lists each holding with its ex-dividend date, pay date, frequency, and amount so you know when income arrives. How to build one with MarketXLS.

3/10/2023 • Robin
Dividend portfolio tracker in Excel showing yield and income analysis with MarketXLS formulas

Dividend portfolio tracking in Excel lets you monitor yield, income, ex-dividend dates, and DRIP growth across all your holdings. Build a complete tracker with MarketXLS formulas.

3/9/2023 • Ankur
Create a Dividend Calendar Spreadsheet to Maximize - dividend yield tracking and income analysis in Excel with MarketXLS

Build a dividend calendar spreadsheet in Excel with ex-dividend date, pay date, frequency, dividend per share, and yield for each holding to forecast retirement income.

3/8/2023 • Robin
Maximize Your Portfolio Performance with Efficient - portfolio optimization and risk metrics in Excel with MarketXLS

The efficient frontier is the set of portfolios with the highest expected return for each level of risk. How to plot it for your portfolio in Excel with MarketXLS.

3/6/2023 • Ankur
5 Essential Principles of Factor Investing - investment strategy framework and analysis in Excel with MarketXLS

The five principles of factor investing: pick factors with persistent premiums, diversify across them, apply rules consistently, hold long term, and review regularly.

1/18/2023 • Anagh
Unlocking the Benefits of Portfolio Rebalancing - portfolio optimization and risk metrics in Excel with MarketXLS

Portfolio rebalancing sells what has grown above target and buys what has lagged, restoring your chosen asset mix and risk level.

1/18/2023 • Anagh
Carhart Four Factor Model - multi-factor regression and portfolio attribution analysis in Excel with MarketXLS

Carhart Four Factor Model extends Fama-French by adding momentum to explain portfolio returns. Learn the formula, how to calculate each factor in Excel, and perform portfolio attribution using MarketXLS.

1/18/2023 • Anagh
Maximizing REIT Returns With a Screener - investment strategy framework and analysis in Excel with MarketXLS

A REIT screener filters real estate investment trusts by property type, dividend yield, FFO or AFFO payout, leverage, and valuation, so you research a shortlist instead of every REIT.

1/18/2023 • Ankur
Secrets to Smart Investing from Larry Swedroe - investment strategy framework and analysis in Excel with MarketXLS

Larry Swedroe's investing principles in brief: diversify across asset classes and countries, keep costs low with funds such as ETFs, manage risk, and follow a written plan.

1/18/2023 • Ankur
10 Portfolio Management Tips Before Retirement - portfolio optimization and risk metrics in Excel with MarketXLS

10 portfolio management tips for retirement planning with diversification, rebalancing, and tax efficiency strategies

1/17/2023 • Anagh
Invest Smarter - Use an Efficient Frontier Calculat - portfolio optimization and risk metrics in Excel with MarketXLS

An efficient frontier calculator uses expected returns, volatilities, and correlations to find the asset mixes with the highest expected return for each level of risk.

1/17/2023 • Ankur
Master Asset Allocation with the Help of Calculato - portfolio optimization and risk metrics in Excel with MarketXLS

Asset allocation calculators turn your risk tolerance, time horizon, and goals into a target mix of stocks, bonds, and cash. What they measure and how to model allocation in Excel.

1/17/2023 • Robin