Selasa, 07 April 2015

[smf_addin] Digest Number 3376

7 Messages

Digest #3376
2b
Re: Morning Star Premium by "Randy Harmelink" rharmelink
2d
Re: Morning Star Premium by "Randy Harmelink" rharmelink
3a
Element #13670 by "Ernst von Fischer" vonfischer22
3b
Re: Element #13670 by "Randy Harmelink" rharmelink

Messages

Mon Apr 6, 2015 4:08 am (PDT) . Posted by:

alonch77

ok thanks for the answers, if anyone knows a good way (also to buy) to download this amount of data without getting the url changed Thanks

Mon Apr 6, 2015 6:15 am (PDT) . Posted by:

kjtemplin

I have Morningstar premium and I am trying to use some of the data elements in Elements #4 but to no avail. I just get "error" returned on the formula. I have been reading how to access on this forum but it is not clear the additional steps needed. Sorry I can't be of more help.

Mon Apr 6, 2015 8:10 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I just tried elements #886 thru #891, just to check, and they're working
fine here.

You do need to log into MorningStar to use those data items, since they are
for subscribers only. But you have to log in with either the EXCEL Web
Query dialog (preferred, keyboard shortcut alt+d+d+w) or with IE, because
EXCEL and the add-in need an IE security cookie in order to be able to
access the subscriber only data.

Note that once you log in, you will need to run the smfForceRecalculation
macro to get fresh copies of previously accessed web pages, otherwise
you'll be extracting data from the add-in's saved web pages that were
retrieved before you logged in.

On Mon, Apr 6, 2015 at 6:15 AM, kjtemplin@icloud.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I have Morningstar premium and I am trying to use some of the data
> elements in Elements #4 but to no avail. I just get "error" returned on
> the formula. I have been reading how to access on this forum but it is not
> clear the additional steps needed. Sorry I can't be of more help.
>

Mon Apr 6, 2015 1:09 pm (PDT) . Posted by:

kjtemplin

Randy:

Thanks so much. That was the missing link. I just did not know how to log into my account at Morningstar in Excel. I did not find those instructions or passed over them in my search.


Question: Do I need to sign in on Excel's Web Query every time I update the spreadsheet? I can't tell if it saves anything other than the web address.


Thanks again for the help.
Ken Templin

Mon Apr 6, 2015 1:29 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

It's the IE security cookie that allows EXCEL and the add-in access to the
website, because EXCEL and the add-in use a MicroSoft process to grab data
from the Internet - the same one IE uses. So it all depends on how you have
your IE cookies managed. Some people have browser settings or tools that
delete them every day. Others let them expire normally. I haven't needed to
log in for weeks, maybe even months, and I can still access the premium
data.

When I get an "Error" result from MorningStar, my first reaction is to open
up the Morningstar.com website in the EXCEL Web Query browser to see if I'm
logged in (i.e. it says "Welcome Randy"). After that, I run the
smfForceRecalculation macro to get a fresh web page retrieval. If that
doesn't fix it, I've usually got some serious issue to look into.
Thankfully, that's a rare occurrence. :)

Morningstar used to do a redirection on the first visit to the web site,
for possible advertising. That was also cookie directed, and required a
visit to the website with either the IE object in the EXCEL Web Query
dialog, or with the IE browser, just to get the cookie set to say the
website had already been visited. I haven't run into that in a while, so
they may no longer be doing it...but the solution was the same.

On Mon, Apr 6, 2015 at 1:09 PM, kjtemplin@icloud.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Question: Do I need to sign in on Excel's Web Query every time I update
> the spreadsheet? I can't tell if it saves anything other than the web
> address.
>
>

Mon Apr 6, 2015 8:44 am (PDT) . Posted by:

"Ernst von Fischer" vonfischer22

It seems that the ReutersRat element #13670 doesn't work any more. It worked
before and the Reuters website is still showing "Dividend Yield - 5 Year
Avg" figures, but the addin hasn't been downloading it at least for the past
couple of weeks. Any advice?

Mon Apr 6, 2015 12:42 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Thanks for the heads up. I updated Reuters elements 13670 to 13672 and 732
on smf-elements-5.txt for changes they've made to the web page. Just labels
they use to identify items.

The new smf-elements-5.txt file can be found on the "Works in Progress" web
page. Best practice is to update that file when EXCEL is closed.

On Mon, Apr 6, 2015 at 8:44 AM, 'Ernst von Fischer' ernst.von.fischer@...
wrote:

>
> It seems that the ReutersRat element #13670 doesn't work any more. It
> worked before and the Reuters website is still showing "Dividend Yield – 5
> Year Avg" figures, but the addin hasn't been downloading it at least for
> the past couple of weeks. Any advice?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar