Installation of Python and R

 

Spearian's Python integration enables an easy scripting access to all Spearian's Functionality.

 

While the Spearian's Python interface supports any Python distribution, Python's Anaconda's distribution is preferred as it encompasses all major Python modules used for financial analytics.


Instructions:

Download and Install the official Anaconda Python Distribution from http://continuum.io/downloads

 

Installation of R

 

R integration does substantially enhance the analytical power of Spearian for Excel, though the add-on does provide non-R functionality without R being installed.

 

Instructions:

1.Download and install the official R distribution from http://cran.r-project.org/bin/windows/base/. Versions R-3.0.1 and higher for Windows (32/64 bit) have been tested and work well with Spearian.
 

2.The libraries used by Spearian are located in the R's sub-directory x64 (e.g. e:\R\R-3.0.1\bin\x64) if you're running the 64 bit version of Excel, or in the R's sub-directory i386 (e.g. e:\R\R-3.0.1\bin\i386) for 32 bit version of Excel.

The application retrieves the path to the currently installed version of R from the Registry entry InstallPath of
a) HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\R-core\R for 64 bit Excel and R
b) HKEY_LOCAL_MACHINE\SOFTWARE\R-core\R for 32 bit Excel and R

If for any reason this doesn't work (the provided tool JiriPik.SpearianForExcel.RFinder.exe displays these values),


it's possible to overwrite this by EITHER specifying the path to the R's libraries directory in via the Ribbon's Options:




OR adding of the path to the R's Libraries to the System's Path Environmental Variable (via Control Panel / System / Advanced System Settings / Environment Variables)

     and then  

 

3.To check all is well, go to the About Box at the ribbon. If all is well, the flag in "R is installed " should be True.

 

 

Copyright © 2013-2017 Jiri Pik

Document Version: Sunday, May 7, 2017