Login Page - Create Account

Support Board


Date/Time: Sun, 22 Dec 2024 05:42:29 +0000



Post From: QuoteBoard question , Can we create our own custom fields ?

[2015-03-10 22:44:07]
User48557 - Posts: 138
I am guessing this can be done on a spreadsheet . Would someone be kind enough to come up with that formula and send the code ? (If even possible)

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.