Real-Time Options Pricing Model with Black-Scholes in Sheets

Create a Google Sheets plugin using Google Apps Script and JavaScript that implements the Black-Scholes options pricing model with live market data integration. The script should dynamically calculate option theoretical values, implied volatility, and Greeks (delta, gamma, theta) with real-time stock price updates. Include error handling for market data API failures and a modular design that allows traders to quickly adjust input parameters like strike price, expiration, and risk-free rate.