Syntax: INDEXCONSTITUENTS(Index Ticker, AutoFormat)


Equivalent Function Names: IC


Purpose: Function used to retrieve current constituents of an index



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


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