Date Ranges on Simulation Spreadsheets

This table gives the date ranges covered by the spreadsheets that I have for sale. For a complete list of products see this page. For active securities, I am very willing to update spreadsheets up to the end of the most recently completed calendar quarter upon request at [email protected] Description Start Date End Date Notes VIX Futures Extended Data (VX OHLC +more), no indexes 26-Mar-2004 …

Read more

Review of Fidelity’s Active Trader Pro

My observations on Fidelity’s  Active Trader Pro® (10.7) The comments below related to the downloaded version of Active Trader Pro. Highlighted Functionality Active Trader Pro’s ability to export charts (including intraday data) for both regular securities and options is very helpful for doing analysis Quotes/Tracking for various volatility indexes (e.g., .VIX9D, .VIX3M, .VVIX, .VIF, etc.) has been added Greeks on VIX options are much better. …

Read more

Option spreads, early exercise and other wrinkles

A week ago Monday I created an IEF (iShares Lehman 7-10 Yr Treas Bond) bear spread in my Schwab margin account—with the short calls deep in the money at S90.   Several of the calls were assigned that night when IEF went ex-dividend ($0.248/share).  Since I wasn’t long IEF, this assignment resulted in a short position being created in my account.   I was surprised the calls were assigned since …

Read more

Short VXX – short XIV backtest

This spreadsheet allows you to enter in any trading date between 30-Jan-2009 and 11-Nov-2011 to backtest the profit/loss performance of a short VIX / short XIV strategy.  See this post for more information and example charts.  See ordering information at the very bottom of this post.

Volatility Tickers

My count of volatility US-based ETPs trading on national exchanges is at 8 as of August 9th, 2024. New Additions: Ticker/Quotes & Leverage Description / Time frame Daily activity? / underlying index ETF / ETNCompany website / Prospectus Comments / Posts ^VIX (Yahoo)$VIX (Schwab)VIX (Fidelity)VIX:IND (Bloomberg).VIX (Reuters)INDEXCBOE:VIX (Google FInance) Cboe Volatility Index®Model-free est. of SPX 30 day volatility VIXDerived from SPX option prices CBOE / …

Read more