RCHGetElementNumber() -- Documentation

Documentation for RCHGetElementNumber() function

Description

Returns a specific data element from a specified data source (i.e. web page).

Syntax

=RCHGetElementNumber( ticker , elementnumber [, errorvalue ] )

Parameters

ticker	=	A ticker symbol indicating which company data is to be returned for. In addition, there are several literals that can be specified for this parameter to request other information. See the "Examples" section for more details.
elementnumber	=	A number specifying which data element is to be retrieved for a ticker symbol. A list of element numbers and the data sources and data elements they are related to can be found in the RCHGetElementNumber-Element-Definitions.xls workbook distributed with the add-in.
errorvalue	=	A string or numeric value to be returned if there is an error in finding the data element. A default value of "error" is used if nothing is passed. This can prevent needing to put IF() statements in a cell to make a display or calculation of items easier to read.

Examples

Example Formula	Value Returned	Description
=RCHGetElementNumber("Version")	Stock Market Functions add-in, Version 2.0j	Tells you which version of the add-in you are using.
=RCHGetElementNumber("Source",941)	YahooKS	Gives you the data source for element number 941
=RCHGetElementNumber("Element",941)	Market Cap	Gives you the element name for element number 941
=RCHGetElementNumber("Web Page",941)	http://finance.yahoo.com/q/ks?s=~~~~~	Gives you the web page element number 941 is retrieved from ("~~~~~" is the ticker symbol)
=RCHGetElementNumber("ElementFile",941)	. ...folder...\smf-element-nn.txt	Gives you the "smf-element-nn.txt" name and file date/time that 941 was (last) loaded from.
=RCHGetElementNumber("IBM", 941)	119,670,000	Market Capitalization from data source "YahooKS" for ticker "IBM"
=RCHGetElementNumber("IBM", 1541)	119,670,000,000	Market Capitalization from data source "MSN" for ticker "IBM"

=RCHGetElementNumber("P-URL",941)	http://finance.yahoo.com/q/ks?s=~~~~~	RCHGetTableCell() function parameter
=RCHGetElementNumber("P-Cells",941)	1	RCHGetTableCell() function parameter
=RCHGetElementNumber("P-Find1",941)	VALUATION MEASURES	RCHGetTableCell() function parameter
=RCHGetElementNumber("P-Find2",941)	MARKET CAP	RCHGetTableCell() function parameter
=RCHGetElementNumber("P-Find3",941)		RCHGetTableCell() function parameter
=RCHGetElementNumber("P-Find4",941)		RCHGetTableCell() function parameter
=RCHGetElementNumber("P-Rows",941)	0	RCHGetTableCell() function parameter
=RCHGetElementNumber("P-End",941)	0	RCHGetTableCell() function parameter
=RCHGetElementNumber("P-Look",941)	0	RCHGetTableCell() function parameter
=RCHGetElementNumber("P-Type",941)	0	RCHGetTableCell() function parameter

Usage notes

When elements are retrieved, the source code of the web page is saved in an array within the VBA environment, then the element is extracted from that source code. It is done that way so that when a number of elements are retrieved from the same web page, the web page only needs to be retrieved once. Note that the array to save web pages is limited to 1000 pages. Anything beyond that will get an error message. The entire array can be reset by either exiting and re-entering EXCEL or by running the smfForceRecalculation macro. This macro purges all saved web pages and reacalculates all functions.
...coming later...