4 New Messages

Digest #2773

Re: Morningstar Data by "raiders8112" raiders8112

Re: smfUpdateDownloadTable macro - company name not working by "Isaac Wiedmann" isaac_wiedmann

Zacks ranking by joelfp2000

Re: Zacks ranking by "Randy Harmelink" rharmelink

Messages

1a

That did it. Thanks. I had tried period=4, not 3.

Thanks

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> The MorningStar URLs need to be changed from "&period=12" to "&period=3".
>
> That changes what is RETRIEVED, but I'm not sure that's the only change you
> would need to make to PROCESS the retrieved data correctly.
>
> On Wed, Sep 11, 2013 at 12:50 PM, raiders8112 <mike.russo@...>wrote:
>
> > Does anyone know how to convert the Morningstar.xlsx file to retrieve
> > quarterly data?
> >
>

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

2a

Re: smfUpdateDownloadTable macro - company name not working

Sat Sep 14, 2013 6:26 pm (PDT) . Posted by:

"Isaac Wiedmann" isaac_wiedmann

Hi guys,

Indeed half of the problem was not having the latest files. After I installed the latest files, element 13863 (Yahoo company name) now works for me; however, just like Kermit my element 13862 (MSN company name) still gives an error.

Personally, I am only using the Yahoo company name element, so the issue is solved for me, but hopefully this info is helpful to solve the MSN issue for others.

Thank you
Isaac

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I'm not real happy with the new Yahoo Groups either. Especially the FILES
> area. I don't see any way to get the full description of a file. I'd also
> like to get rid of the "cover" at the top that takes up half the page. They
> remove it when looking at a conversation, but not when looking at files.
>
> If you have MSN problems, element 13862 is NOT going to work. It is an MSN
> element.
>
> The element definition file does have the ability to have comments. When it
> loads definitions, it ignores all lines that have an apostrophe in the
> first byte of the line. So I could add a last change date as the first
> record of a file.
>
> My ability to help on your new system may be limited, since I don't have
> that environment here and would have no way to reproduce any issues.
>
> On Fri, Sep 13, 2013 at 9:16 AM, Kermit W. Prather
> <kermitp@...>wrote:
>
> >
> > Randy, there is some strange stuff going on today. Turns out my failure
> > of the 13862 element is due to my long running MSN issue on my Vista 64 bit
> > desktop. ****
> >
> > You can probably ignore the rest of this message. Other than the new issue
> > which Iâ€™ll document in a new posting. ****
> >
> > ** **
> >
> > First, I thought I had the latest smf-elements-1.txt file But when I
> > attempted to go online to the SMF-addin group Yahoo I get screen formats
> > I have never seen before.****
> >
> > Is it just me or has Yahoo changed the layouts?****
> >
> > If this is their new format I think it sucks. ****
> >
> > I get a list of files folder but I could not figure out how to access the
> > files.****
> >
> > ** **
> >
> > Well, I finally figured out how to open the smf-elements-1.txt file an
> > hour later. I downloaded it and replaced the version I had even though
> > visually they look the same. ****
> >
> > ** **
> >
> > Here is the definition I have for element 13862 in smf-elements01.txt
> > file: I have no way of telling if it is the right level since there is no
> > version code in the file and windows show a 7/24/2013 date as the last
> > update in the folder. ****
> >
> > Would you consider putting a last change date in the files at some point?
> > ****
> >
> > ** **
> >
> > MY previous version****
> >
> > 13862;MSN;Company Name;=TRIM(smfGetTagContent("
> > http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=~~~~~
> > ","h1",0,"title="""))****
> >
> > ** **
> >
> > My newly downloaded version****
> >
> > ** **
> >
> > 13862;MSN;Company Name;=TRIM(smfGetTagContent("
> > http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=~~~~~
> > ","h1",0,"title="""))****
> >
> > ** **
> >
> > I canâ€™t see any difference and I still get the error. But then I
> > remembered that I have on-going problems with MSN elements on My Vista 64
> > bit system. I have not been able to resolve the MSN issue ****
> >
> > ** **
> >
> > So I tried it on my Windows 7 32 bit machine I then discovered I could not
> > get the smfFixLinks macro to convert the links to the new system. Iâ€™ll
> > post a new message on this issue.
> >
>

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

3a

Zacks ranking

Sat Sep 14, 2013 8:10 pm (PDT) . Posted by:

joelfp2000

Randy,

It doesn't appear that element # 848 is working (Zack's ranking).

Thanks in advance for your help and for all of your hard work in
keeping this add-in up to date!

Joel

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

3b

Re: Zacks ranking

Sat Sep 14, 2013 9:08 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I just tried:

=RCHGetElementNumber("MMM";,848)

...and it worked fine for me. Maybe Zacks was updating and down?

On Sat, Sep 14, 2013 at 8:10 PM, <joel.andrews@lpl.com> wrote:

>
>
> It doesn't appear that element # 848 is working (Zack's ranking).
>
>