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

Sailing through the IEF ex-dividend

IEF, Barclays 7-10 year Treasury note ETF, went ex-dividend April 1st with a declared dividend of $0.248 per share.  Somewhat surprisingly my IEF + DTYS hedge didn’t dip at all, closing at 146.11, the same close as the 31st.  I don’t see any reason why DTYS should go up on IEF’s ex-dividend date—and it is probably just a random thing. I’m not complaining.  During the …

Read more

IEF + DTYS: A low risk hedge with dividends?

I continue to evaluate (and invest in) a hedge position created by going long both IEF, Barclays 7  to 10 year treasury ETF and DTYS, Barclays’ iPath® US Treasury 10-year Bear ETN. The net position, holding equal shares of both securities should yield around 1.7% annually, and since I’m willing to bet that interest rates won’t be going down anytime soon I’m boosting the overall …

Read more

Mimicking the VIX index

The Holy Grail of volatility investing would be an ETN or ETF that matched the movements of VIX—CBOE’s volatility index on the S&P 500.   As a hedging vehicle it would be nearly ideal—negatively correlated to fast moves of the S&P 500 with a stable floor during quiet times.  So far no one has figured how to economically offer a fund that does this.  Instead …

Read more