Intraday Stats During Opening Hours

Forums › ProRealTime English forum › ProRealTime platform support › Intraday Stats During Opening Hours

Viewing 12 posts - 1 through 12 (of 12 total)
  • 11/18/2022 at 12:50 PM #204389
    Voyager

    Hi there, was wondering if anybody could help with this simple requirement:

    Let’s use Australia 200 Cash CFD for the below example.

    Is there a simple way to click a button or have an indicator whereby on click the following happen:

    • The chart immediately snaps to a view showing the opening hours (10am – 4pm) on the 5m chart (i.e. the screen will only show 72 5min candles).
      • Or if this is not possible then alternatively have the platform draw vertical separators or colour code the period between 10am-4pm.
    • Then of those 72 candles on screen, it will show the Open, Close, High and Low for the 10am-4pm session only (not showing premarket data). Perhaps right in the top left corner for convenience.
    • Bonus: And even better if I could make one click to export the Open, Close, High and Low in CSV format.

     

    I was wondering if the above can be achieved with some simple configuration and not requiring any coding?

    Thanks in advance!

     

     

    11/18/2022 at 4:19 PM #204393
    JS

    Hi @Voyager

    You can easily adjust the graph yourself:

    Set your “units” to 72

    Limit your chart view from 10:00 am to 4:00 pm

    (All candles will display the Open High Low and Close…)

    11/19/2022 at 4:10 PM #204471
    Voyager

    Hi JS thanks for responding.

    I was hoping more something like this. Was wondering if this is possible out of the box or will I need to program some custom indicator?

    Say I have a chart with a n number of candles on screen. I’d like to see the high, low, open and close only for the set of candles on screen like below.

    Additionally when trading an instrument such as Australia 200 Cash CFD the price data is continuous as it is based on the futures price which trade 24 hours a day 5 days a week.

    And this makes it hard to see the times that matter which are the opening hours (in this case 10am-4pm). So was wondering is there a way to have color-coded session breaks like this?

    Thanks and appreciate your input.

    11/19/2022 at 4:55 PM #204475
    JS

    Hi Voyager,

    For the colored background you can use the indicator…

    You can set the color yourself according to the RGB table…

     

    11/19/2022 at 5:13 PM #204476
    JS

    As for the Open/High/Low/Close…
    Each bar/candle has its own Open/High/Low/Close
    What you show on your screenshot is the Open of the session and the highest value, the lowest value and the Close of the session. You won’t know these values until the session ends…
    You can determine these values with:

    If OpenTime = SessionStart then
    xOpen = Open
    ElsIf OpenTime = SessionEnd then
    xClose = Close
    xHigh = Highest[72](High)
    xLow = Lowest[72](Low)
    EndIf

    11/19/2022 at 9:41 PM #204486
    JS

    Hi @Voyager

    Here is the full indicator with colored background and text…

    Perhaps needless to say:

    1. Import the “itf -file” (under “Indicators”)
    2. Add the indicator below the “Price” (top left of your chart)

     

    1 user thanked author for this post.
    avatar Voyager
    11/20/2022 at 9:47 AM #204495
    Voyager

    Hi @Voyager thanks for the code snippets, much appreciated!

    You’ve helped me resolve the colored background for the session and that’s visually very helpful and that bit is all good now.

    Regarding the annotation of the chart with the Session Open, Close, High and Low it’s getting really close to what I had in mind.

    I was wondering if it were possible to access specific bars based on specific time conditions and not just based on using the index offsets.

    The reason for this is if I switch from a 5m chart to a 15m chart the offset is no longer 72 candles but instead only 24 15 minute bars between 10am-4pm. And if I switch to a 10m it will be 36 bars.

    Perhaps this will illustrate better what I mean. I’ve added some pseudo-code in [brackets]:

    Also while playing around with the settings, I came across Dynamic Horizontal Line and was wondering if we could utilise that in the code instead of using DrawText?

    But if that is not possible (I’m guessing it will draw 4 lines for every single day thus cluttering the entire chart?) the text annotation is very much good enough.

    Thanks for your input.

     

    11/20/2022 at 9:02 PM #204538
    JS

    Hi @Voyager

    The problem with the text can be solved with “GetTimeFrame”

    “GetTimeFrame” gives the time frame in seconds so you can calculate the periods with:

    GTF = GetTimeFrame

    Period = 3600 / GTF * 6

     

    11/22/2022 at 1:50 AM #204599
    Voyager

    Hi @JS thanks for the new code using time to calculate the daily highs and lows.

    I saw your attached screenshot and it looks great however I seem to be unable to reproduce it on my end? I copied your code as is.

    I was confused because I keep getting lots of overlapping text during the Market Open hours (i.e. the periods with highlighted background) such that it becomes unreadable.

    And also in your screenshot there is no text annotation for the Market Close hours which is what I was expecting on my end too. However I get a lot of “noise” during Market Close periods with lots of Highs and Lows being reported which I was surprised because they fall outside the time period that the IF statement should take care of?

    Any idea what could be causing this overlapping and unclear text?

     

     

     

     

    11/22/2022 at 8:02 AM #204609
    JS

    Hi @Voyager

    Try this…

     

    11/26/2022 at 11:55 AM #204846
    Voyager

    Hi @JS thanks for the code.

    I’ve just tested it and it works much better now with far fewer overlapping text. For some reason there is still some but far less such that I can live with that.

    I’ll have a go at implementing your code for both the session background color and the High/Lows for other timezones and other markets myself.

    Thanks for your help with this and I believe I can mark this support topic as resolved now.

    I hope you have a nice weekend!

    1 user thanked author for this post.
    avatar JS
    11/26/2022 at 11:30 PM #204879
    robertogozzi

    @Voyager

    Do not embed pics and other files in your post, as this slows down the loading of pages; Select File is all you need to  attach them.

    Thank you 🙂

     

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

Find exclusive trading pro-tools on ProRealCode Marketplace

Similar topics:
change opening hours
looking for info on new v12 feature: configure opening times of intraday candles
checking daily criteria in an intraday screener possible?
draw lines from candle 12 hours ago
high low mid during trading hour
how do i calculate roi% based on a combination of eod and intraday time frames?
intraday historical data
intraday trade mgmt on chart
liquidity at the opening of dax
opening time of dax future (ib) ?

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