[smf_addin] Digest Number 3154

EXCEL Stock Market Functions Add-in Group

3 Messages

Digest #3154

1a

Re: Problems with data from Google? by aeonff

2a

Referencing earnings report dates from WSJ no longer works by ghart21

2b

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

Messages

1a

Re: Problems with data from Google?

Mon Aug 18, 2014 2:21 am (PDT) . Posted by:

aeonff

Yep it solved it.Thanks a lot !!!Ori

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

2a

Referencing earnings report dates from WSJ no longer works

Mon Aug 18, 2014 9:36 am (PDT) . Posted by:

ghart21

body{font-family:
Geneva,Arial,Helvetica,sans-serif;font-size:9pt;background-color:
#ffffff;color: black;}
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&quot;,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 (2) . Top ^

2b

Re: Referencing earnings report dates from WSJ no longer works

Mon Aug 18, 2014 9:58 am (PDT) . Posted by:

rharmelink

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, <ghart23@earthlink.net> 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&quot;,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 (2) . Top ^

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

Visit Your Group

• New Members 27

• Privacy • Unsubscribe • Terms of Use