[R] RExcel issues

Michael Ashton m.ashton at enduringinvestments.com
Thu Mar 1 23:45:37 CET 2018


Thanks though - didn’t know there was that ecosystem. I will try that list. 

> On Mar 1, 2018, at 5:37 PM, David Winsemius <dwinsemius at comcast.net> wrote:
> 
> 
>> On Mar 1, 2018, at 2:02 PM, Michael Ashton <m.ashton at enduringinvestments.com> wrote:
>> 
>> Hi -
>> 
>> For a while I've used RExcel without problems to run a repeating portfolio optimization problem where I solve for a portfolio allocation targeting a particular risk, then solve for a different risk, etc. I call the commands with (e.g.) rinterface.Rrun "(R command)"
>> 
>> Recently that macro started blowing up, returning #RErrors, and when I try to trace the error I find that it is some kind of OLE error. I can't seem to find anything about it online and it's hard to replicate for someone else since you'd have to have my installation and my spreadsheet.
>> 
>> But I thought I'd ask the community and see if anyone else has had this problem recently with Rexcel. I'm calling solnp from within the RRun command, but again...it worked for a long time and I don't think it's the inputs that are wonky. Perhaps an update of R was incompatible with Rexcel? I've updated Rexcel to 3.2.16 but it made no difference.
> 
> I'm pretty sure that RExcel is a commercial program and I assume that licensed users are expected to bring problems to the vendor.
> 
> http://rcom.univie.ac.at/contact.html
> 
> 
>> 
>> Any suggestions of what to try will be warmly entertained!
>> 
>> Thanks,
>> 
>> Mike
>> 
>> Michael Ashton, CFA
>> Managing Principal
>> 
>> Enduring Investments LLC
>> W: 973.457.4602
>> C: 551.655.8006
> 
> I assume with that address you have a commercial license.
> 
> -- 
> 
> David Winsemius
> Alameda, CA, USA
> 
> 'Any technology distinguishable from magic is insufficiently advanced.'   -Gehm's Corollary to Clarke's Third Law
> 
> 
> 
> 



More information about the R-help mailing list