Home >> Support Board

Support Board

Date/Time: Sun, 24 Nov 2024 06:06:43 +0000

How to Post a Message for Support

normalization question

View Count: 273

[2024-06-11 17:54:15] #1 [Go To First Post]
User411320 - Posts: 289
Hello, I'm attempting a normalization formula (seen in the picture) but I'm not getting the result of 0 and 1. Instead I'm getting values greater than 1 and less than 0 (seen in the other picture). I wrote the formula from the picture as =(E3-$V$3)/($W$3-$V$3). E (last price) V (MIN function of E) W (Max function of E) any help would be appreciated


Screenshot 2024-06-10 130823.png / V - Attached On 2024-06-11 17:53:55 UTC - Size: 15.6 KB - 60 views Screenshot 2024-06-11 134722.png / V - Attached On 2024-06-11 17:54:05 UTC - Size: 23.18 KB - 51 views

[2024-06-11 23:13:29] #2 [Go To First Post]
John - SC Support - Posts: 36238
Your formula is correct. You must have something else somewhere that is not correct. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2024-06-12 11:49:31] #3 [Go To First Post]
User411320 - Posts: 289
John, What else can it be? is it because it's a futures contract? I also tried it on ES and RTY and it was the same issue. Not sure if this can be it but i have the min and max function of the last 100 values so: =MIN(E3:E102) =MAX(E3:E102) When I change the amount of values it doesn't fix the problem though Date Time Of Last Edit: 2024-06-12 11:52:12

[2024-06-12 16:00:56] #4 [Go To First Post]
John - SC Support - Posts: 36238
Your problem is the number of bars over which you are calculating the MIN and MAX. This is why you see the values look good for a bit close to the most recent bar, but then goes haywire prior to that. You need to calculate the Min and Max over the number of bars for which you want to normalize the data. Also, you should use an absolute reference for the MIN and MAX so you get the same value in the entire row. For instance, it should look like this: =MIN($E$3:$E$2000) For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2024-06-12 18:03:14] #5 [Go To First Post]
User411320 - Posts: 289
John, Thanks for the explanation, I used the following formulas: =MAX($E$3:$E$22) =MIN($E$3:$E$22 but it's still giving the same issue. please see attached pic


Screenshot 2024-06-12 140239.png / V - Attached On 2024-06-12 18:03:05 UTC - Size: 27.64 KB - 37 views

[2024-06-12 19:27:52] #6 [Go To First Post]
John - SC Support - Posts: 36238
You need to go our more than just 19 bars. You need to do something like =MAX($E$3:$E$2000). You may need to go more than 2000, depending on how many bars are in your chart and how far you want to normalize the data. You will also want to ensure that you have enough rows in your spreadsheet by checking the Input for "Number of Rows". Refer to the following: Spreadsheet Study Inputs: Number of Rows If you are not sure how many bars are in your chart, one easy way to find the number is to use the "Bar Numbering" study and be sure to set the Input for "Do Not Reset At Start of New Day" to "Yes". For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2024-06-12 20:00:00] #7 [Go To First Post]
User411320 - Posts: 289
Hello John, I followed your instructions and generated the following. please see attached pics


Screenshot 2024-06-12 155736.png / V - Attached On 2024-06-12 19:59:33 UTC - Size: 71.03 KB - 44 views Screenshot 2024-06-12 155846.png / V - Attached On 2024-06-12 19:59:42 UTC - Size: 35.52 KB - 41 views

[2024-06-13 14:17:25] #8 [Go To First Post]
John - SC Support - Posts: 36238
The normalized data is within the range of zero to one, so everything looks good to us. Is there something you were wondering about? For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2024-06-18 17:24:53] #9 [Go To First Post]
User411320 - Posts: 289
How would I go about bounding it like overbought or oversold?

[2024-06-18 19:25:34] #10 [Go To First Post]
John - SC Support - Posts: 36238
We can not answer that question. That is a personal decision that you need to determine. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

To post a message in this thread, you need to log in with your Sierra Chart account: