SPC’s BERT Library of Functions for Investors
SPC uses BERT to integrate R and MS Excel. The Basic Excel R Toolkit, or BERT, is the R console for Excel. BERT lets you add new functions to Excel using R, or control Excel directly from R, in real time. BERT makes it possible to do complex statistics and analytics in Excel, adding all the power of R to your spreadsheets
BERT is free (licensed under the GPL v2) and it has been developed by Structured Data LLC. On technical basis, BERT is designed to support running R functions from Excel spreadsheet cells. In Excel terms, it’s for writing User-Defined Functions (UDFs) in R.
We have created a library of functions using BERT for hedge fund investors. The download of below mentioned library of functions is available on our website under DOWNLOADS menu. The DOWNLOADS section also has few tools such as “Quantitative Fund Over View”, “Portfolio Simulator”, “Risk budgeting” that hedge fund investors can use to make decisions related to investments.
Risk Management Functions
Performance Measurement Functions
Visit the DOWNLOADS section of our website www.spconsultingllp.com to get the BERT Ad-in installer along with reference fund data file.