Company Info Batch

Are you after a lot of data fast? Our company info batch feature allows you to apply the companyInfo data type to a large range of symbols at the same time. This returns the data significantly faster than individual functions and only counts as 1 external request for your daily quota. Company Info Batch functions exactly the same as Real-time Batch, just use the SF() function as you normally would but instead of applying it to a single cell use it on a vertical range like so:

=SF(A1:A100, "companyInfo", "sector")

[multi-cell array of market caps]

All comapnyInfo subtypes such as name, exchange, sector, lastDiv, beta etc... work with the batch functionality like so:

=SF(A1:A100, "companyInfo", "exchange")

[multi-cell array of year highs]

You can even chain together metrics to return 1000s of data points at once:

=SF(A1:A100, "companyInfo", "name&exchange&sector&lastDiv")

Examples

Example 1 - Single metric (market capitalisation)

=SF(A2:A11, "companyInfo", "marketCap")

Example 2 - Mutliple metrics

=SF(A2:A20, "companyInfo", "name&exchange&sector&lastDiv")

Example 2 - Single Metric (sector)

=SF(A2:A11, "companyInfo", "sector")