Archive

Posts Tagged ‘dividend’

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..

Stocks And Options Tables

June 9th, 2009 Comments off

I run an investment newsletter that deals in dividend-paying stocks. I need someone to create 2 types of tables:
1. Dividend Yield tables- A table that would show current price data, (20-minute updates approx.), from the web, for specific predetermined stocks, their dividends paid per share, and their 52-week range. The tables would give the annualized yields for the dividends, and also a risk factor rating that I would input.
I want to list different tables for different industry sectors.

2. Call option calculator- A table that would show:
-current price data, (20-minute updates approx.), for specific predetermined stocks from Table 1
- their dividends paid per share prior to the option expiration date
- the annualized yield of these dividends
- specific call options’ strike price, symbol, expiration date
- the current bid price of these options
- the annualized yield of these call options.
- the sum of the annualized dividend yield and call option yield, referred to as “Total Static Yield”
- the potential annualized yield if the stock were “assigned”, (sold), at a call option strike price higher
than the current price/share
- the sum of the static yield plus the potential annualized yield, referred to as “Total Potential Yield”

3. Put option calculator- A table that would show:
- current stock price data, (20-minute updates approx.),for specific predetermined stocks from Table 1
- their dividends paid per share prior to the option expiration date
- the annualized yield of these dividends
- specific put options’ strike price, symbol, expiration date
- the current bid price of these put options
- the cash requirement for these put options -(simply the strike price x 100)
- the annualized yield of these put options

4. A “Public User” version of the 2 above calculators, in which a visitor to my website would be able to
enter up to 3 different stocks and compare their yields.

I need to be able to input various stocks and put and call options into the tables on a daily/weekly basis.
I use a Mac. My website is currently with a Mac-based host, but, this could be altered, if necessary. Please advise.

There are other tables that I’d like to incorporate in the future, but for now, I’d like to start with these.

Bear