I’m rebuilding our metals and resins risk playbook and need coursework that teaches procurement-focused VaR, hedge trigger design, and stress-testing should-costs. Has anyone completed CME hedging classes or FRM/ERM modules that run 6–8 weeks with live casework and tools (Excel/Python) to model LME aluminum and diesel exposure?
, the procurement angle on VaR always gets shortchanged. > anyone completed CME hedging classes or FRM/ERM modules that run 6–8 weeks — CME’s metals/energy hedging classes are solid but usually shorter; what worked for us was pairing them with a 6‑week sprint to build an Excel/Python historical‑sim VaR for LME aluminum 3M and NY Harbor ULSD, set budget‑based hedge triggers, and stress should‑costs using 2008/2020 windows (tools here: https://www.cmegroup.com/education/). If you need a true cohort, FRM is heavy for this use; a live coach overlay while you run the casework can fill the gap.
Quick example: the best lift we got was to ‘tie VaR to coverage days’ — compute a 10‑day 95% VaR on LME 3M + Midwest premium + FX (and ULSD for diesel), and trigger when VaR/ton exceeds contribution margin/ton. Do you want a vendor‑agnostic cohort or are you fine with an exchange‑led program? CME Institute has practical metals/energy modules and the tooling plays well with Excel/Python: https://www.cmegroup.com/education/.
And best fit I’ve found for a 6–8 week cohort with live casework is Risk.net’s Risk Learning certificate on commodity hedging (Risk Learning – Training and Development for Risk Professionals), which covers VaR, trigger design, and hands-on models in Excel with optional Python. Caveat: the tooling is basic, so for “stress-testing should-costs” build scenarios that include invoice-lag basis and regional premia for aluminum and diesel, not just the flat curve. If you need deeper LME specifics, pair it with the LME’s two-day hedging course for aluminum contracts.
If you want a 6–8 week cohort with live casework, the closest match I’ve used is ICE Education’s metals/energy stream — weekly labs and templates you can take back to the desk: Education | ICE. For “hedge trigger design,” add a basis module that splits LME cash vs Midwest premium and diesel rack vs HO futures, then fire triggers when basis drift eats, say, 30–40% of your should-cost buffer — beats relying on flat price moves alone. FRM helped me conceptually but , it’s heavy on bank capital theory; do you need a credential, or just a hands-on sprint to rebuild the playbook?