logo
SPC provides consulting excellence in analytics, data management and reporting services to small and medium enterprises.
Feel Free To contact Us

+91 20 6524 2455

info@spconsultingllp.com

Mont Vert Marc, Pune, India

+91 20 6524 2455

Mont Vert Marc, Pune, India

Top

SPC’s BERT Library of Functions for Investors

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.

No Comments

Post a Comment