Archive

Posts Tagged ‘into sql’

Stock Market Data Into Sql

July 11th, 2009 Comments off

I’m looking for someone who can get the following information into a MS SQL database. Program should be able to schedule a start and stop time for each market, program will run 24 hrs a day, be scheduled in my computer startup, but that doesnt mean it will download data 24 hrs, just start to download data at the scheduled time and cycle through.

Example, NASDAQ I want to run from x to y, NYSE I want to schedule different times.

Stock market symbol will be given along with market
The following needs retrieve

all call and put pricings
last selling price
daily volume so far and average volume for 10 days
day hi and lo
Market Cap
Ex-Dividend Date
Dividend Payable Date
Dividend Yield
Declared Dividend
Previous Close
52 week range
P/E Trailing
EPS Trailing
Next Earnings Date
Current news not in the system already
Industry ranking numbers if possible
List of data fundamentals
List of earnings data
Insider activity..

It doesnt need to be lightning fast, but it does need to be stable and I need to be able to see the program running, perhaps by displaying the stock market and symbol its downloading data for..

Bear