rahul deora
2012-May-21 05:15 UTC
[R] convert function in RTAQ package for high frequency data analysis
Hello Everyone, I am trying to convert the txt file into RData format by using convert function in RTAQ package.The txt file looks like: 2010-07-01 08:04:28 SBUX Q 24.9500 100 T 0 0 2010-07-01 08:04:28 SBUX Q 24.9500 100 T 0 0 2010-07-01 08:04:28 SBUX Q 24.9600 300 T 0 0 The code I am using is:> convert(from="2010-07-01",to="2010-07-01",datasource="C:\\workdirectory\\TAQdata",datadestination="C:\\workdirectory\\datadestination",trades=T,quotes=F,ticker="SBUX",dir=F,format="%Y-%m-%d %H:%M:%S",) Warning message: In read.table(file = file, header = header, sep = sep, quote = quote, : incomplete final line found by readTableHeader on 'C:\workdirectory\TAQdata/2010-07-01/SBUX_trades.txt'> sbux.t <-TAQLoad(tickers="SBUX",from="2010-07-01",to="2010-07-01",trades=T,quotes=F,datasource="C:\\workdirectory\\datadestination")> head(sbux.t,3)I am getting the following output: SYMBOL EX PRICE SIZE COND CORR G127 <NA> "2010-07-01" "SBUX" "24.9500" "100" "1" "0" "0" <NA> "2010-07-01" "SBUX" "24.9500" "100" "1" "0" "0" <NA> "2010-07-01" "SBUX" "24.9600" "300" "1" "0" "0" Warning message: timezone of object (GMT) is different than current timezone (). But my desired output is: SYMBOL EX PRICE SIZE COND CORR G127 2010-07-01 08:04:28 "SBUX" "Q" "24.9500" " 100" "T" "0" "0" 2010-07-01 08:04:28 "SBUX" "Q" "24.9500" " 100" "T" "0" "0" 2010-07-01 08:04:28 "SBUX" "Q" "24.9600" " 300" "T" "0" "0" Can someone please help? Thanks [[alternative HTML version deleted]]