Limited Time Offer - Get Up To 30% OFF
Step-by-Step Guide to FX Forwards, Carry and Options
This is how analysts on the desks are trained
Join the Market Wizardry ranks at:
Get Ahead of Your Competition Today
The spreadsheet guide really helped me understand the theories I had memorized in Business School. I always learnt better by looking through EXCEL formulas and pressing F2 on different cells. What a lifesaver!
**** Wang
Verified Buyer
I was thoroughly impressed with the step-by-step approach this course provided through Excel, vastly improving my understanding of bootstrapping. It was a breath of fresh air versus my dry coursework that I will always appreciate. Thank you MarketWizardry!
**** Sullivan
Verified Buyer
Just ended by internship at a BB, and looking back, I am very grateful for the nuggets of insights this guide has provided me. From knowing what careless mistakes to avoid, to having this in my pocket to impress my team, I am confident of getting a return offer
**** Gupta
Verified Buyer
EXCEL Guide to FX Forwards, Carry and Options
WHY IT'S INVALUABLE:
Demystify John Hull and understand the concepts through EXCEL formulas
Bootstrap a real yield curve and build upon it
Learn how a zero coupon curve is used to calculate FX Forwards
FX Forwards then become the building blocks of calculations around carry and options
Contains invaluable teaching notes that tell you what mistakes to avoid and tips to impress
Get ahead of other candidates vying for a permanent role on the trading floor
EXCEL Driven
Demystify Textbooks
Unlock Your Mind
Start NOW
Aim to Impress
Bootstrapping. Bootstrapping of both a USD and EUR curve as basis for module. Step-by-step is covered in Bootstrapping module.
FX Forwards. Fundamentals and formulas to calculate FX Forwards from Zero Coupon Rates - textbook formulas translated into EXCEL magic.
Spot Adjustments. Definitely not taught in school, but absolutely essential for life on a trading desk. How do you calculate forward points for tenors pre-Spot? i.e. T+1?
Forwards Trading. Understand how traders quote and execute FX Forwards.
Carry. Calculate carry from the Forward curve and pick up an easy back of envelope formula for intuitive calculations on the go.
Options. Black-Scholes model pricer, built off FX Forward Curve and Carry spreadsheets - understand how it all ties together.
Data. Market based data for a realistic simulation
Pricing
Start your Preparation Today - No Time to Waste
Frequently Asked Questions
Whether you have inquiries about financial modeling or our EXCEL Guides, our team at Market Wizardry is here to assist you with timely and precise responses. Email the MD at wiz @marketwizardry.com anytime.
Here are some helpful FAQs:
How is this different from my textbook or coursework?
Same concepts, different way of looking at them. You may well understand fully what John Hull is saying, others like me prefer to do learn it through spreadsheets.
Here at MW, we are focused on teaching through EXCEL, and introducing formulas and scenarios which you will encounter as an analyst on a trading floor.
What is included in the EXCEL Guide?
The EXCEL guide contains four main components
1. Quick Bootstrapping Model
2. All the formulas to calculate FX Forwards, Options and Carry which you can explore deeper by pressing F2 on the call. Don't worry, we have not locked the important cells.
3. Explanation of how the formula works alongside teaching notes
4. Common pitfalls to avoid and ways to impress
What formats are available for materials?
Only available in EXCEL - all notes are contained within
Will I receive personalized feedback from instructors?
We might offer 1 on 1 coaching in the future, but at this present moment, our EXCEL guides are pretty self-explanatory.
Is there a risk-free trial available?
We offer money-back guarantee up to 30 days if you did not think it helped at all!
What Our Customers Are Saying
What Our Students Are Saying
The Best Investment I've Ever Made!
"I have aspired to sharpen my financial modelling skills through Market Wizardry for years, and I finally bought this EXCEL Guide! I was very pleasantly surprised when I opened the guide that it was intuitive. It was the best investment I ever made. 10/10 would recommend!"
**** Finch
Relieved
"I always struggled in lectures when concepts are taught through mathematical formulas and notation. However, I know that I am an intuitive learner and I understand these concepts at a high level. Was extremely relieved that Market Wizardry offers EXCEL guides for me to learn it my preferred way. Thank you!"
Alice *****
A Step Ahead
"Very grateful to the guide that I was a step ahead of other summer interns. Basic knowledge of formatting and spreadsheet structure goes a long way to impress my bosses. I even improved some of their spreadsheets in 10 weeks!"
**** Ollie
Step-by-Step Guide to
FX Forwards, Carry and Options
This is how analysts on the desks are trained