Looking to calculate the percentage difference from the current day 5 min candle at open as well as the next 2 candles. 9:30-9:35, 9:35-9:40, and 9:40 - 9:45 candles volume ). The calculation is getting the last 5 days of 5 min candle volume at the same time slot and calculate the average volume . Then take the average of the five days and compare it to the current day candle volume. add a label on the chart with volume percent increase for 9:30 - " percent increase", 9:35 "percent increase" and 9:40 "percent increase"
Here is a chart of the data to help understand the goal:
Take candles 1-5 sum divided by 5 and take avg sum to find percent diff with current [0] candle. do that for the next two candles as well.
Note the volumes in the chart as in 129.00 in the first column is 129 thousand (I just rounded for the manual process) Date is 9/16 for CRWD
Not show how robust this scan can be but figured I would ask- Can we scan for multiple days back ( like 10 days of candle sums divide by that amount of candles 10 to get avg and then percent diff to current candle )and use the "Input and options screen" to modify the days back up to 10 as an example. As well as can it be that if you're on a 15 min chart it will locate average of 15 min bars rather than 5 min bars. Very much appreciate your help in this.
Here is a chart of the data to help understand the goal:
Take candles 1-5 sum divided by 5 and take avg sum to find percent diff with current [0] candle. do that for the next two candles as well.
Note the volumes in the chart as in 129.00 in the first column is 129 thousand (I just rounded for the manual process) Date is 9/16 for CRWD
Not show how robust this scan can be but figured I would ask- Can we scan for multiple days back ( like 10 days of candle sums divide by that amount of candles 10 to get avg and then percent diff to current candle )and use the "Input and options screen" to modify the days back up to 10 as an example. As well as can it be that if you're on a 15 min chart it will locate average of 15 min bars rather than 5 min bars. Very much appreciate your help in this.
| CRWD | 5 min bars | ||
| Days back | 9:30 candle | 9:35 candle | 9:40 candle |
| 0.00 | 129.00 | 46.00 | 44.00 |
| 1.00 | 38.00 | 32.00 | 14.00 |
| 2.00 | 75.00 | 21.00 | 27.00 |
| 3.00 | 62.00 | 45.00 | 29.00 |
| 4.00 | 65.00 | 29.00 | 24.00 |
| 5.00 | 93.00 | 50.00 | 38.00 |
| Sum of 1-5 | $ 333.00 | 177 | $ 132.00 |
| $ 66.60 | 35.4 | $ 26.40 | |
| 1st Candle of day | 2nd candle of day | 3 rd candle of day | |
| This would be the label on chart | 193.69% | 129.94% | 166.67% |
