Terminé

Build SQL Database of Stock Prices from [login to view URL]

[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!

Compétences : MySQL, PHP, Architecture Logicielle

en voir plus : xml programming language, www c programming language com, www clear com, www 3000 com, ubuntu programming, ubuntu for linux price, sql programming language, sql price, sql create table price, programming in ubuntu, php programming language developer, parts database access, open table com, my sql developer, my sql create database, job stock, job offers programming, is xml a programming language, is sql a programming language, how to write a programming language

Concernant l'employeur :
( 1 commentaire ) Brighton, United Kingdom

Nº du projet : #7240247

Décerné à:

entrepreneur2000

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 Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 4 jours
(172 Commentaires)
8.2

15 freelance font une offre moyenne de $276 pour ce travail

kchg

Hello! I am interest your project and I hope to work with you. My Ranking is Top 7th on freelancer. I have enough experience with WEB developing for 5+ years. Client satisfaction is my top priority. I will comple Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(423 Commentaires)
9.6
hwanghendra

Hi Sir/Madam. Ready to start. Thanks ................................................................................................

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(468 Commentaires)
7.5
vinothsethu

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(99 Commentaires)
7.3
sunsoftpro

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(116 Commentaires)
6.9
NayaPakistan

Hello. I can write the script in PHP with proper comments so its easy to update in future.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(241 Commentaires)
6.6
leomedina01

Hi sir, My name is Leonardo Medina, and I'm from Brazil. I have lots of experience in PHP. I'm an experienced Web Developer working since 1996 in this field, with: * 7+ years experience in PHP, ASP, HTML, CSS Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(151 Commentaires)
6.8
vishaygupta

I understood the problem. I have done similar work for my company but not specific to this website. I will manage this one too. I will use Java language to do it as it will be easier to run and manage the Mysql DB also Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(55 Commentaires)
6.1
Churaliya

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(43 Commentaires)
6.1
ibbuzz

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!

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 15 jours
(96 Commentaires)
5.8
bhawin91

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(29 Commentaires)
4.8
DanielHuisman

I have over 6 years of experience in JavaScript and MySQL. I would use Node.js (a widely used JavaScript framework), because it's flexible and easy to use. I have written similar application before and I will be able t Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(6 Commentaires)
3.6
aign

Hi! I can do it in python or php. But i have some questions: 1. There is registration needed to use API, do you have registration or i need to register myself ? 2. Do you need any interface to show data in your datab Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(3 Commentaires)
2.0
thisknee

Hi, I've done similar project with bigcommerce api, it gets all the orders for the day, etc.. I can create a php script which be can scheduled to run in the background and get all the data and store in your database Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)
0.0
maemigh

I would normally use Perl for automating a job like this (despite Quandl not having existing libraries), but I can do it in PHP if that is your language of choice. I would do this as one script. First the script wo Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0