Senin, 22 Oktober 2012

[smf_addin] Digest Number 2380

2 New Messages

Digest #2380

Messages

Sun Oct 21, 2012 12:58 pm (PDT) . Posted by:

"Ron Spruell" hashky

Randy -

It turns out that M* embeds the Ticker Symbol in the Name.  If I copy
and paste into Excel, I can right click on the Name and get the URL,
e.g. for the Name

American Tower Corp has

http://library.morningstar.com/Quote/Quote.html?ticker=AMT

embedded.

I found a macro for extracting the URL here:
http://www.bohack.com/2009/06/get-the-url-from-a-hyperlink-in-excel/

Once I get the URL the string extraction is easy.  (Because I read a most of your posts.)

Cell P2 contains the URL

=RIGHT(P2,LEN(P2)-FIND("=",P2))

Is there something in the smf_addin that extracts the URL?

Ron Spruell

>________________________________
> From: Randy Harmelink <rharmelink@gmail.com>
>To: smf_addin@yahoogroups.com
>Sent: Thursday, October 18, 2012 7:51 PM
>Subject: Re: [smf_addin] Morningstar "Library Premium" Stock Screens
>
>

>On a similar listing, I suggested pulling the ticker symbol from the link in the table cell with the name -- see:
>
>http://finance.groups.yahoo.com/group/smf_addin/message/8961
>
>
>On Thu, Oct 18, 2012 at 5:41 AM, Ron Spruell <hashky@yahoo.com> wrote:
>
>
>>
>>I can do Morningstar "Library Premium" Stock Screens and I get a webpage that I can copy and paste into Excel.  As you can imagine "Library Premium" is not the same as "Premium" ($).  The problem is that "Library Premium" does not return Ticker Symbols.  It returns the Company Name.  I wrote some Excel equations to extract the symbol, but they were only about 60% successful.  It is easier just to manually extract time wise.
>>As you know "3M Co" is different than "3M Co."  If I match the left 5 characters, I get an answer.  The left 6 characters do not match.  This is only one example.
>>
>>
>>
>>Is there any charade like function (Sounds Like) in Excel that you know?  Is there another way to extract the symbol?
>>
>>
>>I could always sign up for M* Premium.
>>
>
>
>
>

Sun Oct 21, 2012 2:26 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

That method was in the message reference I gave you...

That is, use smfGetTagContent() to get the link, and then smfStrExtr() to
extract the ticker symbol from the link.

On Sun, Oct 21, 2012 at 12:58 PM, Ron Spruell <hashky@yahoo.com> wrote:

>
> It turns out that M* embeds the Ticker Symbol in the Name. If I copy and
> paste into Excel, I can right click on the Name and get the URL, e.g. for
> the Name
>
> American Tower Corp has
> http://library.morningstar.com/Quote/Quote.html?ticker=AMT
> embedded.
>
> I found a macro for extracting the URL here:
> http://www.bohack.com/2009/06/get-the-url-from-a-hyperlink-in-excel/
>
> Once I get the URL the string extraction is easy. (Because I read a most
> of your posts.)
>
> Cell P2 contains the URL
>
> =RIGHT(P2,LEN(P2)-FIND("=",P2))
>
> Is there something in the smf_addin that extracts the URL?
>
>
> ------------------------------
> *From:* Randy Harmelink <rharmelink@gmail.com>
> *To:* smf_addin@yahoogroups.com
> *Sent:* Thursday, October 18, 2012 7:51 PM
> *Subject:* Re: [smf_addin] Morningstar "Library Premium" Stock Screens
>
>
> On a similar listing, I suggested pulling the ticker symbol from the link
> in the table cell with the name -- see:
>
> http://finance.groups.yahoo.com/group/smf_addin/message/8961
>
>

Tidak ada komentar:

Posting Komentar