Reference no: EM132113660
(Uses Excel) Create a table that simulate the buy and sell decisions of a stock trader at the New York Stock Exchange. Include an input sections which lists how much your stock price must go up or down before you would buy or sell - set this value to 5. Then set up a table with the following columns:
* Prior Day Stock Price: Note that on the first day you will need to type in a value - use $215.00 for your initial value. For the remaining days (rows), use a reference to prior day's price. Use the currency data type.
* Change From Prior Day: The daily change will be within the range +25 to -25. Use a single equation ONLY. The equation must include a random function. Use the currency data type.
* Current Day Stock Price. The new price - just the prior price plus the change.
* Buy: Use a function to set this equal to "Buy" when the stock price goes up by more than 5 (or any other value set in the input section), otherwise set it equal to "".
* Sell: Use a function to set this equal to "Sell" when the stock price goes down by more than 5 (or any other value set in the input section), otherwise set it equal to "".
Use the fill handle to autofill the table down to at least 5 days.
All cells in the table must contain ONLY references and equations. The only exception is the first row's "Prior Day Stock Price" where you type in the $215.00.
(this uses Excel)