Hi guys, I've searched the forums and can only find Jose's end of day VWAP and I am wondering if anyone has made an intra day VWAP indicator? Are people calling something different here? It's a really useful tool for intra day trading in stocks so I'm a bit surprised metastock doesn't ship with it attached. Am I missing it under a different name? You use it from the open of each day (10 am in Australia, and it ends at the close 4:10pm in Australia). Does anyone else use this sort of tool? 

VWAP stands for volume weighted average price and nearly all intra day execution by insitutions use it as a benchmark

Craig

Thanks for that. I've tried this morning with the following but it does not start on the right day! I'm confused as to why it won't pin the beginning of the VWAP calculation to the day I enter

sm:=Input("starting month",1,12,2); sd:=Input("starting day of month",1,31,5); sy:=Input("starting year",1980,2100,2018); d1:= sd=DayOfMonth() AND sm=Month() AND sy=Year(); AVG:=(O+H+L+C)/4; Cum(V*AVG)/Cum(V);

Why does it calculate it from first date loaded? How do I pin it to my desired start time?

Is there a way to pin it at 10am of every day that a stock trades and leave it on my intra day charts forever? So it would reset at each day's open and start calculating from the open until the close. Leaving it on a chart is a massive advantage because you see where yesterdays VWAP was and how support resistance affects todays trading. Is this sort of thing possible with Metastock? Craig

Edited by user Monday, February 5, 2018 1:41:24 AM(UTC)  | Reason: Not specified

Originally Posted by: Gherkin

Any one know how to pin VWAP to the open for intra day data? It seems so easy, as VWAP is in almost every trading software I can see, but I can't make it work. 

Actually today I've tried every single VWAP formula that's been posted on the forums or that I've found elswhere, and only 1 VWAP formula works and it's for end of day data! Its the VWAP for support and resistance formula

VWAP is very handy for trading.

I mainly use intraday VWAP for trading but the anchored VWAP (end of day data) is meant to be useful for position trading.

Hello,

One thing to keep in mind is that MetaStock formulas are designed to calculate over the entirety of the data loaded into the chart.

You have defined a date in D1, but there is nothing done with D1 beyond this, so the subsequent formula just ignores this variable.

What you could possibly do is use ValueWhen in conjunction with your date, and capture the formula value at this time. Then subtract this variable from the final formula line, i.e.

AVG:=(O+H+L+C)/4;
sm:=Input("starting month",1,12,2);
sd:=Input("starting day of month",1,31,5);
sy:=Input("starting year",1980,2100,2018);
d1:=ValueWhen(1,sd=DayOfMonth() AND sm=Month() AND sy=Year(),Cum(V*AVG)/Cum(V));
Cum(V*AVG)/Cum(V)-d1;

Might need Hour() and Minute() to make it work better with intraday data but I believe this might be something along the lines of what you are looking to do.

Originally Posted by: MS Support

Originally Posted by: Gherkin

Hello,

One thing to keep in mind is that MetaStock formulas are designed to calculate over the entirety of the data loaded into the chart.

I've got an intra day ATR that you can pin to a specific time / date for each and every chart. I was hoping that there's a solution like that for this intra day VWAP indicator. It's a pretty big deal that it's missing to be honest. I'll bet there's no other metric so universally used by institutions and hedge funds.