Last Updated on September 21, 2023 by Mark Ursell

In this article, I talk about how to calculate the PSAR indicator. I show how the indicator can be used and describe the formulas for calculating it in Excel.

I have also recorded a video showing how to calculate the PSAR indicator using Excel. I suggest you check out the video because it contains additional information that is not in the article.

## The PSAR

Parabolic markets are a rare phenomenon. These unusual markets occur when the price moves up or down at an increasing rate.

If you are trading in the direction of a parabolic market, it is a fantastic experience to feel the market surging along with you. However, it is a terrible experience to be on the wrong side of a parabolic move.

One of the great thinkers and developers of technical indicators, J Welles Wilder, realised that traders can be very profitable if they have an indicator that identifies and helps to trade these parabolic moves.

The Parabolic Stop and Reverse (PSAR) is a distinctive technical indicator developed by Wilder. The PSAR indicator is used to identify the trend, time market entries and as a trailing stop-loss.

The PSAR always moves with the trend. When the market is falling the PSAR is above the price. When the market is rising the PSAR is below the price.

The most striking thing about the PSAR is that, when the market moves actively, the indicator accelerates in response. This acceleration creates a distinctive parabolic pattern.

Speeding up the PSAR allow traders to take as much profit as possible from fast market moves. The speed of the acceleration and maximum acceleration can be changed to suit the market and trading strategy.

## The Next Step: Get More Winning Trades

If you are eager to take your trading strategies and market analysis to the next level, consider exploring Tradinformed Excel Backtest Models. These Excel-based models will help you design, optimize and track your trading strategies.

The 15-in-1 Package is our most powerful package. This will help you learn how to backtest trading strategies and make informed trading decisions while providing you with the tools you need to develop your own trading systems.

## Video

Watch the video for a complete explanation of how to calculate the PSAR indicator.

## How to Calculate the PSAR

The PSAR needs to start somewhere, and so the first line of the indicator will use the data from the first price bar. In the video, I have started the PSAR in a downtrend. The initial direction is not important because the PSAR is self-correcting. In this example, the initial PSAR value is the high price, and the initial Extreme Point value is the low price.

The second line of calculation starts with the Initial PSAR. This value is calculated using the formula:

**Previous PSAR – ((Previous PSAR – Previous Extreme Point) * Acceleration Factor)**

It is important to remember that in a downtrend the PSAR cannot be lower than the high price of the previous two periods. In an uptrend, the PSAR cannot be higher than the low price of the two previous periods.

The initial PSAR will become the Actual PSAR unless it has been touched by the price. If the price touches the initial PSAR value then the indicator changes direction and the previous Extreme Point becomes the actual PSAR.

In a downtrend, the Extreme Point is the lowest price during that downtrend. In an uptrend, the Extreme Point is the highest price during that uptrend.

The initial value of the Acceleration Value is 0.02. When the price makes a new Extreme Point, the Acceleration Value increases by 0.02 up to a maximum of 0.2. It is this acceleration factor that makes the PSAR go parabolic.

#### Excel Formulas:

##### First Line:

**G5** =D5

**H5** =H2

**I5** =(K5-G5)*H5

**K5** =C5

**L5** Falling

##### Second Line:

**G6** =IF(L6=”falling”,MIN(G5,D6),IF(L6=”rising”,MAX(G5,C6),””))

**H6** =IF(AND(L6=L5,G6<>G5,H5<$H$3),H5+$H$2,IF(AND(L5=L6,G6=G5),H5,IF(L5<>L6,$H$2,$H$3)))

**I6** =(K6-G6)*H6

**J6** =IF(L5=”falling”,MAX(K5-I5,C5,C4),IF(L5=”rising”,MIN(K5-I5,D5,D4),””))

**K6** =IF(AND(L5=”falling”,C6<J6),J6,IF(AND(L5=”rising”,D6>J6),J6,IF(AND(L5=”falling”,C6>=J6),G5,IF(AND(L5=”rising”,D6<=J6),G5,””))))

**L6** =IF(K6>E6,”Falling”,”Rising”)

## Calculate More Indicators

If you are interested in technical indicators have a look at the page on Calculating Technical Indicators.

Would you be able to share your spread sheet? You have two posts with different formula which produce different rise/fall results. One of the posts has listed an incomplete formula for one of the columns which I adjusted after watching your video. But I still think something is wrong, since the results are very different from the indicator in Think or Swim for the same data. Thank you.

The spreadsheet is available in my eBook 21 Technical Indicators The book comes with a free spreadsheet including 20 other technical indicators.