notices - See details
Notices
RW
Rowan Williams-Short (not verified)
27th February 2016 | 12:37am

Thanks Will - this is really useful!

I started using short-cut keys in Excel in the nineties, and have never looked back. Something you might have added is the massive value in learning to write macros in Excel. I first did the equivalent in Lotus in about 1992, but Excel's VBA made that much easier later in the nineties. Having a suite of tailored functions - for example to calculate a bond's price (slightly different and more precise here in South Africa than the US formula used by Excel), a bond's convexity, an option's delta and so on is invaluable and has saved me countless hours. Another macro sucks in overnight data on hundreds of bonds and equities, updates all portfolio analysis metrics I need and prepares an attribution analysis before I can finish making a cup of tea.

I will definitely be trying KeyRocket in case there are tricks I have missed. Oh, and thanks for adding to my vocabulary too: picayune - what a fabulous word. Would "picayune politics" be an oxymoron?

Rowan