> Stocks, forex, crypto, bonds, comodities, economic data and more made easy. Find examples for accessing every **IEX** endpoint using **Cryptosheets** through: - `side panel console` - `custom functions` (Excel & Googlesheets) - `templates` ## Excel

| App Url | Docs Url | Name | Example | Parameters | # of Parameters | | --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | --------------------------------------------------- | -------- | ----------- | | Try It | [Docs](/providers/iex/logo) | **Logo** | =CS.QUERY("IEX","Logo") | =CS.PARAMETERS("IEX","Logo") | 2 | | Try It | [Docs](/providers/iex/book) | **Book** | =CS.QUERY("IEX","Book") | =CS.PARAMETERS("IEX","Book") | 2 | | Try It | [Docs](/providers/iex/stock-historical-prices) | **Stock Historical Prices** | =CS.QUERY("IEX","Stock Historical Prices") | =CS.PARAMETERS("IEX","Stock Historical Prices") | 12 | | Try It | [Docs](/providers/iex/stock-historical-prices---range) | **Stock Historical Prices - Range** | =CS.QUERY("IEX","Stock Historical Prices - Range") | =CS.PARAMETERS("IEX","Stock Historical Prices - Range") | 13 | | Try It | [Docs](/providers/iex/stock-historical-prices---date) | **Stock Historical Prices - Date** | =CS.QUERY("IEX","Stock Historical Prices - Date") | =CS.PARAMETERS("IEX","Stock Historical Prices - Date") | 13 | | Try It | [Docs](/providers/iex/cryptocurrency-quotes) | **Cryptocurrency Quotes** | =CS.QUERY("IEX","Cryptocurrency Quotes") | =CS.PARAMETERS("IEX","Cryptocurrency Quotes") | 2 | | Try It | [Docs](/providers/iex/historical-energy-prices) | **Historical Energy Prices** | =CS.QUERY("IEX","Historical Energy Prices") | =CS.PARAMETERS("IEX","Historical Energy Prices") | 13 | | Try It | [Docs](/providers/iex/cryptocurrency-symbols) | **Cryptocurrency Symbols** | =CS.QUERY("IEX","Cryptocurrency Symbols") | =CS.PARAMETERS("IEX","Cryptocurrency Symbols") | 1 | | Try It | [Docs](/providers/iex/fx-symbols) | **FX Symbols** | =CS.QUERY("IEX","FX Symbols") | =CS.PARAMETERS("IEX","FX Symbols") | 1 | | Try It | [Docs](/providers/iex/iex-symbols) | **IEX Symbols** | =CS.QUERY("IEX","IEX Symbols") | =CS.PARAMETERS("IEX","IEX Symbols") | 1 | | Try It | [Docs](/providers/iex/international-exchanges) | **International Exchanges** | =CS.QUERY("IEX","International Exchanges") | =CS.PARAMETERS("IEX","International Exchanges") | 1 | | Try It | [Docs](/providers/iex/mutual-fund-symbols) | **Mutual Fund Symbols** | =CS.QUERY("IEX","Mutual Fund Symbols") | =CS.PARAMETERS("IEX","Mutual Fund Symbols") | 1 | | Try It | [Docs](/providers/iex/options-symbols) | **Options Symbols** | =CS.QUERY("IEX","Options Symbols") | =CS.PARAMETERS("IEX","Options Symbols") | 1 | | Try It | [Docs](/providers/iex/otc-symbols) | **OTC Symbols** | =CS.QUERY("IEX","OTC Symbols") | =CS.PARAMETERS("IEX","OTC Symbols") | 1 | | Try It | [Docs](/providers/iex/sectors) | **Sectors** | =CS.QUERY("IEX","Sectors") | =CS.PARAMETERS("IEX","Sectors") | 1 | | Try It | [Docs](/providers/iex/symbols) | **Symbols** | =CS.QUERY("IEX","Symbols") | =CS.PARAMETERS("IEX","Symbols") | 1 | | Try It | [Docs](/providers/iex/tags) | **Tags** | =CS.QUERY("IEX","Tags") | =CS.PARAMETERS("IEX","Tags") | 1 | | Try It | [Docs](/providers/iex/u.s.-exchanges) | **U.S. Exchanges** | =CS.QUERY("IEX","U.S. Exchanges") | =CS.PARAMETERS("IEX","U.S. Exchanges") | 1 | | Try It | [Docs](/providers/iex/historical-economic-data) | **Historical Economic Data** | =CS.QUERY("IEX","Historical Economic Data") | =CS.PARAMETERS("IEX","Historical Economic Data") | 13 | | Try It | [Docs](/providers/iex/historical-treasuries-rates) | **Historical Treasuries Rates** | =CS.QUERY("IEX","Historical Treasuries Rates") | =CS.PARAMETERS("IEX","Historical Treasuries Rates") | 13 | | Try It | [Docs](/providers/iex/current-market-data-keys) | **Current Market Data Keys** | =CS.QUERY("IEX","Current Market Data Keys") | =CS.PARAMETERS("IEX","Current Market Data Keys") | 2 | | Try It | [Docs](/providers/iex/current-market-data-point) | **Current Market Data Point** | =CS.QUERY("IEX","Current Market Data Point") | =CS.PARAMETERS("IEX","Current Market Data Point") | 3 | | Try It | [Docs](/providers/iex/iex-tops) | **IEX TOPS** | =CS.QUERY("IEX","IEX TOPS") | =CS.PARAMETERS("IEX","IEX TOPS") | 1 | | Try It | [Docs](/providers/iex/iex-tops-last) | **IEX TOPS Last** | =CS.QUERY("IEX","IEX TOPS Last") | =CS.PARAMETERS("IEX","IEX TOPS Last") | 1 | | Try It | [Docs](/providers/iex/cryptocurrency-book) | **Cryptocurrency Book** | =CS.QUERY("IEX","Cryptocurrency Book") | =CS.PARAMETERS("IEX","Cryptocurrency Book") | 2 | | Try It | [Docs](/providers/iex/cryptocurrency-price) | **Cryptocurrency Price** | =CS.QUERY("IEX","Cryptocurrency Price") | =CS.PARAMETERS("IEX","Cryptocurrency Price") | 2 | | Try It | [Docs](/providers/iex/latest-currency-rates) | **Latest Currency Rates** | =CS.QUERY("IEX","Latest Currency Rates") | =CS.PARAMETERS("IEX","Latest Currency Rates") | 1 | | Try It | [Docs](/providers/iex/currency-conversion) | **Currency Conversion** | =CS.QUERY("IEX","Currency Conversion") | =CS.PARAMETERS("IEX","Currency Conversion") | 3 | | Try It | [Docs](/providers/iex/search) | **Search** | =CS.QUERY("IEX","Search") | =CS.PARAMETERS("IEX","Search") | 2 | | Try It | [Docs](/providers/iex/international-symbols-by-exchange) | **International Symbols by Exchange** | =CS.QUERY("IEX","International Symbols by Exchange") | =CS.PARAMETERS("IEX","International Symbols by Exchange") | 2 | | Try It | [Docs](/providers/iex/international-symbols-by-region) | **International Symbols by Region** | =CS.QUERY("IEX","International Symbols by Region") | =CS.PARAMETERS("IEX","International Symbols by Region") | 2 | | Try It | [Docs](/providers/iex/stats-historical-summary) | **Stats Historical Summary** | =CS.QUERY("IEX","Stats Historical Summary") | =CS.PARAMETERS("IEX","Stats Historical Summary") | 2 | | Try It | [Docs](/providers/iex/stats-intraday) | **Stats Intraday** | =CS.QUERY("IEX","Stats Intraday") | =CS.PARAMETERS("IEX","Stats Intraday") | 1 | | Try It | [Docs](/providers/iex/stats-recent) | **Stats Recent** | =CS.QUERY("IEX","Stats Recent") | =CS.PARAMETERS("IEX","Stats Recent") | 1 | | Try It | [Docs](/providers/iex/stats-records) | **Stats Records** | =CS.QUERY("IEX","Stats Records") | =CS.PARAMETERS("IEX","Stats Records") | 1 | | Try It | [Docs](/providers/iex/collections) | **Collections** | =CS.QUERY("IEX","Collections") | =CS.PARAMETERS("IEX","Collections") | 3 | | Try It | [Docs](/providers/iex/earnings-today) | **Earnings Today** | =CS.QUERY("IEX","Earnings Today") | =CS.PARAMETERS("IEX","Earnings Today") | 1 | | Try It | [Docs](/providers/iex/ipos-today) | **IPOs Today** | =CS.QUERY("IEX","IPOs Today") | =CS.PARAMETERS("IEX","IPOs Today") | 1 | | Try It | [Docs](/providers/iex/upcoming-ipos) | **Upcoming IPOS** | =CS.QUERY("IEX","Upcoming IPOS") | =CS.PARAMETERS("IEX","Upcoming IPOS") | 1 | | Try It | [Docs](/providers/iex/list) | **List** | =CS.QUERY("IEX","List") | =CS.PARAMETERS("IEX","List") | 4 | | Try It | [Docs](/providers/iex/sector-performance) | **Sector Performance** | =CS.QUERY("IEX","Sector Performance") | =CS.PARAMETERS("IEX","Sector Performance") | 1 | | Try It | [Docs](/providers/iex/market-volume) | **Market Volume** | =CS.QUERY("IEX","Market Volume") | =CS.PARAMETERS("IEX","Market Volume") | 1 | | Try It | [Docs](/providers/iex/deep) | **DEEP** | =CS.QUERY("IEX","DEEP") | =CS.PARAMETERS("IEX","DEEP") | 2 | | Try It | [Docs](/providers/iex/deep-auction) | **DEEP Auction** | =CS.QUERY("IEX","DEEP Auction") | =CS.PARAMETERS("IEX","DEEP Auction") | 2 | | Try It | [Docs](/providers/iex/deep-book) | **DEEP Book** | =CS.QUERY("IEX","DEEP Book") | =CS.PARAMETERS("IEX","DEEP Book") | 2 | | Try It | [Docs](/providers/iex/deep-operational-halt-status) | **DEEP Operational Halt Status** | =CS.QUERY("IEX","DEEP Operational Halt Status") | =CS.PARAMETERS("IEX","DEEP Operational Halt Status") | 2 | | Try It | [Docs](/providers/iex/deep-official-price) | **DEEP Official Price** | =CS.QUERY("IEX","DEEP Official Price") | =CS.PARAMETERS("IEX","DEEP Official Price") | 2 | | Try It | [Docs](/providers/iex/deep-security-event) | **DEEP Security Event** | =CS.QUERY("IEX","DEEP Security Event") | =CS.PARAMETERS("IEX","DEEP Security Event") | 2 | | Try It | [Docs](/providers/iex/deep-short-sale-price-test-status) | **DEEP Short Sale Price Test Status** | =CS.QUERY("IEX","DEEP Short Sale Price Test Status") | =CS.PARAMETERS("IEX","DEEP Short Sale Price Test Status") | 2 | | Try It | [Docs](/providers/iex/deep-system-event) | **DEEP System Event** | =CS.QUERY("IEX","DEEP System Event") | =CS.PARAMETERS("IEX","DEEP System Event") | 1 | | Try It | [Docs](/providers/iex/deep-trades) | **DEEP Trades** | =CS.QUERY("IEX","DEEP Trades") | =CS.PARAMETERS("IEX","DEEP Trades") | 3 | | Try It | [Docs](/providers/iex/deep-trade-break) | **DEEP Trade Break** | =CS.QUERY("IEX","DEEP Trade Break") | =CS.PARAMETERS("IEX","DEEP Trade Break") | 3 | | Try It | [Docs](/providers/iex/deep-trading-status) | **DEEP Trading Status** | =CS.QUERY("IEX","DEEP Trading Status") | =CS.PARAMETERS("IEX","DEEP Trading Status") | 2 | | Try It | [Docs](/providers/iex/financials-as-reported-by-filing) | **Financials As Reported by Filing** | =CS.QUERY("IEX","Financials As Reported by Filing") | =CS.PARAMETERS("IEX","Financials As Reported by Filing") | 14 | | Try It | [Docs](/providers/iex/financials-as-reported---all) | **Financials As Reported - ALL** | =CS.QUERY("IEX","Financials As Reported - ALL") | =CS.PARAMETERS("IEX","Financials As Reported - ALL") | 13 | | Try It | [Docs](/providers/iex/historical-news-by-symbol) | **Historical News by Symbol** | =CS.QUERY("IEX","Historical News by Symbol") | =CS.PARAMETERS("IEX","Historical News by Symbol") | 13 | | Try It | [Docs](/providers/iex/historical-news---all) | **Historical News - All** | =CS.QUERY("IEX","Historical News - All") | =CS.PARAMETERS("IEX","Historical News - All") | 12 | | Try It | [Docs](/providers/iex/bonus-issue) | **Bonus Issue** | =CS.QUERY("IEX","Bonus Issue") | =CS.PARAMETERS("IEX","Bonus Issue") | 12 | | Try It | [Docs](/providers/iex/distribution) | **Distribution** | =CS.QUERY("IEX","Distribution") | =CS.PARAMETERS("IEX","Distribution") | 12 | | Try It | [Docs](/providers/iex/dividends) | **Dividends** | =CS.QUERY("IEX","Dividends") | =CS.PARAMETERS("IEX","Dividends") | 12 | | Try It | [Docs](/providers/iex/return-of-capital) | **Return of Capital** | =CS.QUERY("IEX","Return of Capital") | =CS.PARAMETERS("IEX","Return of Capital") | 12 | | Try It | [Docs](/providers/iex/rights-issue) | **Rights Issue** | =CS.QUERY("IEX","Rights Issue") | =CS.PARAMETERS("IEX","Rights Issue") | 12 | | Try It | [Docs](/providers/iex/right-to-purchase) | **Right to Purchase** | =CS.QUERY("IEX","Right to Purchase") | =CS.PARAMETERS("IEX","Right to Purchase") | 12 | | Try It | [Docs](/providers/iex/security-reclassification) | **Security Reclassification** | =CS.QUERY("IEX","Security Reclassification") | =CS.PARAMETERS("IEX","Security Reclassification") | 12 | | Try It | [Docs](/providers/iex/security-swap) | **Security Swap** | =CS.QUERY("IEX","Security Swap") | =CS.PARAMETERS("IEX","Security Swap") | 12 | | Try It | [Docs](/providers/iex/spinoff) | **Spinoff** | =CS.QUERY("IEX","Spinoff") | =CS.PARAMETERS("IEX","Spinoff") | 12 | | Try It | [Docs](/providers/iex/splits) | **Splits** | =CS.QUERY("IEX","Splits") | =CS.PARAMETERS("IEX","Splits") | 12 | | Try It | [Docs](/providers/iex/bonus-issue-by-symbol) | **Bonus Issue by Symbol** | =CS.QUERY("IEX","Bonus Issue by Symbol") | =CS.PARAMETERS("IEX","Bonus Issue by Symbol") | 13 | | Try It | [Docs](/providers/iex/distribution-by-symbol) | **Distribution by Symbol** | =CS.QUERY("IEX","Distribution by Symbol") | =CS.PARAMETERS("IEX","Distribution by Symbol") | 13 | | Try It | [Docs](/providers/iex/dividends-by-symbol) | **Dividends by Symbol** | =CS.QUERY("IEX","Dividends by Symbol") | =CS.PARAMETERS("IEX","Dividends by Symbol") | 13 | | Try It | [Docs](/providers/iex/return-of-capital-by-symbol) | **Return of Capital by Symbol** | =CS.QUERY("IEX","Return of Capital by Symbol") | =CS.PARAMETERS("IEX","Return of Capital by Symbol") | 13 | | Try It | [Docs](/providers/iex/rights-issue-by-symbol) | **Rights Issue by Symbol** | =CS.QUERY("IEX","Rights Issue by Symbol") | =CS.PARAMETERS("IEX","Rights Issue by Symbol") | 13 | | Try It | [Docs](/providers/iex/right-to-purchase-by-symbol) | **Right to Purchase by Symbol** | =CS.QUERY("IEX","Right to Purchase by Symbol") | =CS.PARAMETERS("IEX","Right to Purchase by Symbol") | 13 | | Try It | [Docs](/providers/iex/security-reclassification-by-symbol) | **Security Reclassification by Symbol** | =CS.QUERY("IEX","Security Reclassification by Symbol") | =CS.PARAMETERS("IEX","Security Reclassification by Symbol") | 13 | | Try It | [Docs](/providers/iex/security-swap-by-symbol) | **Security Swap by Symbol** | =CS.QUERY("IEX","Security Swap by Symbol") | =CS.PARAMETERS("IEX","Security Swap by Symbol") | 13 | | Try It | [Docs](/providers/iex/spinoff-by-symbol) | **Spinoff by Symbol** | =CS.QUERY("IEX","Spinoff by Symbol") | =CS.PARAMETERS("IEX","Spinoff by Symbol") | 13 | | Try It | [Docs](/providers/iex/splits-by-symbol) | **Splits by Symbol** | =CS.QUERY("IEX","Splits by Symbol") | =CS.PARAMETERS("IEX","Splits by Symbol") | 13 | | Try It | [Docs](/providers/iex/intraday-prices) | **Intraday Prices** | =CS.QUERY("IEX","Intraday Prices") | =CS.PARAMETERS("IEX","Intraday Prices") | 10 | | Try It | [Docs](/providers/iex/delayed-quote) | **Delayed Quote** | =CS.QUERY("IEX","Delayed Quote") | =CS.PARAMETERS("IEX","Delayed Quote") | 3 | | Try It | [Docs](/providers/iex/largest-trades) | **Largest Trades** | =CS.QUERY("IEX","Largest Trades") | =CS.PARAMETERS("IEX","Largest Trades") | 2 | | Try It | [Docs](/providers/iex/ohlc) | **OHLC** | =CS.QUERY("IEX","OHLC") | =CS.PARAMETERS("IEX","OHLC") | 2 | | Try It | [Docs](/providers/iex/previous-day-price) | **Previous Day Price** | =CS.QUERY("IEX","Previous Day Price") | =CS.PARAMETERS("IEX","Previous Day Price") | 2 | | Try It | [Docs](/providers/iex/price-only) | **Price Only** | =CS.QUERY("IEX","Price Only") | =CS.PARAMETERS("IEX","Price Only") | 2 | | Try It | [Docs](/providers/iex/quote) | **Quote** | =CS.QUERY("IEX","Quote") | =CS.PARAMETERS("IEX","Quote") | 2 | | Try It | [Docs](/providers/iex/volume-by-venue) | **Volume by Venue** | =CS.QUERY("IEX","Volume by Venue") | =CS.PARAMETERS("IEX","Volume by Venue") | 2 | | Try It | [Docs](/providers/iex/company) | **Company** | =CS.QUERY("IEX","Company") | =CS.PARAMETERS("IEX","Company") | 2 | | Try It | [Docs](/providers/iex/insider-roster) | **Insider Roster** | =CS.QUERY("IEX","Insider Roster") | =CS.PARAMETERS("IEX","Insider Roster") | 2 | | Try It | [Docs](/providers/iex/insider-summary) | **Insider Summary** | =CS.QUERY("IEX","Insider Summary") | =CS.PARAMETERS("IEX","Insider Summary") | 2 | | Try It | [Docs](/providers/iex/insider-transactions) | **Insider Transactions** | =CS.QUERY("IEX","Insider Transactions") | =CS.PARAMETERS("IEX","Insider Transactions") | 2 | | Try It | [Docs](/providers/iex/peer-groups) | **Peer Groups** | =CS.QUERY("IEX","Peer Groups") | =CS.PARAMETERS("IEX","Peer Groups") | 2 | | Try It | [Docs](/providers/iex/balance-sheet) | **Balance Sheet** | =CS.QUERY("IEX","Balance Sheet") | =CS.PARAMETERS("IEX","Balance Sheet") | 4 | | Try It | [Docs](/providers/iex/cash-flow) | **Cash Flow** | =CS.QUERY("IEX","Cash Flow") | =CS.PARAMETERS("IEX","Cash Flow") | 4 | | Try It | [Docs](/providers/iex/dividends---basic) | **Dividends - Basic** | =CS.QUERY("IEX","Dividends - Basic") | =CS.PARAMETERS("IEX","Dividends - Basic") | 3 | | Try It | [Docs](/providers/iex/earnings) | **Earnings** | =CS.QUERY("IEX","Earnings") | =CS.PARAMETERS("IEX","Earnings") | 4 | | Try It | [Docs](/providers/iex/financials) | **Financials** | =CS.QUERY("IEX","Financials") | =CS.PARAMETERS("IEX","Financials") | 3 | | Try It | [Docs](/providers/iex/income-statement) | **Income Statement** | =CS.QUERY("IEX","Income Statement") | =CS.PARAMETERS("IEX","Income Statement") | 4 | | Try It | [Docs](/providers/iex/splits---basic) | **Splits - Basic** | =CS.QUERY("IEX","Splits - Basic") | =CS.PARAMETERS("IEX","Splits - Basic") | 3 | | Try It | [Docs](/providers/iex/advanced-stats) | **Advanced Stats** | =CS.QUERY("IEX","Advanced Stats") | =CS.PARAMETERS("IEX","Advanced Stats") | 2 | | Try It | [Docs](/providers/iex/analyst-recommendations) | **Analyst Recommendations** | =CS.QUERY("IEX","Analyst Recommendations") | =CS.PARAMETERS("IEX","Analyst Recommendations") | 2 | | Try It | [Docs](/providers/iex/estimates) | **Estimates** | =CS.QUERY("IEX","Estimates") | =CS.PARAMETERS("IEX","Estimates") | 2 | | Try It | [Docs](/providers/iex/fund-ownership) | **Fund Ownership** | =CS.QUERY("IEX","Fund Ownership") | =CS.PARAMETERS("IEX","Fund Ownership") | 2 | | Try It | [Docs](/providers/iex/institutional-ownership) | **Institutional Ownership** | =CS.QUERY("IEX","Institutional Ownership") | =CS.PARAMETERS("IEX","Institutional Ownership") | 2 | | Try It | [Docs](/providers/iex/key-stats) | **Key Stats** | =CS.QUERY("IEX","Key Stats") | =CS.PARAMETERS("IEX","Key Stats") | 2 | | Try It | [Docs](/providers/iex/price-target) | **Price Target** | =CS.QUERY("IEX","Price Target") | =CS.PARAMETERS("IEX","Price Target") | 2 | | Try It | [Docs](/providers/iex/end-of-day-options) | **End of Day Options** | =CS.QUERY("IEX","End of Day Options") | =CS.PARAMETERS("IEX","End of Day Options") | 3 | | Try It | [Docs](/providers/iex/social-sentiment) | **Social Sentiment** | =CS.QUERY("IEX","Social Sentiment") | =CS.PARAMETERS("IEX","Social Sentiment") | 2 | | Try It | [Docs](/providers/iex/ceo-compensation) | **CEO Compensation** | =CS.QUERY("IEX","CEO Compensation") | =CS.PARAMETERS("IEX","CEO Compensation") | 2 | | Try It | [Docs](/providers/iex/technical-indicators) | **Technical Indicators** | =CS.QUERY("IEX","Technical Indicators") | =CS.PARAMETERS("IEX","Technical Indicators") | 4 | | Try It | [Docs](/providers/iex/timeseries-keys) | **Timeseries Keys** | =CS.QUERY("IEX","Timeseries Keys") | =CS.PARAMETERS("IEX","Timeseries Keys") | 2 | | Try It | [Docs](/providers/iex/full-economic-timeseries) | **Full Economic Timeseries** | =CS.QUERY("IEX","Full Economic Timeseries") | =CS.PARAMETERS("IEX","Full Economic Timeseries") | 3 | | Try It | [Docs](/providers/iex/full-treasury-timeseries) | **Full Treasury Timeseries** | =CS.QUERY("IEX","Full Treasury Timeseries") | =CS.PARAMETERS("IEX","Full Treasury Timeseries") | 3 | | Try It | [Docs](/providers/iex/full-energy-timeseries) | **Full Energy Timeseries** | =CS.QUERY("IEX","Full Energy Timeseries") | =CS.PARAMETERS("IEX","Full Energy Timeseries") | 3 | | Try It | [Docs](/providers/iex/full-news-timeseries) | **Full News Timeseries** | =CS.QUERY("IEX","Full News Timeseries") | =CS.PARAMETERS("IEX","Full News Timeseries") | 3 |

## Google Sheets

| App Url | Docs Url | Name | Example | Parameters | # of Parameters | | --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | ------------------------------------------------------------------------------------------------------------------------------ | -------- | ----------- | | Try It | [Docs](/providers/iex/logo) | **Logo** | =CSQUERY("IEX","Logo") | =CSPARAMETERS("IEX","Logo") | 2 | | Try It | [Docs](/providers/iex/book) | **Book** | =CSQUERY("IEX","Book") | =CSPARAMETERS("IEX","Book") | 2 | | Try It | [Docs](/providers/iex/stock-historical-prices) | **Stock Historical Prices** | =CSQUERY("IEX","Stock Historical Prices") | =CSPARAMETERS("IEX","Stock Historical Prices") | 12 | | Try It | [Docs](/providers/iex/stock-historical-prices---range) | **Stock Historical Prices - Range** | =CSQUERY("IEX","Stock Historical Prices - Range") | =CSPARAMETERS("IEX","Stock Historical Prices - Range") | 13 | | Try It | [Docs](/providers/iex/stock-historical-prices---date) | **Stock Historical Prices - Date** | =CSQUERY("IEX","Stock Historical Prices - Date") | =CSPARAMETERS("IEX","Stock Historical Prices - Date") | 13 | | Try It | [Docs](/providers/iex/cryptocurrency-quotes) | **Cryptocurrency Quotes** | =CSQUERY("IEX","Cryptocurrency Quotes") | =CSPARAMETERS("IEX","Cryptocurrency Quotes") | 2 | | Try It | [Docs](/providers/iex/historical-energy-prices) | **Historical Energy Prices** | =CSQUERY("IEX","Historical Energy Prices") | =CSPARAMETERS("IEX","Historical Energy Prices") | 13 | | Try It | [Docs](/providers/iex/cryptocurrency-symbols) | **Cryptocurrency Symbols** | =CSQUERY("IEX","Cryptocurrency Symbols") | =CSPARAMETERS("IEX","Cryptocurrency Symbols") | 1 | | Try It | [Docs](/providers/iex/fx-symbols) | **FX Symbols** | =CSQUERY("IEX","FX Symbols") | =CSPARAMETERS("IEX","FX Symbols") | 1 | | Try It | [Docs](/providers/iex/iex-symbols) | **IEX Symbols** | =CSQUERY("IEX","IEX Symbols") | =CSPARAMETERS("IEX","IEX Symbols") | 1 | | Try It | [Docs](/providers/iex/international-exchanges) | **International Exchanges** | =CSQUERY("IEX","International Exchanges") | =CSPARAMETERS("IEX","International Exchanges") | 1 | | Try It | [Docs](/providers/iex/mutual-fund-symbols) | **Mutual Fund Symbols** | =CSQUERY("IEX","Mutual Fund Symbols") | =CSPARAMETERS("IEX","Mutual Fund Symbols") | 1 | | Try It | [Docs](/providers/iex/options-symbols) | **Options Symbols** | =CSQUERY("IEX","Options Symbols") | =CSPARAMETERS("IEX","Options Symbols") | 1 | | Try It | [Docs](/providers/iex/otc-symbols) | **OTC Symbols** | =CSQUERY("IEX","OTC Symbols") | =CSPARAMETERS("IEX","OTC Symbols") | 1 | | Try It | [Docs](/providers/iex/sectors) | **Sectors** | =CSQUERY("IEX","Sectors") | =CSPARAMETERS("IEX","Sectors") | 1 | | Try It | [Docs](/providers/iex/symbols) | **Symbols** | =CSQUERY("IEX","Symbols") | =CSPARAMETERS("IEX","Symbols") | 1 | | Try It | [Docs](/providers/iex/tags) | **Tags** | =CSQUERY("IEX","Tags") | =CSPARAMETERS("IEX","Tags") | 1 | | Try It | [Docs](/providers/iex/u.s.-exchanges) | **U.S. Exchanges** | =CSQUERY("IEX","U.S. Exchanges") | =CSPARAMETERS("IEX","U.S. Exchanges") | 1 | | Try It | [Docs](/providers/iex/historical-economic-data) | **Historical Economic Data** | =CSQUERY("IEX","Historical Economic Data") | =CSPARAMETERS("IEX","Historical Economic Data") | 13 | | Try It | [Docs](/providers/iex/historical-treasuries-rates) | **Historical Treasuries Rates** | =CSQUERY("IEX","Historical Treasuries Rates") | =CSPARAMETERS("IEX","Historical Treasuries Rates") | 13 | | Try It | [Docs](/providers/iex/current-market-data-keys) | **Current Market Data Keys** | =CSQUERY("IEX","Current Market Data Keys") | =CSPARAMETERS("IEX","Current Market Data Keys") | 2 | | Try It | [Docs](/providers/iex/current-market-data-point) | **Current Market Data Point** | =CSQUERY("IEX","Current Market Data Point") | =CSPARAMETERS("IEX","Current Market Data Point") | 3 | | Try It | [Docs](/providers/iex/iex-tops) | **IEX TOPS** | =CSQUERY("IEX","IEX TOPS") | =CSPARAMETERS("IEX","IEX TOPS") | 1 | | Try It | [Docs](/providers/iex/iex-tops-last) | **IEX TOPS Last** | =CSQUERY("IEX","IEX TOPS Last") | =CSPARAMETERS("IEX","IEX TOPS Last") | 1 | | Try It | [Docs](/providers/iex/cryptocurrency-book) | **Cryptocurrency Book** | =CSQUERY("IEX","Cryptocurrency Book") | =CSPARAMETERS("IEX","Cryptocurrency Book") | 2 | | Try It | [Docs](/providers/iex/cryptocurrency-price) | **Cryptocurrency Price** | =CSQUERY("IEX","Cryptocurrency Price") | =CSPARAMETERS("IEX","Cryptocurrency Price") | 2 | | Try It | [Docs](/providers/iex/latest-currency-rates) | **Latest Currency Rates** | =CSQUERY("IEX","Latest Currency Rates") | =CSPARAMETERS("IEX","Latest Currency Rates") | 1 | | Try It | [Docs](/providers/iex/currency-conversion) | **Currency Conversion** | =CSQUERY("IEX","Currency Conversion") | =CSPARAMETERS("IEX","Currency Conversion") | 3 | | Try It | [Docs](/providers/iex/search) | **Search** | =CSQUERY("IEX","Search") | =CSPARAMETERS("IEX","Search") | 2 | | Try It | [Docs](/providers/iex/international-symbols-by-exchange) | **International Symbols by Exchange** | =CSQUERY("IEX","International Symbols by Exchange") | =CSPARAMETERS("IEX","International Symbols by Exchange") | 2 | | Try It | [Docs](/providers/iex/international-symbols-by-region) | **International Symbols by Region** | =CSQUERY("IEX","International Symbols by Region") | =CSPARAMETERS("IEX","International Symbols by Region") | 2 | | Try It | [Docs](/providers/iex/stats-historical-summary) | **Stats Historical Summary** | =CSQUERY("IEX","Stats Historical Summary") | =CSPARAMETERS("IEX","Stats Historical Summary") | 2 | | Try It | [Docs](/providers/iex/stats-intraday) | **Stats Intraday** | =CSQUERY("IEX","Stats Intraday") | =CSPARAMETERS("IEX","Stats Intraday") | 1 | | Try It | [Docs](/providers/iex/stats-recent) | **Stats Recent** | =CSQUERY("IEX","Stats Recent") | =CSPARAMETERS("IEX","Stats Recent") | 1 | | Try It | [Docs](/providers/iex/stats-records) | **Stats Records** | =CSQUERY("IEX","Stats Records") | =CSPARAMETERS("IEX","Stats Records") | 1 | | Try It | [Docs](/providers/iex/collections) | **Collections** | =CSQUERY("IEX","Collections") | =CSPARAMETERS("IEX","Collections") | 3 | | Try It | [Docs](/providers/iex/earnings-today) | **Earnings Today** | =CSQUERY("IEX","Earnings Today") | =CSPARAMETERS("IEX","Earnings Today") | 1 | | Try It | [Docs](/providers/iex/ipos-today) | **IPOs Today** | =CSQUERY("IEX","IPOs Today") | =CSPARAMETERS("IEX","IPOs Today") | 1 | | Try It | [Docs](/providers/iex/upcoming-ipos) | **Upcoming IPOS** | =CSQUERY("IEX","Upcoming IPOS") | =CSPARAMETERS("IEX","Upcoming IPOS") | 1 | | Try It | [Docs](/providers/iex/list) | **List** | =CSQUERY("IEX","List") | =CSPARAMETERS("IEX","List") | 4 | | Try It | [Docs](/providers/iex/sector-performance) | **Sector Performance** | =CSQUERY("IEX","Sector Performance") | =CSPARAMETERS("IEX","Sector Performance") | 1 | | Try It | [Docs](/providers/iex/market-volume) | **Market Volume** | =CSQUERY("IEX","Market Volume") | =CSPARAMETERS("IEX","Market Volume") | 1 | | Try It | [Docs](/providers/iex/deep) | **DEEP** | =CSQUERY("IEX","DEEP") | =CSPARAMETERS("IEX","DEEP") | 2 | | Try It | [Docs](/providers/iex/deep-auction) | **DEEP Auction** | =CSQUERY("IEX","DEEP Auction") | =CSPARAMETERS("IEX","DEEP Auction") | 2 | | Try It | [Docs](/providers/iex/deep-book) | **DEEP Book** | =CSQUERY("IEX","DEEP Book") | =CSPARAMETERS("IEX","DEEP Book") | 2 | | Try It | [Docs](/providers/iex/deep-operational-halt-status) | **DEEP Operational Halt Status** | =CSQUERY("IEX","DEEP Operational Halt Status") | =CSPARAMETERS("IEX","DEEP Operational Halt Status") | 2 | | Try It | [Docs](/providers/iex/deep-official-price) | **DEEP Official Price** | =CSQUERY("IEX","DEEP Official Price") | =CSPARAMETERS("IEX","DEEP Official Price") | 2 | | Try It | [Docs](/providers/iex/deep-security-event) | **DEEP Security Event** | =CSQUERY("IEX","DEEP Security Event") | =CSPARAMETERS("IEX","DEEP Security Event") | 2 | | Try It | [Docs](/providers/iex/deep-short-sale-price-test-status) | **DEEP Short Sale Price Test Status** | =CSQUERY("IEX","DEEP Short Sale Price Test Status") | =CSPARAMETERS("IEX","DEEP Short Sale Price Test Status") | 2 | | Try It | [Docs](/providers/iex/deep-system-event) | **DEEP System Event** | =CSQUERY("IEX","DEEP System Event") | =CSPARAMETERS("IEX","DEEP System Event") | 1 | | Try It | [Docs](/providers/iex/deep-trades) | **DEEP Trades** | =CSQUERY("IEX","DEEP Trades") | =CSPARAMETERS("IEX","DEEP Trades") | 3 | | Try It | [Docs](/providers/iex/deep-trade-break) | **DEEP Trade Break** | =CSQUERY("IEX","DEEP Trade Break") | =CSPARAMETERS("IEX","DEEP Trade Break") | 3 | | Try It | [Docs](/providers/iex/deep-trading-status) | **DEEP Trading Status** | =CSQUERY("IEX","DEEP Trading Status") | =CSPARAMETERS("IEX","DEEP Trading Status") | 2 | | Try It | [Docs](/providers/iex/financials-as-reported-by-filing) | **Financials As Reported by Filing** | =CSQUERY("IEX","Financials As Reported by Filing") | =CSPARAMETERS("IEX","Financials As Reported by Filing") | 14 | | Try It | [Docs](/providers/iex/financials-as-reported---all) | **Financials As Reported - ALL** | =CSQUERY("IEX","Financials As Reported - ALL") | =CSPARAMETERS("IEX","Financials As Reported - ALL") | 13 | | Try It | [Docs](/providers/iex/historical-news-by-symbol) | **Historical News by Symbol** | =CSQUERY("IEX","Historical News by Symbol") | =CSPARAMETERS("IEX","Historical News by Symbol") | 13 | | Try It | [Docs](/providers/iex/historical-news---all) | **Historical News - All** | =CSQUERY("IEX","Historical News - All") | =CSPARAMETERS("IEX","Historical News - All") | 12 | | Try It | [Docs](/providers/iex/bonus-issue) | **Bonus Issue** | =CSQUERY("IEX","Bonus Issue") | =CSPARAMETERS("IEX","Bonus Issue") | 12 | | Try It | [Docs](/providers/iex/distribution) | **Distribution** | =CSQUERY("IEX","Distribution") | =CSPARAMETERS("IEX","Distribution") | 12 | | Try It | [Docs](/providers/iex/dividends) | **Dividends** | =CSQUERY("IEX","Dividends") | =CSPARAMETERS("IEX","Dividends") | 12 | | Try It | [Docs](/providers/iex/return-of-capital) | **Return of Capital** | =CSQUERY("IEX","Return of Capital") | =CSPARAMETERS("IEX","Return of Capital") | 12 | | Try It | [Docs](/providers/iex/rights-issue) | **Rights Issue** | =CSQUERY("IEX","Rights Issue") | =CSPARAMETERS("IEX","Rights Issue") | 12 | | Try It | [Docs](/providers/iex/right-to-purchase) | **Right to Purchase** | =CSQUERY("IEX","Right to Purchase") | =CSPARAMETERS("IEX","Right to Purchase") | 12 | | Try It | [Docs](/providers/iex/security-reclassification) | **Security Reclassification** | =CSQUERY("IEX","Security Reclassification") | =CSPARAMETERS("IEX","Security Reclassification") | 12 | | Try It | [Docs](/providers/iex/security-swap) | **Security Swap** | =CSQUERY("IEX","Security Swap") | =CSPARAMETERS("IEX","Security Swap") | 12 | | Try It | [Docs](/providers/iex/spinoff) | **Spinoff** | =CSQUERY("IEX","Spinoff") | =CSPARAMETERS("IEX","Spinoff") | 12 | | Try It | [Docs](/providers/iex/splits) | **Splits** | =CSQUERY("IEX","Splits") | =CSPARAMETERS("IEX","Splits") | 12 | | Try It | [Docs](/providers/iex/bonus-issue-by-symbol) | **Bonus Issue by Symbol** | =CSQUERY("IEX","Bonus Issue by Symbol") | =CSPARAMETERS("IEX","Bonus Issue by Symbol") | 13 | | Try It | [Docs](/providers/iex/distribution-by-symbol) | **Distribution by Symbol** | =CSQUERY("IEX","Distribution by Symbol") | =CSPARAMETERS("IEX","Distribution by Symbol") | 13 | | Try It | [Docs](/providers/iex/dividends-by-symbol) | **Dividends by Symbol** | =CSQUERY("IEX","Dividends by Symbol") | =CSPARAMETERS("IEX","Dividends by Symbol") | 13 | | Try It | [Docs](/providers/iex/return-of-capital-by-symbol) | **Return of Capital by Symbol** | =CSQUERY("IEX","Return of Capital by Symbol") | =CSPARAMETERS("IEX","Return of Capital by Symbol") | 13 | | Try It | [Docs](/providers/iex/rights-issue-by-symbol) | **Rights Issue by Symbol** | =CSQUERY("IEX","Rights Issue by Symbol") | =CSPARAMETERS("IEX","Rights Issue by Symbol") | 13 | | Try It | [Docs](/providers/iex/right-to-purchase-by-symbol) | **Right to Purchase by Symbol** | =CSQUERY("IEX","Right to Purchase by Symbol") | =CSPARAMETERS("IEX","Right to Purchase by Symbol") | 13 | | Try It | [Docs](/providers/iex/security-reclassification-by-symbol) | **Security Reclassification by Symbol** | =CSQUERY("IEX","Security Reclassification by Symbol") | =CSPARAMETERS("IEX","Security Reclassification by Symbol") | 13 | | Try It | [Docs](/providers/iex/security-swap-by-symbol) | **Security Swap by Symbol** | =CSQUERY("IEX","Security Swap by Symbol") | =CSPARAMETERS("IEX","Security Swap by Symbol") | 13 | | Try It | [Docs](/providers/iex/spinoff-by-symbol) | **Spinoff by Symbol** | =CSQUERY("IEX","Spinoff by Symbol") | =CSPARAMETERS("IEX","Spinoff by Symbol") | 13 | | Try It | [Docs](/providers/iex/splits-by-symbol) | **Splits by Symbol** | =CSQUERY("IEX","Splits by Symbol") | =CSPARAMETERS("IEX","Splits by Symbol") | 13 | | Try It | [Docs](/providers/iex/intraday-prices) | **Intraday Prices** | =CSQUERY("IEX","Intraday Prices") | =CSPARAMETERS("IEX","Intraday Prices") | 10 | | Try It | [Docs](/providers/iex/delayed-quote) | **Delayed Quote** | =CSQUERY("IEX","Delayed Quote") | =CSPARAMETERS("IEX","Delayed Quote") | 3 | | Try It | [Docs](/providers/iex/largest-trades) | **Largest Trades** | =CSQUERY("IEX","Largest Trades") | =CSPARAMETERS("IEX","Largest Trades") | 2 | | Try It | [Docs](/providers/iex/ohlc) | **OHLC** | =CSQUERY("IEX","OHLC") | =CSPARAMETERS("IEX","OHLC") | 2 | | Try It | [Docs](/providers/iex/previous-day-price) | **Previous Day Price** | =CSQUERY("IEX","Previous Day Price") | =CSPARAMETERS("IEX","Previous Day Price") | 2 | | Try It | [Docs](/providers/iex/price-only) | **Price Only** | =CSQUERY("IEX","Price Only") | =CSPARAMETERS("IEX","Price Only") | 2 | | Try It | [Docs](/providers/iex/quote) | **Quote** | =CSQUERY("IEX","Quote") | =CSPARAMETERS("IEX","Quote") | 2 | | Try It | [Docs](/providers/iex/volume-by-venue) | **Volume by Venue** | =CSQUERY("IEX","Volume by Venue") | =CSPARAMETERS("IEX","Volume by Venue") | 2 | | Try It | [Docs](/providers/iex/company) | **Company** | =CSQUERY("IEX","Company") | =CSPARAMETERS("IEX","Company") | 2 | | Try It | [Docs](/providers/iex/insider-roster) | **Insider Roster** | =CSQUERY("IEX","Insider Roster") | =CSPARAMETERS("IEX","Insider Roster") | 2 | | Try It | [Docs](/providers/iex/insider-summary) | **Insider Summary** | =CSQUERY("IEX","Insider Summary") | =CSPARAMETERS("IEX","Insider Summary") | 2 | | Try It | [Docs](/providers/iex/insider-transactions) | **Insider Transactions** | =CSQUERY("IEX","Insider Transactions") | =CSPARAMETERS("IEX","Insider Transactions") | 2 | | Try It | [Docs](/providers/iex/peer-groups) | **Peer Groups** | =CSQUERY("IEX","Peer Groups") | =CSPARAMETERS("IEX","Peer Groups") | 2 | | Try It | [Docs](/providers/iex/balance-sheet) | **Balance Sheet** | =CSQUERY("IEX","Balance Sheet") | =CSPARAMETERS("IEX","Balance Sheet") | 4 | | Try It | [Docs](/providers/iex/cash-flow) | **Cash Flow** | =CSQUERY("IEX","Cash Flow") | =CSPARAMETERS("IEX","Cash Flow") | 4 | | Try It | [Docs](/providers/iex/dividends---basic) | **Dividends - Basic** | =CSQUERY("IEX","Dividends - Basic") | =CSPARAMETERS("IEX","Dividends - Basic") | 3 | | Try It | [Docs](/providers/iex/earnings) | **Earnings** | =CSQUERY("IEX","Earnings") | =CSPARAMETERS("IEX","Earnings") | 4 | | Try It | [Docs](/providers/iex/financials) | **Financials** | =CSQUERY("IEX","Financials") | =CSPARAMETERS("IEX","Financials") | 3 | | Try It | [Docs](/providers/iex/income-statement) | **Income Statement** | =CSQUERY("IEX","Income Statement") | =CSPARAMETERS("IEX","Income Statement") | 4 | | Try It | [Docs](/providers/iex/splits---basic) | **Splits - Basic** | =CSQUERY("IEX","Splits - Basic") | =CSPARAMETERS("IEX","Splits - Basic") | 3 | | Try It | [Docs](/providers/iex/advanced-stats) | **Advanced Stats** | =CSQUERY("IEX","Advanced Stats") | =CSPARAMETERS("IEX","Advanced Stats") | 2 | | Try It | [Docs](/providers/iex/analyst-recommendations) | **Analyst Recommendations** | =CSQUERY("IEX","Analyst Recommendations") | =CSPARAMETERS("IEX","Analyst Recommendations") | 2 | | Try It | [Docs](/providers/iex/estimates) | **Estimates** | =CSQUERY("IEX","Estimates") | =CSPARAMETERS("IEX","Estimates") | 2 | | Try It | [Docs](/providers/iex/fund-ownership) | **Fund Ownership** | =CSQUERY("IEX","Fund Ownership") | =CSPARAMETERS("IEX","Fund Ownership") | 2 | | Try It | [Docs](/providers/iex/institutional-ownership) | **Institutional Ownership** | =CSQUERY("IEX","Institutional Ownership") | =CSPARAMETERS("IEX","Institutional Ownership") | 2 | | Try It | [Docs](/providers/iex/key-stats) | **Key Stats** | =CSQUERY("IEX","Key Stats") | =CSPARAMETERS("IEX","Key Stats") | 2 | | Try It | [Docs](/providers/iex/price-target) | **Price Target** | =CSQUERY("IEX","Price Target") | =CSPARAMETERS("IEX","Price Target") | 2 | | Try It | [Docs](/providers/iex/end-of-day-options) | **End of Day Options** | =CSQUERY("IEX","End of Day Options") | =CSPARAMETERS("IEX","End of Day Options") | 3 | | Try It | [Docs](/providers/iex/social-sentiment) | **Social Sentiment** | =CSQUERY("IEX","Social Sentiment") | =CSPARAMETERS("IEX","Social Sentiment") | 2 | | Try It | [Docs](/providers/iex/ceo-compensation) | **CEO Compensation** | =CSQUERY("IEX","CEO Compensation") | =CSPARAMETERS("IEX","CEO Compensation") | 2 | | Try It | [Docs](/providers/iex/technical-indicators) | **Technical Indicators** | =CSQUERY("IEX","Technical Indicators") | =CSPARAMETERS("IEX","Technical Indicators") | 4 | | Try It | [Docs](/providers/iex/timeseries-keys) | **Timeseries Keys** | =CSQUERY("IEX","Timeseries Keys") | =CSPARAMETERS("IEX","Timeseries Keys") | 2 | | Try It | [Docs](/providers/iex/full-economic-timeseries) | **Full Economic Timeseries** | =CSQUERY("IEX","Full Economic Timeseries") | =CSPARAMETERS("IEX","Full Economic Timeseries") | 3 | | Try It | [Docs](/providers/iex/full-treasury-timeseries) | **Full Treasury Timeseries** | =CSQUERY("IEX","Full Treasury Timeseries") | =CSPARAMETERS("IEX","Full Treasury Timeseries") | 3 | | Try It | [Docs](/providers/iex/full-energy-timeseries) | **Full Energy Timeseries** | =CSQUERY("IEX","Full Energy Timeseries") | =CSPARAMETERS("IEX","Full Energy Timeseries") | 3 | | Try It | [Docs](/providers/iex/full-news-timeseries) | **Full News Timeseries** | =CSQUERY("IEX","Full News Timeseries") | =CSPARAMETERS("IEX","Full News Timeseries") | 3 |

[Signing up for Cryptosheets is free](https://app.cryptosheets.com/#/register) get crypto data in 30 seconds or less **Get Cryptosheets for Microsoft Excel** **Get Cryptosheets for Googlesheets** \*Note: you must have one of the [supported versions](https://docs.microsoft.com/en-us/office/dev/add-ins/excel/custom-functions-architecture) of Microsoft Office or Excel for custom functions to work **Click here** for additional documentation from IEX Learn more [here](https://intercom.help/cryptosheets/en/) --- Tags: `IEX` `provider`