Hi there, Each time I use the GetElementNUmber I get the "Undefined" message instead of the value I am searching. Does anyone know what it is happening?...
That sounds like you didn't unzip all of the contents of the ZIP file into the folder that contains the add-in. The element definitions are in TXT files that...
The more important question would be who's definitions did you want? They can vary quite a bit based on the source. If you have a large number of them that...
got it, somthing weird on the darn trust center settings. had to play with edit links. Sorry about that. This add-in along with excel 2007 VBA capabilities ...
Randy, Many thanks for the pointer. Whose sector/industry definitions are available through your function set? My preference would be for those from S&P or...
... If you have a source, one of the functions can probably get at it. There are elements defined for the Morningstar items: 877 Industry 878 Sector I...
FYI, I do not believe that you will find S&P (GICS) sectors and industries on any free site. I believe you need to pay for, and be licensed to use that piece...
I should also point out that there are licensing rules for much of this sort of information, including for GICS, which is 'owned' by S&P and MSCI. Generally...
I wrote some VBA code in Access 2002 to open up my excel spreadsheet and update the spreadsheet. I am using the GetElementNumber function. I thought that...
Randy, Any plans on providing an RSS related function as part of the addin? Many news feeds including Bloomberg and Reuters, Yahoo, and others are delivered...
I do this with access 2007 and its not a problem, however I open the excel file with a macro in access. I use the RunApp in the action column then something...
I'm not sure I see the advantage of that, versus picking them up off a web page. The point of an RSS reader is for it to periodically check the feed for new...
Hi, I am a new member and haven't yet explored the group too much so please forgive if this is irrelevant to the forum. However, I just started day trading and...
Check out this template in the files area: RCHGetWebData-Template-BarChart-Quotes-Extract.xls When BarChart.com displays charts on the web page, they do have...
Ahh, but you don't get the links off the web page (not easily anyways), or the summaries of the article. No worries, will see if I can find something that...
H Randyi, I would like to use the template RCHGetWebData-Template-BarChart-Quotes-Extract.xls (very nice work!) for a batch vba-task. Two Questions arise: ...
How can I log into Morningstar via EXCEL Web Query process. When I try to log in via IE, even as a premium member, I frequently get "Premium" instead of the...
Keyboard shortcut alt-d-d-w opens up the EXCEL Web Query dialog window. Just navigate to Morningstar and log in normally. After that, functions should work...
Sounds like you might not be setting the 'Remember my login information' Check Box on the Morningstar login screen. I seem to forget to do that about half the...