Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Theory Icdt 99 7th International Conference Jerusalem Israel January 10 12 1999 Proceedings Lncs 1540

Authors: Catriel Beeri ,Peter Buneman

1st Edition

3540654526, 978-3540654520

More Books

Students also viewed these Databases questions

Question

formula for calculating net income before tax

Answered: 1 week ago