I really don't see why "speed" should be equal to d1. Isn't the expression for speed this:

I might add that this is all in Wikipedia. Moreover, I don't really see why you'd need VBA to do all these, as they're relatively simple spreadsheet formulae.

More...

Yes, d1 is itself a variable included in the formula for speed (among other Greeks), but I was wondering if the VB code on the noted site might be solving for speed and calling it d1 as a misnomer. I suppose it was more of an Excel question and I should probably have confined it to an Excel forum. I wasn't sure if those guys on excelforum.com (awesome though they are) would know much about option Greeks, though. As for why use VB, I simply don't know the spreadsheet formulas for calculating speed or the other Greeks. Can you direct me to them, kindly? Alternatively, is there any place on the net or otherwise where we can get quotes for speed on a given contract? No broker seems to offer that in their analytics, and even resources like Optionvue or Optionetcis Platinum don't have it.

For the Excel versions of all things Black-Scholes, I normally go with Collector's stuff (I mean Espen Haug). He's generally the authority on option pricing and his website has a lot of good stuff. See here:http://www.espenhaug.com/black_scholes.html
Scroll down for the formulae, both in Excel directly and in VBA.

For the Excel versions of all things Black-Scholes, I normally go with Collector's stuff (I mean Espen Haug). He's generally the authority on option pricing and his website has a lot of good stuff. See here:http://www.espenhaug.com/black_scholes.html
Scroll down for the formulae, both in Excel directly and in VBA.