MarketXLS Blog

Stock Data Excel Add-in tools let you pull real-time quotes, historical prices, fundamentals, and options chains directly into your spreadsheet — no copy-paste, no CSV downloads, no broken links.

Improve Portfolio Strategy by Checking Covariance Among Two Stocks Covariance analysis is a vital tool in portfolio management, providing insights into the degree to which two stocks move together.

Stock portfolio tracker in Excel showing dashboard with portfolio value, P&L, and holdings analysis

Ex-Dividend Dates determine whether you qualify for upcoming dividend payments — and tracking them in Excel ensures you never miss a payment or make a poorly timed purchase.

How to Get Stock History for Multiple Stocks in Excel? Getting stock history in Excel for multiple stocks can be a great way to track progress or analyze trends.

Understanding Terminal Value in Stocks Terminal value refers to a value used to estimate the future cash flows of a company beyond the explicit forecast period in a discounted cash flow (DCF)...

Exploring Negative Correlation in Stock Market Investing In stock market investing, utilizing correlation between different types of securities can help investors manage risks and boost investment...

How to Analyze Dogs of the Dow Stocks for Investing \================================================= Dogs of the Dow investing strategy is one of the most popular and well known stock selection...

Exploring Bargain Penny Stocks Trading Under 10 Cents In today’s volatile stock market, penny stocks remain the top investment option among investors.

Learn How to Use a Technical Stock Screener Technical analysis is a technique deploying the analysis of stock prices to predict the future performance of a particular stock by studying its past...

Achieving High Yields with Penny Stocks and Dividends If youre an investor looking for higher yields than what the major markets offer, penny stocks may be just what youre looking for. Penny stocks, while they come with a risk and volatility, offer investors the potential for higher returns. Combined with dividend payouts, these small stocks */ -->

Stock trend analysis with historical data showing moving averages, support and resistance levels

Dividend stock screener showing criteria for yield, payout ratio, and consecutive years of growth

Mastering the Art of Bollinger Band Trading Day trading can be an overwhelming and daunting task for those who lack experience, knowledge, or in-depth understanding.

How to Identify and Use RSI in Trading What is Relative Strength Index (RSI)? Relative Strength Index (RSI) is a technical analysis indicator used in stock trading for measuring momentum and to...

The Advantages of a Dedicated Stock Trading Platform Investing in stocks can be a daunting task for many.