Modelling UVXY trading strategies with Excel

UVXY is an ETF that targets 1.5x the daily returns of a 30-day constant-maturity position in VX futures – the SPVIXSTR index. Before 2018, it targeted 2x returns – but Volmageddon ruined the fun. UVXY has to trade every day: Anyone can trade UVXY in the market, and it trades close to the index because …

Read more

Valuation Timing with Excel

Data analysis plays a central role in making sense of financial markets. But how can you verify the conclusions others draw, or better yet, uncover your own insights? Microsoft Excel remains one of the most powerful and accessible tools for financial data analysis, allowing anyone—from beginners to seasoned analysts—to explore data, test hypotheses, and make …

Read more