Build SQL Database of Stock Prices from [login to view URL]
$30-250 USD
Paid on delivery
[login to view URL] offers an API for downloading historical stock market data. Your job is to write a script that downloads all historical price data of approximately 3000 stocks into a MySQL table on my Linux (Ubuntu) PC and updates it daily. You may use HTML, XML, PHP or any other suitable and widely used programming language. Please state the languages you are planning to use in your bid, or I will not accept it. I put a premium on common languages and simplicity!
The MySQL table is to contain the following columns:
Ticker of stock
Date
Open
High
Low
Close
Volume
Ex-Dividend
Split Ratio
Adj. Open
Adj. High
Adj. Low
Adj. Close
Adj. Volume
I will be able to spot errors in the data, but I will not be able to help you correct erroneous code. The code must include clear comments that make it easy for any developer to correct or expand upon the code independently.
For more information on how to access the data, see
[login to view URL]
[login to view URL]
Note carefully that there is one table for every stock on [login to view URL] . However, the SQL database to which you will import the data contains only one table with all stocks.
Also note that there are two distinct parts of the job: First, you must create a database of all currently existing historical data. Then, you must also write a script that appends newly generated data every day. These tasks may be done with two separate pieces of code or with a single piece of code, whichever you think is more efficient.
Good luck bidding!
Project ID: #7240247
About the project
Awarded to:
Hello, I specialise in solutions for stock markets and trading. I have built few tools to capture EOD stock data from Yahoo Finance, so capturing it from Quandl should not be a problem at all. I will build it purely More
14 freelancers are bidding on average $285 for this job
Hello. I can write the script in PHP with proper comments so its easy to update in future.
Hi Sir/Madam. Ready to start. Thanks ................................................................................................
Hi, I have 7 years experience in programming and certified by Microsoft and Freelancer. I am very familiar with API programming and worked on many APIs like ebay, BigCommerce, Shopify, google, twtitter, facebook, insta More
Hi Employer, I have read your description and been interested in your project. I will use PHP. Please specify your stock categories or your list of stocks you want to get their data. I'm ready to discuss and start to More
Hello Sir, I have done many similar systems. So I can build this system to you easily. I can deliver this system to you in 2 days. Also Please check my feedback. Looking forward to hear from you soon. Thanks.
Hi! Please let discuss we are interested in your project. You have required a web api for this purpose or what please discuss. Thanks and regards!