Support Board
Date/Time: Sun, 16 Mar 2025 22:50:19 +0000
Spreadsheet formula problem
View Count: 506
| [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
|
SC1.JPG| [2022-08-17 16:14:09] |
| John - SC Support - Posts: 38678 |
|
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: 4185 |
|
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: