4 New Messages

Digest #2878

Morningstar text changing problem by jovica.bozic

Re: Morningstar text changing problem by "Randy Harmelink" rharmelink

I installed the SMF add in yesterday,,,,not working by d0c59d6d82cd1e8632aab23a655b26f4

Re: I installed the SMF add in yesterday,,,,not working [2 Attachmen by "Randy Harmelink" rharmelink

Messages

1a

Morningstar text changing problem

Thu Nov 28, 2013 1:59 am (PST) . Posted by:

jovica.bozic

My method is to retrieve data to sheet1 with smfGetCSVFile and in sheet2 to sort and organize data with match/index function, based on some standard financial report that suits my needs.
But, after looking at just 3 companies I've noticed that text is changing every time (e.g. Net Property, Plant... to Property, Plant...,net, or Income before taxes to Income before income taxes) so I get an error with match function. How can I fix that problem?

Thanks.

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

1b

Re: Morningstar text changing problem

Thu Nov 28, 2013 3:21 am (PST) . Posted by:

"Randy Harmelink" rharmelink

I'm not sure there is any reliable solution, if MorningStar can provide any
number of variations on the line item labels. You certainly can't itemize
them all.

On Thu, Nov 28, 2013 at 2:59 AM, <jovica.bozic@yahoo.com> wrote:

>
> My method is to retrieve data to sheet1 with smfGetCSVFile and in sheet2
> to sort and organize data with match/index function, based on some standard
> financial report that suits my needs.
> But, after looking at just 3 companies I've noticed that text is changing
> every time (e.g. Net Property, Plant... to Property, Plant...,net, or
> Income before taxes to Income before income taxes) so I get an error with
> match function. How can I fix that problem?
>

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

2a

I installed the SMF add in yesterday,,,,not working

Thu Nov 28, 2013 4:19 pm (PST) . Posted by:

d0c59d6d82cd1e8632aab23a655b26f4

This my first try to use Rchgetelementnumber(GOOG,34) and it showed me an error message...
I don't know where I was wrong.....

Attachments with this message:

2 of 2 Photo(s)

AAAAAAAAA.png

KKKKKKKKKK.png

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

2b

Re: I installed the SMF add in yesterday,,,,not working [2 Attachmen

Thu Nov 28, 2013 4:30 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Hmmm. What do you get with:

=RCHGetElementNumber("Version")
=smfGetAParms(34)

Do you see a print report if you open up this web page in the EXCEL Web
Query dialog (keyboard shortcut alt+d+d+w, cancel out when done):

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=GOOG

Double-hmmm. I just tried that page in FireFox and got a web page with
about 5 lines of data on it. I wonder if MSN is buggy/glitchy today, or
maybe just one of their servers, since it worked fine the second time?

You can try using the smfForceRecalculation macro (more info on it in the
LINKS area of the group), to force the add-in to get a fresh copy of the
web page.

On Thu, Nov 28, 2013 at 3:41 PM, <tajieamber@sina.com> wrote:

> This my first try to use Rchgetelementnumber(GOOG,34) and it showed me
> an error message...
>
> I don't know where I was wrong.....
>