IndexConstituents

 

Syntax: INDEXCONSTITUENTS(Index Ticker, AutoFormat)

 

Equivalent Function Names: IC

 

Purpose: Function used to retrieve current constituents of an index

 

Parameters: 
 

1.IndexTicker is a Yahoo index ticker.

 

2.AutoFormat - an optional flag signifying if the result should be automatically converted to a range and if the result should be automatically formatted as Excel Data Types
 

Examples:

1. Retrieve components of an index

=IC("^DJI") retrieves tickers of all constituents of Dow Jones Industrial Index. AutoRange automatically expands the result.
 

 

 

 

Copyright © 2013-2017 Jiri Pik

Document Version: Sunday, May 7, 2017