Question: must be in python using pycharm 3. (20 points) A stock broker is analyzing a ticker (the stock code, e.g., AMZN for Amazon, AAPL for

must be in python using pycharm 3. (20 points) A stock brokeris analyzing a ticker (the stock code, e.g., AMZN for Amazon, AAPLfor Apple) and she needs to write a report for her bossmust be in python using pycharm

3. (20 points) A stock broker is analyzing a ticker (the stock code, e.g., AMZN for Amazon, AAPL for Apple) and she needs to write a report for her boss about the stock. The broker then wrote a program to pull data from the past year in the format Open-High-Low-Close (OHLC), which is very similar to a candlestick chart. She now has a long list in the format of [O, H, Li, C, , H2, L2, C2, , Hn, Ln, Cn]. However, to make sense of the data, she needs to write a few more functions to answer the following questions: a. What is the highest price of the stock in the past year? What day has it happened (the index of the array)? What is the lowest closing price of the stock in the past year? b. c. What is the average opening price in the past 6 months? (Please note that the stock market does not open every day, so do not hardcode the parameter). 3. (20 points) A stock broker is analyzing a ticker (the stock code, e.g., AMZN for Amazon, AAPL for Apple) and she needs to write a report for her boss about the stock. The broker then wrote a program to pull data from the past year in the format Open-High-Low-Close (OHLC), which is very similar to a candlestick chart. She now has a long list in the format of [O, H, Li, C, , H2, L2, C2, , Hn, Ln, Cn]. However, to make sense of the data, she needs to write a few more functions to answer the following questions: a. What is the highest price of the stock in the past year? What day has it happened (the index of the array)? What is the lowest closing price of the stock in the past year? b. c. What is the average opening price in the past 6 months? (Please note that the stock market does not open every day, so do not hardcode the parameter)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!