4 Messages
Digest #4516
Messages
Thu Apr 11, 2019 12:31 pm (PDT) . Posted by:
friedman_steve
Look like the ADVfn element number formulas not working? for example:
=RCHGetElementNumber($C13,9506)
Or is there another good place to grab most recent quarter balance sheet items? (specially cash, and all debt), as well as recent EBITDA.
I was able to use this formula instead. But didn't know how to make formula automatically grab the most recent column. I used 5 here for 5th column, but this won't work if it's a new company (such as the ticker PLAN)
=RCHGetTableCell("https://www.advfn.com/stock-market/NYSE/JNJ/financials?btn=quarterly_reports&mode=company_data",5,"EBITDA",,,,0,2)
Thanks.
=RCHGetElementNumber($C13,9506)
Or is there another good place to grab most recent quarter balance sheet items? (specially cash, and all debt), as well as recent EBITDA.
I was able to use this formula instead. But didn't know how to make formula automatically grab the most recent column. I used 5 here for 5th column, but this won't work if it's a new company (such as the ticker PLAN)
=RCHGetTableCell("https://www.advfn.com/stock-market/NYSE/JNJ/financials?btn=quarterly_reports&mode=company_data",5,"
Thanks.
Thu Apr 11, 2019 1:13 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
This is working here:
=RCHGetElementNumber("JNJ",9506)
Did you try an smfForceRecalculation? There could have been a temporary
issue, or a bad page retrieval.
These days, I use GuruFocus for most of my financials. But I'm a subscriber
and can access their fully-stocked CSV file. Non-subscribers get limited
periods and can't get all line items.
The difficultly in determining which column to get is why I wrote a special
function to do it. It get involved trying to do it via a direct formula.
You need to use multiple work values.
On Thu, Apr 11, 2019 at 12:36 PM friedman_steve@... wrote:
>
> Look like the ADVfn element number formulas not working?
> for example:
> =RCHGetElementNumber($C13,9506)
>
> Or is there another good place to grab most recent quarter balance sheet
> items? (specially cash, and all debt), as well as recent EBITDA.
>
> I was able to use this formula instead. But didn't know how to make
> formula automatically grab the most recent column. I used 5 here for 5th
> column, but this won't work if it's a new company (such as the ticker PLAN)
> =RCHGetTableCell("
> https://www.advfn.com/stock-market/NYSE/JNJ/financials?btn=quarterly_reports&mode=company_data
> ",5,"EBITDA",,,,0,2)
>
>
>
=RCHGetElementNumber("JNJ",9506)
Did you try an smfForceRecalculation? There could have been a temporary
issue, or a bad page retrieval.
These days, I use GuruFocus for most of my financials. But I'm a subscriber
and can access their fully-stocked CSV file. Non-subscribers get limited
periods and can't get all line items.
The difficultly in determining which column to get is why I wrote a special
function to do it. It get involved trying to do it via a direct formula.
You need to use multiple work values.
On Thu, Apr 11, 2019 at 12:36 PM friedman_steve@... wrote:
>
> Look like the ADVfn element number formulas not working?
> for example:
> =RCHGetElementNumber($C13,9506)
>
> Or is there another good place to grab most recent quarter balance sheet
> items? (specially cash, and all debt), as well as recent EBITDA.
>
> I was able to use this formula instead. But didn't know how to make
> formula automatically grab the most recent column. I used 5 here for 5th
> column, but this won't work if it's a new company (such as the ticker PLAN)
> =RCHGetTableCell("
> https://www.advfn.com/stock-market/NYSE/JNJ/financials?btn=quarterly_reports&mode=company_data
> ",5,"
>
>
>
Thu Apr 11, 2019 3:32 pm (PDT) . Posted by:
"Carl Mims" aab3c65c4611ee62fa3f26b79f046867
Randy
Since you converted to GuruFocus do they use the same symbols as Yahoo? Given the number I have, and already doing the conversion from Google to Yahoo, it is a very big job for me. Also, can you speak to their Financials. Yahoo at times seems to lag several months compared to what I got from Google.
Carl
> On Apr 11, 2019, at 2:12 PM, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> This is working here:
>
> =RCHGetElementNumber("JNJ",9506)
>
> Did you try an smfForceRecalculation? There could have been a temporary issue, or a bad page retrieval.
>
> These days, I use GuruFocus for most of my financials. But I'm a subscriber and can access their fully-stocked CSV file. Non-subscribers get limited periods and can't get all line items.
>
> The difficultly in determining which column to get is why I wrote a special function to do it. It get involved trying to do it via a direct formula. You need to use multiple work values.
>
>
> On Thu, Apr 11, 2019 at 12:36 PM friedman_steve@... wrote:
>
> Look like the ADVfn element number formulas not working?
> for example:
> =RCHGetElementNumber($C13,9506)
>
> Or is there another good place to grab most recent quarter balance sheet items? (specially cash, and all debt), as well as recent EBITDA.
>
> I was able to use this formula instead. But didn't know how to make formula automatically grab the most recent column. I used 5 here for 5th column, but this won't work if it's a new company (such as the ticker PLAN)
> =RCHGetTableCell("https://www.advfn.com/stock-market/NYSE/JNJ/financials?btn=quarterly_reports&mode=company_data <https://www.advfn.com/stock-market/NYSE/JNJ/financials?btn=quarterly_reports&mode=company_data>",5,"EBITDA",,,,0,2)
>
>
>
>
Since you converted to GuruFocus do they use the same symbols as Yahoo? Given the number I have, and already doing the conversion from Google to Yahoo, it is a very big job for me. Also, can you speak to their Financials. Yahoo at times seems to lag several months compared to what I got from Google.
Carl
> On Apr 11, 2019, at 2:12 PM, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> This is working here:
>
> =RCHGetElementNumber("JNJ",9506)
>
> Did you try an smfForceRecalculation? There could have been a temporary issue, or a bad page retrieval.
>
> These days, I use GuruFocus for most of my financials. But I'm a subscriber and can access their fully-stocked CSV file. Non-subscribers get limited periods and can't get all line items.
>
> The difficultly in determining which column to get is why I wrote a special function to do it. It get involved trying to do it via a direct formula. You need to use multiple work values.
>
>
> On Thu, Apr 11, 2019 at 12:36 PM friedman_steve@... wrote:
>
> Look like the ADVfn element number formulas not working?
> for example:
> =RCHGetElementNumber($C13,9506)
>
> Or is there another good place to grab most recent quarter balance sheet items? (specially cash, and all debt), as well as recent EBITDA.
>
> I was able to use this formula instead. But didn't know how to make formula automatically grab the most recent column. I used 5 here for 5th column, but this won't work if it's a new company (such as the ticker PLAN)
> =RCHGetTableCell("https://www.advfn.com/stock-market/NYSE/JNJ/financials?btn=quarterly_reports&mode=company_data <https://www.advfn.com/stock-market/NYSE/JNJ/financials?btn=quarterly_reports&mode=company_data>",5,
>
>
>
>
Thu Apr 11, 2019 4:27 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I'm afraid I don't use the financials enough to speak to their timeliness.
I used to have severe problems with that on AdvFN. I have used the
dividends frequently from GuruFocus, and they seem to be up-to-date with
announcements. Unlike Yahoo.
As far as ticker symbols, GF uses periods instead of the hyphens Yahoo uses
(e.g. BRK.A instead of BRK-A).
On Thu, Apr 11, 2019 at 3:35 PM Carl Mims carlmims@... wrote:
>
> Since you converted to GuruFocus do they use the same symbols as Yahoo?
> Given the number I have, and already doing the conversion from Google to
> Yahoo, it is a very big job for me. Also, can you speak to their
> Financials. Yahoo at times seems to lag several months compared to what I
> got from Google.
>
>
I used to have severe problems with that on AdvFN. I have used the
dividends frequently from GuruFocus, and they seem to be up-to-date with
announcements. Unlike Yahoo.
As far as ticker symbols, GF uses periods instead of the hyphens Yahoo uses
(e.g. BRK.A instead of BRK-A).
On Thu, Apr 11, 2019 at 3:35 PM Carl Mims carlmims@... wrote:
>
> Since you converted to GuruFocus do they use the same symbols as Yahoo?
> Given the number I have, and already doing the conversion from Google to
> Yahoo, it is a very big job for me. Also, can you speak to their
> Financials. Yahoo at times seems to lag several months compared to what I
> got from Google.
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar