Login Page - Create Account

Support Board


Date/Time: Thu, 21 Nov 2024 13:07:09 +0000



Volume x Delta on footprint chart

View Count: 442

[2024-08-26 18:55:38]
CWST - Posts: 6
Hello there, Just reaching out as I keen on setting up my footprint chart for seeing the volume x delta with the total delta at the top and the total volume at the bottom. also want volumes above 1000 to be reflected on a certain colour eg purple and volume over 1500 a different colour and also with red for a -ve overall delta and green for a +ve overall delta. Currently have the setting on the bid x ask.


Thanks
[2024-08-26 20:53:04]
John - SC Support - Posts: 36174
To display values above/below a bar (or Numbers Bar) you would use the "Study Subgraph Above/Below Bar as Text" study. Refer to the following:
Study Subgraph Above/Below Bar as Text

To color these values a certain color, you would use the "Color Bar Based on Alert Condition" study. Refer to the following:
Color Bar Based on Alert Condition
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2024-08-27 10:39:43]
CWST - Posts: 6
Hello there, Firstly how did i get it to display volume x delta. at the moment its displaying the bid x ask.

Thanks
[2024-08-27 15:13:00]
John - SC Support - Posts: 36174
If you want to see the Volume and Delta within the Numbers Bars, you would need to use two columns. One that is set to display the Volume and the other column to display the Delta. Refer to the following:
Numbers Bars: Column # Numbers Bars Text
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2024-08-27 19:26:05]
User688525 - Posts: 257
Hi John,
Is there a way with or without ACSIL to display both Volume and Delta in the same single column (or another combination) without requiring two columns?

Thank you
[2024-08-27 20:12:46]
John - SC Support - Posts: 36174
No, there is not a way to display both Volume and Delta on the same line in a single column.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2024-08-27 20:50:59]
User688525 - Posts: 257
Hi John,
Thank you for confirming.
[2024-08-29 12:41:02]
CWST - Posts: 6
Hello there, Would it be possible to see a video tutorial of how to set up the footprint accordingly or get someone to remotely guide me on how to do it ? Thanks
[2024-08-29 14:38:21]
John - SC Support - Posts: 36174
The Videos we produce are at the following link, of which there is one for Numbers Bars:
Video Library

You can also search YouTube for others that may have produced videos on this topic.

Also, you can reach out to the people at the following list who help customers with setups:
Sierra Chart Personal Assistance
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2024-08-30 13:13:28]
ShuvFlowTrader - Posts: 30
Hi, is there an option to export Footprint Bid/Ask volumes (esp at High & low) into spreadsheet based trading system or in excel ?
[2024-08-30 16:16:13]
John - SC Support - Posts: 36174
There is not a direct option to export Numbers Bars data.

The one way around this is to use the "Spreadsheet Formula" study, which (despite its name) uses the Alert Syntax. Refer to the following:
Spreadsheet Formula

And within the Alert Syntax are options to access the Total Volume, Bid Volume, and Ask Volume at a price point. Refer to the following:
Study/Chart Alerts And Scanning: Special Functions

You can also use this in combination with the Main Price Graph Identifiers. Refer to the following:
Study/Chart Alerts And Scanning: Available Main Price Graph Identifiers/Variables

So you to get the Bid Size at the Low of every bar by entering the following formula in the Spreadsheet Formula:
=BVAP(L, 0)

You can then use the "Write Bar and Study Data to File" study to get the data output automatically. Or, if you just need snapshots, and not data at all times, then you can just do an export using "Edit >> Export Bar and Study Data to Text File". Refer to the following:
Write Bar and Study Data To File

Edit Menu: Edit >> Export Bar and Study Data to Text File
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2024-09-02 13:43:56]
ShuvFlowTrader - Posts: 30
Thanks John, thats been extremely helpful.
Just one question though, in the spreadsheet system, we are able to see the Total volume per price level (if the Number bars output is set to True) , is it too much work to include the Bid & Ask breakdown also in the same spreadsheet ? Then we can incorporate those directly in the Trading strategy thru Spreadsheet
[2024-09-04 17:59:37]
John - SC Support - Posts: 36174
That is a Feature Request. We take all requests, but we can not say when we would get to any particular item.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2024-11-13 17:55:51]
ShuvFlowTrader - Posts: 30
Hi John, seeing an odd behaviour in VWAP Rolling study (ID15) and normal VWAP(ID10). Both the VWAPs are jumping abruptly with a big gap intraday. Whereas the VbP visible Bars(ID17) VWAP is more consistent and smooth and tallies with other chart providers.
Can you pls advice as I was relying on ID10 & ID15 and its trigerring bad signals thru spreadsheet trader.
In the attached file, see how the VWAP jumped from 6011 to 6028 for ES .
The timestamp was 2024-11-13 17:15:00 & 2024-11-13 17:11:48 in Range chart.

Also attached is the chart, where you see the Pink bold line for VWAP coming from VbP (ID17) study which is fine, but I cant get this in the spreadsheet apparently, is there a way ?
Date Time Of Last Edit: 2024-11-13 18:02:14
imageVWAP Jump 13Nov2024.JPG / V - Attached On 2024-11-13 17:54:09 UTC - Size: 29.65 KB - 16 views
imageVbP VWAP Pink.JPG / V - Attached On 2024-11-13 18:01:15 UTC - Size: 45.71 KB - 15 views
[2024-11-13 19:40:53]
John - SC Support - Posts: 36174
We really do not have enough information to say what exactly is occurring, but within the Volume Weighted Average Price study there is an option for "Base on Underlying Data", you should have this set to "Yes", unless there is a specific reason you do not want it to be. Refer to the following:
Volume Weighted Average Price (VWAP) with Standard Deviation Lines: Inputs
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2024-11-15 12:26:31]
ShuvFlowTrader - Posts: 30
I have turned that Option to Yes and it doesn't make any visible difference.
Can you pls confirm if the VWAP & VWAP(Rolling) is based on Tick/Transactions Or discreet Last/OHLC etc candle numbers ? It seems the later , hence am always finding the VWAP from VbP study always different from the standard VWAP indicators (attached see the diff between the Blue line on standard VWAP vs Pink based on VbP ). The Pink VWAP from VbP studies seems to be more accurate in reflecting all transactions. But it changes as I scale the chart including ore/less bars and I need a consistent VWAP to refer from the spreadsheet trading. The Blue one (standard VWAP with setting of Underlying Data set to Yes) is definitely not correct ti seems.




Thanks
Date Time Of Last Edit: 2024-11-15 12:39:28
imageVWAP Discrepancy.JPG / V - Attached On 2024-11-15 12:25:37 UTC - Size: 28.56 KB - 13 views
[2024-11-15 15:52:15]
John - SC Support - Posts: 36174
Can you pls confirm if the VWAP & VWAP(Rolling) is based on Tick/Transactions Or discreet Last/OHLC etc candle numbers ?

It depends on the setting for "Base on Underlying Data". If this is set to "No", then the study uses the Last price for each bar along with the bar Volume. If this is set to "Yes", then it is using the per tick information. When this option is set to "Yes", then you will get the exact same VWAP between the Volume Weighted Average Price and the Volume by Price study, as long as the periods are set to be the same.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2024-11-15 17:49:36]
ShuvFlowTrader - Posts: 30
That is clearly not happening. see the attached screenshot, the Blue (normal)VWAP abruptly drops, pls find the setting am using.
The Pink VWAP(from VbP) aligns with the external provider like TradingView, if I show only the current day's bars.
I have tried changing the 'Input' setting for the VWAP from Last to OHLC avg etc, it doesn't change much.

The attached screenshot shows the time too, its London timezone for ES.
Date Time Of Last Edit: 2024-11-15 17:51:21
imageVWAP Discrepancy2.JPG / V - Attached On 2024-11-15 17:49:25 UTC - Size: 33.81 KB - 13 views
imageVWAP setting.JPG / V - Attached On 2024-11-15 17:49:30 UTC - Size: 60.46 KB - 10 views
[2024-11-15 19:41:48]
John - SC Support - Posts: 36174
There is something in your setup between those two studies that is making them different.

Please get us a chart that has just those two studies on it so we can see how you have them setup. Refer to the following:
Support Board Posting Information: Providing Chartbook with Only a Single Chart

Just so you are aware, we did test this after your first post and before we responded to ensure that there were no changes that would cause a difference. We get the exact same VWAP with both studies. But again, they have to be setup to start at the same point in time.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing

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

Login

Login Page - Create Account