return on each bar instead of last bar

Forums › ProRealTime English forum › ProBuilder support › return on each bar instead of last bar

Viewing 15 posts - 1 through 15 (of 15 total)
  • 06/04/2024 at 9:07 PM #233498
    alex62948

    Hello,

    In the following code, I am trying to obtain the current volume ratio to the average volume at the same hour.
    The problem is that the indicator returns the ratio for the last bar. I want to return the ratio for each 5-minute intraday bar.
    Do you have any solution ideas?

     

    Instant volume ratio : Zratio3 indicator

     

    Zhisto3 indicator, called below :

     

    On the first 5 minutes bar, I’m expecting a 510 ratio value, which is the result of the Zhisto3 indicator with 153500 hour parameter

    But I obtain 15 on the Zratio3 indicator for this first bar.

     

    06/05/2024 at 6:48 PM #233563
    JS

    Hi,

    The calculation of the “Instant Volume Ratio” with the “For” loop makes no sense, in the end you only calculate the last values… 🙂

    The “Zhisto3 Indicator” has a time frame of 5 minutes, and the calculation is with 20 volumes…

    Why 20 and not, for example, 12 (1 hour = 12 * 5 minutes) …

    Can you also show some more values in the graph, for example first, middle and last values…

    1 user thanked author for this post.
    avatar Iván
    06/05/2024 at 7:09 PM #233564
    alex62948

    Hi

    Thank you for your interest.

    I use the FOR loop to store data in an array. I want to display each data on each bar but I don’t know how to do this.

    You are right saying that in the end, it calculate the last values. I wish to calculate one for each bar.

    The calculation is not on 20 volumes but on 20 days because of this instruction :

    if opentime=hourstart then (reset each historical volume)

    06/05/2024 at 8:27 PM #233566
    JS

    Can you indicate which values you use to arrive at a Ratio of 510?

    I now have a “DailyVolume” which starts at 153000…

    And I calculated an “AvgVolume” over 20 days…

    AvgVolume=6,724,476.9 (153000) …?

    AvgVolume=6,401,719.6 (153500) …?

    06/05/2024 at 9:48 PM #233568
    JS

    I end up with these numbers…

    06/06/2024 at 12:54 PM #233580
    alex62948

    Hi,

    The average volume is calculated at the current hour.

    The ratio of 510 is obtained on AMC US Stock at time 15:35, cumulating the first bar volume and the second bar on 5 minutes timeframe.

    then this cumulative volume is divided by the average20days which is calculated à the same time, so 15:35 and x 100 to obtain a % value.

    So 510 means 5,10 : the actual cumulative volume is 5 x greater than its average.

    So the cumulative ratio is updated every 5 minutes but I wish to store its value on each 5m bar instead of having only the value for the last bar

    Thank you again for your help

    06/06/2024 at 2:09 PM #233584
    JS

    Hi Alex,

    Try this indicator… (minimum 21 days of historical data needed)

    06/06/2024 at 4:06 PM #233590
    alex62948

    Hi JS

    Thank you, JS, for your proposal.

    However, it doesn’t quite match what I’m looking for.
    With your indicator, the 20-day average is calculated over the entire day.
    I want to calculate the 20-day average at the same instant as the current 5-minute bar.
    I can achieve this with the previous code.
    What I can’t do is store the historical ratio for each 5-minute bar.
    In fact, with each new bar, the new cumulative value overwrites the old one.
    It’s this previous value that I want to assign to each bar in my ideal indicator.
    That’s why I used an array to try to store each value. But it doesn’t work.

    Do you think it’s possible to meet these rules in Probuilder?

    06/06/2024 at 5:57 PM #233593
    JS

    Hi Alex,

    Let’s take it one step at a time… 🙂

    Does this calculation of the average correspond to what you expect…?

     

    06/06/2024 at 8:44 PM #233599
    alex62948

    Hi JS,

    No it doesn’t correspond to what I expect

    In your last code, the average is calculated on 20 bars on 5m timeframe.

    I want to calculate the average of CurrentDailyVolume on 20 days

     

    06/06/2024 at 11:10 PM #233600
    JS

    Hi,

    The average of 20 days of CurrentDailyVolume:

    TimeFrame (5 min)

    Avg20CurrentDailyVolume=Average[20*78](CurrentDailyVolume)

    (78 x 5 min = 6,5 hour x 20 days)

     

    06/07/2024 at 5:17 PM #233625
    alex62948

    Hi JS,

    Thank you for your proposal and for helping me

    Let me explain what it doesn’t meet my requirements

    Instead of 20 days, let’s say I’ll calculate the average over the previous 3 days, to simplify.

     

    TimeFrame(5 minutes)

    Current day: it’s 16:00 June, the 7th
    vol0 = CurrentDailyVolume = Cumulative volume of bars 0 to 5 (there are 6 five-minute bars between 15:30 and 16:00)

    Day D-1 June, the 6th, always at 16:00
    vol1 = CurrentDailyVolume(D-1) = Cumulative volume of bars 0 to 5 of day D-1

    Day D-2
    vol2 = CurrentDailyVolume(D-2) = Cumulative volume of bars 0 to 5 of day D-2

    Day D-3
    vol3 = CurrentDailyVolume(D-3) = Cumulative volume of bars 0 to 5 of day D-3

    Average3daysCurrentDailyVolume = (vol1 + vol2 + vol3) / 3

    This average must be displayed on 16:00 bar of actual day

    Each bar must have its own average, so that the indicator curve does not constantly rise but reflects the average at instant t.

    06/07/2024 at 5:53 PM #233627
    JS

    I am sorry Alex, but I really don’t understand what you’re looking for …

    06/08/2024 at 6:55 AM #233629
    JS

    Hi Alex,

    In the example below, the “red spikes” are the cumulative daily volume, at 16:00, of the last three volumes (as an example) and the green lines are the three-day average of the last three cumulative daily volumes (at 16:00)…

    Is this what you’re looking for?

    06/08/2024 at 7:32 AM #233631
    JC_Bywan

    Hi,

    This June 4th initial post feels the same as the question you asked on french forum before. If that’s the case, too late to delete it as “double post / double thread” (one of the forum guidelines in the yellow box at bottom of this page), but instead I’ll just take this opportunity to explain the main reason behind avoiding double posting even accross different languages forums is to have a single conversation instead of several parallel ones, and make users’ forum searches point to complete threads rather than parallel simultaneous-in-the-past ones. I understand not receiving an immediate reply in one language forum can generate desire to post it again as international, but without the no double- (or more) posting rule the forum would be a big mess, so the moderators volunteering in the community are asked to remind of that rule when it happens.

    Moderation point aside, I see you posted here yesterday afternoon so I guess you didn’t see my reply on your french forum first post yesterday morning, here’s the link just in case:

    https://www.prorealcode.com/topic/comparaison-des-volumes-a-une-heure-donnee/#post-233612

    Have a good weekend

     

  • Author
    Posts
Viewing 15 posts - 1 through 15 (of 15 total)

Find exclusive trading pro-tools on ProRealCode Marketplace

Similar topics:
buy immediately instead of bar next buy
code_condition for last bar changes
renko bar is definitly finished and displayed on the graphic
attached orders not closing when order bar is closed
bar counter display current day only
buy on certin dates, not on technical singal
buy on retest on a certain candle
closing order bar
code to exit position at next bar
draw segments around signal bar

Create your free account now and post your request to benefit from the help of the community
Register or Login