Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

xts tick data rolling subset

Tags:

r

xts

I have created an xts object from historical tick data, sourced from a SQL database. I would like to create subsets of the tick data, for example:

Show daily ticks between 10am and 2:30pm. This would allow me to create specific data sets for specific trade ideas, based on the time of day. The format of my index is as follows:

> index(merged[3567,])
[1] "2011-08-01 13:17:59 SAST"

Could an expert in xts please advise me how I would go about creating these subsets? Any advice would be greatly appreciated.

like image 433
E.D. Avatar asked Dec 05 '25 01:12

E.D.


1 Answers

You can do it with time-of-day subsetting:

merged["T10:00/T14:30"]
like image 60
Joshua Ulrich Avatar answered Dec 07 '25 16:12

Joshua Ulrich



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!