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.
RCHGetElementNumber() is only designed to get one data element at a time. And you CANNOT use it to get data on thousands of tickers in a single spreadsheet.
Hey, I tried to do an array formula using =RCHGetElementNumber(A2:A6483,341) A2:A6483 is the list of tickers. The only values I was able to get are #VALUE! Is
I have no life. :) Actually, it's kind of like my version of sitting down to do crossword or Sodoku puzzles. I've been doing it as long as I can remember.
=RCHGetTableCell( URL, Cell#, [Find1], [Find2], [Find3], [Find4], [Row#], [EndMarker], [Look#], [ErrorMsg], [Type] ) I was using the row put failed to use the