[smf_addin] Digest Number 3155

EXCEL Stock Market Functions Add-in Group

4 Messages

Digest #3155

1a

Re: Referencing earnings report dates from WSJ no longer works by ghart21

1b

Re: Referencing earnings report dates from WSJ no longer works by "Randy Harmelink" rharmelink

2a

IBD Question by lakshmi8th

2b

Re: IBD Question by "Randy Harmelink" rharmelink

Messages

1a

Re: Referencing earnings report dates from WSJ no longer works

Tue Aug 19, 2014 8:07 am (PDT) . Posted by:

ghart21

body{font-family:
Geneva,Arial,Helvetica,sans-serif;font-size:9pt;background-color:
#ffffff;color: black;}
Thanks Randy

And thanks so much for an unbelievably useful tool. Unmatched !!

Any suggestions as to a "replacement" source for that next (and
last if possible) earnings report dates?

George Hart


-----Original Message-----
From: "rharmelink@gmail.com [smf_addin]"
Sent: Aug 18, 2014 12:58 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: Referencing earnings report dates from
WSJ no longer works

It looks like they are now dynamically generating the web page,
so the data is no longer within the source code of the delivered
web page. I don't see any way for the add-in to extract the data
at this point. Sorry. ---In smf_addin@yahoogroups.com, wrote :
Randy
Until the last couple of days the flowing method of getting the
last and next earnings reporting dates from the Wall Street
Journal worked fine where B2 contained a stock symbol
=smfGetTagContent("http://quotes.wsj.com/"&B2&"/financials","span\
",1,">Next
http://quotes.wsj.com/"&B2&"/financials";,"span",1,">Next Earnings
Report")
Any idea what may have changed? I noticed that "Next Earning's
Report" has become "Next Report" but simply changing that
reference does not solve problem
Thanks in advance
George Hart

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

1b

Re: Referencing earnings report dates from WSJ no longer works

Tue Aug 19, 2014 8:15 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Yahoo and Zacks both have elements defined for the next earnings release
date:

=RCHGetElementNumber("MMM",1285)
=RCHGetElementNumber("MMM",13893)

For the last earnings release date, from Zacks:

=RCHGetElementNumber("MMM",1290)

You may want to look over the two Zacks templates for related items:

http://ogres-crypt.com/SMF/Templates/#Zacks

On Tue, Aug 19, 2014 at 8:07 AM, ghart23@... wrote:

>
> Any suggestions as to a "replacement" source for that next (and last if
> possible) earnings report dates?
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

2a

IBD Question

Tue Aug 19, 2014 9:07 pm (PDT) . Posted by:

lakshmi8th

Randy,
I just updated my Internet Explorer to version 11 because IBD just advised that it no longer supports Internet Explorer vs. 9. Now my spreadsheets don't work. Any idea what happened?
Thanks so much for this wonderful tool,
Jeff

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

2b

Re: IBD Question

Tue Aug 19, 2014 9:12 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

You're leaving me to guess what "don't work" means.

Since EXCEL and the add-in share the same Internet engine that IE does, I
hope it's just a matter of creating the IE security cookie under the new
version of IE. Use the EXCEL Web Query dialog to see if you're still log in
(keyboard shortcut alt+d+d+w). If not, log in. Then run
smfForceRecalculation and try your workbook again.

But I have no experience with later versions of IE.

On Tue, Aug 19, 2014 at 7:55 PM, simran8thplane@... wrote:

> I just updated my Internet Explorer to version 11 because IBD just
> advised that it no longer supports Internet Explorer vs. 9. Now my
> spreadsheets don't work. Any idea what happened?
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Visit Your Group

• New Members 29

• Privacy • Unsubscribe • Terms of Use