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.
Acest exercițiu face parte din cursul
Modelare financiară în Google Sheets
Instrucțiuni pentru exercițiu
- 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.
Exercițiu interactiv practic
Transformă teoria în practică cu unul dintre exercițiile noastre interactive
Începe exercițiul