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

19 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

January 6, 2021 at 3:06 PM

Is this broken again?

I am having trouble getting this to work via the Nov 25 comment or by changing to table 9 as mentioned above.

Sue
January 7, 2021 at 11:17 AM

how do we import past earnings report dates into google sheets?

January 7, 2021 at 5:37 PM
This comment has been removed by the author.
January 7, 2021 at 5:48 PM

Did some digging and fixed the formula. The 11th row and 6th column is what those numbers mean. The all important "8" below is the number of the table on the finviz page that the formula searches. I think finviz only shows the future earnings date after the company has announced one. And I guess finviz keeps re-arranging the number of tables on the page? Anyway, here is what works as of today:

=INDEX(ImportHTML("https://www.finviz.com/quote.ashx?t="&A2,"table",8),11,6)
Example result: *Nov 02 AMC*

I didn't want the asterisks so i removed them by adding the substitute formula, below:

=SUBSTITUTE(INDEX(ImportHTML("https://www.finviz.com/quote.ashx?t="&A2,"table",8),11,6),"*","")
Example result: Nov 02 AMC

BMO=before market open
AMC=after market close

January 8, 2021 at 8:31 AM

Thanks so ntquigley! That worked like a charm. Getting rid of the asterix was a nice cherry on top :)

February 20, 2021 at 12:57 AM

I'm using

=IMPORTXML("https://www.earningswhispers.com/stocks/"&E8;"//div[@id='datebox']/div[@class='mainitem']")

Post a Comment