[R] rmoving dates from an xts object...
akshay kulkarni
@k@h@y_e4 @end|ng |rom hotm@||@com
Tue Jul 12 19:04:46 CEST 2022
dear Gabor,
THanks a lot....
Yours sincerely,
AKSHAYM KULKARNI
________________________________
From: Gabor Grothendieck <ggrothendieck using gmail.com>
Sent: Sunday, July 10, 2022 11:34 PM
To: akshay kulkarni <akshay_e4 using hotmail.com>
Cc: R help Mailing list <r-help using r-project.org>
Subject: Re: [R] rmoving dates from an xts object...
Look at the examples at the end of ?xts for more info.
library(quantmod)
getSymbols("AAPL")
class(AAPL)
## [1] "xts" "zoo"
range(time(AAPL))
## [1] "2007-01-03" "2022-07-08"
# everything up to indicated date
a1 <- AAPL["/2018-02-01"]
# remove non consecutive dates
d <- as.Date(c("2022-07-01", "2022-07-06")) # dates to remove
a2 <- AAPL[ ! time(AAPL) %in% d ]
On Sun, Jul 10, 2022 at 11:42 AM akshay kulkarni <akshay_e4 using hotmail.com> wrote:
>
> Dear members,
> I have OHLC data of 500 stocks: OHLCData and dates. These are of xts object. I want to do the following:
>
>
> 1. I want to remove a contiguous set of dates from the xts object. for example, I want to remove data from the OHLC data from "2022-20-7"
> 2. to "2018-2-2", continuously.
> 3.
>
> 2. I want to remove a set of dates, which are not contiguous.
>
> Any idea on how to accomplish it? I can write an intricate for loop, but any other method? Does an xts object behave like an atomic vector : OHLCData[[i]][-dates[[i]]] ?
>
> Many thanks in advance....
>
> THanking you,
> Yours sincerely,
> AKSHAY M KULKARNI
>
> [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help using r-project.org mailing list -- To UNSUBSCRIBE and more, see
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
--
Statistics & Software Consulting
GKX Group, GKX Associates Inc.
tel: 1-877-GKX-GROUP
email: ggrothendieck at gmail.com
[[alternative HTML version deleted]]
More information about the R-help
mailing list