Login Page - Create Account

Support Board


Date/Time: Mon, 25 Nov 2024 17:32:14 +0000



Setting up a VWAP at a specific time everyday

View Count: 505

[2024-02-06 03:55:57]
User38682 - Posts: 18
Hi I was trying to create a study to measure vwap at the end of day and plot a moving average for the last 20 or 30 days? Can you help me figure out how to do that?
[2024-02-06 15:58:43]
John - SC Support - Posts: 36253
To get an average of the VWAP value from a specific time each day, use the "Relative Volume" study and set it to be based on the VWAP study. Refer to the following:
Relative Volume
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2024-02-06 21:44:39]
User38682 - Posts: 18
Is it possible for you to provide an example? I'm not good at programming.
[2024-02-06 21:49:38]
John - SC Support - Posts: 36253
It's not programming, the "Relative Volume" can be used to give you an average of data from the same time every day. Refer to the information for the study here:
Relative Volume
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2024-02-15 04:21:58]
User38682 - Posts: 18
I guess I'm interested in a rolling settlement value, that plots the moving average of the vwap settlement value. I can't figure out how to plot that. I know you don't think its not programming for you but I would say it is not easy for me. I'm just asking for a little help. Can you give me an example, for you it really wouldn't take long?
[2024-02-15 15:22:06]
John - SC Support - Posts: 36253
We are not understanding what you are looking for in terms of a "VWAP Settlement Value". What exactly is this?
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2024-02-19 16:59:55]
User38682 - Posts: 18
I measure the volume between 12:30:00-12:59:59 everyday and that's settlement volume and vwap price, for the trading day. I take the last 5 days and plot them on my chart. So I want to have a rolling value over the last 20 days, hopefully that makes sense?
[2024-02-19 17:50:00]
John - SC Support - Posts: 36253
How are you getting the volume and VWAP price for that time period? Is this a 30 minute chart?

If you are using 30 minute chart bars, then again, refer to the "Relative Volume" study which will give you the average of what you want for that time period (bar) over x number of days.
Relative Volume
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2024-02-22 01:33:23]
User38682 - Posts: 18
no it's a 1 minute bar
[2024-02-22 16:42:50]
John - SC Support - Posts: 36253
The easiest way to do what you want is to create a separate 30 minute chart and use the Relative Volume study. You can use the "Text Display for Study from Chart" to then display the current value in the 1 minute chart. Refer to the following:
Relative Volume

Text Display For Study

Otherwise, you would have to use the Spreadsheet Study to get what you want and you will need to do a fair number of manipulations to get the information as you want it.
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