similar to: Question with RExcel

Hi I want to implement Egarch (1,1) with t distribution model using RExcel and VBA. May I know the syntax. Following is the code that I 'm using. rinterface.RRun "spec=ugarchspec(variance.model=list(model=(eGARCH),garchOrder=c(1,1)), mean.model=list(armaOrder=c(1,1), arfima=FALSE), distribution.model=(std))" rinterface.RRun "fit = ugarchfit(Data = b, spec = spec)"

Full_Name: Isto Aho Version: 2.0.0 OS: Windows XP Submission from: (NULL) (80.186.9.143) Hi, The bug can be reproduced as follows. Install R 2.0.0 and RExcel. Take an excel sheet having 65000 rows and 11 columns, integer values. Give the 'context' command 'put R val' for the large enough selection of rows. (I didn't check, how many are needed, but it seems that 10000 rows

Hello All I've just started to use RExcel instead of CMD Batches. But I don't get the console output to an data.frame and push to Excel. With the CMD batch you got the console out relatively easy with C:\LocalData\R\bin\R CMD BATCH --slave %rscript% %logfile% to a file. But how can I get it to Excel with RExcel an VBA? Thanks, Dario [[alternative HTML version deleted]]

Hello, I must tell you once again to address your questions to r-help at r-project.org And since there was no subject line, I've made up one. Your question seems to be a question about excel, and I really can't help you. Maybe someone else can. But if you write.table(etszP) can't you read that file into excel? Rui Barradas Em 22-08-2013 15:57, siddhartha.geddam at eclerx.com

Dear R-help, Call RInterface.StartRServer ' Works fine Call RInterface.RRun("objects()") ' Works fine Call Rinterface.RRun( other R commands which do not generate errors, the demos etc ) ' Works fine But ... Call RInterface.RRun("doesnotexist") ' Sends Excel into endless loop it appears After about 90 seconds a dialog box appears "Microsoft

Hi, I am running a test to call an R script with in excel using VBA. My VBA code is shown bellow. The middle section of this mail also includes the content of my Rscript. The bottom part shows the error message form the R console. It seems that Excel is opening the R console without any problems. The problem I am seeing is that Rinterface.RRun instruction is interpreting the "\T"

I have an R file R_test.R saved in C:\R_test folder. The R_test.R looks like this: setwd("C:/R_test") rnorm(100) write(rnorm(100),"data.txt") q(save="no", runLast = F) Next I would like use an Excel VBA/macro Shell() function to call R and execute R_test.R file. The syntax is *Shell(pathname*[*,windowstyle*]*)* I wrote an Excel macro RunRcode like this: Sub

Hi List, Is there any way to pass on directly VBA variable content into a R variable? on windows XP & using R 2.12.0 I have installed RExcel addin (with associated D(COM)) >> It function fine when trying to pass Excel Range to R but I failed (sorry if it is only my own limitation, search till now unsuccessful) to find out how to pass directly VBA array into R Below an example -

Hi, I often work with R by writing long(ish) Excel-VBA macros interspersed with calls to R via RExcel. A typical example of this would be: Sub VBAMacro() 'fetch some data from an excel sheet 'do some basic stuff on said data 'transfer data from vba to R 'run some R statements 'get data back to vba 'show results on the excel sheet 'clean R by deleting all vars

I'm using R-Excel's macro mode to make an R based Excel tool for inventory management. It's quite a lot of R-code which I made in R at first and now I am trying to transform it into excel. The R code is a simulation of a random path x times, put into matrices and then doing some transformations on it. I pasted the R code on a seperate sheet in my Excel file, which by means of VBA I

Buenos días: ¿Hay alguna forma de conectar VBA de Excel con R, de forma que desde Excel se puedan cursar instrucciones de R?, ¿ y V.Basic con R? Gracias anticipadas. Saludos [[alternative HTML version deleted]]

Hi, I was trying to run your code in my VBA editor, however could not succeed. The execution stumbled in the line "Call Rinterface.StartRServer" itself. I have RCOM package installed into my R environment. Do I need to install anything else to run that? Would guys here guide me? Thanks -- View this message in context: http://n4.nabble.com/R-Excel-Macro-Problem-tp858831p1592196.html

Muchas gracias, Sergio. Saludos cordiales. Eduardo Freyre -----Mensaje original----- De: miguel.angel.rodriguez.muinos en sergas.es [mailto:miguel.angel.rodriguez.muinos en sergas.es] Enviado el: viernes, 12 de julio de 2013 12:39 Para: efreyre en movistar.es; r-help-es en r-project.org Asunto: RE: [R-es] Conexion excel vba con R y VBasic con R Hola Eduardo. Lo que buscas lo puedes

Issue: Usage of ETS R codes through RExcel macros in VBA Given below is my command code: Rinterface.runrcodefromrange Range(?Sheet1!B2:D8?) Following are the codes written in the given cell reference: #!rput zz 'Sheet1'!$B$2:$B$22 library(forecast) zz <- ts(zz,freq=365,start=c(2009,1)) etsz <- ets(zz,model='AAN') etszP <- forecast(etsz,h=34) write.table(etszP) How

Even using the VBA back of Excel to create interfaces with R would make a lot of sense. Suppose I could have access to VBA macros that import and export data into R , it would be great. The R GUI series like Rattle come even closer to Excel...so a VBA _R_ExCel package might be useful to ordinary folks . Besides Excel costs money, so adding R functions to Open Office would help both of them ( if

Dear all, I’m having an awkward problem in R. When I write the command Fisher.test(school.data,workspace=2e+07), where school.data is the matrix corresponding to the data set, I get the error message: FEXACT error 7. LDSTP is too small for this problem. Try increasing the size of the workspace. Increasing the workspace: Fisher.test(school.data,workspace=1e+10), I

Is there an "easy" or good way to run/launch an Excel VBA macro from within R? --------------------------------- Pinpoint customers who are looking for what you sell. [[alternative HTML version deleted]]

I wrote a R script say called computeCovarMatrix.R and i want to call and run this piece from Excel visual basic. does anyone know how to do that? thanks, KZ [[alternative HTML version deleted]]

Hi all: Thanks in advance for your assistance. I just started learning R. I'm trying to use the Help and the downloadable manuals. I am stuck on trying to multiply matrices. Can anyone please supply a couple of lines of code that I can plug into a fresh console to see how a double precision (1x3) matrix is multiplied by a double precision (3x3) matrix? I keep getting an error

dear listers, right now, we are trying to use r to implement sas dde function, e.g. interact with excel. however, we can't find a way to call vba from r？ any insight is appreciated. [[alternative HTML version deleted]]