Calculating VAR and CVAR
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.
Calculating Beta 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 …
Automatically Downloading Data From The Web in Excel
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 …
Reducing Rows and File Size
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 …