i want to get stock end-of-day price from NYSE. i want to do this automatic,by API or something like this. does any one know from where can i take thta info? from NYSE?

—-

Han Wang • http://ichart.finance.yahoo.com/table.csv?s=<your symbol here>&d=7&e=19&f=2011&g=d&a=0&b=3&c=1950&ignore=.csv

a = start month, 0 = Jan
b = start day
c = start year

d = end month, 0 = Jan
e = end day
f = end year

Then parse out the csv lines for what you want to do.

Microsoft from 3/13/1986 to 8/19/2011

http://ichart.finance.yahoo.com/table.csv?s=MSFT&a=02&b=13&c=1986&d=07&e=19&f=2011&g=d&ignore=.csv

My earlier post was pretty hacked together, here’s a clearer explaination with Java supporting code:

http://hanwangquant.blogspot.com/2011/08/using-yahoos-historical-price-api.html

, you may try for a start, the following spreadsheet:http://alphapowertrading.com/Yahoo4.xls

Simply follow the instructions on the first tab to add, delete or modify the list of stocks. The spreadsheet comes from the old web site: http://www.gummy-stuff.org/Yahoo-data.htm , the author has retired but there is link to the archived site.

Hope it can help answer your question.

 

 

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!