(1) How do you import fundamental stock data from Yahoo into Google Sheets? - Quora

(1) How do you import fundamental stock data from Yahoo into Google Sheets? - Quora: Shannon Chan, Spreadsheet geek
Written Mar 30, 2015
Here's a list of formulas that can help you import live Yahoo finance data into google spreadsheet. All you need to do is input the stock's ticker into cell A1, copy and paste any of the formulas below into any other cell and you'll have neatly formatted stock data right in your spreadsheet.

For summary trading data:
=IMPORTHTML("http://finance.yahoo.com/q?s="& $A$1,"table",2)
=IMPORTHTML("http://finance.yahoo.com/q?s="& $B$1,"table",3)

For historical prices:
=IMPORTHTML("http://finance.yahoo.com/q/hp?s="&$A$1&" Historical Prices","table")

For Key statistics:
Valuation Measures
=IMPORTHTML("http://finance.yahoo.com/q/ks?s="& $A$1&" Key Statistics","table", 11)