Import specific data for Yahoo finance into Google sheets

Question

I want to import specific data from a table from Yahoo finance to Google sheets.

So far, I have managed to import the table from Yahoo but the specific row e.g. float data

I have used this: =IMPORTHTML("http://finance.yahoo.com/q/ks?s="& $B$1&"+Key+Statistics","table", 2)

This line select the stock symbol in my spreadsheet, then draws the table from Yahoo,

Answer 1

You can accomplish it by accessing that index, try:

• =index(IMPORTHTML("http://finance.yahoo.com/q/ks?s="& $B$1&"+Key+Statistics","table", 2), 4, 2)

the index function will basically get a single item when the output is a table.