Python - Import JSON Data from API to CSV format with Excel calculation (Correlation Formula)
$12-30 SGD
Paid on delivery
This is a small project to import Stock Data of 1 stock with date range, say 1 year (JSON format) from an API using Python and convert the data to a file in csv format. This stock data (1 year~) should be present in 1 csv file.
The JSON data stored in this csv file, (retrieved from the API) will contain 3 main columns. Opening price and Closing price and Date. You will create 3 more columns "Previous Day - Current Day Opening Price" and "Opening price - Closing Price" and "Closing Price previous day - Current day opening price". Based on these three columns, you will use the excel formula CORREL() and give an output to see if there is a correlation between these 3 columns.
The python script should be able to automate this for 2500 stocks. So, about 2500 csv files will be created.
Finally, the script should create 1 main csv file containing the correlation data with all the 2500 stocks.
Additionally with the 3 columns in the csv file, there has to be 4 more columns based on simple subtraction and addition of the 3 columns. Details are added in the project description file attached.
Project ID: #16390090
About the project
14 freelancers are bidding on average $30 for this job
Dear sir As a python developer, I am confident with this job and can start the work right now. Looking forward to hearing from you soon. Best, Jiang
Hello, * Excellent with Python & Related Frameworks * Excellent with Product Development * Excellent with Python Front-End * Excellent 8 Years ERP Development Experience * Excellent 12 Year Experience P More
I have spent over two years working at a financial research firm as a data analyst using Python and Excel to automate the collection, validation and analysis of data from various sources. What you are requesting--getti More
I have much fluency in python, apis, json and operating csv files. I believe in delivering work on time with full customer satisfaction.
1. Maximum support after I finish this project 2. I do because of the responsibility and the value you will pay me