How to Calculate the PSAR Indicator Using Excel

[@eitan71]

10 years in the future of the video, and i thank you very much for a great video. EXCELLENT explanation, like no other. Thank you!

[@TurtleTrader]

Your video is an amazingly detailed explanation how the Parabolic Stop and Reverse is designed and functions when trading the markets. Thank you Mark.

[@siyuancheng9575]

Awesome video with great explaination! Many many thanks

[@MarkUrsell]

You are welcome!

[@rcapower19147]

Amazing video! Thanks so much for your help!

[@MarkUrsell]

(〉 L 〈) Thanks for the comment. I appreciate the feedback, glad you found it helpful.

[@kartheekchinta734]

Hi bro can you give the explantion regarding individual day calculations to monitor and to invest on the next day if it was bullish.

[@revieve8095]

Very well explained & gr8 efforts. Can we do at google sheet?

[@MarkUrsell]

Yes, it's exactly the same for Google Sheets. And you can combine it with Google Finance historical and (almost) live stock prices.

[@david79lam47]

Thanks you very much ! I just finished one by your teaching

[@Proboy7200]

Hey Mark, this is wonderful, however in few charts there are 3 variables to the PSAR, "Start", "Accelerator / Increment" and "Maximum". How can we add the "Start" variable in the calculation, I use 2 PSAR .01,.01,.20 and .02,.02,.20. Plz help

[@MarkUrsell]

Hi Vikash, good question. Firstly, have a look at the version on this video: kzbin.info/www/bejne/g6aooXp4dq1qptk which is a newer version. Enter a new variable cell in You need to adjust the Acceleration column. Enter a new variable cell in H4 which will be your start value. Adjust the formula in Cell H6: =IF(AND(L6=L5,G6G5,H5

[@MrAmirarsalaan]

@@MarkUrsell thanks for sharing your knowledge, calculation at this video is closer to what I see on IG.com trend. Updated one is off. Stochastic calculation is off also.

[@amolyewale1348]

really nice video, can I get information about stock charts? can it draw in excel or need of special software?

[@MarkUrsell]

Hi, thanks for the feedback. You can draw stock charts in Excel. Just select: Insert - More Charts - Stock Chart

[@miteshkansara4325]

I think there is a small mistake in the formula... according to the law of parabolic system, when today's sar is higher than previous or today's low, we need to consider yesterdays/today's low as the sar for today and next day... can u please look over this again? or upload a file with required updates... BTW ! u did a great job by uploading this video ! Thanks a lot ! U rock !!!

[@thembelssengwayo6896]

How is the initial value of the SAR calculated? Is it arbitrary or the is a specific formular for the initial value?

[@MarkUrsell]

I usually start with a recent high. You could also start with a recent low. It doesn't matter because the formulas will adjust when the change direction

[@1980Felipemonteiro]

Thanks for the video!

[@Dosflamingos]

Thanks!

[@billmietelski]

Bill was here.

[@MarkUrsell]

You've watched a lot of videos Bill!

[@billmietelski]

@@MarkUrsell Yeah, I thought I'd go back to the beginning, both to grab any nuggets I've missed, and to observe the evolution of this channel. The 'Bill was here' comment is my idea of a breadcrumb ... it helps me keep track of which videos I've seen, and which still need my attention. Actually, I might have watched too many videos yesterday, because KZbin started throwing errors when I tried posting ... maybe it thought I was a bot crawling the web. My other 'breadcrumb' is giving each video a thumbs up ... that'll also tell me which videos I've seen, and which I haven't (yet).

[@djay7682]

WE WANT 52WEEK HIGH LOW FORMULA.

[@Sukidezu]

11:03