[smf_addin] Digest Number 4564

EXCEL Stock Market Functions Add-in Group

6 Messages

Digest #4564

1a

the formula "=IF( $D12="","",  RCHGetElementNumber($D12, 4925) )" is by zbgb952

1b

Re: the formula "=IF( $D12="","", RCHGetElementNumber($D12, 4925) )" by "Randy Harmelink" rharmelink

1c

Re: the formula "=IF( $D12="","", RCHGetElementNumber($D12, 4925) )" by zbgb952

1d

Re: the formula "=IF( $D12="","", RCHGetElementNumber($D12, 4925) )" by "Randy Harmelink" rharmelink

2a

Randy, now it looks like IF($D13="","",RCHGetElementNumber($D13,543) by zbgb952

2b

Re: Randy, now it looks like IF($D13="","",RCHGetElementNumber($D13, by "Randy Harmelink" rharmelink

Messages

1a

the formula "=IF( $D12="","",  RCHGetElementNumber($D12, 4925) )" is

Fri Jun 28, 2019 8:28 pm (PDT) . Posted by:

zbgb952

Hello Randy, It appears that the formula "=IF( $D12="","", RCHGetElementNumber($D12, 4925) ) "
has stopped working for me. It is to find the DIVIDEND YIELD of the stock ticker that is in cell $D12 or any other cell. The formula is responding with #NAME?. Note..that yesterday I was getting "error" instead. I went the smf website and saw that it said that some of the element numbers were changed so I copied/pasted the updated copy of your "smf-elements-2.txt" file to my computer and now I amg getting #Name? instead of error .


What can I do to correct this? what other formula can I replace this with that will give me a stock's current dividend yield?


Thanks.


Morey

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

1b

Re: the formula "=IF( $D12="","", RCHGetElementNumber($D12, 4925) )"

Fri Jun 28, 2019 8:55 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

#NAME? would typically mean the function itself isn't being found. That
would have nothing to do with the smf-elements-2.txt file. It sounds like
you somehow deactivated the add-in?

Based on the formula, I suspect you are getting a number of them? If so, it
would be much faster to grab the information with
smfGetYahooPortfolioView(). You can array-enter that over a range and get
multiple data items for multiple ticker symbols, with a single Internet
request.

On Fri, Jun 28, 2019 at 8:28 PM mb0329@msn.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Hello Randy, It appears that the formula "=IF( $D12="","",
> RCHGetElementNumber($D12, 4925) ) "
> has stopped working for me. It is to find the DIVIDEND YIELD of the stock
> ticker that is in cell $D12 or any other cell. The formula is responding
> with #NAME?. Note..that yesterday I was getting "error" instead. I went the
> smf website and saw that it said that some of the element numbers were
> changed so I copied/pasted the updated copy of your "smf-elements-2.txt"
> file to my computer and now I amg getting #Name? instead of error .
>
> What can I do to correct this? what other formula can I replace this with
> that will give me a stock's current dividend yield?
>
>

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

1c

Re: the formula "=IF( $D12="","", RCHGetElementNumber($D12, 4925) )"

Fri Jun 28, 2019 9:24 pm (PDT) . Posted by:

zbgb952

Deactivated what add-on? This function in my spreadsheet is working:
"IF($D11="","",RCHGetElementNumber($D11,543)) ". However the 4925 one isn't.


Anything I can do about that? or can you type out the function I can use to replace it? I need it to return the dividend yield for a single stock symbol. Thanks.


Morey

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

1d

Re: the formula "=IF( $D12="","", RCHGetElementNumber($D12, 4925) )"

Sat Jun 29, 2019 12:25 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I can't think of a situation where element 4925 would return #NAME? and 543
would not.

What do you get if you use these in a new worksheet:

=RCHGetElementNumber("MMM";,543)
=RCHGetElementNumber("MMM";,4925)
=RCHGetElementNumber("Definition",4925)
=RCHGetElementNumber("Version&quot;)

On Fri, Jun 28, 2019 at 9:25 PM mb0329@... wrote:

>
> Deactivated what add-on? This function in my spreadsheet is working:
> "IF($D11="","",RCHGetElementNumber($D11,543)) ". However the 4925 one
> isn't.
>
> Anything I can do about that? or can you type out the function I can use
> to replace it? I need it to return the dividend yield for a single stock
> symbol. Thanks.
>
>
>

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

2a

Randy, now it looks like IF($D13="","",RCHGetElementNumber($D13,543)

Fri Jun 28, 2019 10:46 pm (PDT) . Posted by:

zbgb952

It looks like IF($D13="","",RCHGetElementNumber($D13,543)) is giving me an error message...though it was working a few hours ago...and I made no changes.


The 543 is for Stockscouter.


Let me know if it is working for you. Maybe they are updating their files, don't know.


Thanks.


Morey

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

2b

Re: Randy, now it looks like IF($D13="","",RCHGetElementNumber($D13,

Sat Jun 29, 2019 12:27 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I get "Error", because it requires a login with EXCEL's "From Web (Legacy)"
browser object.

Can you access the web page with that browser object?

On Fri, Jun 28, 2019 at 10:48 PM mb0329@... wrote:

>
> It looks like IF($D13="","",RCHGetElementNumber($D13,543)) is giving me an
> error message...though it was working a few hours ago...and I made no
> changes.
>
> The 543 is for Stockscouter.
>
> Let me know if it is working for you. Maybe they are updating their files,
> don't know.
>
>
>

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

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

Visit Your Group

• Privacy • Unsubscribe • Terms of Use