EconStatsCraft rigorous, plain-spoken econometrics
Econometrics that explains itself.
Regression, panel data, time series and the whole battery of tests. Every result is followed by a verdict you can defend.
Load a dataset to see it here.
EconStatsCraft › Forwards, futures & swaps
No-arbitrage pricing of the linear derivatives: a forward on an asset with income or storage costs, a currency forward from interest parity, a forward rate agreement and a plain-vanilla swap from a zero curve - with the arbitrage trade spelled out when a market price is off.
If you want to own an asset in a year, you can buy it now and borrow the money, or agree today to buy it in a year. Both leave you owning the asset in a year, so they must cost the same, or someone could buy the cheap one, sell the expensive one and keep the difference. That single argument prices forwards on shares, commodities and currencies, and, applied to interest rates, FRAs and swaps.
Pricing or valuing forwards, futures, FX forwards, FRAs and swaps, spotting cash-and-carry arbitrage, and the derivatives readings of CFA Levels I and II and FRM Part I.
Buy the asset for S_0, financed at r, receive income worth I and pay storage u: the cost of delivering it at T is (S_0-I)e^{(r+u-q)T}, which must equal the forward price. For currencies, investing one unit of domestic currency at home must equal converting it, investing abroad and converting back forward: F=S\frac{(1+r_d)^T}{(1+r_f)^T}. A forward rate solves (1+r_1t_1)(1+f\,(t_2-t_1))=(1+r_2t_2). A swap's fixed rate sets the fixed leg equal to a floating leg worth par: c\sum Z_k + Z_n = 1.
F_0 = (S_0 - I)\,e^{(r+u-q)T},\qquad F_{FX} = S\left(\frac{1+r_d}{1+r_f}\right)^T,\qquad \text{swap rate} = \frac{1-Z_n}{\sum_{k=1}^n Z_k}
A share at 100 with a 2% continuous dividend yield and a 5% risk-free rate. The one-year forward is 100 × e^(0.05 − 0.02) = 103.05. If the market quotes 105, the forward is too expensive: borrow 100, buy the share, sell the forward at 105, and at delivery hand over the share, repay 103.05 net of dividends and keep about 1.95. A long forward written earlier at 101 is now worth (103.05 − 101) × e^(−0.05), about 1.95. In swap mode, a five-year curve rising from 3.0% to 4.0% gives a par swap rate of 3.97%.
| If you see this | It means | Do this |
|---|---|---|
| Forward far from the market price | Income or storage not entered | Add the dividend yield or storage cost |
| FX forward looks inverted | Quote convention reversed | Spot here is domestic per unit of foreign |
| Swap rate above every zero rate | Curve entered as decimals | Enter rates in percent |
| FRA payment seems too large | Not discounted from t2 to t1 | The settlement already discounts it |
Yield curve, for the zero rates a swap needs. Bond pricing, for discounting.
Black–Scholes option pricing · Bond price, duration & convexity · Merton distance to default · EMI / home loan planner · CAPM / beta estimation · Multi-factor model · Portfolio optimization · Value at Risk & Expected Shortfall · Performance & drawdown · Time value of money & NPV/IRR · Equity valuation (DDM, FCF, residual income) · Cost of capital (WACC) · Binomial option pricing · Option strategies (payoff & profit) · Credit risk & Basel capital · Extreme value theory (tail risk)
Line chart · Area chart · Bar chart · Stacked bar · Scatter plot · Bubble chart · Histogram · Box plot · Pie chart · Heat map · Rebased to 100 · Lorenz curve and Gini
World map · Bivariate map · Flow map · India - state map · India - district map
Descriptive statistics · Summary by group · Two-way table · Classical statistical tests
Multiple regression (OLS) · Logit / Probit · Tobit (censored) · Truncated regression · Multinomial logit · Ordered logit / probit · Quantile regression · Poisson / Negative binomial
Time-varying coefficients (Kalman) · Unit root tests · Correlogram (ACF / PACF) · ARIMA / SARIMA · Rolling-origin cross-validation · Theta method · Unobserved components · STL forecasting · Forecast combination · Markov regime switching · Change frequency (resample) · ARCH / GARCH volatility · Decompose & filter · Spectral analysis · Exponential smoothing · Forecast accuracy
Yield curve (Nelson–Siegel / Svensson) · Dynamic factor model · Dynamic regression (ARIMAX) · Structural VAR · VAR · Granger causality · Cointegration · VECM · ARDL & bounds test
Panel regression · Panel cointegration tests · Heterogeneous panel: Mean Group & PMG · Gravity model of trade · Dynamic panel GMM · Panel diagnostics · Panel unit-root tests
Principal components (PCA) · Factor analysis · Cluster analysis
Conjoint analysis · MaxDiff (best–worst scaling) · TURF - reach of a product line · Price sensitivity (Van Westendorp) · Market basket analysis · Perceptual map · Scale reliability (Cronbach’s alpha) · Key driver analysis
Spatial autocorrelation · Spatial regression · Heckman selection · Instrumental variables (2SLS) · Difference-in-differences · Staggered difference-in-differences · Regression discontinuity · Matching & weighting · Oaxaca–Blinder decomposition
Black–Scholes option pricing · Bond price, duration & convexity · Merton distance to default · EMI / home loan planner · CAPM / beta estimation · Multi-factor model · Portfolio optimization · Value at Risk & Expected Shortfall · Performance & drawdown · Time value of money & NPV/IRR · Equity valuation (DDM, FCF, residual income) · Cost of capital (WACC) · Binomial option pricing · Option strategies (payoff & profit) · Forwards, futures & swaps · Credit risk & Basel capital · Extreme value theory (tail risk)
Life table · Life annuity · Life insurance pricing · Chain ladder reserving · Buhlmann credibility · Survival analysis · Mortality graduation · Aggregate loss model · Ruin probability · Multi-state Markov model · Loss severity fitting
Monte Carlo experiment · F-test, Wald & Chow · Structural breaks & stability
Regression vs machine learning · Ridge / Lasso / Elastic Net · Random forest · Gradient boosting
EconStatsCraft rigorous, plain-spoken econometrics
Regression, panel data, time series and the whole battery of tests. Every result is followed by a verdict you can defend.
Load a dataset to see it here.
Pick the example closest to your question. You get a spreadsheet with the right columns and a few rows showing the expected format - replace the numbers with your own, then paste or upload it back.
Copy the header row from the table above (or from the downloaded template), put your own rows underneath, and paste the whole thing here. It is checked against the layout before anything is imported.
Or click a row in the preview below.
For a units or notes row.
Search every source at once. World Bank indicators need countries and years; everything else loads in one click.
Loading the catalogue…
The engine stays loaded, so this is quick - and it leaves your open tab and panel layout alone.
⌘/Ctrl+Enter runs the current analysis. ⌘/Ctrl+P exports the session as a PDF. Esc closes this.
In the Notebook: Enter starts a new block and
Shift+Enter a new line inside one; Backspace at the start
joins back into the paragraph above; / on an empty line inserts anything.
⌘/Ctrl+B, I, E, H and
M apply bold, italic, code, highlight and maths.
#, ##, -, 1., > and
``` at the start of a line convert it.
Sign in to run unlimited analyses.
Scroll to pan · Esc to close