[smf_addin] Digest Number 4565

EXCEL Stock Market Functions Add-in Group

11 Messages

Digest #4565

1a

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

1b

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

1c

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

1d

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

2a

Randy, do you know of any websites that have free stock ratings? by zbgb952

2b

Re: Randy, do you know of any websites that have free stock ratings? by "Randy Harmelink" rharmelink

3a

what is Excel formula for:  https://www.stockscores.com/charts/chart by zbgb952

3b

Re: what is Excel formula for: https://www.stockscores.com/charts/ch by "Randy Harmelink" rharmelink

4a

Getting Errors for RCHGetElementNumbers 987, 945, 972, 977, 978, 979 by sjagers

4b

Re: Getting Errors for RCHGetElementNumbers 987, 945, 972, 977, 978, by "Randy Harmelink" rharmelink

4c

Re: Getting Errors for RCHGetElementNumbers 987, 945, 972, 977, 978, by sjagers

Messages

1a

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

Sat Jun 29, 2019 8:18 am (PDT) . Posted by:

zbgb952

Hello Randy,
In your response you mention "EXCEL's "From Web (Legacy)" browser object.".
I never heard of this/that.
What is it?


Morey

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

1b

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

Sat Jun 29, 2019 8:28 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

It's what you get when you do the alt+d+d+w keyboard shortcut. When I add
it to my Quick Access Toolbar, the option is called "From Web (Legacy)"...

On Sat, Jun 29, 2019 at 8:18 AM mb0329@... wrote:

>
> In your response you mention "EXCEL's "From Web (Legacy)" browser object.".
> I never heard of this/that.
> What is it?
>
>
>

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

1c

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

Sat Jun 29, 2019 8:38 am (PDT) . Posted by:

zbgb952

I don't know what this is. Never heard of it.


The stockscouter website I use is


https://quotes.freerealtime.com/stock-scouter?title=AAPL https://quotes.freerealtime.com/stock-scouter?title=AAPL


However, it is now saying, for example, that aapl is invalid...or any other stock symbol you use.

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

1d

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

Sat Jun 29, 2019 8:48 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I also get that for any ticker symbol I use, even if I click through from
one on their StockScouter lists. So probably a problem on their site.

On Sat, Jun 29, 2019 at 8:38 AM mb0329@... wrote:

>
> I don't know what this is. Never heard of it.
>
> The stockscouter website I use is
>
> https://quotes.freerealtime.com/stock-scouter?title=AAPL
>
> However, it is now saying, for example, that aapl is invalid...or any
> other stock symbol you use.
>
>
>

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

2a

Randy, do you know of any websites that have free stock ratings?

Sat Jun 29, 2019 9:44 am (PDT) . Posted by:

zbgb952

Randy, do you know of any websites that have free stock ratings?


I've been using https://quotes.freerealtime.com/stock-scouter?title=AAPL https://quotes.freerealtime.com/stock-scouter?title=AAPL



But apparently it isn't working any more.


And if so, can I access it through SMF...what would be the formula to use in Excel?



Thanks.


Morey

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

2b

Re: Randy, do you know of any websites that have free stock ratings?

Sat Jun 29, 2019 10:13 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I don't currently use any ratings services...

On Sat, Jun 29, 2019 at 9:44 AM mb0329@... wrote:

> Randy, do you know of any websites that have free stock ratings?
>
> I've been using https://quotes.freerealtime.com/stock-scouter?title=AAPL
>
> But apparently it isn't working any more.
>
> And if so, can I access it through SMF...what would be the formula to use
> in Excel?
>
>
>

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

3a

what is Excel formula for:  https://www.stockscores.com/charts/chart

Sat Jun 29, 2019 12:13 pm (PDT) . Posted by:

zbgb952

Hello Randy,
It looks like I may have another website that gives you free rankings of stocks.


Here is an example:


https://www.stockscores.com/charts/charts/?ticker=t https://www.stockscores.com/charts/charts/?ticker=t




The other should give you a ranking for T .. AT&T.


What would be the formula I could use in Excel that will enable me to extract the rating which is at the top...and would point to a cell in my Excel spreadsheet for the stock ticker?


You may want to add this sight to SMF!!! :)
especially...if Stockscouter no longer works in the future.


Thanks.


Morey

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

3b

Re: what is Excel formula for: https://www.stockscores.com/charts/ch

Sat Jun 29, 2019 2:04 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Take a look at elements #783 thru #836...

On Sat, Jun 29, 2019 at 12:14 PM mb0329@... wrote:

>
> It looks like I may have another website that gives you free rankings of
> stocks.
>
> Here is an example:
>
> https://www.stockscores.com/charts/charts/?ticker=t
>
>
> The other should give you a ranking for T .. AT&T.
>
> What would be the formula I could use in Excel that will enable me to
> extract the rating which is at the top...and would point to a cell in my
> Excel spreadsheet for the stock ticker?
>
> You may want to add this sight to SMF!!! :)
> especially...if Stockscouter no longer works in the future.
>
>
>

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

4a

Getting Errors for RCHGetElementNumbers 987, 945, 972, 977, 978, 979

Sat Jun 29, 2019 2:13 pm (PDT) . Posted by:

sjagers

Hi Randy,

I hope all is well with you. Question for you....

All of a sudden (yesterday and today), I'm getting an "Error" for RCHGetElementNumbers 987, 945, 972, 977, 978, 979, 982, 4925 for any stock symbol that I use.

These ElementNumbers worked last week. Do you experience an Error with these numbers? Do you think Yahoo did something to their website again?

Thanks.

Steve

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

4b

Re: Getting Errors for RCHGetElementNumbers 987, 945, 972, 977, 978,

Sat Jun 29, 2019 2:21 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

See
https://smf-add-in.blogspot.com/2019/06/alert-some-yahoo-element-definitions.html

On Sat, Jun 29, 2019 at 2:13 PM sjagers@... wrote:

>
> I hope all is well with you. Question for you....
>
> All of a sudden (yesterday and today), I'm getting an "Error" for
> RCHGetElementNumbers 987, 945, 972, 977, 978, 979, 982, 4925 for any stock
> symbol that I use.
>
> These ElementNumbers worked last week. Do you experience an Error with
> these numbers? Do you think Yahoo did something to their website again?
>
>
>

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

4c

Re: Getting Errors for RCHGetElementNumbers 987, 945, 972, 977, 978,

Sun Jun 30, 2019 5:32 am (PDT) . Posted by:

sjagers

Thanks for the quick reply. Your new Elements-2 file fixed my my problem. I appreciate your help.

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

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

Visit Your Group

• Privacy • Unsubscribe • Terms of Use