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.
Wednesday, November 28, 2007
Using GoogleFinance()
Posted by TeKJunk at 2:41 AM
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment