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

13 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)

bob
August 26, 2020 at 4:53 PM

Thanks . it worked

October 20, 2020 at 2:02 PM

The table number changed again, what is the new formula? How can I find out the table number?

October 21, 2020 at 12:51 PM

Go Low, I just tried 9 as the table number and it seems to be working.

October 21, 2020 at 1:05 PM

@Jen X, thanks! Table 9 is slowly working for me. How did you figure that out? Just by trying or can we figure out by looking at the HTML code?

October 21, 2020 at 1:50 PM

@Go Low, I just saw above last time the table number was changed it was reduced by two, so I thought I'd just try that again and it worked! Dumb luck basically.

SK
November 10, 2020 at 1:36 PM

The formula with 9 is pulling a date but when I cross check, the dates don't match. Is that the case with you all? Any suggestions?

November 25, 2020 at 11:56 AM

Try this:

=IF(ISBLANK(A2),,index(SPLIT(SUBSTITUTE(index(IMPORTHTML("http://finviz.com/quote.ashx?t="&A2,"table", 9),11,6),"*",""), "AB"), 0, 1))

removes chars, just leaves the date

Post a Comment