Create a scripts in Python (I suppose two), which will download data from Yahoo Finance and save it to CSV files and to MySQL.
You can use a library to download data from finance.yahoo.com.
The source is a TXT file with stock symbols (attached file – [login to view URL]).
I need to be able to set the start date and end date.
Downloaded data history is need to be modified / verified, especially replace the NA values. Replace NA items by lineraly smoothed replacement as described on page 41.
Save modified data in the following ways.
1. CSV files
a. All Close from all stock symbols save to one CSV file
. First column will be date.
b. Each stock/symbol save in separate CSV file – filename – stock/symbol name. Save: Date, Open, High, Low, Close, Adjusted Close, Volume.
a. All Close from all stock symbols save in one table where the first column will be date
b. Each stock symbols save in own table – name – stock/symbol name.
Save: Date, Open, High, Low, Close, Adjusted Close, Volume.
For both variants (CSV, MySQL), I need to automatically add new data from Yahoo Finance. At a specific time, the script will download new data and add it to the historically downloaded data.
Additional NA may occur during the daily update at specific time. In this case, please replace NA with the last known value.
List of replaced items please save in a new file / table, where will be date and “assigned” value. Autoupdate.
In the appendix you will find the book "Automated Trading with R Quantitative Research and Platform Development" including codes in R. Everything is perfectly described in Part 2, Chapters 2 and 3.
Scripts have to be very well and detail commented for an absolute beginner in Python.
I need also description of commissioning and support.
I'm a beginner in Python and MySQL, so if the design is nonsensical, for example, if it is not possible to work with combinations of letters and numbers in the database, let me know in advance.
Budget USD 60 - 80
14 фрілансерів(-и) у середньому готові виконати цю роботу за $141
I am an engineer and confident of what I can do and deliver. I can work on Arduino, Python, Matlab, among others. I am asking for a chance to work with you on your project. Thanks