Silicon Investor (SI) -- The First Internet Community

STOCKTALK

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor. We ask that you disable ad blocking while on Silicon Investor in the best interests of our community. If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.

Strategies & Market Trends : Picks of the quarter -- Ignore unavailable to you. Want to Upgrade?

To: Elroy who wrote (1931)	12/6/2006 10:57:57 AM
From: Taro	Respond to of 20435

Anything which makes your pro bono work for us on this board easier is my pleasure, done. Taro

To: Elroy who wrote (1931)	12/6/2006 7:11:19 PM
From: Sonki	Read Replies (2) \| Respond to of 20435

How can I get financial market information updated automatically to my spreadsheets? this spreadsheet can be shared by public to whome u can give access and each person can update their own trades. if u actually use this let me knw how it wrks out for u. ty. You can get stock market quotes and other data updated to your spreadsheets by using the GoogleFinance function. Using the GoogleFinance function To use the GoogleFinance function, enter the following formula in the desired spreadsheet cell: docs.google.com Syntax: Syntax: =GoogleFinance("symbol", "attribute"); where "symbol" represents the stock symbol of the company you're looking for (ike GOOG, QQQ, and so on), and "attribute" represents the type of market data that you want (like Price, Volume, and so on). If the attribute is left blank, price is returned by default. Here are a couple examples using the formula: * To insert the current volume of Google stock: =GoogleFinance("GOOG", "volume") * To insert the current price of Google stock: =GoogleFinance("GOOG") and =GoogleFinance("GOOG", "price") * Alternatively, the stock symbol and/or the attribute values can come from spreadsheet cells. For example, the function can be: =GoogleFinance(A2, B1) In this case, the attribute specified as a string in cell B1 would be returned for the stock symbol in cell A2. Note: In order for the formula to compute properly, quotation marks must be used around both the "symbol" and the "attribute." Some of the attributes you can use 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. Note: Stock quotes and other data may be delayed up to 20 minutes. Information is provided "as is" and solely for informational purposes, not for trading purposes or advice. For more information, please read our Stock Quotes Disclaimer.