Wednesday, November 28, 2007

Using GoogleFinance()

Stock information can be pulled via the simple formula GoogleFinance(ticker, attribute) and pushed into a GoogleDocs spreadsheet. It is a very easy way to access real time data and create financial models.
The following types of market data are currently available:
price: market price of the stock - delayed by up to 20 minutes.
priceopen: the opening price of the stock for the current day.
high: the highest price the stock traded for the current day.
low: the lowest price the stock traded for the current day.
volume: number of shares traded of this stock for the current day.
marketcap: the market cap of the stock.
tradetime: the last time the stock traded.
datadelay: the delay in the data presented for this stock using the googleFinance() function.
volumeavg: the average volume for this stock.
pe: the Price-to-Earnings ratio for this stock.
eps: the earnings-per-share for this stock.
high52: the 52-week high for this stock.
low52: the 52-week low for this stock.
change: the change in the price of this stock since yesterday's market close.
beta: the beta value of this stock.
changepct: the percentage change in the price of this stock since yesterday's close.
closeyest: yesterday's closing price of this stock.
shares: the number of shares outstanding of this stock.
currency: the currency in which this stock is traded.
Hopefully this list will expand in the future and access to international market data will also be supported.

No comments: