Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Logout MarketXLS

Fear and Greed Index (Understanding Investor Sentiments)

Written by Vanshika Kothari
Sun Jul 04 2021
Fear & Greed Index
See how MarketXLS helps you take advantage in the markets.
Download Option Templates →
Fear & Greed Index

Investor sentiments play a significant role in driving the market prices, direction, volatility, and volume. Hence, tracking these sentiments and emotions of investors becomes essential. Developed by CNN Money, the Fear & Greed Index measures two main emotions that influence how much investors are inclined to pay for stocks. 

The fear & greed index is measured on the basis of seven different factors. Each factor is equally weighted and gauged from 0 to 100 and to generate the index value. Thus, in theory, the Index can gauge whether the stock market is reasonably priced. 

Understanding the Index

Excessive fear tends to drive down share prices, and too much greed tends to have the opposite effect is the underlying logic behind the Index.

People tend to get FOMO (Fear of missing out) which makes them greedy when the market is rising. Quite often, it is also seen that people sell their holdings in the irrational reaction to seeing red numbers. With the help of the Fear & Greed Index, you can be saved from your own emotional overreactions. There are two simple things assumed:

  1. Extreme fear can signal that investors are too worried, which could be a buying opportunity.
  2. When Investors are too greedy, that means the market is due for a correction.

Calculation of the Index

IPA0nOs4oBKojX5e_kWQC2SH5Lx7sXACUni7FcWgsq1N_w” alt=”Fear & Greed Index”/>

From: https://corporatefinanceinstitute.com/ 

As described earlier, the fear & greed index is calculated based on seven different factors – each factor is gauged from 0 to 100 and equally weighted to generate the index value.

  1. Stock Price Strength

This factor is a ratio of the number of stocks on the New York Stock Exchange (NYSE) reaching 52-week highs relative to reaching hitting 52-week lows. A greater number of 52-week lows indicates versus 52-week highs indicates fear and vice versa.

  1. Stock Price Breadth

Stock Price Breadth is based on the trading volumes  of rising stocks relative to declining stocks on the NYSE. A greater volume of rising stocks versus declining stocks indicate greed and vice versa.

  1. Market Momentum

Momentum is the speed of price changes in stock. The performance of the S&P 500 relative to its 125-day average measures the market momentum. A higher performance relatively indicates greed and vice versa.

  1. Put and Call Options

The extent to which call options lag behind put options, signifying fear, or surpass them, indicating greed.

  1. Safe Haven Demand

Bonds are usually considered safer compared to stocks. Better performance of bonds relative to the performance of stocks indicates fear and vice versa.

  1. Junk Bond Demand

The greater yield spread between investment-grade bonds and junk bonds indicates fear and vice versa. 

  1.  Market Volatility

 A higher value of the Chicago Board Options Exchange Volatility Index (VIX) concentrating on a 50-day Moving Average indicates fear and vice versa.

The Bottom Line

Historically, the fear & greed index has been a reliable indicator of a significant change in equity markets. It can be a great tool to time entry and exit in the market. As stated by Warren Buffett, “Be fearful when others are greedy, and greedy when others are fearful.” The fear & greed index can help investors understand the general sentiment and act accordingly on their trades. 

Most experts agree on a buy-and-hold strategy to be the best way of seeing returns in a portfolio over the long term. Arguably, tools such as the fear & greed index encourage investors to frequently trade in and out of stocks and generate less favorable returns.


All trademarks referenced are the property of their respective owners. Other trademarks and trade names may be used in this document to refer to either the entity claiming the marks and names or their products. MarketXLS disclaims any proprietary interest in trademarks and trade names other than its own, or affiliation with the trademark owners.

None of the content published on marketxls.com constitutes a recommendation that any particular security, portfolio of securities, transaction, or investment strategy is suitable for any specific person. The author is not offering any professional advice of any kind. The reader should consult a professional financial advisor to determine their suitability for any strategies discussed herein. The article is written for helping users collect the required information from various sources deemed to be an authority in their content. The trademarks if any are the property of their owners and no representations are made.


Fear and Greed Index – Overview, Calculation, Example

Fear and Greed Index Definition

Fear & Greed Index – Investor Sentiment

Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
Download Option Templates
Stock screens
Public saved screens

Top 100 Gainers Today

Top 100 losers Today

Call: 1-877-778-8358
Ankur Mohan MarketXLS
I am so happy you are here. My name is Ankur and I am the founder/CEO of MarketXLS. Over the past four years, I have helped more than 2500 customers to implement their own investment research strategies and monitoring systems in Excel.
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONSGet started today
Search for a stock

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today

Top MarketXLS Rank stocks

STORE Capital Corporation logo

STORE Capital Corporation

Optionable: Yes
Market Cap: 8,978 M
Industry: REIT - Diversified
52 week range    
Dillard's Inc. logo

Dillard's Inc.

Optionable: Yes
Market Cap: 5,077 M
Industry: Department Stores
52 week range    
Williams-Sonoma Inc. (DE) logo

Williams-Sonoma Inc. (DE)

Optionable: Yes
Market Cap: 8,796 M
Industry: Specialty Retail
52 week range    
ICF International Inc. logo

ICF International Inc.

Optionable: Yes
Market Cap: 2,040 M
Industry: Business Services
52 week range    
First Interstate BancSystem Inc. logo

First Interstate BancSystem Inc.

Optionable: Yes
Market Cap: 4,622 M
Industry: Banks - Regional - US
52 week range    
Global Cord Blood Corporation logo

Global Cord Blood Corporation

Optionable: Yes
Market Cap: 317 M
Industry: Biotechnology
52 week range    
Penske Automotive Group Inc. logo

Penske Automotive Group Inc.

Optionable: Yes
Market Cap: 7,684 M
Industry: Auto & Truck Dealerships
52 week range    
General Mills Inc. logo

General Mills Inc.

Optionable: Yes
Market Cap: 44,923 M
Industry: Packaged Foods
52 week range    
Allegiance Bancshares Inc. logo

Allegiance Bancshares Inc.

Optionable: Yes
Market Cap: 883 M
Industry: Banks - Regional - US
52 week range    
National Research Corporation logo

National Research Corporation

Optionable: No
Market Cap: 948 M
Industry: Diagnostics & Research
52 week range    

More Features