Daily high and low screener and summer time change problem

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #112481 quote
    Tom1012
    Participant
    New

    Hello,
    I am new to programming and I need help for my scan. It it has two scanning values and is used for US stocks. I hope someone of you has time for my code.

    1. Scan
    I need an scan, that finds out if the daily high or the daily low is reached first. The value that is reached first will be saved. For example the daily high is reached 30 min after the open and has a value of 35. And the daily low is reached after 90 Min and has a value of 20. Than the daily high should be used in the calculation because 30 min are less than 90 min. The scan should do this for the last 30 days and build the average value of this data. I want to see the biggest price value on top of the screen window.

    2. Scan
    This one also needs to find out if the daily high or low is reached first. If the daily high is reached first the scan has to get the opening price of the day and the high of the first 5 min candle. Now the indicator should calculate the value of the high of the first 5 min minus the opening price.

    If the daily low is reached first the scan has to geht the opening price of the day and the low of the first 5 min candle. Now the indicator should calculate the value of the opening price minus the low of the first 5 min.

    This should also calculate the 30 day average of the values and just show me the valaue for each stock in a seperate column. It is not used to sort the stocks.

    3. Problems

    The big problem with the second scan is that we have in Germany a time switch. Each winter and summer the time switches one hour forward or backwards. That means that the market open is either at 15:30 or 14:30 which is a problem when you calculate the last 30 days. I want to screen the market every day and don’t like to wait until the time swicht is 30 days ago. That means you can’t calculate the first 5 min candle with the time. Because when you set the market open in the scan at 15:30, and the time switch occurs the new opening time is 14:30 and the scan uses the wrong data.

    I hope someone has a code example for me. If you don’t clearly understand what I mean you can just ask so that I can explain my ideas better.

    Thank your for all your help!! And I am sorry if my Englisch is not perfekt.

    Yours faithfully,
    Thomas

    #112483 quote
    Vonasi
    Moderator
    Master

    Welcome to the forums.

    Please give your topics more meaningful titles rather than ‘I need help with my screener’ otherwise the forums will just be full of topics with meaningless titles all saying ‘I need help’. I have changed your topic title to something that reflects the questions being asked a little better.

    #112485 quote
    robertogozzi
    Moderator
    Master

    Please do not double post, no matter what language you use.
    I deleted the German one since this one already had an answer.

    Thank you.

    #112487 quote
    Tom1012
    Participant
    New

    Hello,
    I am sorry for my mistakes. I am new to this platform and didn’t know that. I hope I was not causing any problems to you.

    Yours faithfully,
    Thomas

Viewing 4 posts - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.

Daily high and low screener and summer time change problem


ProScreener: Market Scanners & Detection

New Reply
Author
author-avatar
Tom1012 @tom1012 Participant
Summary

This topic contains 3 replies,
has 3 voices, and was last updated by Tom1012
6 years, 4 months ago.

Topic Details
Forum: ProScreener: Market Scanners & Detection
Language: English
Started: 11/10/2019
Status: Active
Attachments: No files
Logo Logo
Loading...