1 Message

Digest #3864

Re: Last and Next Earnings Report Date by hedgefundit

Message

1a

Re: Last and Next Earnings Report Date

Tue Dec 13, 2016 7:35 am (PST) . Posted by:

hedgefundit

The web site has changed a fair amount and I just made some updates to fix my spreadsheets. Here are the codes I ended up using;

Earnings Date

=smfStrExtr(SUBSTITUTE(RCHGetWebData("https://www.earningswhispers.com/stocks/"&$A17,"og:description",100),"%20"," "),"earnings on ",". Shares")

Announcement Time

=SUBSTITUTE(smfStrExtr(SUBSTITUTE(RCHGetWebData("https://www.earningswhispers.com/stocks/"&$A17,"twitter.com",150),"%20"," ")," at "," via")," ET","")

and here is the Date Confirmed code

=IF(IFERROR(FIND("icon-checkmark",RCHGetWebData("https://www.earningswhispers.com/stocks/"&$A18,"epsconfirmed",200)),0) > 0,1,0)

and a modified Days to earnings

=IF(IFERROR(C17-TODAY()>=0, FALSE), C17-TODAY(), "Unknown")

These all work as of today, but as always, that may change.

Doug