Friday, June 27, 2014
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
21 Response to How to Import Earnings Date into a Google Spreadsheet
Thank You!!
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!
This no longer pulls correctly.
=INDEX(ImportHTML("http://www.finviz.com/quote.ashx?t="&A2,"table",11),11,6)
This works...change 13 to 11
How to get the next earnings. This formula gives July 30th for Apple when I need the next release date. Thanks
As a follow up this formula below still works,
=INDEX(ImportHTML("http://www.finviz.com/quote.ashx?t="&A2,"table",11),11,6)
Thanks . it worked
The table number changed again, what is the new formula? How can I find out the table number?
Go Low, I just tried 9 as the table number and it seems to be working.
@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?
@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.
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?
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
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.
how do we import past earnings report dates into google sheets?
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
Thanks so ntquigley! That worked like a charm. Getting rid of the asterix was a nice cherry on top :)
I'm using
=IMPORTXML("https://www.earningswhispers.com/stocks/"&E8;"//div[@id='datebox']/div[@class='mainitem']")
Olli, your formula did the trick! It doesn't display when on the day but it is more accurate than finviz which was more important. Finviz was wrong on a few of mine.
Olli this no longer seems to work. Is there a newer code that will?
Post a Comment