[R-SIG-Finance] rbind and duplicates in monthly futures

[Peter Neumaier]

Hi all, in the interim I've managed to import the halfhourly data, cast to
a matrix, then rbind the two months
and convert to XTS for later use by my algo strategy.

I am wondering how the data overlap will be treated by the quantstrat
framework and how
it might be impacting the calculations (i.e. P&L during overlaps).

Below the files and the code I am using:

APR <-
as.matrix(read.zoo("NGF201404_6weeks30mins.csv",sep=",",tz="",header=T))
MAY <-
as.matrix(read.zoo("NGF201405_6weeks30mins.csv",sep=",",tz="",header=T))

APR_MAY <- as.xts(rbind(APR,MAY))


http://tempsend.com/BBA86DB4ED

http://tempsend.com/0EDA07753B

Thanks
Peter

On Mon, Apr 4, 2016 at 2:30 PM, Joshua Ulrich <josh.m.ulrich at gmail.com>
wrote:

> On Mon, Apr 4, 2016 at 7:24 AM, Peter Neumaier <peter.neumaier at gmail.com>
> wrote:
> > Hi all, I am trying to rbind monthly futures to a continuous time series
> to
> > be run through an algo strategy. The problem here is that data is
> > overlapping, i.e. my Feb contract trades for 6 weeks and when I rbind
> with
> > my March data I get an overlap for last two weeks of Jan.
> >
> > How can I create a time series that is continuous, not overlapping and
> > useable in quantstrat (i.e. XTS format)? I am not posting any code as it
> > would be really one single rbind statement.
> >
> Even though the code may be simple, you still would be more likely to
> receive help if you provide a minimal reproducible example of the
> issue.  In this case, the data are not simple, and most people will
> not take the time to construct sample data in order to attempt to
> reproduce the issue you describe.
>
> > Thanks
> > Peter
> >
> >         [[alternative HTML version deleted]]
> >
> > _______________________________________________
> > R-SIG-Finance at r-project.org mailing list
> > https://stat.ethz.ch/mailman/listinfo/r-sig-finance
> > -- Subscriber-posting only. If you want to post, subscribe first.
> > -- Also note that this is not the r-help list where general R questions
> should go.
>
>
>
> --
> Joshua Ulrich  |  about.me/joshuaulrich
> FOSS Trading  |  www.fosstrading.com
> R/Finance 2016 | www.rinfinance.com
>

	[[alternative HTML version deleted]]