MarketXLS Blog

What is Arbitrage? Profit from Arbitrage means purchasing an asset in one market at a lower price and simultaneously selling the same in another market at a high price.

Learn the difference between cyclical and non-cyclical stocks and how to determine the nature of a stock using MarketXLS.

The DuPont method is an essential analysis used to assess a company’s performance in detail. Donaldson Brown, a DuPont Corporation salesman, found the DuPont equation in 1920.

Introduction The dividend discount model, also known as the Gordon Growth Model,is used to determine a stock’s intrinsic value based on a future series of dividends that grow at a constant rate.

Neophyte and even experienced investors are often wary of options trading. Many people view options as risky, exotic, and only for investors with large bankrolls.

Everyone in the investment world has heard of Warren Buffet— one of the worlds wealthiest people, consistently ranking high on Forbes list of billionaires. Known as the Oracle of Omaha, Warren Buffett is one of the most successful investors of all time. Investors revere his investing strategies across the globe. He follows the Benjamin Graham */ -->

Swing trading is a market strategy where positions are held for longer than one day. Most fundamentals traders tend to be swing traders because changes in the fundamentals of a corporation usually...

What is Quantitative Analysis? Quantitative Analysis of stocks is a technique that uses mathematical and statistical modeling, functions, formulas, and measurements to understand the behavior of a...

Introduction In 1988 Geraldine Weiss, renowned as ‘The Dividend Detective,’ wrote the classic ‘Dividends Don’t Lie’, which centralized on the Dividend-Yield Theory as a method of mastering Value...

Piotroski F-Score calculation and screening guide covering all 9 criteria, step-by-step Excel implementation, stock screening workflows, and practical ranking strategies using MarketXLS.

Overview: Investing In The Indian Stock Market India permitted foreign investments into the country in the 1990s.

Correlation matrix analysis helps investors measure portfolio diversification, identify hidden risk concentrations, and optimize asset allocation using real Excel formulas and data-driven tools.

Charles Schwab users can export portfolio data to Excel and unlock advanced analysis with MarketXLS. Learn how to build risk dashboards, calculate efficient frontiers, and analyze holdings beyond Schwab's built-in tools.

Markets worldwide are much more integrated now than before, allowing businesses and investors a chance to tap into investment opportunities they could never access from a distance. Emerging markets are grabbing investors attention as some people look for places to diversify their portfolios. Emerging markets are selling at discounted valuation multiples to the U.S. markets, */ -->

Drones – The new coming of age technology  IMG Source: https://stockhead.

Risk Parity Portfolio The risk parity approach to portfolio construction seeks to allocate the capital in a portfolio based on a risk-weighted basis.