[R] setting up R -- VM Fusion, WIndows7

2015-07-30 Thread Matthew Johnson
Hi, As i need R to speak to Bloomberg (and big only runs on windows), i'm running windows 7 via VM Fusion on my mac. I think i am having permission problems, as i cannot use install.packages, and cannot change .libPaths via either a .Rprofile, or Profile.site. I've posted more detail in this

Re: [R] templated use of aggregate

2012-06-13 Thread Matthew Johnson
]). thanks and best regards matt johnson On 13 June 2012 15:06, David Winsemius dwinsem...@comcast.net wrote: On Jun 12, 2012, at 11:32 PM, Matthew Johnson wrote: Dear R-help, I have an xts data set that i have subset by date. now it contains a date-time-stamp, and two columns (price

Re: [R] templated use of aggregate

2012-06-13 Thread Matthew Johnson
if the index entries in ‘order.by’ are not unique mnz[, 1] mnz[, -1] 197.90 408 297.89 208 So is this a bug in XTS? thanks for your patience mj On 13 June 2012 15:53, David Winsemius dwinsem...@comcast.net wrote: On Jun 13, 2012, at 9:38 AM, Matthew Johnson wrote: Sorry, i'll try

Re: [R] templated use of aggregate

2012-06-13 Thread Matthew Johnson
thank you for your patience. i assure you i will get better with the appropriate etiquette - and hopefully eventually contribute. On 13 June 2012 16:18, David Winsemius dwinsem...@comcast.net wrote: On Jun 13, 2012, at 10:09 AM, Matthew Johnson wrote: my sessioninfo was as follows

[R] what does .indexDate() do - R::xts

2012-06-12 Thread Matthew Johnson
Dear R experts, I am learning the very useful XTS package, but cannot figure out the purpose of some commands. in particular, the .indexDate() command does not work as expected. say: x - timeBasedSeq('2010-01-01/2010-01-02 12:00') x - xts(1:length(x), x) then i can subset on date as follows:

Re: [R] what does .indexDate() do - R::xts

2012-06-12 Thread Matthew Johnson
thanks. i think i understand: the difference is that the first command converts my 'searched-for' date to a number and matches it, but the second does not? On 13 June 2012 12:58, Joshua Ulrich josh.m.ulr...@gmail.com wrote: On Tue, Jun 12, 2012 at 9:48 PM, Matthew Johnson mcoog...@gmail.com

[R] templated use of aggregate

2012-06-12 Thread Matthew Johnson
Dear R-help, I have an xts data set that i have subset by date. now it contains a date-time-stamp, and two columns (price and volume traded): my objective is to create tables of volume traded at a price - and i've been successfully using aggregate to do so in interactive use. say the data looks

[R] fine control of plots after use of layout(matrix ...

2012-06-03 Thread Matthew Johnson
Sir, I would like to create a combined line-bar plot, with the line up top and bar plot below, but with the x-axes suppressed on the topmost plot, the line and bar plot areas joined by a common line, and the x-axes (of dates) joined to the bottom part of the bar plot. i have been able to format

Re: [R] fine control of plots after use of layout(matrix ...

2012-06-03 Thread Matthew Johnson
, Matthew Johnson mcoog...@gmail.com wrote: Thanks. So i can call par after the layout command? I did not realise. Some par options are set by calling par() directly, while others must be included in the plot command itself. Sarah Sent from my iPad On 03/06/2012, at 9:42 PM, Sarah Goslee

Re: [R] fine control of plots after use of layout(matrix ...

2012-06-03 Thread Matthew Johnson
Thank you. Sent from my iPad On 04/06/2012, at 7:12 AM, Sarah Goslee sarah.gos...@gmail.com wrote: On Sun, Jun 3, 2012 at 5:02 PM, Matthew Johnson mcoog...@gmail.com wrote: Thanks. The solution i have been persuing is reading Murrell - and trying to figure out grid / Viewport commands

[R] mtext bug

2012-06-02 Thread Matthew Johnson
Sir, I have hit a the limits of my understanding of text / par / opar etc... I have a few related xts data frames which have multiple columns, and have written a for-loop to make a set of charts - however i do not get any margin text when i run the loop. when i test the code outside of the loop

Re: [R] mtext bug

2012-06-02 Thread Matthew Johnson
thanks very much - fixed. On 3 June 2012 08:26, Duncan Murdoch murdoch.dun...@gmail.com wrote: On 12-06-02 6:21 PM, Matthew Johnson wrote: Sir, I have hit a the limits of my understanding of text / par / opar etc... I have a few related xts data frames which have multiple columns

Re: [R] mtext bug

2012-06-02 Thread Matthew Johnson
, Matthew Johnson mcoog...@gmail.com wrote: thanks very much - fixed. On 3 June 2012 08:26, Duncan Murdoch murdoch.dun...@gmail.com wrote: On 12-06-02 6:21 PM, Matthew Johnson wrote: Sir, I have hit a the limits of my understanding of text / par / opar etc... I have a few related xts

[R] Aligning time series

2012-05-14 Thread Matthew Johnson
Sir, I have large data sets of economic indicators and would like to align them to a reference series - say the unemployment rate or industrial production. Is there a canned routine that returns the optimal lead / lag according to some (or a variety) of algorithims? not all series will be of the

Re: [R] Aligning time series

2012-05-14 Thread Matthew Johnson
ggrothendi...@gmail.com wrote: On Mon, May 14, 2012 at 5:09 AM, Matthew Johnson mcoog...@gmail.com wrote: Sir, I have large data sets of economic indicators and would like to align them to a reference series - say the unemployment rate or industrial production. Is there a canned routine

[R] Writing data including NAs to access using RODBC

2011-12-02 Thread Matthew Johnson
Hi, I have run into a problem writing data using RODBC. The dataframe i have read in from access includes some NAs. I have put the data into an xts object, manipulated the data, and would now like to append two columns of the manipulated data to the original table in access. I cannot append the