Rabu, 01 Oktober 2014

[smf_addin] Digest Number 3196

15 Messages

Digest #3196
1a
1b
Re: Error getting stock name by "Randy Harmelink" rharmelink
2a
Re: SMFGetOptionQuotes returning "Error" by "Randy Harmelink" rharmelink
4a
Need a Morningstar Formula by ridgebacksexcel
4c
Re: Need a Morningstar Formula by "Randy Harmelink" rharmelink
5b
Re: what happened to MSN Stock Scouter? by "Randy Harmelink" rharmelink

Messages

Tue Sep 30, 2014 6:29 pm (PDT) . Posted by:

garyhartling

I'm getting an "Error" when I try to get a stock name, e.g. "=RCHGetElementNumber("C",13862)"

Tue Sep 30, 2014 6:52 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/27031

On Tue, Sep 30, 2014 at 6:29 PM, Gary.Hartling@... wrote:

> I'm getting an "Error" when I try to get a stock name, e.g.
> "=RCHGetElementNumber("C",13862)"
>

Wed Oct 1, 2014 7:20 am (PDT) . Posted by:

garyhartling

OK, so the fix would be to do a CTRL-h (Find/Replace) searching for 13862 and replacing with 13863 (Yahoo source), replace all, in any spreadsheet trying to look up the company name from the ticker.

Tue Sep 30, 2014 6:50 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

You should make sure your Internet Options are set to always get fresh
content, or it could happen again.

On Tue, Sep 30, 2014 at 5:34 PM, katsuomorinaga@...wrote:

>
> OK I went through and manually deleted all my Temporary Internet Files by
> hand and that seems to have done the trick. The Web query went through
> without a hitch as well.
>
> Thanks for your time and keep up the great work!
>

Tue Sep 30, 2014 9:24 pm (PDT) . Posted by:

katsuomorinaga

The funny thing is it was already set to always get new version, but until I manually deleted the cache files it just didn't work for me. So maybe something to add to the list of things to try for troubleshooting.

Thanks again. Cheers!

Tue Sep 30, 2014 7:07 pm (PDT) . Posted by:

ghart21

I'm getting an "Error" when I try to get next earnings date, e.g. "=RCHGetElementNumber("C",13893)"
New Problem


Also
I'm getting an "Error" when I try to get last earnings date, e.g. "=RCHGetElementNumber("C",1290)"
Zacks

Tue Sep 30, 2014 7:14 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Both of those are working fine here. What are your element definitions?
That is:

=smfGetAParms(13893)
=smfGetAParms(1290)

Also, which version of the add-in:

=RCHGetElementNumber("Version")

On Tue, Sep 30, 2014 at 7:07 PM, ghart23@... wrote:

> I'm getting an "Error" when I try to get next earnings date, e.g.
> "=RCHGetElementNumber("C",13893)"
>
> New Problem
>
> Also
>
> I'm getting an "Error" when I try to get last earnings date, e.g.
> "=RCHGetElementNumber("C",1290)"
>
> Zacks
>

Tue Sep 30, 2014 9:17 pm (PDT) . Posted by:

ghart21

body{font-family:
Geneva,Arial,Helvetica,sans-serif;font-size:9pt;background-color:
#ffffff;color: black;}
Randy

I had started to use a laptop that had the 2012 version on it
rather than my customary desktop which ahs the 2014 version.
Hence the problem.

I've now updated that machine.

Thanks so much

George Hart


-----Original Message-----
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]"
Sent: Sep 30, 2014 10:14 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Error getting next and last earnings
date from Zacks

Both of those are working fine here. What are your element
definitions?
That is:

=smfGetAParms(13893)
=smfGetAParms(1290)

Also, which version of the add-in:

=RCHGetElementNumber("Version")

On Tue, Sep 30, 2014 at 7:07 PM, ghart23@... wrote:

> I'm getting an "Error" when I try to get next earnings date,
e.g.
> "=RCHGetElementNumber("C",13893)"
>
> New Problem
>
> Also
>
> I'm getting an "Error" when I try to get last earnings date,
e.g.
> "=RCHGetElementNumber("C",1290)"
>
> Zacks
>

Tue Sep 30, 2014 9:27 pm (PDT) . Posted by:

ridgebacksexcel

Randy,


I am updating some formulas since MSN changed everything. I like the Morningstar site a lot and use it for a few lookups.


Can you help me with extracting the "Latest Indicated Dividend Amount " from this page please?


http://quotes.morningstar.com/stock/c-dividends?&t=aapl http://quotes.morningstar.com/stock/c-dividends?&t=aapl




http://quotes.morningstar.com/stock/c-dividends?&t=aapl http://quotes.morningstar.com/stock/c-dividends?&t=aapl Latest Indicated Dividend Amount 0.4700



View on quotes.morningstar.com http://quotes.morningstar.com/stock/c-dividends?&t=aapl
Preview by Yahoo



I was trying to duplicate a previous RCHGetTableCell formula for this type of table but I can't seem to get it right.


Thanks.

Tue Sep 30, 2014 11:11 pm (PDT) . Posted by:

zbgb952

What do you mean MSN changed everything?... I, in fact, am unable to find MSN Stock Scouter which I have used for several years. It worked fine yesterday. Now it seems to be gone? What is going on?

Tue Sep 30, 2014 11:51 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Try this:

=RCHGetTableCell("http://quotes.morningstar.com/stock/c-dividends?&t=aapl",1,"Latest
Indicated")

On Tue, Sep 30, 2014 at 9:27 PM, tmallen2@bellsouth.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I am updating some formulas since MSN changed everything. I like the
> Morningstar site a lot and use it for a few lookups.
>
> Can you help me with extracting the "Latest Indicated Dividend Amount "
> from this page please?
>
> http://quotes.morningstar.com/stock/c-dividends?&t=aapl
>
> http://quotes.morningstar.com/stock/c-dividends?&t=aapl
> Latest Indicated Dividend Amount 0.4700
> View on quotes.morningstar.com
> <http://quotes.morningstar.com/stock/c-dividends?&t=aapl>
> Preview by Yahoo
>
> I was trying to duplicate a previous RCHGetTableCell formula for this type
> of table but I can't seem to get it right.
>

Tue Sep 30, 2014 10:11 pm (PDT) . Posted by:

zbgb952

My spreadsheet that links to the msn stock scouter website just comes up with 'error&#39;
everywhere and i cannot locate MSN Stock Scouter on internet. I get taken to some website that doesn't even look like msn.

Anyone else having this problem? Anyone know what is going on? It is 10:11 PM pacific time on
Tuesday 9/30/14 as I write this.

Thanks.




Tue Sep 30, 2014 11:56 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/27031

I hadn't looked for StockScouter. However, since the stock screener they
now have uses MorningStar data items, I'd says chances are that it's gone
for good.

On Tue, Sep 30, 2014 at 10:11 PM, mb0329@msn.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> My spreadsheet that links to the msn stock scouter website just comes up
> with 'error&#39;
> everywhere and i cannot locate MSN Stock Scouter on internet. I get taken
> to some website that doesn't even look like msn.
>
> Anyone else having this problem? Anyone know what is going on? It is 10:11
> PM pacific time on
> Tuesday 9/30/14 as I write this.
>

Wed Oct 1, 2014 12:56 am (PDT) . Posted by:

zbgb952

Looks like this is another lousy stinking change they are doing. I used to use their screener many years ago when it was based on the stock scouter rankings...then they got rid of it...but you could still get the rankings one stock at a time. Now it looks like they got rid of that too. Total deterioration of the MSN website for me if this is true.

Wed Oct 1, 2014 10:50 am (PDT) . Posted by:

zbgb952

Hello Randy,


Why is:



RCHGetElementNumber(ticker , 63) (5 year dividend growth) returning #value ?


If it has to do with MSN is there another way to get the dividend growth%? Thanks.






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

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)