How to Calculate the PSAR Indicator Using Excel

Поделиться
HTML-код
  • Опубликовано: 4 ноя 2024

Комментарии • 25

  • @eitan71
    @eitan71 6 месяцев назад

    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
    @TurtleTrader 10 лет назад +4

    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
    @siyuancheng9575 2 года назад +1

    Awesome video with great explaination! Many many thanks

  • @rcapower19147
    @rcapower19147 10 лет назад +6

    Amazing video! Thanks so much for your help!

    • @MarkUrsell
      @MarkUrsell  10 лет назад

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

  • @david79lam47
    @david79lam47 3 года назад

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

  • @revieve8095
    @revieve8095 Год назад +1

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

    • @MarkUrsell
      @MarkUrsell  Год назад

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

  • @kartheekchinta734
    @kartheekchinta734 11 месяцев назад

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

  • @thembelssengwayo6896
    @thembelssengwayo6896 Год назад

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

    • @MarkUrsell
      @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

  • @miteshkansara4325
    @miteshkansara4325 10 лет назад

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

  • @Proboy7200
    @Proboy7200 4 года назад +2

    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
      @MarkUrsell  3 года назад

      Hi Vikash, good question. Firstly, have a look at the version on this video: ruclips.net/video/MuEpGBAH7pw/видео.html 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
      @MrAmirarsalaan 3 года назад

      @@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
    @amolyewale1348 7 лет назад +1

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

    • @MarkUrsell
      @MarkUrsell  7 лет назад

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

  • @1980Felipemonteiro
    @1980Felipemonteiro 9 лет назад +2

    Thanks for the video!

  • @Dosflamingos
    @Dosflamingos 5 лет назад +1

    Thanks!

  • @billmietelski
    @billmietelski 2 года назад +1

    Bill was here.

    • @MarkUrsell
      @MarkUrsell  2 года назад +1

      You've watched a lot of videos Bill!

    • @billmietelski
      @billmietelski 2 года назад

      @@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 RUclips 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
    @djay7682 6 лет назад

    WE WANT 52WEEK HIGH LOW FORMULA.

  • @Sukidezu
    @Sukidezu 2 года назад

    11:03