Login Page - Create Account

Support Board


Date/Time: Thu, 28 Mar 2024 21:27:04 +0000



Spreadsheet formula problem

View Count: 276

[2022-08-17 15:26:09]
User718690 - Posts: 18
Hello,

I have a SC spreadsheet in which I have 2 columns with bid and ask volume for each tick. How can I create from this data 5 bar (X interval) running sum of bid volume and ask volume ?

I tried with count, sum but with no success. Plz for help.

edit: attached is my chart settings too
Date Time Of Last Edit: 2022-08-17 15:27:46
imageSC1.JPG / V - Attached On 2022-08-17 15:25:08 UTC - Size: 38.71 KB - 70 views
imageCS2.JPG / V - Attached On 2022-08-17 15:27:21 UTC - Size: 84.53 KB - 58 views
[2022-08-17 16:14:09]
John - SC Support - Posts: 30444
In the next calculation column available enter the following formula in cell 3 for the Bid data:
=K3 + K4 + K5 + K6 + k7

You would then do the same thing in another column for the Ask (L) data.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2022-08-18 09:53:52]
User718690 - Posts: 18
Thanks for the reply,

but I don't think this solves the problem. I tried this before I wrote to you and it's not what I'm looking for.

I am trying to make some instruments based on B/A volume. In the link below, I have indicated the CQG tool as an example. If you have any other ideas I'll be happy to test them.

thank you again

https://news.cqg.com/workspaces/2016/03/cqg-bidask-volume-oscillators
https://www.youtube.com/watch?v=UkF3AXyFraI&ab_channel=CQG%2CInc.
[2022-08-18 13:21:27]
Sawtooth - Posts: 3952
How can I create from this data 5 bar (X interval) running sum of bid volume and ask volume ?
Try this in row 3 of a Formula Column:
=SUM(OFFSET(ID1.SG1@3,0,0,$H$2,1))
where ID1 is the Bid Volume study, and H2 is the x interval

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

Login

Login Page - Create Account