Objective is to connect to yahoo finance URL and grab many (~100) securities prices and get into mysql database. Perform custom calculations on some of the data to result in custom index values. The calculation for each custom index will change monthly so we need to be able to change the formula but since it's only once a month it's not critical that it be particularly easy.
The data and resulting custom indexes should update in "real time" (actually, Yahoo uses 15 minute delayed data but that's fine for our purposes. We just need the data and custom indexes to update automatically using this "real time" data.
Since the Yahoo data gets goofy when the markets are closed we'll need to save the last index value for the day and display that without doing the calculation once the market has closed. Upon the market open the next day we'll need to commence calculation again automatically.
Once the data has been gathered and custom indexes are calculated we'll need to use PHP to get them onto our existing website.
Following features requested:
1. Ability to set mysql db.
2. Ability to set symbols list for download.
3. Ability to set download options. These options dictate precisely what piece of data is collectd for the relevant stock. Data might be previous closing price or most recent price, etc. If you'll Google search for "getting yahoo finance values into PHP", you'll find lists of the download options and the syntax for gathering data.
4. Ability to constantly download data in "real time"
5. Ability to calculate custom indexes using this "real time" data.
6. Ability to get these custom indexes to existing web site using PHP
7. Calculations and transfer to website should be bullet-proof so that once it's started it can run for weeks without attention.
Must provide working version with instructions. Must be on skype for chatting.
I'd like it 2 weeks from awarding the project.
16 freelancers are bidding on average $219 for this job
Hello, 10+ years exp full time freelancer here, can deliver a quality & professional work in the timeframe posted. Please contact me via PM for any question, Thanks.