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

6 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

September 5, 2019 at 3:18 PM

How to get the next earnings. This formula gives July 30th for Apple when I need the next release date. Thanks

October 31, 2019 at 7:15 AM

As a follow up this formula below still works,


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

Post a Comment