Login Page - Create Account

Support Board


Date/Time: Sun, 22 Dec 2024 05:01:34 +0000



QuoteBoard question , Can we create our own custom fields ?

View Count: 1082

[2015-03-08 20:24:50]
User48557 - Posts: 138
For my quote board i only need the fields that are shown in the picture and i would also like to add a formula of my own if possible and have it as a quote board heading.

My formula is the comparison of the current volume to the 7 day average volume (as a percent) . For the given time of day. Can this be done?

Date Time Of Last Edit: 2015-03-08 20:26:02
imageCapture quote.GIF / V - Attached On 2015-03-08 20:15:06 UTC - Size: 57.82 KB - 425 views
[2015-03-09 00:55:39]
nioko54130 - Posts: 108
+1

great idea
[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.






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

Login

Login Page - Create Account