Support Board
Date/Time: Sat, 30 Nov 2024 03:50:29 +0000
Post From: study
| [2022-12-14 21:56:02] |
| John - SC Support - Posts: 36350 |
|
From Google Translate: Hello,
I would like to automatically plot vwap levels from the previous day into the current day. Can you tell me how to do it? Thanks The only way to grab a piece of information from a prior point and then carry it forward is to use the Spreadsheet Study for this. Assuming you already have the VWAP study on the chart and that your chart is Time-Based, then you would start by putting the following formula in the K column: =IF(FRACTIME(A3) = 15.5/24, ID1.SG1@3, 0) Where 15.5 represents the hour and portion of minutes of the start of the last bar from the previous day (15:30 in this case). It is divided by 24 to define it as a decimal which is how Sierra Chart handles time internally. ID1.SG1@3 is the ID (1) of the VWAP study and Subgraph (SG1) of the VWAP itself. The @3 is a spreadsheet nomenclature for row 3, so the beginning of the data in the spreadsheet. Then in Column L put the following: =MOSTRECENTNONZEROVALUE(K3:K1000) Where K is the K column and the range is dependent on your data and number of entries in your spreadsheet. This will then give you a line in the L column that represents the previous day's VWAP in the current day. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |