3month percentage change

Viewing 9 posts - 1 through 9 (of 9 total)
  • Author
    Posts
  • 10/18/2023 at 8:29 AM #222585 quote
    sarus
    Participant
    Junior

    How can I see the 3month percentage change of my instruments? (and 6 month percentage change)?

    10/18/2023 at 10:40 AM #222594 quote
    robertogozzi
    Moderator
    Master

    You can use the RULER to draw it between two points to know those data.

    My pics show a 3-month and a 6-month difference.

    I used the MONTHLY timeframe to shrink it amd make it easier, but you can use it on any timeframe.

    x3.jpg x3.jpg x6.jpg x6.jpg
    10/18/2023 at 10:50 AM #222598 quote
    sarus
    Participant
    Junior

    I mean to see the 3 month percentage change in a list for all my instruments

    10/18/2023 at 11:17 AM #222604 quote
    robertogozzi
    Moderator
    Master

    Do you want a screener?

    10/18/2023 at 11:50 AM #222605 quote
    sarus
    Participant
    Junior

    Either in my list either as a screener but i find it strange that the software has no way to let you see % change over a certain period for your list of stocks. This seems very basic to me

    10/18/2023 at 12:49 PM #222608 quote
    robertogozzi
    Moderator
    Master

    This is a screener:

    N     = 3
myVAR = high[2] - low
myVAR = high[max(1,N-1)] - low
PC    = myVAR * 100 / high[max(1,N-1)]
SCREENER[PC](PC AS "% Variation")

    N is the number of months.

    10/18/2023 at 1:20 PM #222609 quote
    sarus
    Participant
    Junior

    seems not correct

    % change 3 months is simply (current close – close 3months ago)/close 3 months ago

    10/18/2023 at 4:03 PM #222621 quote
    robertogozzi
    Moderator
    Master

    That’s not the percentage, that’s just a ratio.

    The % must be calculated on the older price. If today a price is 90 and 3 months ago it was 100, there’s been a drop of 10 points, which is 10% calculated on the starting price, while it’s (incorrectly) 11.11% if calculated on todays’s price.

    Anyway, if you prefer the calculation on today’s price, there you go:

    N     = 3
myVAR = high[max(1,N-1)] - low
PC    = high[max(1,N-1)] * 100 / myVAR
SCREENER[PC](PC AS "% Variation")

    You can safely remove line 2 from my previous code, it’s useless as it is overridden in line 3. I just used it to make some tests.

    10/19/2023 at 5:02 PM #222651 quote
    JS
    Participant
    Senior

    Hi Sarus,

    A screener based on your formula looks like this…

    You can apply this screener to your lists and when you work in V12 you can add multiple columns with your criteria…

    TimeFrame(Monthly)
ProChange3M=((Close-Close[3])/Close[3])*100
ProChange6M=((Close-Close[6])/Close[6])*100
Screener[1](ProChange3M as "%3M", ProChange6M as "%6M")
    Scherm­afbeelding-2023-10-19-om-18.01.43.png Scherm­afbeelding-2023-10-19-om-18.01.43.png
  • Author
    Posts
Viewing 9 posts - 1 through 9 (of 9 total)
  • You must be logged in to reply to this topic.

3month percentage change


Platform Support: Charts, Data & Broker Setup

New Reply
Author
author-avatar
sarus @sarus Participant
Summary

This topic contains 8 replies,
has 3 voices, and was last updated by JS
2 years, 4 months ago.

Topic Details
Forum: Platform Support: Charts, Data & Broker Setup
Language: English
Started: 10/18/2023
Status: Active
Attachments: 3 files
Logo Logo
Loading...
Do you like cookies? 🍪 We use cookies to ensure you get the best experience on our website. (Learn more)
©2026 ProRealCode - Trading & Coding with ProRealTime™