title: Google sheets and finviz tables
body: <p>I am using google sheets to grab data from finviz. Let's use facebook (FB) for my example.</p>
  <p><a href="https://finviz.com/quote.ashx?t=FB" rel="nofollow noreferrer">https://finviz.com/quote.ashx?t=FB</a></p>
  <p>I randomly entered this combination</p>
  <pre><code>=SUBSTITUTE(INDEX(IMPORTHTML(&quot;http://finviz.com/quote.ashx?t=&quot;&amp;$B1, &quot;table&quot;, ), 1, 1), &quot;*&quot;, &quot;&quot;)
  </code></pre>
  <p>I don't know why it returns insider trading when there's no table # for it.</p>
  <p>Also, I am trying to figure out how to get data for the income statement table. How do I get this? Is there a way to find out where the table number is?</p>