top of page

​Welcome to the website of William Stetson

​

Projects

///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

SQL Implied Volatility Function

This is a scalar function which returns the Implied Volatility of an option. Also included is a Black-Scholes scalar function.

SQL Yield To Maturity Function

This is a scalar function which returns the Yield to Maturity.

///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

Excel SQL Importer

This is an Excel VBA spreadsheet with an editable data link to an SQL database to allow the user to directly manipulate SQL data in excel. It allows basic SELECT commands as well as a manual mode for more advanced selection.

///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

​NPV Helper

This is a basic spreadsheet for NPV analysis

  • s-facebook
  • Twitter Metallic
bottom of page