- Excel Automated Trading Execution Spreadsheet for Interactive Brokers (IB) Trader Workstation (TWS)
~~$1,200.00~~$555.00This solution provides a start for automated trading execution on Interactive Brokers (IB) Trader Workstation (TWS). Market Orders, Market-on-Touch Order, Limits Orders, Trailing Limit Orders The download comes complete with:- Installation package:
- TWS API Installer [TWS API Install 971.06.msi]
- TWS Installer [tws-latest-windows-x86.exe]
- Step-by-step Installation Instructions [_installation_instructions.pdf]

- Excel Spreadsheet [TwsDde_971.06_20160906_2222_QB001.xls]

- Installation package:
- Loan Mortgage Monthly Payment Calculator
~~$5.00~~$1.00This Excel spreadsheet calculates the monthly payment for a standard loan or mortgage. It uses the =PMT() function in excel. Requirements:- Microsoft Excel 2013
- and earlier versions that support =PMT() function.

- Option Chain Downloader for finance.yahoo.com
~~$100.00~~$88.00This Excel spreadsheet loads option chain data for any ticker available on finance.yahoo.com. URL to demonstration video: https://youtu.be/QIBzGg7_SnI Here are some features:- Option Chain for any* ticker on finance.yahoo.com
- Option Chain for all available expiration dates
- Option Chain for puts and calls

- Option Pricing & Risk (Greeks) for Digital(Binary) Options on NADEX
~~$555.00~~$500.00This Excel spreadsheet contains Visual Basic (VBA) functions that calculate digital(binary) option price and risk (Greeks), namely: Delta, Gamma, Vega, Theta - Option Pricing & Risk (Greeks) for finance.yahoo.com
~~$1,000.00~~$555.00This Excel spreadsheet loads option chain data for any ticker available on finance.yahoo.com. Here are some features:- Option Mid Prices from Ask, Bid Prices on finance.yahoo.com
- Option Mid Implied Volatility
- Option Price (using Mid Implied Volatility, or user-defined volatility)
- Option Greeks (Delta, Gamma, Vega, Theta)
- Option Portfolio Position Market Value and Greeks

- The option portfolio supports up to 4 legs (ie. spread, butterfly, iron condor, etc)
- Graph of profit-and-loss (P&L) vs strike price
- Graph of Implied Volatility (IV) Term Structure or Skew

- Option Pricing & Risk (Greeks) Graphs Generation Tool
~~$1,000.00~~$555.00This Excel spreadsheet contains Visual Basic (VBA) functions that calculate option price and risk (Greeks), namely: Delta, Gamma, Speed, Vega, Volga, Vanna, Theta, Rho(=ppmu+ppr), ppmu (Sensitivity to Drift), ppr (Sensitivity to Risk-Free-Rate) - Option Strategy (2 Legs) P&L Attribution Back-Test
~~$199.00~~$88.00This Excel spreadsheet graphs historical price, implied-volatility, and IV-Rank. It also performs a back-test for the Profit & Loss (PnL) of any (Underlying+2-legged option) strategy:- Vanilla Call, Vanilla Put
- Calendar Call/Put Spread
- Call spread
- Put spread
- Straddle
- Strangle
- Covered-Call (-Underlying, +Call)
- and so on...

- Delta PnL
- Gamma PnL
- Vega PnL
- Theta PnL

- Microsoft Excel 2013
- Bloomberg API (for live data refresh)

- Option Strategy (4 Legs) P&L Attribution Back-Test
~~$299.00~~$99.00This Excel spreadsheet graphs historical price, implied-volatility, and IV-Rank. It also performs a back-test for the Profit & Loss (PnL) of any (Underlying+2-legged option) strategy:- Vanilla Call, Vanilla Put
- Calendar Call/Put Spread
- Call spread
- Put spread
- Straddle
- Strangle
- Covered-Call (-Underlying, +Call)
- and so on...

- Delta PnL
- Gamma PnL
- Vega PnL
- Theta PnL

- Microsoft Excel 2013
- Bloomberg API (for live data refresh)

- Portfolio Construction Tool: Beta Neutral Relative Value
~~$200.00~~$99.00This Excel spreadsheet calculates the returns statistics of a set of user-defined tickers: mean, standard deviation, correlation, and beta (correlated standard deviation). It includes an example of setting up a beta-neutral relative-value portfolio of 2 securities.