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 …