capture stock prices in a database

This project is in two phases. First I want to capture stock prices in a database. The database can be MySQL or SQL Express as I would like to keep the cost down. There are 7 fields that need to be captured and I would like to capture them from Yahoo finance. There are about 3000 stocks that will be updated on a daily basis. The data source may change to a different vendor whose API I don't have at this time. Once the database is complete I need an application that performs calculations and querries using the stock data. The data will then be exported to an Excel spreadsheet. The app needs to be installed on 3 to 4 computers so I would like to host the data off-site in order for the users to have access to the same data. ## Deliverables This project will need some maintenance in the future so I would like the programmer to be available to make modification in the future for a reasonable rate. I created a spreadsheet that does everything described except for the database. It uses a third party DDE Link so when I choose the coder I will send you the sheet but the cells will not populate due to you not having the data connection. * * *This broadcast message was sent to all bidders on Saturday Jan 3, 2009 6:20:32 AM: Thank you all for you bids and comments. After reading through them I realize that my description of the project is vague so I will try to be more clear below. 1. A database that captures;trade date, symbol,open, High, Low, Close and Volume. The data is free on Yahoo Finance but I want the program to be flexible enough that if I want to use a different source for the data in the future that it won't be difficult to change. 2. Initially I want to load the stock symbols in bulk, meaning if there are 3000 symbols I don't want to enter them by hand, I want to send you the list via .txt or .xls and have you load them into the database. I need the ability to add or remove symbols. For each symbol I would like to go back and fetch the last 6 months of data and then on a daily basis fetch today's data. the fetch would be done once per day at a pre-determined time or when the user requests it. The database will get quite large as it will start with 3000 stocks * 6 months of data * 7 fields and will be added to daily. So keep that in mind when suggesting the database software. 3. The next bit is where I need your suggestions on how to best query the data. The database could reside on my home PC but I don't think I have a static IP so I may host the server off-site at a place such as www.aplus.net. 2 people need access to the data so is a web app best or a desktop app? The calculations that I need returned are trivial. They look at previous days High, Low, Open and Close and run 3 if then statements, 2 will return false and 1 will return a value. The value will then be used to produce 2 additional values(Bid and Offer). I will try to attach a spreadsheet after I am done with this note. 4. The web/desktop app will allow me to view the Bid and Offer and export them to excel along with 3 other fields, Stock, Buy or Sell, Account and Destination. There are a few criteria that each stock must pass so I am not sure if that is done on the database side or the app side. For instance close stock price must be > 5 and Avg 6 month volume must be > 250,000. So as you can see you will have to calculate the Avg 6 month volume by using the volume field in the database. I would also like to calculate the stocks Beta using 6 months of data, or if you know of a site that provides it you could fetch it from there. The Beta should be compared to the stock SPY. I hope this cleared things up a bit. As I stated before I will try to attach the Excel sheet that I use now. Thanks, Larry * * *This broadcast message was sent to all bidders on Monday Jan 5, 2009 8:24:01 AM: Thank you all for your bids and comments thus far. I have received 43 bids and 25 comments and then bids and comments with multiple comments. So as you can see I have much to review. There have been some wide ranging and excellent ideas and a large spread in cost. I am more concerned with choosing the right programmer than the cost so please bear with me for a few days while I cull the list down. I am sure all of you are qualified for the job and I thank you for your time and effort. I will get back to you within the next day or two. Thanks, Larry