Jumat, 19 April 2019

[smf_addin] Digest Number 4521

4 Messages

Digest #4521
1a
Re: GuruFocus by turley.muller
1b
Re: GuruFocus by "Randy Harmelink" rharmelink

Messages

Thu Apr 18, 2019 2:16 pm (PDT) . Posted by:

turley.muller

I just became a member of Guru myself. thanks for the recommendation, Randy. It's perfect. Has everything. But one thing, I am pulling 7. years or so of quarterly FS and like the 4th quarter for several years the EPS is wrong- it's the same. I checked the website; it's wrong there too. The net income is correct so I just calc the EPS using the share count. I wonder why. that is though.

Guru is definitely the best source. Before I was having to pull things from 3 or 4 different sources since none had everything I wanted. I recommend it.

Thu Apr 18, 2019 2:30 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

If you notice incorrect data, you should contact them. Just click on the
"Contact Us" link at the bottom of the page in question. I've gotten very
quick responses from them whenever I've reported an issue on dividends,
such as it not showing up even though the dividend has been reported. The
data has often showed up the next day.

Two issues I have with GuruFocus:

1. Separate fees for different global coverage.
2. Historical quotes are not adjusted for dividends.

On Thu, Apr 18, 2019 at 2:17 PM tmuller2@... wrote:

>
> I just became a member of Guru myself. thanks for the recommendation,
> Randy. It's perfect. Has everything. But one thing, I am pulling 7. years
> or so of quarterly FS and like the 4th quarter for several years the EPS is
> wrong- it's the same. I checked the website; it's wrong there too. The net
> income is correct so I just calc the EPS using the share count. I wonder
> why. that is though.
>
> Guru is definitely the best source. Before I was having to pull things
> from 3 or 4 different sources since none had everything I wanted. I
> recommend it.
>
>
>

Thu Apr 18, 2019 3:22 pm (PDT) . Posted by:

"Tony Costello" CostelloT

Randy,    This works well for the first 100 rows of data, but if there are more than 100, you need to scroll to the next page.  Is there a solution to retrieve them all?
Thanks,
Tony

On Monday, April 1, 2019, 10:31:54 AM CDT, Randy Harmelink rharmelink@gmail..com [smf_addin] <smf_addin@yahoogroups.com> wrote:

 

Try:
=RCHGetHTMLTable("https://finance.yahoo.com/calendar/earnings?day=2019-04-01",">EPS Estimate")

On Mon, Apr 1, 2019 at 6:56 AM costellot@... wrote:

    Which SMF function can I use to extract the stock symbols for a given date from the Yahoo earnings calendar? https://finance.yahoo.com/calendar/earnings?day=2019-04-01

Thu Apr 18, 2019 3:43 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I don't see a way to get them all at once. You can do a second formula for
each additional set of 100 tickers:

=RCHGetHTMLTable("
https://finance.yahoo.com/calendar/earnings?day=2019-03-14&offset=100&size=100",">EPS
Estimate")

On Thu, Apr 18, 2019 at 3:22 PM Tony Costello costellot@... wrote:

>
> This works well for the first 100 rows of data, but if there are more
> than 100, you need to scroll to the next page. Is there a solution to
> retrieve them all?
>
> On Monday, April 1, 2019, 10:31:54 AM CDT, Randy Harmelink...wrote:
> Try:
>
> =RCHGetHTMLTable("
> https://finance.yahoo.com/calendar/earnings?day=2019-04-01",">EPS
> Estimate")
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar