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.
Randy: Is there an example of capturing the newly reformated IBD Stock Checkup data in a Horizontal line format for a limited list of stocks, one per line? I
Unfortunately, the RCHGetYahooHistory() function can only return the data that Yahoo is providing... You may be able to use something like this source:
I'm stuck. Using the RCHGetYahooHistory function, is there a way to get the daily volumes for the NYSE and the NASDAQ? I've used ticker ^NYA but it doesn't
Those are acronyms related to the Covered Call workbooks: RIU = Return If Unchanged (that is, the price of the underlying security) RIE = Return If Exercised