• 
• 
• 
• 
• 
• 
• 
• 

Send to a friend

• linkedin
• twitter
• facebook
• code

Originally published: 13/06/2018 06:34
Publication number: ELQ-21664-1
View all versions & Certificate

FIFA World Cup 18 - Monte Carlo Simulation Model

FIFA World Cup 18 Monte Carlo Simulation Model

by Rafael Le Saux, CFA, AFM
10+ years of Investment Valuation and Modelling International Experience - CFA CharterholderFollow 10

20 reviews1,205 views|2 comments|Bookmark download for free

excel modelmonte carlofootballrandomfifa world cuprussia 2018

Description
FIFA World Cup 18 Monte Carlo Simulation Model, based on sport betting odds and providing estimated odds of winning for every national squad.

Model includes the combination of RAND function and data tables to create a repetitive stochastic process.

Same combination can be used for other simulation, providing an interesting alternative to more complex programming tools, such as VBA or MATLAB.

This Best Practice includes
1 Excel Model

Rafael Le Saux, CFA, AFM offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Further information

Reviews

• • 
    4.8 / 5 (20 votes)

    • 80%
    • 20%
    • -
    • -
    • -
  • Rate this Downloadable Best Practice
    

    Write a review

• Vasile Popovici the Excel guru(last updated: 20/05/2021 03:58)
  
• Dominik Zajac(last updated: 29/04/2021 19:40)
  
• Julio Ariel Dueñas Santana(last updated: 19/04/2021 21:25)
  
• Selling England By The Pound(last updated: 23/03/2021 03:32)
  
• Jarrod Barraza, CFA(last updated: 10/02/2021 13:56)
  
• Marcos Romo(last updated: 01/07/2020 19:49)
  
• Ahmad Tablieh(last updated: 04/04/2020 10:42)
  
• Charles.HA. Chen(last updated: 23/08/2019 01:16)
  
• Choi Tony(last updated: 13/06/2019 01:17)
  
• Syed Nayab Haider(last updated: 24/11/2018 17:46)
  
• Kingsley Valentine Uzogor(last updated: 08/11/2018 02:34)
  
• Loic Velechy(last updated: 12/10/2018 17:33)
  
• Liam Teske(last updated: 01/10/2018 21:40)
  
• Reto Wernli(last updated: 25/09/2018 15:24)
  
• Jerry Li.Jerry(last updated: 31/07/2018 03:00)
  
• Giovanni Quaranta(last updated: 26/07/2018 09:40)
  
• Federico Luttini(last updated: 17/06/2018 14:54)
  
• Shaun Barker(last updated: 15/06/2018 06:09)
  
• Ashish sharma(last updated: 13/06/2018 12:32)
  
• Tim Demoures(last updated: 13/06/2018 08:50)
  

keyboard_arrow_downShow all

Post Comment

• 

  Reto Wernli 3 years ago
  User

  Hi Rafael. I don't seem to get how you initiate the Simulation to fill the Columns C, F, I and L in Sheet "Monte Carlo".
  Thanks for your help.

  arrow_drop_uparrow_drop_downReply reply

  • 

    Rafael Le Saux, CFA, AFM 3 years ago
    Authorstar

    Hi Reto,
    
    Thank you for your message.
    
    Have you tried pressing F9 to recalculate?
    
    Please let me know if that works.
    
    Best Regards

    1arrow_drop_uparrow_drop_downReply reply