New Page for Stock Project 14 - Another way of purchasing stock. The first method of investment that we have explored what is called a lumo sum purchase of stock (53200). Now I want a new tab (sheet in same filo) that the investment will be random amounts with the same dates. I want you to now purchase random amounts of stock every Tuesday and Friday from the First Tuesday of the Semester to the End, you will submit this before the End but you have to keep up with this one and 3 to the End. At the end you can compare the two ways of investing and decided on which way was better for your stock. Example In this example, all the cells in the Yellow will need to have corresponding cell addressed formulas. The good thing is there are no Copyable $$'s needed in this sheet To create a new page in your stock project, open your Sheet, and at the bottom left there is a (+) Click this and enter the above "white" information Use the values that I have above to test out your formulas. The first row may not have a copyable formulas (Cumulative investment and Cumulative Shares), but the 2nd date you should have copyable formulas you can drag down Stock Project 2020 - Det --TAB-F1 PAAR Stock APL No Price on Am Pent Date Cum Share Current Change al HO 20 5180.00 510000 0.4 0:47 1140.00 DO 0 310000 12000 0.54 1000 5330 532 3150 100 1400 15 SA TADO $180.00 0001 211 SOS 1/7/2020 an 2000 OD 2114 12020 100 51.000.00 0. 1410 51004 . 17.000 151077 1130.00 1.190.00 0410 300 51.210.10 1 1200 6 $180.00 BL000 51 2000 SUM 31000 310000 470 148.00 100% Once your formulas give you the Yellow cell answers, enter your Dates and Prices into the "white" cells. You can copy and paste your dates and stock prices from SP#3, just select the first two columns and CTRL-C, then on the new sheet click on the cell you want that into to start at and then CTRLV. Just the dates and prices, nothing else or you will have to undo if you copy over into the yellowed cells. The formula for the Amount invested will be -RANDBETWEEN(10,20) 10 Copy this down, and then change these values to Money using the menu buttons above the sheet. This will generate random values between $100 and $200 that you will then use to purchase stock at the dates price Submit entire file, both pages in one file, Into Stock Project 04. in the Sheets video, there are examples on how to make a Cumulative Total New Page for Stock Project 14 - Another way of purchasing stock. The first method of investment that we have explored what is called a lumo sum purchase of stock (53200). Now I want a new tab (sheet in same filo) that the investment will be random amounts with the same dates. I want you to now purchase random amounts of stock every Tuesday and Friday from the First Tuesday of the Semester to the End, you will submit this before the End but you have to keep up with this one and 3 to the End. At the end you can compare the two ways of investing and decided on which way was better for your stock. Example In this example, all the cells in the Yellow will need to have corresponding cell addressed formulas. The good thing is there are no Copyable $$'s needed in this sheet To create a new page in your stock project, open your Sheet, and at the bottom left there is a (+) Click this and enter the above "white" information Use the values that I have above to test out your formulas. The first row may not have a copyable formulas (Cumulative investment and Cumulative Shares), but the 2nd date you should have copyable formulas you can drag down Stock Project 2020 - Det --TAB-F1 PAAR Stock APL No Price on Am Pent Date Cum Share Current Change al HO 20 5180.00 510000 0.4 0:47 1140.00 DO 0 310000 12000 0.54 1000 5330 532 3150 100 1400 15 SA TADO $180.00 0001 211 SOS 1/7/2020 an 2000 OD 2114 12020 100 51.000.00 0. 1410 51004 . 17.000 151077 1130.00 1.190.00 0410 300 51.210.10 1 1200 6 $180.00 BL000 51 2000 SUM 31000 310000 470 148.00 100% Once your formulas give you the Yellow cell answers, enter your Dates and Prices into the "white" cells. You can copy and paste your dates and stock prices from SP#3, just select the first two columns and CTRL-C, then on the new sheet click on the cell you want that into to start at and then CTRLV. Just the dates and prices, nothing else or you will have to undo if you copy over into the yellowed cells. The formula for the Amount invested will be -RANDBETWEEN(10,20) 10 Copy this down, and then change these values to Money using the menu buttons above the sheet. This will generate random values between $100 and $200 that you will then use to purchase stock at the dates price Submit entire file, both pages in one file, Into Stock Project 04. in the Sheets video, there are examples on how to make a Cumulative Total
