Visinomics

Visinomics

Observations, Calculations, and Values

Visinomics RSS Feed
 
 
 
 

Archive for Macros

How To Run Dozens of Sensitivities In Under A Minute

Excel has a function called Data Tables can be very useful, since it allows you to insert live sensitivities into your model. Live sensitivities can be very useful, but can easily slow down a larger model. It’s not hard to copy and paste/special/values on a data table to speed things back up again, [...]

Portfolio Management, Excel Style

Some people are content to use Quicken to manage their portfolios. I prefer keeping track of every little detail and see every calculation. So, I do it all the old fashioned way… in a spreadsheet. But getting an accurate read can be time consuming if you have to manually enter in stock [...]