Skip to main content

IEX Cloud for Excel: Custom Functions (Beta)

  • Updated

 

IEX Cloud's Excel plug-in makes it easy to connect real-time and historical financial data into Excel spreadsheets, including U.S. stock prices, financial statements, and more. Get started by downloading "IEX Cloud Stock Data" on Microsoft AppSource.

Once installed, you can use either the application itself or custom functions to import data into spreadsheets. Note that only a subset of fields from IEX Cloud's Quote endpoint are available via custom functions. To access the other endpoints available on IEX Cloud for Excel, you must use the application directly.

If you're new to IEX Cloud for Excel, start by reading our introductory guide here.

Custom Functions for Excel

IEX Cloud for Excel supports the following custom functions:

1) IEXC.GETQUOTE(token, symbol, [properties])

Returns specified properties from IEX Cloud's Quote endpoint. Parameters:

  • token: IEX Cloud public API token to use

  • symbol: stock symbol / ticker (US Stocks only)

  • properties (optional): comma delimited string of properties to return. If omitted, default return is: 'latestPrice,latestVolume,latestTime,latestUpdate,latestSource,change,changePercent'

Example:

quotesss.png

Returns:

return.png

 

2) IEXC.GETLATESTPRICERECURRING(token, symbol, [refreshSeconds])

 

Returns the latestPrice from IEX Cloud's Quote endpoint. Parameters:

  • token: IEX Cloud public API token to use

  • symbol: stock symbol/ticker (US Stocks only)

  • refreshSeconds (optional): Number of seconds between data refresh. Minimum is 10 seconds. We suggest refresh intervals of at least 20 seconds to avoid degradation of spreadsheet performance.

Example:

latestp.png

Returns:

21.png

 

3) IEXC.GETLATESTVOLUMERECURRING(token, symbol, [refreshSeconds])

Returns the latestVolume from IEX Cloud's Quote endpoint. Parameters:

  • token: IEX Cloud public API token to use

  • symbol: stock symbol/ticker (US Stocks only)

  • refreshSeconds (optional): Number of seconds between data refresh. Minimum is 10 seconds. We would recommend refresh intervals of at least 20 seconds to avoid degradation of spreadsheet performance.

 

Powered by Zendesk