Support Board
Date/Time: Fri, 27 Dec 2024 12:08:54 +0000
Post From: Relative Volume Index
| [2014-08-27 09:37:27] |
| User96105 - Posts: 113 |
|
Hi Shaharabin, I’ve spend some time looking at this (first time looking at the spreadsheet study), and I can see that this is very powerful ~ many thanks for your help with this. I wonder if you would indulge me again with your help? I need to refine the spreadsheet a little more as I would like to be able to monitor the moving “relative volume” whilst I’m trading by comparing the current day’s volume so far with the average at that same specific time point during the day. So a 5 minutes chart would be about right I think, producing a recalculation every 5 minutes. So using a 5 minute chart, what I think I need to do is produce a column “Daily Cumulative Volume” (column K) which calculates the total volume at each 5 minute row. This column needs to reset at the beginning of each new trading day to commence a new cumulative calculation. I then need another column “Average Cumulative Volume” (column L) which calculates the average total volume over the past x days at each 5 minute row. Finally I need another column “Cumulative Index” (column M) which would be (Column K) – (Column L at the same time point in the preceding trading day). At least, I think this is what I need, but I have little idea how to achieve it. Sorry, I’m sure this is very amateurish, but this is new to me…! Thanks, |