MarketXLS Blog

Yahoo Portfolio is a great way to keep track of your investments and stock purchases online. Yahoo Finance portfolio has a great and intuitive way to add your transactions and then track your portfolio in real-time. And with the Create New View screen you can simply add many more parameters in the table and compare */ -->

There’s more than one way to gain exposure in and profit from the stock market. Investing in stocks as the primary asset is one, and trading contract for differences or CFDs is another.

Key Updates in this release 1###New Portfolio Analytics Functions In this release we have added very advanced portfolio analytics functions.

Option premium is the price paid for an options contract, determined by intrinsic value, time value, volatility, and other factors. Learn how to calculate, analyze, and track option premiums using Excel and MarketXLS formulas.

The Efficient frontier using excel is one of the most important financial tools that help an investor compose an investment portfolio with the maximum returns and minimum amount of risk.

! The Binomial Option Pricing Model Excel is available as a template with MarketXLS. The Binomial Option Pricing Model is a popular model for stock options evaluation, and to calculate the options...

Stock volatility calculator methods explained for Excel. Learn historical vs implied volatility, annualizing returns, VIX analysis, and how to calculate volatility using MarketXLS functions.

Key Updates in this release 1###New Function Search UtilityTo make it easier for you to search for a function and get the details on it, in this release, we have a new Search and Help button on the...

Learn about the covered put options strategy, how it works, and when to use it for income generation.

Investing in the stock market is an excellent way to earnextra income. You can be an active trader and watch for dips and surges in themarket or be a passive investor and wait for your assets to...

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

! In most of the situations, it’s always better to trade options that are highly liquid and active. In this article, I will show you how you can use MarketXLS’s inbuilt option scanner to quickly find...

What is a drawdown?A drawdown (usually understood as maximum stock drawdown) is an indicator of downside risk over a specified period of time.

Fundamental analysis of stocks explained with valuation ratios, financial statement analysis, key metrics, and step-by-step Excel tracking using MarketXLS formulas for PE ratio, revenue, market cap, and more.

Historical option prices data enables traders to backtest strategies, analyze implied volatility patterns, and make informed trading decisions using Excel-based tools and real market data.

The United States enjoy a massive mutual fund base. The availability of so many mutual fund investment opportunities, however, comes with the challenge of proper market analysis.