[smf_addin] Digest Number 3451

EXCEL Stock Market Functions Add-in Group

7 Messages

Digest #3451

1a

Re: getting started with smf by rr76012

2a

Rankandfiled.com by rdenotari

2b

Re: Rankandfiled.com by "Randy Harmelink" rharmelink

3a

Re: Hoping to only retrieve 10 years of Gurufocus financial data by hamishthedenizen

3b

Re: Hoping to only retrieve 10 years of Gurufocus financial data by "cgrain" cgrain76

3c

Re: Hoping to only retrieve 10 years of Gurufocus financial data by dcharlotte99

3d

Re: Hoping to only retrieve 10 years of Gurufocus financial data by danseiler2000

Messages

1a

Re: getting started with smf

Tue Jul 7, 2015 6:29 am (PDT) . Posted by:

rr76012

Hello Everyone,


Reuters element # 13674 offers a rchgetelementnumber for the past 5 year growth rate of Dividends.


Since element# 63 no longer works, maybe this will help.


If I, or anyone else, finds another element# offering a past 5 year dividend growth rate, please share.


Thank You.

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

2a

Rankandfiled.com

Tue Jul 7, 2015 7:46 am (PDT) . Posted by:

rdenotari

Is there anyway to export the data from the RankandFiled.com website using the addin?


Rank and Filed | SEC filings for humans http://rankandfiled.com/#/public/AAPL/income


Rank and Filed | SEC filings for humans http://rankandfiled.com/#/public/AAPL/income Rank and Filed is like the Securities and Exchange Commission's EDGAR database, but for humans. Free access to filings and financial data!



View on rankandfiled.com http://rankandfiled.com/#/public/AAPL/income
Preview by Yahoo

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

2b

Re: Rankandfiled.com

Tue Jul 7, 2015 8:36 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Not easily that I can see. You may have to extract it out of the JSON
output that is used to build the web page:

http://rankandfiled.com/data/filer/320193/quarterly/periodic
http://rankandfiled.com/data/filer/320193/quarterly/instant
http://rankandfiled.com/data/filer/320193/annual/periodic
http://rankandfiled.com/data/filer/320193/annual/instant

On Tue, Jul 7, 2015 at 7:46 AM, rdenotari@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Is there anyway to export the data from the RankandFiled.com website
> using the addin?
>
> Rank and Filed | SEC filings for humans
> <http://rankandfiled.com/#/public/AAPL/income>
> Rank and Filed | SEC filings for humans
> <http://rankandfiled.com/#/public/AAPL/income>
> Rank and Filed is like the Securities and Exchange Commission's EDGAR
> database, but for humans. Free access to filings and financial data!
> View on rankandfiled.com
> <http://rankandfiled.com/#/public/AAPL/income>
> Preview by Yahoo
>
>
>
>

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

3a

Re: Hoping to only retrieve 10 years of Gurufocus financial data

Tue Jul 7, 2015 2:43 pm (PDT) . Posted by:

hamishthedenizen

Sorry guys, I'm buried here. I will try to get to it for you ASAP, but I can't see it happening before this weekend at the earliest
Just so I'm clear, do you want a 15 years version or the 10 year version?
Just so you're aware, I don't think you can get more than 5 years of data any more without a paid membership.

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

3b

Re: Hoping to only retrieve 10 years of Gurufocus financial data

Tue Jul 7, 2015 2:53 pm (PDT) . Posted by:

"cgrain" cgrain76

You can only get 5 years of data for free.

From: mailto:smf_addin@yahoogroups.com
Sent: Tuesday, July 07, 2015 5:43 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: Hoping to only retrieve 10 years of Gurufocus financial data

Sorry guys, I'm buried here. I will try to get to it for you ASAP, but I can't see it happening before this weekend at the earliest
Just so I'm clear, do you want a 15 years version or the 10 year version?
Just so you're aware, I don't think you can get more than 5 years of data any more without a paid membership.

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

3c

Re: Hoping to only retrieve 10 years of Gurufocus financial data

Tue Jul 7, 2015 7:07 pm (PDT) . Posted by:

dcharlotte99

Hi and thanks. I'm hoping to be able to get 10 years of Income/Balance/Cash Flow Statement free. Was using the Gurufocus spreadsheet. I had QA/QC'd your early versions and added some of my own stuff so have a lot invested in it. Today I tried the other available versions in the Files area without luck.

Any help or options appreciated. I guess paying GuruFocus the $350 per year would solve it but with my fairly small accounts that's a bit much. I'm exploring xbrl downloads but the formatting doesn't seem to work well.

Thanks again.

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

3d

Re: Hoping to only retrieve 10 years of Gurufocus financial data

Tue Jul 7, 2015 9:14 pm (PDT) . Posted by:

danseiler2000

In the same boat.

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

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

Visit Your Group

• New Members 21

• Privacy • Unsubscribe • Terms of Use