How to Import Earnings Date into a Google Spreadsheet

You can use the formula below to import Earnings Date into your Google Finance Spreadsheets. There is a limit of 50 per spreadsheet. A2 would be the cell your ticker is in.

=INDEX(ImportHTML("http://www.finviz.com/quote.ashx?t="&A2,"table",13),11,6)

Example

4 Response to How to Import Earnings Date into a Google Spreadsheet

February 27, 2014 at 9:10 PM

Thank You!!

ML
July 19, 2014 at 3:18 PM

when I click on the example hyberlink I get the following message
Sorry, the file you have requested does not exist.

could you post the example again. thanks!

February 19, 2019 at 2:57 PM

This no longer pulls correctly.

May 23, 2019 at 2:18 PM

=INDEX(ImportHTML("http://www.finviz.com/quote.ashx?t="&A2,"table",11),11,6)

This works...change 13 to 11

Post a Comment