This group is the home base for the Stock Market Functions add-in developed by Randy Harmelink. This add-in contains a number of user defined functions for EXCEL that can allow data to be extracted and/or retrieved from the web and placed directly into EXCEL cells or ranges.
The files area of this group contains the add-in, documentation on its functions, and a number of templates that have examples of how the various functions can be used. The add-in was developed using EXCEL 2002 under a WinXP operating system, so other platforms and/or versions may have issues.
If you're reporting a problem, remember that I'm not a mind reader -- "It doesn't work right" is not a helpful description of a problem. Please try to include relevant information, such as:
-- The specific function(s) or template(s) you are having problems with.
-- The parameter(s) you are using with the function(s).
-- The version of EXCEL you use.
-- The operating system you're running EXCEL under.
-- The steps you took to try to resolve the problem.
-- The ticker symbols or URLs that are being used.
-- The results you expect to get and what you actually get.
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
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
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
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: