# Monte Carlo Simulation

**URL:** <https://connect.superhuman.com/t/monte-carlo-simulation/14949>\
**Category:** Ask the Community\
**Created:** [April 6, 2020, 5:36pm UTC](https://connect.superhuman.com/t/monte-carlo-simulation/14949 "2020-04-06T17:36:54Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![egonsenheim](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/egonsenheim/32/8264_2.png) [@egonsenheim](https://connect.superhuman.com/u/egonsenheim)\
**Post date:** [April 6, 2020, 5:36pm UTC](https://connect.superhuman.com/t/monte-carlo-simulation/14949/1 "2020-04-06T17:36:54Z")

</div>

Has anyone attempted to build a monte carlo simulation using Coda?

---

<div class="post-metadata">

**Author:** ![Sam\_Harrison](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/sam_harrison/32/10980_2.png) [@Sam\_Harrison](https://connect.superhuman.com/u/Sam_Harrison)\
**Post date:** [April 7, 2020, 11:17am UTC](https://connect.superhuman.com/t/monte-carlo-simulation/14949/2 "2020-04-07T11:17:44Z")

</div>

I haven’t, but would be very interested to see if anyone has! Technically I don’t think it would be too difficult but I suspect the sticking point will be storing data, e.g. if you want a table with a row for each iteration, then that could be one massive table. Can Coda cope with 100,000s of rows?

---

<div class="post-metadata">

**Author:** ![Federico\_Stefanato](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/federico_stefanato/32/10092_2.png) [@Federico\_Stefanato](https://connect.superhuman.com/u/Federico_Stefanato)\
**Post date:** [April 7, 2020, 2:25pm UTC](https://connect.superhuman.com/t/monte-carlo-simulation/14949/3 "2020-04-07T14:25:25Z")

</div>

Hi @egonsenheim,

I was wondering if this would be a good advantage.  
Monte Carlo simulations - usually - require quite a lot of computational power and I don’t think this is the main benefit of Coda.

What is the use-case you were thinking about?

---

<div class="post-metadata">

**Author:** ![egonsenheim](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/egonsenheim/32/8264_2.png) [@egonsenheim](https://connect.superhuman.com/u/egonsenheim)\
**Post date:** [April 7, 2020, 2:50pm UTC](https://connect.superhuman.com/t/monte-carlo-simulation/14949/4 "2020-04-07T14:50:32Z")

</div>

Hi, @Federico_Stefanato, you may be right. I am using Coda to build flexible financial models. The advantage over excel is that I can make changes to the model drivers without breaking the model more easily than in excel. Plus, my models are available through any web browser and my mobile devices.

The use-case for the monteo carlo simulation is forecasting financial statement data within a specified range of potential outcomes. I have seen something similar in excel with 5,000 simulations (link to excel model here: [https://github.com/ARKInvest/ARK-Invest-Tesla-Valuation-Model/blob/master/Tesla%202024%20Valuation%20Extract\_3.25.20\_v4.1.xlsx](https://github.com/ARKInvest/ARK-Invest-Tesla-Valuation-Model/blob/master/Tesla%202024%20Valuation%20Extract_3.25.20_v4.1.xlsx)).

I could run this in python and use the API to feed the data back to Coda if the computational power is a gating item.

---

<div class="post-metadata">

**Author:** ![Brandon\_Trew](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/brandon_trew/32/11525_2.png) [@Brandon\_Trew](https://connect.superhuman.com/u/Brandon_Trew)\
**Post date:** [May 5, 2020, 10:50pm UTC](https://connect.superhuman.com/t/monte-carlo-simulation/14949/5 "2020-05-05T22:50:23Z")

</div>

Not exactly what you asked for, but might be a starting point: [https://coda.io/@brandon-trew/template-time-series-scenario-modeling](https://coda.io/@brandon-trew/template-time-series-scenario-modeling)

You could automatically create pretty large timeseries outputs like this, and you could use random numbers in the formula inputs (columns in the time series) to simulate those kinds of random events.

---

<div class="post-metadata">

**Author:** ![Andrew\_Cowell](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/andrew_cowell/32/30886_2.png) [@Andrew\_Cowell](https://connect.superhuman.com/u/Andrew_Cowell)\
**Post date:** [July 26, 2023, 3:28pm UTC](https://connect.superhuman.com/t/monte-carlo-simulation/14949/6 "2023-07-26T15:28:43Z")

</div>

Hey @egonsenheim,

We have just released a Monte Carlo Simulator Pack and accompanying document. Please feel free to check it out [here](https://connect.superhuman.com/t/monte-carlo-project-estimation/41569).

---

<div class="post-metadata">

**Author:** ![system](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/system/32/24484_2.png) [@system](https://connect.superhuman.com/u/system)\
**Post date:** [September 29, 2023, 9:00am UTC](https://connect.superhuman.com/t/monte-carlo-simulation/14949/7 "2023-09-29T09:00:18Z")

</div>

Closed on September 29, 2023, 9:00am UTC

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
