similar to: intraday OHLC plot

R version 2.12.0, 64 bit on Windows. Here is a short script that illustrates the problem: library(tseries) library(xts) setwd('C:\\cygwin\\home\\Ted\\New.Task\\NKs-01-08-12\\NKs\\tests') x = read.table("quotes_h.2.dat", header = FALSE, sep="\t", skip=0) str(x) y <- data.frame(as.POSIXlt(paste(x$V2,substr(x$V4,4,8),sep=" "),format='%Y-%m-%d

The plotOHLC function in the tseries package is useful to plot timeseries of various financial assets with open/high/low/close data. I had often wondered if it could be made to run a little faster. It turns out that the following patch does --- plotOHLC.R.orig 2003-12-14 12:02:20.000000000 -0600 +++ plotOHLC.R 2003-12-14 12:03:42.000000000 -0600 @@ -21,14 +21,9 @@ ylim <-

Hi there I have some timeseries data which I plot in a OHLC Plot. In the same plot I'd like to have the EMA of this timeseries. I tried to add the EMA point to OHLC with lines(), but this doesn't work. Has anyone an idea how to handle it? Regards, Michael Zak

Hi I have som financial tick data that i have converted in to 45 min bars. These are unequally spaced in time. I wonder if it is possible to plot these like bars as the plotOHLC does. As I have understood plotOHLC uses class(mts) that must be equally spaced? Regards Paer [[alternative HTML version deleted]]

HI, May be this helps: set.seed(24) ?mat1<- matrix(sample(1:60,30*24,replace=TRUE),ncol=24) colnames(mat1)<- rep(c("O","H","L","C"),6) indx<-seq_along(colnames(mat1)) n<- length(unique(colnames(mat1))) ?res<- lapply(split(indx,(indx-1)%%n+1),function(i) mat1[,i]) lapply(res,head,2) #$`1` #????? O? O? O? O? O? O #[1,] 18 56 51 24 24 52 #[2,]

Hi Everyone. I am downloading intraday Bloomberg data from R. The code I give is: library(zoo) library(chron) library(RBloomberg) conn<-blpConnect(show.days="trading",na.action="previous.days",periodici ty="daily") dat<-blpGetData(conn, "VG1 Index", c("LAST_PRICE"), start=as.chron(as.Date("2006-9-01",

Hello, I'm new to R and am having trouble plotting intraday data on a chart. I haven't had any success with using ideas from some other posts or other content. My data is in csv format, here's the first few rows: TimeStamp..UTC. Open High Low Close 1 2011-06-15 13:30:00:0000 127175 127500 126925 127425 2 2011-06-15 14:00:00:0000 127400 127575 127225 127225 3 2011-06-15

I'm trying to read intraday zoo but running into issues (again) ... what am I missing here? (the date doesn't seem to read in correctly) > head(dat) TrdDate TrdTime impliedVol 1 20090102 09:55:03 0.3610715 2 20090102 09:55:04 0.3637943 3 20090102 09:55:05 0.3752375 4 20090102 09:55:05 0.4190025 5 20090102 09:55:06 0.3696080 6 20090102 09:55:06 0.4944981 > f <-

Hi, I have an intraday timeseries of financial data (see below) which has gaps due to market opening and closing hours. I am trying to plot it, but the time gap is always visible in the plot. I tried converting data to xts, zoo, timeSeries and plotting it with different functions i.e. plot.xts, plot.zoo. The only way to make it work was with function 'chartSeries' in the quantmod package

Hello,   I would like to create a function that computes intraday returns of a financial asset on a calendar time basis, without making any loop. For instance, I want to get price returns every 60 seconds. The main problem is that the times series of prices is irregularly spaced in time. I have looked in the "zoo" or "its" classes but have not found any answer to my problem.

Hi, You may need to add "dec=","" in the read.csv. dat1<- read.table(text=" Time;Mid 31/01/2013 00:00;1,35679 31/01/2013 00:01;1,35678 31/01/2013 00:02;1,356785 31/01/2013 00:03;1,35689 31/01/2013 00:04;1,3569 31/01/2013 00:05;1,3569 31/01/2013 00:06;1,356885 31/01/2013 00:07;1,35691 31/01/2013 00:08;1,357

Hello all, I'm trying to use zoo.read but can't figure out how to deal with the time format. (example below) would be nice if someone could help. best regards, Immanuel --------------------------- L <- "Date,Time,Open,High,Low,Close,Up,Down 05.02.2001,00:30,421.20,421.20,421.20,421.20,11,0 05.02.2001,01:30,421.20,421.40,421.20,421.40,7,0

I am trying to create a high low close style chart but I keep getting the following error statement; "x is not a open/high/low/close time series". I've used the function is.ts and R responds TRUE but the ohlcPlot function gives the above error statement. I'm actually planning to plot some odds ratios with their confidence intervals and the hi-low-close chart should do the

Hi all I have some tick-by-tick data and I have calculated the intraday returns. I want to sum up the intraday squared returns to calculate the daily volatility(or daily variance). I know that the s-plus FinMerics has the function aggregateSeries function that can be apply to daily data: aggregateSeries(x, Fun, by="daily"), but the counterpart function in R:applySeries can not be apply

On Fri, Apr 8, 2016 at 10:51 AM, James Hirschorn <james.hirschorn at hotmail.com> wrote: > > > On 04/06/2016 07:58 PM, Joshua Ulrich wrote: >> >> On Tue, Apr 5, 2016 at 9:17 PM, James Hirschorn >> <james.hirschorn at hotmail.com> wrote: >>> >>> OpCl works on xts objects but not on quantmod.OHLC objects. Is this a >>> bug?

On 04/06/2016 07:58 PM, Joshua Ulrich wrote: > On Tue, Apr 5, 2016 at 9:17 PM, James Hirschorn > <james.hirschorn at hotmail.com> wrote: >> OpCl works on xts objects but not on quantmod.OHLC objects. Is this a bug? >> > Thanks for the minimal, reproducible example. > > Looks like a bug. There's no as.quantmod.OHLC.xts method, so the zoo > method is

OpCl works on xts objects but not on quantmod.OHLC objects. Is this a bug? Example error: x.Date <- as.Date("2003-02-01") + c(1, 3, 7, 9, 14) - 1 set.seed(1) x <- zoo(matrix(runif(20, 0, 1), nrow=5, ncol=4), x.Date) q <- as.quantmod.OHLC(x,c("Open","High","Low","Close")) # error OpCl(q) #> Error in `colnames<-`(`*tmp*`, value =

I find it's just great to be able to say: library(tseries) x <- get.hist.quote(instrument="ongc.ns") and it gets a full time-series of the stock price of the symbol ongc.ns from Yahoo quote. However, once my hopes have been raised by such beauty :-) I get disappointed when I do > plot(x) and the annotation is horrible! The x axis is not labelled as dates. The default

Hello, I'm trying to do two things: -1. Ensure that I understand how quantmod adjust's OHLC data -2. Determine how I ought to adjust my data. My overarching-goal is to adjust my OHLC data appropriately to minimize the difference between my backtest returns, and the returns I would get if I was trading for real (which I'll be doing shortly). Background: -1. I'm using Alpha

Here is a relatively simple script (with comments as to the logic interspersed): # Some of these libraries are probably not needed here, but leaving them in place harms nothing: library(tseries) library(xts) library(quantmod) library(fGarch) library(fTrading) library(ggplot2) # Set the working directory, where the data file is located, and read the raw data