MarketXLS Blog

What are Long Call Options?A long call option strategy is purchasing a call option with the expectation that the underlying stock will rise.

What is the SPY?The SPDR S&P 500 Trust ETF (SPY) is an exchange-traded fund (ETF) that tracks the Standard & Poor’s 500 (S&P 500) index.

What is it?Most beginner options strategies are named by juggling the four words- long, short, call, and put. Understand these four basic terminologies, and half the job is done.

Beneish M-Score guide covering all 8 variables for detecting earnings manipulation, the complete formula, step-by-step Excel calculation, and screening strategies using MarketXLS.

What is it?Out of the myriad of options strategies out there, long put strategy is probably the simplest of all. Unlike most strategies, long put involves just one step.

Diagonal Spread options strategy explained — setup, Greeks impact, risk management, variations, and how to model diagonal spreads in Excel with MarketXLS formulas.

Introduction There has always been an ambiguity around options trading regarding the potential profits and the risks involved. Some find it too risky, while others use it to hedge their portfolios.

Sortino ratio measures risk-adjusted returns using only downside volatility — giving a clearer picture than Sharpe ratio. Learn the formula, Excel calculation, and portfolio analysis.

Pharma penny stocks require thorough research and screening before investing. Learn how to analyze pharmaceutical small-cap stocks using MarketXLS formulas for fundamentals, revenue, and valuation.

5g penny stocks 5G is the fifth generation of cellular networks. While its predecessor 4G LTE mostly focused on high-speed video streaming, major stakeholders claim 5G to do much more than just...

As COVID-19 is forcing people to find new ways to connect, work, and live from home, tech penny stocks are finding renewed interest among the traders.

Dividends The dividend is a token of gratitude from a company to its shareholders keeping in mind the time and risk factors involved with the money they have invested.

Best options to buy research guide showing screening criteria for volume, IV, and spreads in Excel

LEAPS options are long-term options contracts with expiration dates over one year out. Learn what LEAPS are, top strategies like the poor man's covered call, and how to analyze them using MarketXLS Excel formulas.

Implied Volatility Screener helps options traders find contracts with the highest or lowest IV for premium selling and volatility strategies. Learn to build an IV screener in Excel with MarketXLS.

What are the liquid options?