Workbook Shop Cart 0

All books › Tabellab

Cover of Excel for Investing & Economics 4
Tabellab

Excel for Investing & Economics 4

The Big, Comprehensive Workbook: 220+ Lessons on Pairs Trading, Risk Budgets, Structured Products and Alternatives – Hands-On Labs with Full Solutions

  • 637pages
  • 220lessons
  • 11courses
  • 220exam questions
$14.99PDF · instant download
Free sample (36 pages)
  • Secure checkout with Stripe (cards, Apple Pay, Google Pay)
  • Download link by email — valid 12 months
  • Full solutions appendix included

What's inside

Excel for Investing & Economics 4: 11 courses, 220 hands-on lessons, with a full solutions appendix.

Learn by doing. Every lesson starts with a clear goal and a short explanation, shows the worksheet cell by cell, and gives you tasks to solve on your own computer in Excel, LibreOffice Calc or Google Sheets. When you are done, check your formulas against the solutions and hints in the appendix and correct your sheet.

  • 11 complete courses, 220 lessons, 220 exam questions with answers
  • Worksheets with row and column labels – easy to type in
  • Tasks with exact solutions and hints in the appendix
  • All figures are fictional practice data

Every course is also available as an interactive course on tabellab.com, where each cell is checked instantly.

Courses in this book

  • Pairs Trading by the Numbers: Spreads, Hedge Ratios, Mean-Reversion Tests, Z-Score Signals, Half-Lives, Backtests & Trading Costs
  • Volatility & Risk Budgets by Hand: Rolling and Exponentially Weighted Volatility, a GARCH(1,1) Recursion, Volatility Targeting, Inverse-Volatility Weights & Risk Parity
  • Structured Products by the Numbers: Zero-Coupon Floors, Capital-Protected Notes, Participation & Caps, Discount Certificates, Reverse Convertibles, Barriers, Worst-Of and Autocall Schedules
  • Alternative Investments by the Numbers: Long/Short Exposure & Leverage, Return Sources, Fund-of-Funds Fees, Liquidity Terms, Unsmoothed Returns, Commitment Pacing & Real Assets
  • International Trade by the Numbers: Comparative Advantage, Terms of Trade, Tariffs & Quotas
  • Macroeconomic Models in a Spreadsheet: Multipliers, AD–AS, IS–LM & the Output Gap
  • Money, Banks & Central Banks: Deposit Creation, the Quantity Equation & Policy-Rate Rules
  • Labour Markets & Inequality: Unemployment, Wage Floors, Lorenz Curves & the Gini Coefficient
  • Economic Growth & Development: Growth Accounting, the Solow Model, Convergence & PPP
  • Behavioural Economics in a Spreadsheet: Present Bias, Loss Aversion, Prospect Theory & Nudge Experiments
  • Economic Impact Assessment: Visitor Spending, Leakage, Multipliers, Jobs per Spend, Additionality & Net Local Impact

Details

FormatPDF, US Letter (8.5 × 11 in)
LanguageEnglish
Pages637
SeriesThe Tabellab Workbook, volume 4
AuthorBabala Özdemir
DeliveryInstant download after payment