Tuesday, October 19, 2010

Downloading stock data from Yahoo

Yahoo provides a simple way to querying their database and get an updated stock-quote.

Here is the way to use it (quoting from Ilmu's blog):
http://finance.yahoo.com/d/quotes.csv?s=
a number of STOCK symbols separated by “+”
&f=a bunch of special tags
for example:
http://finance.yahoo.com/d/quotes.csv?s=XOM+BBDb.TO+JNJ+MSFT&f=snd1l1yr
where some special tags are:

aAska2Average Daily Volume
a5
Ask Size

b
Bid
b2
Ask (Real-time)b3Bid (Real-time)

b4
Book Value
b6
Bid Size
c
Change & Percent Change
c1Change
c3
Commission
c6
Change (Real-time)

c8
After Hours Change (Real-time)dDividend/Share
d1
Last Trade Date

d2
Trade Date
e
Earnings/Sharee1Error Indication (returned for symbol changed / invalid)

e7
EPS Estimate Current Year
e8
EPS Estimate Next Year
e9
EPS Estimate Next Quarter
f6Float Shares
g
Day’s Low
h
Day’s High

j
52-week Lowk52-week High
g1
Holdings Gain Percent

g3
Annualized Gain
g4
Holdings Gaing5Holdings Gain Percent (Real-time)

g6
Holdings Gain (Real-time)
i
More Info
i5
Order Book (Real-time)
j1Market Capitalization
j3
Market Cap (Real-time)
j4
EBITDA

j5
Change From 52-week Lowj6Percent Change From 52-week Low
k1
Last Trade (Real-time) With Time

k2
Change Percent (Real-time)
k3
Last Trade Sizek4Change From 52-week High

k5
Percebt Change From 52-week High
l
Last Trade (With Time)
l1
Last Trade (Price Only)
l2High Limit
l3
Low Limit
m
Day’s Range

m2
Day’s Range (Real-time)m350-day Moving Average
m4
200-day Moving Average

m5
Change From 200-day Moving Average
m6
Percent Change From 200-day Moving Averagem7Change From 50-day Moving Average

m8
Percent Change From 50-day Moving Average
n
Name
n4
Notes
oOpen
p
Previous Close
p1
Price Paid

p2
Change in Percentp5Price/Sales
p6
Price/Book

q
Ex-Dividend Date
r
P/E Ratior1Dividend Pay Date

r2
P/E Ratio (Real-time)
r5
PEG Ratio
r6
Price/EPS Estimate Current Year
r7Price/EPS Estimate Next Year
s
Symbol
s1
Shares Owned

s7
Short Ratiot1Last Trade Time
t6
Trade Links

t7
Ticker Trend
t8
1 yr Target PricevVolume

v1
Holdings Value
v7
Holdings Value (Real-time)
w
52-week Range
w1Day’s Value Change
w4
Day’s Value Change (Real-time)
x
Stock Exchange

y
Dividend Yield
:)

They can be easily used by curl or other scripting languages to get the stock updates! Google also has a similar way of downloading stock data but Yahoo has much bigger set of information.


 

Saturday, October 16, 2010

Ten free websites for information on stocks

Internet is full of information sources for stocks. 

Here is a list of websites I refer to the most:
1. Yahoo Finance: Yahoo finance is one destination which aggregates every thing from stock-market related news to SEC filings to stock-quotes for many years. They provide a rich set of APIs to query their servers. It is the only yahoo property which I like more than google. 




2. Google Finance: Google finance lags yahoo in terms of information but their feature-set is definitely compelling.


3. stockcharts: I want to look at different stock charts and their patterns regularly and stockcharts provides a very rich set of overlay and technical analysis. 





4. wikiinvest: wikiinvest is like wikipedia for stocks, but it offers more. They allow importing the brokerage account directly into the account and show their worth, trends, news all at one place and for free!






5. Fool: Fool is good destination to look for news and has a strong community of passionate stock traders and investors.
 






6. zacks: Zacks is a good portal which provides an in-depth analysis of stocks.
 






7. seekingalpha: Seekingalpha is another source of news but they have a number of cool features like adding Apps to your profile. This can allow getting all the news and reports all at one place.
8. gummy_stuff: Contains some cool stuff by a former maths profs from statistical information to spreadsheets for maintaining portfolio.
9. stocktwits: It has an interesting iPhone app to get twitter updates on stocks.
 






10. bloomberg: Last but not the least, bloomberg is a good website for news related to stock-market.









You can always look for interesting sites online related to stocks by looking at what people bookmark!