始める無料で始める

Create the steps for min and max stock prices

You just finished creating the range of stock prices to estimate probability values for. To set up that estimation, you will create a table of stock prices with 200 steps between the minimum and maximum values. By using many steps, you can get a better feel for probabiltiies of stock prices across the possible range of the data.

この演習はコースの一部です

Google Sheetsで学ぶファイナンシャル・モデリング

コースを見る

演習の手順

  • Calculate the step range in B11 by taking the (max-min)/200.
  • The first step in A15 should be set to equal the minimum value in B9.
  • in A16:A215 create the next steps by adding the previous step value to the Stock Price step in B11.

実践的なインタラクティブ演習

理論を実践に変える、インタラクティブな演習のひとつをお試しください

演習を開始する