Support Board
Date/Time: Tue, 24 Jun 2025 05:04:45 +0000
[Programming Help] - average percent change
View Count: 615
| [2022-02-05 13:16:58] |
| User156295 - Posts: 104 |
|
How to get Average from Percent Change Since Open value from different symbols? There are different symbols on each chart or symbol on one chart added by add additional symbol study. Than we have Percent Change Since Open study on each symbol. And now how to obtain average from these percents - to be able to show on the chart. Seems to be quite simple but really do not know how to get it... |
| [2022-02-05 17:03:45] |
| ForgivingComputers.com - Posts: 1071 |
|
You need one copy of the Percent Change study for each symbol. Then change the "Based On" setting to each Additional Symbol. Then Add a Moving Average Study for each percent, each Based on one of the Percent Change Studies. Input Data needs to be set to Percent Change. |
| [2022-02-06 10:23:57] |
| User156295 - Posts: 104 |
|
Hmm I need rather smth like this: data: symbol 1 -> percent change since open value 1 symbol 2 -> percent change since open value 2 symbol 3 -> percent change since open value 3 calculation should be: median = (value 1 + value 2 + value 3)/3 *100 result in % and best if ploted as bars on time dependent chart and would need some hint how to obtain this in SC |
| [2022-02-06 23:19:55] |
| ForgivingComputers.com - Posts: 1071 |
|
Use a Spreadsheet Formula Study with the ID and SG of each of the percent change studies and draw it as a bar. value 1 = ID1.SG1 value 2 = ID2.SG1 value 3 = ID3.SG1 So the formula will be: = 100 * (ID1.SG1 + ID2.SG1 + ID3.SG1) / 3
|
To post a message in this thread, you need to log in with your Sierra Chart account: