R to Excel

[Joy Pathak]

Hey guys

Maybe a trivial question but...

Anyone know a way I can call functions from specific packages into excel?

I am trying to see if I can call functions from this package: GitHub - imanuelcostigan/dataonderivatives: Easily source publicly available data on derivatives

in excel/vba. Is that doable?

 

[Sanket Patel]

I haven't touched touched R in what seems like years but a quick google search yielded A million ways to connect R and Excel which seems to be fairly promising

 

[Joy Pathak]

yeah. haha i obviously exhausted all of google first before posting here.

 

[Sanket Patel]

I've used RExcel in the past and it worked well enough statconn and

 

[yetanotherquant]

My use case: I had a legacy tool written in Excel/VBA and needed to extend it quickly with advanced time series functionality.
I called Rscript.exe from VBA code.
If you have to transfer a significant number of parameters, you might need to right and read them to/from files (both in Excel and R sides).

The solution was far from being robust. It may do for ad-hoc or manual process but if you want a fully automated software, it is not a proper way.

 

[pingu]

RExcel all the way