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.
Latihan ini merupakan bagian dari kursus
Pemodelan Keuangan di Google Sheets
Instruksi latihan
- Calculate the step range in
B11by taking the (max-min)/200. - The first step in
A15should be set to equal the minimum value inB9. - in
A16:A215create the next steps by adding the previous step value to the Stock Price step inB11.
Latihan interaktif langsung
Ubah teori menjadi aksi dengan salah satu latihan interaktif kami
Mulai latihan