Selasa, 26 Juni 2018

[smf_addin] Digest Number 4347

15 Messages

Digest #4347
1b
Re: Navellier Port ranking not working by "Randy Harmelink" rharmelink
1d
Re: Navellier Port ranking not working by "Randy Harmelink" rharmelink
4a
Re: Data from SMF does not match Yahoo by "Carl Mims" aab3c65c4611ee62fa3f26b79f046867
4b
Re: Data from SMF does not match Yahoo by "Randy Harmelink" rharmelink

Messages

Tue Jun 26, 2018 2:14 pm (PDT) . Posted by:

zbgb952

Hello Randy,


I tried =RCHGetTableCell("https://navelliergrowth.investorplace.com/portfolio-grader/stock-report.html?t="&"T",0,"Total Grade:")


and got "error"...this didn't work..pls advise...thanks....


Tue Jun 26, 2018 3:24 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Wrong URL. Try:

=RCHGetTableCell("
https://navelliergrowth.com/portfolio-grader/stock-report.html?t="&"T",0,"Total
Grade:")

On Tue, Jun 26, 2018 at 2:12 PM, mb0329@
​...
wrote:

>
>
> I tried =RCHGetTableCell("https://navelliergrowth.investorplace.
> com/portfolio-grader/stock-report.html?t="&"T",0,"Total Grade:")
>
> and got "error"...this didn't work..pls advise...thanks...
>
>

Tue Jun 26, 2018 3:46 pm (PDT) . Posted by:

zbgb952

Thanks Randy. This seems to work..but note, that instead of giving the value of 'D' it gives the value of 'Total Value:D'...but I guess I can use the mid$ function to extract it, right?

Tue Jun 26, 2018 4:15 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Either Mid() or smfStrExtr() or Substitute().

On Tue, Jun 26, 2018 at 3:46 PM, mb0329@msn.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> Thanks Randy. This seems to work..but note, that instead of giving the
> value of 'D' it gives the value of 'Total Value:D'...but I guess I can use
> the mid$ function to extract it, right?
>

Tue Jun 26, 2018 2:17 pm (PDT) . Posted by:

zbgb952

Hello Randy, what Excel formula can I use to get dividend yield? I know this should be simple but I havent used smf for awhile and am making alot of updates to my spreadsheets. Thanks.


Tue Jun 26, 2018 3:26 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I would suggest using the smfGetYahooPortfolioView() function. It would
allow you to get a number of different data items on a number of different
ticker symbols, in a single Internet request. Take a look at the template
on the web site.

On Tue, Jun 26, 2018 at 2:17 PM, mb0329@
​...
wrote:

>
> Hello Randy, what Excel formula can I use to get dividend yield? I know
> this should be simple but I havent used smf for awhile and am making alot
> of updates to my spreadsheets. Thanks.
>
>
>

Tue Jun 26, 2018 3:56 pm (PDT) . Posted by:

zbgb952

Can you give me an example of the formula using Yahoo Finance?...thanks

Tue Jun 26, 2018 4:16 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Like I said, check out the template. It is the example and shows all the
fields available.

On Tue, Jun 26, 2018 at 3:56 PM, mb0329@
​...
wrote:

>
> Can you give me an example of the formula using Yahoo Finance?..thanks
>
>
>

Tue Jun 26, 2018 8:36 pm (PDT) . Posted by:

zbgb952

Hello Randy...the smfGetYahooPortfolioView() formula looks too complicated for me and I am not interested in using an array formatted type formula.


Can you suggest a simple formula that I can just have get a stock ticker from an excel cell and put the current dividend yield in another cell? I looked at the template and got pretty confused. Thanks.

Tue Jun 26, 2018 10:11 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

See:

https://groups.google.com/d/msg/smf-addin/mdrfnIQIL8g/Aa0xX1lVAwAJ

On Tue, Jun 26, 2018 at 8:35 PM, mb0329@
​...
wrote:

>
> Hello Randy...the smfGetYahooPortfolioView() formula looks too
> complicated for me and I am not interested in using an array formatted type
> formula.
>
> Can you suggest a simple formula that I can just have get a stock ticker
> from an excel cell and put the current dividend yield in another cell? I
> looked at the template and got pretty confused. Thanks.
>
>

Tue Jun 26, 2018 2:20 pm (PDT) . Posted by:

john_hoel

That pretty much says it. I should get today's close, but I don't. Anyone else seeing this?

Tue Jun 26, 2018 6:30 pm (PDT) . Posted by:

"Carl Mims" aab3c65c4611ee62fa3f26b79f046867

Randy

Simply using your element # listed from the YahooKS area of your document sheet.

950 Fiscal Year End for example =RCHGetElementNumber(PIK.F,950)
956 Revenue
959 Cost of Goods
961 Net Income
Inventories = =smfGetYahooJSONField(PIK.F,"balanceSheetHistory","quoteSummary.result.0.balanceSheetHistory.balanceSheetStatements.0.inventory.raw") You gave me this
954 Assets
954 Equity

That is all I am getting for about 1,000 symbols over the course of a year. I am now running into a number of examples where they website finance.yahoo.com <http://finance.yahoo.com/> is updated but using the above the most current is a year old.

Is there a better method similar to inventories? Is there a better place rather than Yahoo?

Thanks,

Carl

> On Jun 21, 2018, at 11:03 AM, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> Element #956 comes from the Key Statistics web page on Yahoo:
>
> https://finance.yahoo.com/quote/PIK.F/key-statistics <https://finance.yahoo.com/quote/PIK.F/key-statistics>
>
> But, yes, the amount Yahoo has posted there is different than what I see on their financial statements web page.
>
> I don't know what function/formula you are using to get the date.
>
>
> On Thu, Jun 21, 2018 at 9:45 AM, carlmims@
> ​...
> wrote:
> I pull a limited number of data points from Yahoo on Income BS data. Always the latest year. I have a number of symbols such as PIK.F which from SMF gets 2/26/17 year-end data as the current but when I go to finance.yahoo.com <http://finance.yahoo.com/> and put that symbol in I get 2/25/18 as the current year and 2/26/17 is the prior year.
>
> Using =RCHGetElementNumber(PKI.F,956) for revenue for example.
>
>
>
>
>

Tue Jun 26, 2018 10:04 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

My better place would be GuruFocus, but I am a subscriber. I don't really
do much with fundamental data these days outside of GuruFocus and
Portfolio123.

On Tue, Jun 26, 2018 at 6:30 PM, Carl Mims carlmims@
​...
wrote:

>
> Simply using your element # listed from the YahooKS area of your document
> sheet.
>
> 950 Fiscal Year End for example =RCHGetElementNumber(PIK.F,950)
> 956 Revenue
> 959 Cost of Goods
> 961 Net Income
> Inventories = =smfGetYahooJSONField(PIK.
> F,"balanceSheetHistory","quoteSummary.result.0.balanceSheetHistory.
> balanceSheetStatements.0.inventory.raw") You gave me this
> 954 Assets
> 954 Equity
>
> That is all I am getting for about 1,000 symbols over the course of a
> year. I am now running into a number of examples where they website
> finance.yahoo.com is updated but using the above the most current is a
> year old.
>
> Is there a better method similar to inventories? Is there a better place
> rather than Yahoo?
>
>
>

Tue Jun 26, 2018 8:46 pm (PDT) . Posted by:

zbgb952

Hello Randy,


What would be the formula using the smfGetTagContent function to get the dividend yield from
the finviz.com website? say, using t as an example




https://finviz.com/quote.ashx?t=t https://finviz.com/quote.ashx?t=t



I already use this function to get dividend growth so i should probably use it to get the dividend yield as well.


Thanks.







For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 22.11

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)