Last chance! 50% off unlimited learning
Sale ends in
Function returns new time series as xts object where first observation is always the opening price and subsequent observations are the closing prices over the interval with as endpoint the timestamp of the result.
aggregatePrice(
pdata,
on = "minutes",
k = 1,
marketopen = "09:30:00",
marketclose = "16:00:00",
fill = FALSE,
tz = NULL
)data.table or xts object to be aggregated containing the intraday price series, possibly across multiple days.
character, indicating the time scale in which "k" is expressed. Possible values are: "milliseconds", "secs", "seconds", "mins", "minutes","hours".
positive integer, indicating the number of periods to aggregate over; e.g. to aggregate a xts object to the 5 minute frequency set k = 5 and on = "minutes".
the market opening time, by default: marketopen = "09:30:00".
the market closing time, by default: marketclose = "16:00:00".
indicates whether rows without trades should be added with the most recent value, FALSE by default.
time zone used, by default: tz = timezone of DT column/index of xts.
A data.table or xts object containing the aggregated time series.
The timestamps of the new time series are the closing times and/or days of the intervals.
In case of previous tick aggregation or on = "seconds"/"minutes"/"hours", the element of the returned series with e.g. timestamp 09:35:00 contains the last observation up to that point, including the value at 09:35:00 itself.
# NOT RUN {
# aggregate price data to the 30 second frequency
aggregatePrice(sample_tdata_microseconds, on = "secs", k = 30)
# aggregate price data to the 30 second frequency including zero return price changes
aggregatePrice(sample_tdata_microseconds, on = "secs", k = 30)
# aggregate price data to half a second frequency including zero return price changes
aggregatePrice(sample_tdata_microseconds, on = "milliseconds", k = 500, fill = TRUE)
# }
Run the code above in your browser using DataLab