Shubham Shah
Customer success, MarketXLS
Shubham Shah wrote 100 articles for the MarketXLS blog between January 2019 and February 2026, covering options trading, stock analysis and valuation, and portfolio and investment strategies. MarketXLS published him on its About Us page in a customer success role.
Articles by Shubham Shah
- Options Trading
Calendar Spread: The Complete Guide to Long Calendar Spreads With Puts and Calls (2026)
Calendar Spread options strategy — a comprehensive guide to long calendar spreads using puts and calls. Learn setup, time decay mechanics, Greek analysis, trade management, and real-time Excel analysis with MarketXLS.
- Stock Analysis
Volatile Penny Stocks: How to Identify, Screen, and Analyze Them in Excel (2026)
Volatile Penny Stocks — how to identify, screen, and analyze high-volatility low-priced stocks using Excel and MarketXLS. Covers volatility metrics, screening criteria, risk factors, and real-time analysis tools.
- Portfolio & Investment Strategies
Investment Tracker in Excel: Build a Real-Time Portfolio Dashboard With Live Data
Investment tracker in Excel lets you monitor every position, dividend, and gain/loss in real time — no web app needed. Build a professional portfolio dashboard with MarketXLS formulas.
- Stock Analysis
Stock Split Calculator Excel: How to Calculate Share Adjustments and Track Split History
Stock Split Calculator Excel guide covering forward splits, reverse splits, cost basis adjustments, and how to track split history using formulas and MarketXLS functions.
- Stock Analysis
Penny Stocks Under 10 Rs: Complete Guide to Screening and Analyzing Low-Price Indian Shares
Penny stocks under 10 Rs in the Indian market offer high risk and high potential reward. Learn how to screen, analyze, and evaluate these low-price shares using MarketXLS formulas and fundamental analysis.
- Options Trading
option greek formula excel
Real-time Option Greeks functions – New Release 9.3.6 We hope you are doing well. With great excitement, we announce the release of MarketXLS Version 9.3.6 today (May 10th, 2024).
- Options Trading
how to get live option chain data in excel
Table of contents - - - - - - - - - - - - - - - - - - - - What Is An Option?Options trading has surged in popularity recently, but many traders face losses due to insufficient understanding of these...
- Options Trading
Option Strategy for Beginners — Top 10
Discover the top 10 options trading strategies for beginners, including covered calls, spreads, straddles, and more, with clear payoff diagrams and expert insights.
- Stock Analysis
Indian Stock Prices in Excel: Real-Time & Historical Data Guide (2025)
Indian Stock Prices in Excel can be retrieved in real-time and historically using MarketXLS formulas. Complete guide for NSE and BSE data with step-by-step instructions for Excel 2016, 2019, and 365.
- Platform & Product News
Options Flow Summary — MarketXLS New Release 9.3.5
Options Flow Summary – MarketXLS New Release 9.3.5 We’re excited to share the newest addition to MarketXLS – our Advanced Options Flow Summary functions in Version 9.3.
- Platform & Product News
Get EOD data for Major US Indices — MarketXLS New Release 9.3.4.9
Get EOD data for Major US Indices — MarketXLS New Release 9.3.4.9 With great excitement, we announce the release of MarketXLS Version 9.3.4.9. Key Updates Summary:- Next Expiration & Next Strike functions give the next expiration date or strike for an underlying. Example, =ExpirationNext(MSFT,1) if todays 22nd June 2023 (Wednesday) it will show the 23rd June 2023 expiration date. Added EOD */ -->
- Stock Analysis
Brand New Menu & Stock Rank Functions — (New Release 9.3.4.6)
We hope you are doing well. We are very excited to announce the new MarketXLS Menu and new functions data in MarketXLS available today, May 6th, 2022, for you to start using.
- Stock Analysis
MarketXLS Screener Release
We take pride in announcing that marketXLS isn’t limiting itself to just excel sheets. Our focus lies on providing the best value for your money and hence we are constantly innovating.
- Options Trading
How to hedge a drop in S&P 500 Using MarketXLS
With market valuations rising, many investors are concerned about the likelihood of a market crash, which is traditionally defined by losses of more than 20% over a 12-month period.
- Options Trading
How Are Options Priced?
MarketXLS offers you simple commands to fetch historical and live option prices, but have you wondered how options contracts are priced?
- Options Trading
Use of Options to Hedge Market Risk
A hedge is a risk-mitigation strategy for investors. A hedge is an instrument or method that increases in value when the value of your portfolio decreases.
- Options Trading
Option Strategies For Professional Traders
Options Strategy Trading – Sounds Heavy, Isn’t it? Well, don’t worry, we are here to help you in this regard.
- Options Trading
Common Mistakes In Options Trading And How To Avoid Them
Common options trading mistakes showing ignoring Greeks, wrong position size, and no risk management
- Options Trading
Options Trading for Passive Income
In our fast-pacing world, time is money. We all have our set ways to generate a daily stream of income for a livelihood.
- Stock Analysis
Trading Using The Fibonacci Retracement Strategy
What Is Fibonacci Retracement? Leonardo Piscano was an Italian mathematician from Pisa. He was nicknamed Fibonacci and he found an interesting pattern in a certain set of numbers.
- Stock Analysis
Buy Stocks Straight From Your Excel Sheet Using MarketXLS!
Buy stocks from Excel showing trade execution workflow and spreadsheet interface
- ETFs, Funds & Alternatives
CryptoCurrency Features in MarketXLS
Cryptocurrency features in MarketXLS showing live BTC, ETH, and XRP prices and portfolio tracking in Excel
- Options Trading
Options Profit Calculator
Options are financial derivatives that involve a buyer and seller where the buyer pays the premium for an option in return for the rights granted by the contract.
- Options Trading
Stock Repair Option Strategy
Stock Repair Option Strategy, as the name indicates, is used to recover from the loss suffered on going long on a stock that has now fallen in price.
- Portfolio & Investment Strategies
Understanding Yield Curve (Trading Strategy & Yield Curve Control)
Yield to maturity (YTM) is the effective rate of return that fixed-income securities earn if held to maturity. It depends on the issue price & coupon rate of the securities.
- Options Trading
Conversion Arbitrage Options Strategy: How to Profit From Put-Call Parity Mispricings
Conversion arbitrage exploits put-call parity mispricings for risk-free profit. Learn how conversion and reverse conversion strategies work, with real P&L examples and MarketXLS Excel formulas.
- Stock Analysis
Introduction To Machine Learning In Stock Markets
Machine learning is the usage of Artificial Intelligence for predicting future results or trends by feeding it historical human data. The ai gradually learns to adapt to the past trends and improves over time in extrapolating those trends to future scenarios. Machine learning has been in the limelight for the past decade, and it is */ -->
- Portfolio & Investment Strategies
Pivot Point Trading: Strategy Guide with Excel Formulas and Examples (2026)
Pivot Point Trading strategies use mathematical calculations based on prior session high, low, and close to identify key support and resistance levels — and Excel makes it easy to calculate and track them.
- Stock Analysis
Overvalued Stocks: How to Identify, Analyze & Avoid Them Using Excel and MarketXLS
Overvalued stocks trade above their intrinsic value and can expose investors to significant downside risk. Learn how to identify overvalued stocks using valuation metrics, screening methods, and MarketXLS Excel formulas.
- Options Trading
Stock Replacement Options Strategy
It is clear from its name; Stock Replacement is a strategy that effectively recreates the position of owning stocks by using other financial instruments.
- Options Trading
Synthetic Short Straddle With Puts Option Strategy
Introduction Options are an important derivative class, which allow traders to take positions and generate profits with a limited amount of risk.
- Stock Analysis
Technical Indicators — Meaning & Application
Technical Indicators’ analysis is the study of historical data to estimate futuristic trends and fluctuations in the prices of stocks. It is used to determine the entry and exit points in the market.
- Stock Analysis
Technical Analysis Chart Patterns: Complete Guide to Using Excel for Pattern Recognition (2026)
Technical Analysis Chart Patterns provide visual signals of potential price movements — and Excel gives you the tools to identify, validate, and backtest these patterns using real market data.
- Stock Analysis
Stock Market Technical Analysis For Beginners
Introduction You might have come across the term technical analysis countless number of times. This word fascinates most of us but very few of us actually know what technical analysis is.
- Portfolio & Investment Strategies
Telecommunications Sector: How to Analyze and Invest in Telecom Stocks with Excel
Telecommunications sector investing requires understanding key companies, 5G trends, dividends, and valuation metrics. Learn how to analyze telecom stocks in Excel with MarketXLS formulas.
- Portfolio & Investment Strategies
Investing In Special-Purpose Acquisition Company (Spacs)
The markets are flooded with IPOs these days. Still, more often than not, we get to hear that investors are not getting allotted their share applications, especially in most anticipated IPOs.
- Stock Analysis
Investing In European Stocks
With the increasing integration of the world markets, the borders are increasingly becoming virtual. The accessibility to goods and services offered across the globe has increased with much ease.
- Stock Analysis
Technical Analysis Timeliness — Meaning And Usage In Marketxls
What is Technical Analysis? */}(https://marketxls.com/blog/wp-content/uploads/2021/05/TAT-1.1.jpg) Technical Analysis is a method for estimating the direction and trend of prices of different stocks...
- Options Trading
Collar Option Strategy: How to Protect Your Stock Positions While Generating Income
Collar option strategy combines a protective put with a covered call to hedge your stock position — often at zero net cost. Learn setup, P&L analysis, and Excel tracking.
- Stock Analysis
Stock Health Check-Up (Is The Stock Healthy To Invest?)
The stock market is filled with individuals who know the price of everything, but the value of nothing. ― Phillip Fisher. Investors need to judge the stocks on various parameters before they invest in them. A proper understanding of the company and its performance is essential before investing, which can be done by a Stock */ -->
- Platform & Product News
Jane Street Capital
The New Player in Town Jane Street Capital,also known asJane Streetis a global proprietary trading company established in the early 2000s in Manhattan, New York.
- Options Trading
How To Profit From Arbitrage Stocks And Options?
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.
- Portfolio & Investment Strategies
Dividend Growth (Gordon Growth Model)
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.
- Options Trading
Options Trading (Strategies)
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.
- Stock Analysis
Warren Buffet Portfolio (Top Stocks)
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 */ -->
- Stock Analysis
Technical Indicators For Swing Traders (Using Marketxls)
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...
- Stock Analysis
Quantitative Analysis And Long Term Ratio Analysis Of Stocks
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...
- Portfolio & Investment Strategies
Weiss Blue-Chip Dividend Yield Screen — Tracking And Implementation
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...
- Stock Analysis
Piotroski F-Score: How to Calculate and Screen Stocks in Excel
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.
- Stock Analysis
Investing In Indian Stocks
Overview: Investing In The Indian Stock Market India permitted foreign investments into the country in the 1990s.
- Portfolio & Investment Strategies
Correlation Matrix: The Complete Guide to Portfolio Diversification Analysis
Correlation matrix analysis helps investors measure portfolio diversification, identify hidden risk concentrations, and optimize asset allocation using real Excel formulas and data-driven tools.
- Portfolio & Investment Strategies
Charles Schwab Portfolio Management: Exporting Data to Excel for Advanced Analysis
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.
- Stock Analysis
Investing In Chinese Stocks
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, */ -->
- Stock Analysis
Drone Stocks — To Invest Or Not To Invest?
Drones – The new coming of age technology  IMG Source: https://stockhead.
- Portfolio & Investment Strategies
Risk Parity Portfolio In Excel — Explanation & Construction
Risk Parity Portfolio The risk parity approach to portfolio construction seeks to allocate the capital in a portfolio based on a risk-weighted basis.
- Options Trading
Trading In Bull Put Spread Options Strategy (Using Excel)
The options trader uses the bull put spread options strategy when having moderately bullish expectations on the market or stock.
- Portfolio & Investment Strategies
The Defensive Investor (Utility) Strategy By Benjamin Graham
The Defensive Investor (Utility) Strategy by Benjamin Graham What is Defensive investor strategy? Benjamin Graham needs no introduction in the world of stock market.
- Stock Analysis
Lynch Screen (Screening Stocks Using Excel)
Peter Lynch screen is a growth investing strategy inspired by the approach of Peter Lynch, who looks for consistently profitable, relatively unknown, low-debt, reasonably priced stocks with high, but not excessive, growth. Peter Lynch wrote: If you stay half-alert, you can pick the spectacular performers right from your place of business or out of the */ -->
- Options Trading
Trading In Bear Call Spread Options Strategy (Using Excel)
The options trader uses the bear call spread options strategy when having moderately bearish expectations on the market or stock.
- Options Trading
Collar Option Strategy — A Synopsis
Collar option strategy showing stock plus put plus call equals zero-cost hedging with payoff diagram
- Options Trading
Option Trading With Ms Excel-Protective Puts Strategy
Protective puts As the name itself suggests, the Protective Put strategy is used by investors to protect their capital gains from a decline in the stock price.
- Options Trading
Option Trading With Ms Excel-Long Butterfly Strategy
Long butterfly with calls The long butterfly call spread is created by buying one in-the-money call option with a low strike price, writing two at-the-money call options, and buying one...
- Options Trading
Short Strangle Option Strategy
A Short Strangle Option Strategy involves selling both OTM call and OTM put options in the same underlying asset with the same expiry date but with different strike prices.
- Options Trading
Options Trading Income: Track and Manage Your Profits in Excel
Options trading income requires careful tracking of premiums collected, assignment events, and net P&L. Learn how to build a complete income tracker in Excel with real formulas.
- Stock Analysis
High Volume Stocks
High volume stocks refer to the securities that investors most trade in a given period. Generally, high volume stocks are less volatile due to the high demand and, thus, less likely to see huge...
- Stock Analysis
High Volatility Penny Stocks-Tracking And Trading (With Marketxls)
Penny stocks have had a long and exciting relationship with the stock markets. How are penny stocks different from regular stocks traded in mainstream markets?
- Portfolio & Investment Strategies
Portfolio Risk Management: Complete Guide to Measuring and Managing Investment Risk in Excel
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.
- Options Trading
Trade Options on Robinhood: Complete Step-by-Step Guide for Beginners (2025)
Trade Options on Robinhood with this complete beginner's guide covering approval levels, order types, strategies, Greeks, and how MarketXLS enhances your options analysis in Excel.
- Options Trading
Options Theta: Understanding Time Decay and How to Use It in Your Trading
Options theta measures the daily time decay of an option's price. Learn how theta works by moneyness, expiration, and volatility — plus MarketXLS formulas for real-time Greeks analysis.
- Options Trading
Long Call Options Trade/Strategy-How To Manage And Track
What are Long Call Options?A long call option strategy is purchasing a call option with the expectation that the underlying stock will rise.
- Options Trading
Spy-Spdr S&P 500 Trust Etf(Most Actively Traded Option)
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.
- Options Trading
Short Call Put- Managing And Tracking
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.
- Stock Analysis
Beneish M-Score: Detect Earnings Manipulation in Excel
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.
- Options Trading
Long Put Option Strategy-Managing And Tracking
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.
- Options Trading
Diagonal Spread: Complete Options Strategy Guide with Excel Setup
Diagonal Spread options strategy explained — setup, Greeks impact, risk management, variations, and how to model diagonal spreads in Excel with MarketXLS formulas.
- Options Trading
Options For Dummies — With Tools Used By Hedge Fund Managers
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.
- Stock Analysis
Pharma Penny Stocks: How to Research and Screen Pharmaceutical Small-Cap Stocks in Excel
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.
- Stock Analysis
Top 5G Penny Stocks-2021
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...
- Stock Analysis
Tech Penny Stocks — Analyzing Using Marketxls
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.
- Stock Analysis
Dividend Paying Penny Stocks-Marketxls
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.
- Options Trading
Best Options To Buy (Use Marketxls For Research)
Best options to buy research guide showing screening criteria for volume, IV, and spreads in Excel
- Options Trading
LEAPS Options: Complete Guide to Long-Term Equity Anticipation Securities
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.
- Options Trading
Implied Volatility Screener: How to Screen, Filter, and Find High-IV Options in Excel
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.
- Options Trading
5 Successful Options Strategies Using The Most Liquid Options
What are the liquid options?
- Stock Analysis
High Volume Penny Stocks (Filter Penny Stocks Using Marketxls)
They say, the more risk you are willing to take the more will be the reward. This is true in the case of penny stocks. You might have heard of the term at least once.
- Options Trading
Delta Neutral
Delta neutral strategy showing portfolio balancing for volatility-focused trading with payoff diagrams
- Options Trading
Short Call Options: Complete Guide to Selling, Tracking & Managing in Excel
Short call options give sellers premium income in exchange for unlimited upside risk. Learn how to set up, track, manage, and roll short calls using MarketXLS in Excel.
- Options Trading
Call Ratio Backspread: Complete Options Strategy Guide With P&L, Greeks & Excel Setup
Call Ratio Backspread is a bullish options strategy that offers unlimited upside profit potential with limited downside risk. Learn the complete setup, P&L scenarios, Greeks analysis, and how to build it in Excel.
- Options Trading
VWAP Strategy: How to Use Volume Weighted Average Price for Options Trading
VWAP Strategy uses the volume weighted average price to identify fair value, time entries, and improve execution in options trading. Learn to calculate VWAP and combine it with options strategies using MarketXLS.
- Options Trading
Put Ratio Backspread Strategy (Manage Your Risk)
Trading of options is increasing day by day, as it provides an opportunity for an investor to gain profit. But one can’t deny the fact that options involve risk and uncertainties.
- Options Trading
Call Ratio Spread: Setup, Payoff, Greeks & Risk Management Guide
Call ratio spread strategy explained with setup, payoff diagrams, Greeks analysis, and risk management. Learn when to use this neutral options strategy and track it in Excel with MarketXLS.
- Options Trading
Put Ratio Spread: Setup, Payoff Diagram, Greeks & Risk Management
Put ratio spread guide covering strategy setup, payoff diagram, max profit and loss calculations, Greeks analysis, risk management, and Excel implementation using MarketXLS options functions.
- Options Trading
How To Manage Risk When Trading Options For Income
Experience and knowledge of all the trading strategies are irrelevant if a trader cannot control risk and manage money.
- Options Trading
Option Chain Data Thinkorswim: Complete Excel Import Guide 2025
Option Chain Data Thinkorswim to Excel — step-by-step export guide using the scan tab, RTD link, and the MarketXLS QM_GetOptionChain direct method for live data.
- Options Trading
Selling Weekly Put Options: Complete Income Strategy Guide With Excel
Selling weekly put options for income explained with strike selection, risk management, Greeks analysis, and step-by-step Excel tracking using MarketXLS option chain and pricing formulas.
- Options Trading
The Wheel Strategy For Options (Explained With Example)
So, you had a conversation with a friend or probably read a book about options. Being a newbie, you search about the strategies to trade options and stumble upon the wheel options strategy. Thumbs up to your research work. Now you surf through various websites and intend to learn the strategy. Good news for you, */ -->
- Options Trading
Options Trading Excel: Build a Complete Options Spreadsheet from Scratch
Options trading Excel spreadsheets give traders real-time option chains, Greeks tracking, P&L analysis, and strategy modeling directly in their familiar Excel environment.
- Options Trading
How To Use Options Trading As An Income Generation Strategy (With Ease)
How to use Options as an Income Generation Strategy?Options trading is one of the most powerful techniques that provide an opportunity for an investor to create wealth.
- Stock Analysis
Stock Drawdown
What is a drawdown?A drawdown (usually understood as maximum stock drawdown) is an indicator of downside risk over a specified period of time.
- Options Trading
Using Marketxls To Find The Best Cash-Secured Put Option To Sell
I have $10,000 and would like to buy some stock but everything seems kind of overpriced to me. I hate paying too much for stock; but on the other hand, I hate for my money to sit around doing nothing.