Portfolio & Investment Strategies

Risk Parity Portfolio In Excel - Explanation & Con - portfolio optimization and risk metrics in Excel with MarketXLS

Risk parity weights assets so each contributes a similar share of portfolio risk. The inverse-volatility formula, and a worked 4-asset reweighting example in Excel with MarketXLS.

3/24/2021 • Shubham Shah
The Defensive Investor (Utility) Strategy By Benja - investment strategy framework and analysis in Excel with MarketXLS

Benjamin Graham's Defensive Investor screen: rules for size, financial strength, earnings and dividend history, growth, and P/E, plus a MarketXLS template.

3/19/2021 • Shubham Shah
Portfolio Risk Management - portfolio optimization and risk metrics dashboard in Excel with MarketXLS

Portfolio risk management is essential for protecting your investments and achieving long-term financial goals. Learn how to measure, monitor, and manage portfolio risk using Excel and MarketXLS.

2/19/2021 • Shubham Shah
Sortino ratio calculation in Excel spreadsheet showing downside deviation and risk-adjusted returns with MarketXLS

Sortino ratio = (return minus minimum acceptable return) / downside deviation. The formula, a step-by-step Excel calculation, and how it compares with the Sharpe ratio.

1/25/2021 • Ankur
Yahoo Portfolio - Export Portfolio In Excel (To Us - portfolio optimization and risk metrics in Excel with MarketXLS

Export your Yahoo Finance portfolio to Excel as a CSV, then turn the symbols and weights into a portfolio analytics dashboard with MarketXLS portfolio functions.

10/9/2020 • Anagh
Efficient Frontier Using Excel (With - portfolio optimization and risk metrics in Excel with MarketXLS

To build an efficient frontier in Excel, you calculate each asset's average monthly return, the covariance matrix of those returns, and then solve for the portfolio weights that give the lowest...

8/17/2020 • Anagh
Portfolio beta calculator showing systematic risk measurement and weighted beta analysis in Excel with MarketXLS

Portfolio beta calculator tools help investors measure systematic risk, understand market sensitivity, and optimize portfolio allocations using Excel formulas and automated analysis.

2/8/2020 • Ankur
Warren Buffet Investment Portfolio Through The Las - portfolio optimization and risk metrics in Excel with MarketXLS

How Warren Buffett built Berkshire Hathaway over its first 50 years: insurance float, wholly owned businesses, and long-term stock holdings, as described in 2014 and 2017.

6/20/2017 • Anagh
Magic Formula Investing Screener In Excel - investment strategy framework and analysis in Excel with MarketXLS

How Joel Greenblatt's magic formula ranks stocks on earnings yield and return on capital, and how to build the screen in Excel with MarketXLS formulas.

5/31/2017 • Ankur
Portfolio analysis in Excel with MarketXLS

MarketXLS adds 1000+ financial-data functions to Excel and Google Sheets: quotes, price history, fundamentals, options, technical indicators, and portfolio tools.

3/21/2017 • Robin