4 Messages

Digest #3434

Re: Anyone managed to grab data from Dividata.com? by "Kermit W. Prather" kermitpra

Corporate bond yield by infinityholdings@ymail.com

Re: Corporate bond yield by "Randy Harmelink" rharmelink

Re: Corporate bond yield by infinityholdings@ymail.com

Messages

1a

Re: Anyone managed to grab data from Dividata.com?

Tue Jun 16, 2015 8:43 am (PDT) . Posted by:

"Kermit W. Prather" kermitpra

I provided a few other sites to get dividend data on June 4th, TRY this link

<https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/28560> https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/28560

Anyone of the 3 sites in message 28560 works for retrieving dividend payouts into an array.

This is the link I now use for retrieving dividend information. I created a 2 column by 300 row array (more than enough rows) and pasted the below formula. I made the table 300 rows because I do not know how many entries will be returned, GE returns 189 entries and WMT returns 188 entries. While most stock return considerably less payouts.
I have not found any site that is 100% correct on dividend payout but this one in my opinion is the easiest and best
For dividend payouts.

=RCHGetHTMLTable("http://www.dividendinformation.com/search_ticker/?identifier="&$C$5,"Amount Per Share",-1,"",1)

Hope this is helpful.

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Friday, June 12, 2015 4:48 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Anyone managed to grab data from Dividata.com?

Yah. They've done something to their website. See this thread:

https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/28511

On Thu, Jun 11, 2015 at 11:17 PM, tzewei_79@yahoo.com.sg [smf_addin] <smf_addin@yahoogroups.com> wrote:
It seems that they revamp their website. Just want to confirm if it was their website that caused cell error. Could someone try to see if you can get data from =RCHGetTableCell( <https://www.dividata.com/stock/STX> "https://www.dividata.com/stock/STX",1,"Industry")

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

2a

Corporate bond yield

Tue Jun 16, 2015 11:09 am (PDT) . Posted by:

infinityholdings@ymail.com

Randy
I am trying to pull bond yields from yahoo but using get table cell cannot differentiate between triple A, double A, and single A, etc. What can I do to fix this or is there a better way to pull these data tables?

Link: http://finance.yahoo.com/bonds/composite_bond_rates http://finance.yahoo.com/bonds/composite_bond_rates

formulas I am using:
=RCHGetTableCell("http://finance.yahoo.com/bonds/composite_bond_rates",1,">Corporate Bonds",">5yr AAA")
=RCHGetTableCell("http://finance.yahoo.com/bonds/composite_bond_rates",1,">Corporate Bonds",">5yr AA")

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

2b

Re: Corporate bond yield

Tue Jun 16, 2015 11:46 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

You're already using the ending ">" on the HTML tag before your string. The
way that web page is coded, you can also using the starting "<" on the next
HTML tag after your string. For example:

=RCHGetTableCell("http://finance.yahoo.com/bonds/composite_bond_rates",1,">Corporate
Bonds",">5yr AAA<")

=RCHGetTableCell("http://finance.yahoo.com/bonds/composite_bond_rates",1,">Corporate
Bonds",">5yr AA<")

On Tue, Jun 16, 2015 at 11:09 AM, coons_adam@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I am trying to pull bond yields from yahoo but using get table cell cannot
> differentiate between triple A, double A, and single A, etc. What can I do
> to fix this or is there a better way to pull these data tables?
>
> Link: http://finance.yahoo.com/bonds/composite_bond_rates
>
> formulas I am using:
>
> =RCHGetTableCell("http://finance.yahoo.com/bonds/composite_bond_rates",1,">Corporate
> Bonds",">5yr AAA")
>
> =RCHGetTableCell("http://finance.yahoo.com/bonds/composite_bond_rates",1,">Corporate
> Bonds",">5yr AA")
>
>