Track the prices and volume: Create a Microsoft Excel workbook. Collect and record information on the volume, as well as the high, low, and closing price of the stock each day for the period beginning 20 trading days before the announcement through 20 trading days following the announcement

Track the prices and volume: Create a Microsoft Excel workbook. Collect and record information on the volume, as well as the high, low, and closing price of the stock each day for the period beginning 20 trading days before the announcement through 20 trading days following the announcement. Refer to this worksheet as DATA. Using Microsoft Excel, create a volume-high-low-close diagram of the stock's trading. Identify the announcement day as day 0, and indicate the days preceding and following the announcement day as - and + (e.g., 5 days prior is -5).

Refer to this worksheet as VHLC. Analyze the impact of the announcement: Identify whether the announcement was a positive surprise, a negative surprise, or no surprise. Discuss the relation between the type of surprise, and the price movement and volume before, during, and after the announcement. (100-200 words) Relate the price and volume movements to market efficiency. Is your evidence consistent with semi-strong market efficiency? Explain. (100-300 words)

Please help me, I have submitted these home works but have not been assisted?