Question: PYTHON PROGRAMMING 1. Please download a CSV file containing the stock history of some companies, for example from: http://finance.yahoo.com/q/hp?s=GOOG http://finance.yahoo.com/q/hp?s=IBM http://finance.yahoo.com/q/hp?s=MSFT (Download Data) Save files

PYTHON PROGRAMMING

1. Please download a CSV file containing the stock history of some companies, for example from:

http://finance.yahoo.com/q/hp?s=GOOG

http://finance.yahoo.com/q/hp?s=IBM

http://finance.yahoo.com/q/hp?s=MSFT

(Download Data)

Save files giving them different names to a local folder on your drive

2. Write a program that searches for CSV files with stock rates in a given folder and for every one of them:

3. Calculates the percentage change between Close and Open price and adds these values as another column to this CSV file.

You can replace the old file or create a new one.

Change = (Close-Open)/Open

4. The output files can be stored in another folder

5. You can use Python to download files. An example is given here: https://raw.githubusercontent.com/prubach/Python_Winter_2022_2/master/download_file.py

6. Please do not use pandas, or only use it as an alternative way of implementing it along a more "manual" way using just python without any libraries.

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!