Daily high and low screener and summer time change problem

Tom1012 · Sun, 10 Nov 2019 01:08:59 +0000

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

This topic has 3 replies, 3 voices, and was last updated 5 years ago by Tom1012.

Viewing 4 posts - 1 through 4 (of 4 total)

11/10/2019 at 2:08 AM #112481

Tom1012

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

Tom1012
Participant

Topics: 1
Replies: 1
Been thanked: 0 times

11/10/2019 at 9:40 AM #112483

Vonasi

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.

Vonasi
Moderator

Topics: 192
Replies: 5088
Been thanked: 1811 times

11/10/2019 at 10:09 AM #112485

robertogozzi

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.

robertogozzi
Moderator

Topics: 69
Replies: 17131
Been thanked: 4030 times

11/10/2019 at 10:22 AM #112487

Tom1012

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

Tom1012
Participant

Topics: 1
Replies: 1
Been thanked: 0 times
Author

Posts

Viewing 4 posts - 1 through 4 (of 4 total)

Find exclusive trading pro-tools on