Time Weighted Average Price

This  spreadsheet study will calculate the Time Weighted Average Price and plot the line on the chart.

This is a self-contained standalone study that does not reference any other study.
It is intended to be used on intraday charts using time-based bars.
It will not work on Historical charts.

The user sets the Input value in cell K3. The default  formula  is the OHLC average.
The user also sets the Start time in cell L3.  The format needs to be hh:mm:ss

The TWAP resets every day at the Start time in L3.
If there is a bar timestamp that matches L3,  it will work on any intraday bar type.

Click on each of these links to download:
TWAP.StdyCollct+
TWAP.scss
and put both files in your Sierra Chart \Data folder. 

The study collection will load the correct spreadsheet study with the correct settings. You must use the study collection to add this study to a chart. 
The spreadsheet file contains the formulas; you must download both files.

This study was created on Chart 1/Sheet1 but can be used on any Chart#.
If you add this study to a chart other than Chart 1,   use the  user options on Sheet1.

v2: Updated to  a more accurate formula , and to allow calculation after Midnight.