176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

MySQL Moving Average Stored Procedure
Sign in to Add to Watch List

IT & Programming > Database Development

View Change History

The client has made the following changes to the job.

Description
Date

Job awarded.

Nov 17, 2012
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Fri, Nov 16, 2012
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: $20 - $50
  • Fixed Price Job
  • Elance Escrow Protection
  • U.S. freelancers must have W9
Sign in to view client's details

I have a MySQL database with historical stock prices. I need to compute the 200-Day and 50-Day moving average for a given stock on a given day. The table has the following structure:
- ID INT (12)
- Symbol VARCHAR (10)
- Data_Date DATE
- Open DOUBLE (11,2)
- High DOUBLE (11,2)
- Low DOUBLE (11,2)
- Close DOUBLE (11,2)
- Volume DOUBLE (11,2)
- MA200Close DOUBLE (11,2) <<< Calculated using the current day's close with the previous 199 close values
- MA50Close DOUBLE (11,2) <<< Calculated using the current day's close with the previous 49 value

NOTE: Sample data can be provided if necessary
------------------------------------------
Added 16 NOV 2012, 21:16 PM EST
I have attached some sample data for you to work with.

Sign in or Register to see more

Job ID: 35266933
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 India
Rich experience in SQL/Database development, performance optimization, administration in MSSQL, MySQL, Sybase ASE etc.Experience includes working...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 35276613  |  Submitted: Nov 17, 2012 07:37 ET 
Proposal SEALED

 Greece  |  
Winner
SQL expert, database and query optimizations
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 35275500  |  Submitted: Nov 17, 2012 06:13 ET 
Delivery
Within 1 day
$20.00

 India  |  
We are a small business on IT Development. We have worked with clients in USA and Malaysia. We do offshore development and maintenance work. We...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 35275357  |  Submitted: Nov 17, 2012 06:01 ET 
Proposal SEALED

 Denmark  |  
One-O-One Solutions is a supplier of accounting and business management software to start-up, small, and midsized businesses. Our aim is to help...
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 35268349  |  Submitted: Nov 16, 2012 21:42 ET 
Proposal SEALED

 United States
• Build new database systems • Backup and restore database system • Set security on database, table, column... • Maintainance :re-index, improve...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 35267507  |  Submitted: Nov 16, 2012 20:14 ET 
Proposal SEALED

S P
 United States  |  
If you are in search for an experienced consultant who can help you with IT projects, look no further. I hold Masters Degree in Computer Science...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 35267285  |  Submitted: Nov 16, 2012 19:54 ET 
Proposal SEALED

Diogo Raminhos      
Diogo Raminhos's identity has been verified.  Learn More
 Portugal  |  
< ? php echo “Hello World!”; ? > You can find some of my skills and experience in my personal website or stackoverflow carrers profile, including...
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 35267239  |  Submitted: Nov 16, 2012 19:51 ET 
Proposal SEALED
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »