Google Sheets spreadsheets can retrieve stock market data. Youtube has a video that shows how–
[USING GOOGLE FINANCE TO ANALYZE STOCKS IN GOOGLE SHEETS - YouTube](https://Stock Spreadsheets on Google Sheets)
You can get a wide variety of info including 20 min delay stock price, PE, close, earnings per share, high low price as well as historical data.
A useful way to track your portfolio or to sort through a list of stocks.
The basic formula is–
=Googlefinance(ticker), [attribute],[start date],enddate|number days], [interval]
Ticker Name Price PE High52 Low52
=GoogleFinance(A3), “name” or B2
Price =Googlefinance (A3,C2) Chg to $A$3 and drag across.
Sample Usage
GOOGLEFINANCE(“NASDAQ:GOOG”, “price”, DATE(2014,1,1), DATE(2014,12,31), “DAILY”)
GOOGLEFINANCE(“NASDAQ:GOOG”,“price”,TODAY()-30,TODAY())
=GOOGLEFINANCE(“NASDAQ:GOOG”,“price”,TODAY()-30,TODAY())
=GOOGLEFINANCE(“GOOG”, “price”, DATE(2019,1,1)) returns one date
=GOOGLEFINANCE(“GOOG”, “price”, DATE(2019,1,1-90)) returns one date 90 days previous
GOOGLEFINANCE(A2,A3)
Syntax
GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date|num_days], [interval])
Attributes
“price” - Real-time price quote, delayed by up to 20 minutes.
“pe” - The price/earnings ratio.
“eps” - The earnings per share.
“closeyest” - The previous day’s closing price.
“close” - The closing price for the specified date(s).
“return13” - Thirteen-week total return. (Mutual funds only)