Support Board

Date/Time: Mon, 06 May 2024 12:02:07 +0000

[User Discussion] - Spreadsheet formula for average volume

[2015-03-16 22:47:56] #1 [Go To First Post]
User48557 - Posts: 138
I would like the spreadsheet to compare the average volume from the past 7 days for the given time. Then compare it to the current volume current time and get a reading as a percent. For example: lets say the E-mini s&p volume as of 8:30 am central is 120,000 . The last 7 days volume reading at 8:30 am was. 122,000 196,000 142,000 120,000 134,000 118,000 150,000 Total = 982,000 Divided by 7 = 140,285 = 8:30 am reading 7 day average Then i would like the spreadsheet to divide the current volume with the 7 day average so my final reading would look like. 86 % (120,000/140,285 = .855) Now i can see that the E-mini s&p is trading only 86% of its normal volume.

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