Pivot Point Trading Strategy

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

[ifso id=”17611″]

Technical analysts use pivot point to determine the overall trend of the market over different time frames. They are calculated using the high, low, and closing prices of previous trading sessions and predict support and resistance levels in the current or upcoming session. Thus, they can be a handy tool for range-bound traders to identify entry points and spot the critical levels that need to be broken for a move to qualify as a breakout for trend traders and breakout traders.

It allows a trader to determine the general trend of the market at different times. For example, if the trading is over the pivot point of the previous session, it indicates a current bullish sentiment. Alternatively, bearish sentiment is indicated if the trading is over and below the pivot point.

Traders can detect the points where the price of that stock could face support or resistance with the help of the different levels in the pivot point. The price movement direction can also be detected when the price moves through some of these levels. These levels are valid only for intraday trading. There are a variety of formulas you can use to find out the pivot levels.

Calculation of Pivot Points

There are various ways to calculate Pivot Points. They can be calculated for various time frames. The Five-Point system that is totaling five price points to derive a pivot point is most commonly used. 

Pivot Point (P) = (Previous High + Previous Low + Previous Close)/3

The first level Support and Resistance

Support 1 (S1) = (Pivot Point∗2)−Previous High

Resistance 1 (R1) = (Pivot Point∗2)−Previous Low

The Second Level Support and Resistance

Support 2 (S2) = Pivot Point−(Previous High−Previous Low)

Resistance 2 (R2) = Pivot Point + (Previous High−Previous Low)

Calculating Pivot Points Using Excel

With the help of MarketXLS, you can generate the Pivot Points in your Excel Sheet efficiently. For instance, here, we have taken Microsoft (Nasdaq: MSFT) and generate the historical data of Open, High, Low, and Close. For this example, we have taken a weekly time frame.

Pivot Point

Once the data is generated, we can calculate the Pivot Points by entering the formula and calculate the Support, Resistance, and Pivot Points. 

Pivot Point

Interpretation and Application of Pivot Point Strategy

Pivot points are excellent tools for timing the entries and exits in any market. The pivot point is the primary focus and the level ofoff which everything else is calculated. Support and resistance levels can also be forecasted using the pivot point calculation. The pivot levels placed on the chart are the basic ones. There are two resistances and two supports. Now that we have generated the Pivot Points, let us understand them with the help of the previous example.

Since it is a weekly chart, we can conclude that the pivot point lies at $260 and the first support at $256.86, with resistance at $265.96. Similarly, the second support and resistance are at $248.6500 and $251.0900, respectively.

If the market has confirmed a strong bias above the pivot point during the trading period, traders should expect any retest of the Pivot Point to provide a rejection. Assuming the market traded above the pivot point for most of the day, and then maybe a bit of bad news hits the market, and the price begins to fall and retest the pivot point. At this point, it is expected that the buyers would again show up and defend their position in the market. We can expect a bounce if the buyers were really in control. This is a great chance to re-enter the market if you have missed the initial start during the day.

Pivot Point Strategy in Intraday Trading

Active attention to market trends is required in Intra-day Trading. There are several strategies that the traders may use to make intraday trading much easier with a concrete decision. Pivot Point Strategy is a useful strategy for Intraday traders that helps them to calculate the expected point from where the prices can soar and find resistance and the expected point from where the prices can dip and find support.

When the correct analysis is done, the pivot levels play an essential role when the market opens each day. For example, if a particular stock opens above the basic pivot level, it is expected to follow a bullish nature; conversely, if the same particular stock opens below the basic pivot level, it should follow a bearish nature. 

Pivot Bounce and Pivot Level Breakout

Pivot Point Bounce is one of the critical strategies, and it helps the trader understand when to buy the stocks and when to sell them. It focuses on finding the bounce in prices at pivot points in the chart. If the price reaches the pivot point and bounces back, it indicates opening the trade.

Pivot Level Breakout is constructed with the stop-limit order strategy, and the trader opens the position when the price passes the pivot level. The short trade is performed when the trend shows a bearish performance and has a long position when the trend shows a bullish performance.


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 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.


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

Top 100 Gainers Today

Top 100 losers Today

Real gdpReal personal consumption expReal private investmentReal govt expenditureReal net exportsReal exportsReal importsFederal receiptsFederal outlaysFederal surplus or deficitFederal debtReal private investment nonresidentialReal private investment residentialReal potential gdpReal personal incomeReal personal consumption exp monthlyRpce durable goodsRpce nondurable goodsRpce servicesPersonal savings rateMonetary baseCurrency in circulationBank reservesMoney supply m1Money supply m2Sp500DjiaWilshire indexVixFinancial stress indexCorporate bond index aaCorporate bond index bbbFederal funds rateTreasury rate 3mTreasury rate 1yTreasury rate 5yTreasury rate 10yTips 5yTips 10yBond yield aaaBond yield baaMortgage rate 15yMortgage rate 30yUs dollar weighted averageUsdollar to euroUsdollar to poundYuan to usdollarCanadiandollar to usdollarYen to usdollarCpiCpi wo food energyCpi foodCpi energyChain price indexChain price index wo food energyGdp price deflatorPpi final demandPpi finished goodsPpi materialPpi crude goodsPpi final demand wo food energyPpi finished goods wo food energyHouse price indexHouse price index 20cityCrude oil priceGasoline priceNatural gas priceIndustrial productionCapacity utilisationInventoriesSales retail foodVehicle sales light weightManufacture orders durablesManufacture orders capital goodsLoansConsumer credit outstandingCorporate profitsHousing startsBuilding permitsResidential constructionEmployees nonfarmEmployees privateEmployees goods producingEmployees service providingEmployees governmentUnemployment rateInitial cliamsAverage weeks unemployedJob openingsHiresSeparationsQuitsLayoffs dischargesHours of productionHourly earningsReal outputPopulationLabor forceLabor force participation rate
Search for a stock

Top MarketXLS Rank stocks

Booz Allen Hamilton Holding Corporation logo

Booz Allen Hamilton Holding Corporation

Optionable: Yes
Market Cap: 11,592 M
Industry: Business Services
52 week range    
Rush Enterprises Inc. Class B Common Stock logo

Rush Enterprises Inc. Class B Common Stock

Optionable: No
Market Cap: 2,753 M
Industry: Auto & Truck Dealerships
52 week range    
BWX Technologies Inc. logo

BWX Technologies Inc.

Optionable: Yes
Market Cap: 4,846 M
Industry: Aerospace & Defense
52 week range    
Ritchie Bros. Auctioneers Incorporated logo

Ritchie Bros. Auctioneers Incorporated

Optionable: Yes
Market Cap: 6,928 M
Industry: Business Services
52 week range    
Ituran Location and Control Ltd. logo

Ituran Location and Control Ltd.

Optionable: Yes
Market Cap: 504 M
Industry: Communication Equipment
52 week range    
General Mills Inc. logo

General Mills Inc.

Optionable: Yes
Market Cap: 42,311 M
Industry: Packaged Foods
52 week range    
CRA InternationalInc. logo

CRA InternationalInc.

Optionable: Yes
Market Cap: 646 M
Industry: Business Services
52 week range    
ConAgra Brands Inc. logo

ConAgra Brands Inc.

Optionable: Yes
Market Cap: 16,287 M
Industry: Packaged Foods
52 week range    
Agree Realty Corporation logo

Agree Realty Corporation

Optionable: Yes
Market Cap: 5,522 M
Industry: REIT - Retail
52 week range    
International Money Express Inc. logo

International Money Express Inc.

Optionable: Yes
Market Cap: 781 M
Industry: Business Services
52 week range    

More Features

Stand with Ukraine

As the situation in Ukraine escalates, many of us in MarketXLS are left with emotions too overwhelming to name. If you’d like to show your support, but aren’t sure how to, we want to help make it easier for you to act.

For any amount donated, we’ll extend your MarketXLS subscription for double of the donated amount. Please send proof of your payment to to avail the extention

From all of us at MarketXLS, thank you!