highfrequency (version 0.6.5)

tradesCleanup: Cleans trade data

Description

This is a wrapper function for cleaning the trade data of all stock data inside the folder datasource. The result is saved in the folder datadestination.

In case you supply the argument "rawtdata", the on-disk functionality is ignored. The function returns a vector indicating how many trades were removed at each cleaning step in this case. and the function returns an xts or data.table object.

The following cleaning functions are performed sequentially: noZeroPrices, selectExchange, salesCondition, mergeTradesSameTimestamp.

Since the function rmTradeOutliersUsingQuotes also requires cleaned quote data as input, it is not incorporated here and there is a seperate wrapper called tradesCleanupUsingQuotes.

Usage

tradesCleanup(
  datasource = NULL,
  datadestination = NULL,
  exchanges,
  tdataraw = NULL,
  report = TRUE,
  selection = "median",
  saveasxts = TRUE
)

Arguments

datasource

character indicating the folder in which the original data is stored.

datadestination

character indicating the folder in which the cleaned data is stored.

exchanges

vector of stock exchange symbols for all data in datasource, e.g. exchanges = c("T","N") retrieves all stock market data from both NYSE and NASDAQ. The possible exchange symbols are:

• A: AMEX

• N: NYSE

• B: Boston

• P: Arca

• C: NSX

• T/Q: NASDAQ

• D: NASD ADF and TRF

• X: Philadelphia

• I: ISE

• M: Chicago

• W: CBOE

• Z: BATS

tdataraw

xts object containing (for ONE stock only) raw trade data. This argument is NULL by default. Enabling it means the arguments from, to, datasource and datadestination will be ignored. (only advisable for small chunks of data)

report

boolean and TRUE by default. In case it is true the function returns (also) a vector indicating how many trades remained after each cleaning step.

selection

argument to be passed on to the cleaning routine mergeTradesSameTimestamp. The default is "median".

saveasxts

indicates whether data should be saved in xts format instead of data.table when using on-disk functionality. TRUE by default.

Value

For each day an xts or data.table object is saved into the folder of that date, containing the cleaned data. This procedure is performed for each stock in "ticker". The function returns a vector indicating how many trades remained after each cleaning step.

In case you supply the argument "rawtdata", the on-disk functionality is ignored and the function returns a list with the cleaned trades as xts object (see examples).

References

Barndorff-Nielsen, O. E., P. R. Hansen, A. Lunde, and N. Shephard (2009). Realized kernels in practice: Trades and quotes. Econometrics Journal 12, C1-C32.

Brownlees, C.T. and Gallo, G.M. (2006). Financial econometric analysis at ultra-high frequency: Data handling concerns. Computational Statistics & Data Analysis, 51, pp. 2232-2245.

Examples

# NOT RUN {
# Consider you have raw trade data for 1 stock for 2 days 
head(sample_tdataraw_microseconds)
dim(sample_tdataraw_microseconds)
tdata_afterfirstcleaning <- tradesCleanup(tdataraw = sample_tdataraw, exchanges = list("N"))
tdata_afterfirstcleaning$report
dim(tdata_afterfirstcleaning$tdata)

#In case you have more data it is advised to use the on-disk functionality
#via "from","to","datasource",etc. arguments

# }