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!