Real-time Batch
Are you after a lot of data fast? Our new realtime batch feature allows you to apply the realTime data type to a range of codes at the same time. This returns the data significantly faster than individual functions and only counts as 1 external request for your daily quota. The functionality is simple, 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)
[multi-cell array of real-time prices]All realTime subtypes such as volume, dayHigh, dayLow etc... work with the batch functionality like so:
=SF(A1:A100, "realTime", "volume")
[multi-cell array of real-time volumes]You can even chain together metrics to return 1000s of data points at once:
=SF(A1:A100, "realTime", "price&volume&dayHigh&dayLow&previousClose&changesPercentage")Important: Does not identify individual errors and so if data is not available for a particular code in your range it will just return a blank cell.
Examples
Example 1 - Batch real-time price
=SF(A2:A10)
Example 2 - Batch real-time multiple metrics
Use just 1 function to call multiple metrics on 100s of stocks at once!
=SF(A2:A24, "realTime", "price&volume&dayHigh&dayLow&previousClose&changesPercentage")
Example 3 - Batch real-time single metric (volume)
=SF(A2:A32, "realTime", "volume")