smfGetYahooPortfolioView() -- Documentation

Documentation for smfGetYahooPortfolioView() function

Description

Returns stock quotes and other data from the Yahoo Portfolios JSON file to an EXCEL range.

Syntax

=smfGetYahooPortfolioView(tickerlist, [fieldlist], [multiples], [headers] ,[rows],[columns])

Parameters

Tickerlist	=	A list of ticker symbols to get quotes and/or other data for from the Yahoo Portfolios JSON file. This parameter can either be a single ticker symbol, a comma-delimited list of ticker symbols, a cell reference, or a range reference. Passing "None" as the first ticker symbol will bypass calculation.
Fieldlist	=	An optional list of field number codes indicating which fields are desired. Each field number code is a 2-byte string ranging from "00" to "91". This parameter can either be a string concatenation of all desired field number codes, a cell reference, or a range reference (which can be numbers instead of 2-byte strings). See the example template for a list of the available field number codes. The default value for this parameter is to display all 91 available fields.
Multiples	=	An optional parameter that allows a ticker symbol to be returned more than once. Defaults to "N", but can be set to "Y" to allow multiples.
Headers	=	An optional parameter that allows column headings to be generated for the returned columns of data. Defaults to 0, but can be set to 1 if you want headers on your output data.
Rows and Columns	=	These are advanced optional parameters to override the size of the returned array of data. Normally, the returned array size is set by the range the formula is entered over. However, if other functions or VBA are involved, these allow the size of the returned range to be specifically set.

Examples

This would be array-entered over a 3-row by 2-column range to return the symbol & last traded price for ticker symbols IBM and MMM
The last parm being 1 will add headers as the first row:

Symbol	Last Price
AAPL	170.48
MMM	93.73

This next example you woul have the fields/elements in C3 to E3 and the tickers would be in B5 to B6.
The formula would be array-entered over a 3-row by 3-column range (C4:E6).
This will return the long name, last traded price & 52-Wk Low for the ticker symbols AAPL and MMM

	2	15	63
	Long Name	Last Price	52-Wk Low
AAPL	Apple Inc.	170.48	147.70
MMM	3M Company	93.73	85.35

Usage notes

In almost all cases, this will need to be an array-entered formula. To array-enter a formula in EXCEL, first highlight the range of cells where you would like the returned data to appear
The number of rows for the range should be AT LEAST the number of ticker symbols you are requesting from the function, while the number of columns for the range should be AT LEAST the number of data items you are requesting for each ticker symbol from the function. Next, enter your formula and then press Ctrl-Shift-Enter.
The smfForceRecalculation macro would typically be used to refresh the function results. A simple EXCEL recalculation (e.g. F9) will not work.
The SMF context menu (available via a right mouse click) also has a "Recalculate Selection" option that can recalculate the smfGetYahooPortfolioView() table.
First highlight the range used by the function and then select the context menu option.