2 Messages
Digest #3167
Messages
Mon Sep 1, 2014 3:37 pm (PDT) . Posted by:
digsupply
Hi Randy
I would like to get some data from the Zacks page: http://www.zacks.com/stock/research/SDRL/earnings-announcements http://www.zacks.com/stock/research/SDRL/earnings-announcements.
On the page there are several tabs, I am just interested in the Dividends Tab, and within, just the first two rows, as follows:
Earnings Announcements Payable Date Amount Announcement Date Ex-Div Date 6/19/2014 $1.00 5/28/2014 6/10/2014 3/20/2014 $0.98 2/27/2014 3/5/2014
Would you please tell me what the formula is? Should I use RCHGetTableCell?
Thank you
I would like to get some data from the Zacks page: http://www.zacks.com/stock/research/SDRL/earnings-announcements http://www.zacks.com/stock/research/SDRL/earnings-announcements.
On the page there are several tabs, I am just interested in the Dividends Tab, and within, just the first two rows, as follows:
Earnings Announcements Payable Date Amount Announcement Date Ex-Div Date 6/19/2014 $1.00 5/28/2014 6/10/2014 3/20/2014 $0.98 2/27/2014 3/5/2014
Would you please tell me what the formula is? Should I use RCHGetTableCell?
Thank you
Mon Sep 1, 2014 6:31 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The formula isn't a pretty one, because the data needs to be extracted from
JavaScript code. I just modified the one being used to grab the earnings
announcements data from that same web page:
=smfStrExtr(smfStrExtr(smfWord(smfWord(","&smfStrExtr(smfGetTagContent("
http://www.zacks.com/stock/research/SDRL/earnings-announcements","script",-1,"Payable
Date"),"""data"" : [ ","]"),...row...,"}"),...column...,","),":
","~"),"""","""")
...where "...row..." ranges goes from 1 on upward (up to 16 for SDRL) and
"...column..." ranges from 2 to 5 for the various items. The SDRL data
appears to have some strange items. For example, the 1969 payable date and
announcement date, which look like they should be 2013.
On Mon, Sep 1, 2014 at 3:36 PM, picsound@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> I would like to get some data from the Zacks page:
> http://www.zacks.com/stock/research/SDRL/earnings-announcements.
>
> On the page there are several tabs, I am just interested in the Dividends
> Tab, and within, just the first two rows, as follows:
> Earnings AnnouncementsPayable DateAmountAnnouncement DateEx-Div Date
> 6/19/2014$1.005/28/20146/10/20143/20/2014$0.982/27/20143/5/2014
>
> Would you please tell me what the formula is? Should I use
> RCHGetTableCell?
>
>
JavaScript code. I just modified the one being used to grab the earnings
announcements data from that same web page:
=smfStrExtr(smfStrExtr(smfWord(smfWord(","&smfStrExtr(smfGetTagContent("
http://www.zacks.com/stock/research/SDRL/earnings-announcements","script",-1,"Payable
Date"),"""data"" : [ ","]"),...row...,"}"),...column...,","),":
","~"),"""","""")
...where "...row..." ranges goes from 1 on upward (up to 16 for SDRL) and
"...column..." ranges from 2 to 5 for the various items. The SDRL data
appears to have some strange items. For example, the 1969 payable date and
announcement date, which look like they should be 2013.
On Mon, Sep 1, 2014 at 3:36 PM, picsound@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> I would like to get some data from the Zacks page:
> http://www.zacks.com/stock/research/SDRL/earnings-announcements.
>
> On the page there are several tabs, I am just interested in the Dividends
> Tab, and within, just the first two rows, as follows:
> Earnings AnnouncementsPayabl
> 6/19/2014$1.
>
> Would you please tell me what the formula is? Should I use
> RCHGetTableCell?
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar