You are here

How to import google finance data to google spreadsheets

Using Google Spreadsheets and Google finance data, you can construct your basic stock screener.  Data available from Google finance is delayed by 20 minutes rather than live. 

Sample function for importing data into Google spreadsheets is as shown below.
GoogleFinance(ticker, [attribute], [start_date], [num_days|end_date], [interval])

Ticker is Stock Symbol, e.g.,. GOOG

The attribute is one of the following ("price" is default). "price" - real-time stock price (delayed by 20 min); "priceopen" - opening price; "high" - current day high price;  "low" - current day low price; "volume" - current day trading volume; "marketcap" - market capitalization; "tradetime" - time of last trade; "datadelay" - How far delayed the realtime data is; "volumeavg" - average daily trading volume; "pe" - price/earnings ratio; "eps" - earnings per share; "high52" - 52-week high price; "low52" - 52-week low price; "change" - The price change since previous trading day's closing price; "beta" - beta value; "changepct" - The percentage change in price since the previous trading day's close; "closeyest" - previous day's closing price; "shares" - outstanding shares; "currency" - currency in which the security is priced.