Making entry/exit reflect VWAP vs MOO or MOC

tedclimo

#1

2/16/2011 9:28 AM

Everything that follows pertains to use of daily bars.

Not sure this is possible, but need to ask.
Is there a way(in Simulations) to make market entry/exit reflect the average of open & close on entry/exit day?
This is best way I can imagine to reflect effects of using a VWAP order in Simulations.

I have a script that relies on getting in/out in a single day(size of orders requires VWAP orders thru trade desk). MOO & MOC will both likely create slippage in real life... vs what Simulator indicates using MOO/MOC orders.

So is it possible, to code script so that it "peeks" into the future(next day/entry day) and creates entry/exit point that is average of Open && Close?

I realize this will not reflect true VWAP, but it will be close enough... and far better than MOO/MOC.

Thanks in advance,

dansmo

#2

2/16/2011 10:20 AM

With Bloomberg and BBLaoder you have the option to load bloomberg´s daily VWAP and can use that as an entry with FundamentalSeries. I did not do this before but I think this should work.

tedclimo

#3

2/16/2011 12:00 PM

Can you offer a snippet of code that would make this work?
Sounds like a great idea, but not sure how to implement effectively.
Assume it will also work on exits??
Here's the big ?, if instruct script to MOO or MOC, how will it know to "Market on VWAP".
Or does Bloomberg substitute OHLC w VWAP only???
Meanwhile, I'll experiment.... perhaps easier done than I imagined.
All the best to you & yours,
T!

Cone

#4

2/16/2011 12:14 PM

QUOTE:
Is there a way(in Simulations) to make market entry/exit reflect the average of open & close on entry/exit day?

You can use the ExitAtPrice method in the Community.Components.

tedclimo

#5

2/17/2011 9:19 AM

Thank you both!

Robert,
Will try your ExitAtPrice method 1st. It is exactly the solution I was seeking.
Will update this thread once I see results.
TTFN

tedclimo

#6

2/18/2011 12:49 PM

Cone et all,
Need your help installing Priority code to the EXITATPRICE example you provided above.

I tried installing the VWAP-style entry/exit into my private script. It worked perfectly, except it does not allow me to use LastPosition.Priority coding. I use a focused portfolio of just 10 stocks (via Pos-Sizer) and this VWAP-style code comes back with errors when I include "LastPosition.Priority coding". See example below.
Can you help me correct the syntax problem?
Perhaps my error is changing Entry to Bar+1.
But in live trading, I have to use today's Technicals/Fundamentals to make a decision for entering tomorrow, hence my desire to get a VWAP-style entry price vs MOO/MOC.

CODE:
Please log in to see this code.

The actual Private script I use is far more detailed. May need to open order ticket later. In the meantime, just trying to get Priority code to cooperate with VWAP-style entry price.

Size:

Color:

Cone et all,
Need your help installing Priority code to the EXITATPRICE example you provided above.

I tried installing the VWAP-style entry/exit into my private script.  It worked perfectly, except it does not allow me to use LastPosition.Priority coding.  I use a focused portfolio of just 10 stocks (via Pos-Sizer) and this VWAP-style code comes back with errors when I include "LastPosition.Priority coding".  See example below.
Can you help me correct the syntax problem?
Perhaps my error is changing Entry to Bar+1.
But in live trading, I have to use today's Technicals/Fundamentals to make a decision for entering tomorrow, hence my desire to get a VWAP-style entry price vs MOO/MOC.
[CODE]
using System;
using System.Collections.Generic;
using System.Text;
using System.Drawing;
using WealthLab;
using WealthLab.Indicators;
using Community.Components; // Support for enter/exit at price here

namespace WealthLab.Strategies
{
	public class AtPriceDemo: WealthScript
	{
		protected override void Execute()
		{	
			// Create an instance of the PositionHelper class, passing WealthScript as "this"
			PositionHelper ph = new PositionHelper( this );
			
			// initialize your average series however you like		
			DataSeries avgSer = 0.5 * Open + 0.5 * Close;
			
			/* In the trading loop here's the buy signal that uses your peeking data.  
			   It won't create an Alert because they're peeking results.  Not a tradeable script! */

DataSeries rsi6 = (RSI.Series( Close, 6 ));
			
			for(int bar = 7; bar < Bars.Count; bar++)
			{
				if (IsLastPositionActive)
				{
					if( true )	// some condition to exit at the average price this month 
						ph.ExitAtPrice(Bars, bar, LastPosition, avgSer[bar], "Out");
				}
				else
				{
					if( true )	// some condition to buy at the average price this month 
						ph.EnterAtPrice(Bars, bar+1, avgSer[bar+1], PositionType.Long, "In");
						LastPosition.Priority = -rsi6[bar];	
				}
			}
			
		}
	}
}

[/CODE]

The actual Private script I use is far more detailed.  May need to open order ticket later.  In the meantime, just trying to get Priority code to cooperate with VWAP-style entry price.

Eugene

#7

2/18/2011 1:14 PM

Correction:

CODE:
Please log in to see this code.

tedclimo

#8

2/18/2011 2:14 PM

Embarassing that I missed a syntax error like this.
Thank you.
Your solution(&Cone's) is perfect!!!
Have a great weekend.

gbullr

#9

8/31/2017 7:00 PM

Does entry and exit at price stil work?

Trying to do what the people above have done. Enter at bar+1 on next day's vwap and exit on bar+1's vwap.

Help would be appreciated.

Thanks again.