In Progress

stock price tracking and analysis

To be considered, don't provide your standard copy/paste answer. Please read, review attachment and answer questions below.

This project has 3 parts to it, if you win this first phase you will automatically get the other 2.

First phase of the project is data collection and quick analysis of the data. The data I am referring to is stock market prices (american and canadian stocks only) and source of the data you can get by using Yahoo's Query Language or scrapping the Yahoo or Google finance site

1. You will write an app that every 5 min will look at a mysql table that will contain stock symbols (it might have 0 symbols at which point you will do nothing, or it might have up to 25 symbols) - I will provide this table, see attached file for more information (click on [url removed, login to view])

2. Once stock symbol is found (ex. NASDAQ:AAPL, TSX:BB) your app will collect certain information about the stock (ex. sector in which it is in, 52 week low and high) and then start collecting stock prices every 5 min for the next 5 days (for each stock).

3. Symbol that you are going to be processing will be marked as such

4. If the same stock symbol is found 15 min later (regardless how many times in a single day), you will do nothing. But if a the same stock symbol is found in the next 5 days, you will mark this stock as special (colour blue)

5. In addition to 4 american, you will also find how 6 other exchanges around the world are doing (ex. London stock exchange).

5. You will then develop 2 reporting pages with filters at the top (see attached)

i) Listing report: top line review of the stocks found on a particular date range (today's date being default). Filters at the top will allow to change views, and each column will also have ability to sort. Below

ii) Detailed stock report: certain details of the particular stock

Since each report page will have filters, I want the data to be passed in query string (ex. [url removed, login to view]

That's it for phase 1. Please answer the following questions and provide your bid

1. How would you rate difficulty of this project? (from 1 to 10, 10 being highest)

2. Do you have experience in stock market?

3. Have you done any technical analysis?

4. How long will it take you to do the first phase?

5. Are you thinking of using Yahoo Query Language, another API or scape a site?

6. Any other suggestions?



Skills: HTML, MySQL, PHP

See more: price tracking mysql, table top range, string processing in c, range query, min range, how to write a market report, how do you find an app, develop app price, be the change you want to see in the world, bb&t, bb & t, bb t, bb and t, market technical analysis, how to do data analysis, data and analysis, market prices, how write technical report, yahoo finance google, tracking api, technical analysis stock, t write a technical report, stock market data, stock market app, stock exchange

About the Employer:
( 5 reviews ) Kelowna, Canada

Project ID: #4686509

Awarded to:


Hello. I've done extensive work over the last 30 with data form global stock exchanges. Please see my PM for the answers to your questions.

$277 CAD in 3 days
(0 Reviews)

6 freelancers are bidding on average $290 for this job


1. difficulty : 2 2. i have experience in stock market.. 3. yes. it is just formula 4. 5-7 days depend on your actual detail requirement. 5. i do not think all the stock market data you interested in are available More

$280 CAD in 7 days
(0 Reviews)

Hi there, We are experts in PHP Open Source (any kind of PHP/MySQL work),wordpress and Ajax/Web 2.0 technology. Some of the projects we completed for php are mentioned below [url removed, login to view] More

$309 CAD in 3 days
(123 Reviews)

Seasoned web scraper. I worked on many similar projects, I have big experience in data mining projects. I can finish this task in short time, with the best quality.

$276 CAD in 3 days
(18 Reviews)

I am ready sir. Thanks

$444 CAD in 3 days
(25 Reviews)

please check my message sir.

$155 CAD in 3 days
(0 Reviews)