시작하기무료로 시작하기

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로 하는 Financial Modeling

강의 보기

연습 안내

  • 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.

실습형 인터랙티브 연습문제

이론을 실습으로 바꾸는 인터랙티브 연습 중 하나를 만나보세요

연습 시작