Your (Quant) Friends in Finance
Generate an efficient frontier of random portfolios with custom constraints in R. Accelerate your project with the power of cloud computing using Techila Technologies’ solution in combination with R’s plyr …
If you’ve already seen our basic VaR tutorial for excel, this tutorial will blow you away. We can do everything in under 10 lines of code and in less than …
We’ll show you the difference between VAR and CVAR using some sweet graphics, and we’ll also show you how to quickly calculate both VAR and CVAR in Excel.
What is Beta? Why use Beta? Learn how and why to calculate historical beta for any security in Excel and the common mistakes that people make when calculating beta. No …
Fetching Data Shouldn’t Be So Difficult. Have you ever wanted to build an excel table that refreshes itself based on the most recent data available? Well, you can! And it …
Got too much data? Reduce row count. Learn how to easily reduce your row count in Excel using modular arithmetic and the handy-dandy filter function. Turn daily timeseries data into …