Local Market Data Power Cache


Requirements: Installation of this feature requires Windows Admin access to install a Windows Service


Local Market Data Power Cache works by adaptively pre-fetching frequently accessed historical time series so that whenever they are accessed by the user, the access is within milliseconds while any network call would require hundreds of milliseconds.


Typical uses:

1. Retrieval of prices of portfolio of securities on a given historical day - no data source in Spearian for Excel provides such an API, so the access to that information would require hours for a portfolio of 5000 securities


2. Advanced Analytics - any advanced analytics requires frequent access to various financial time series, if they should be downloaded all over again, the time required would be not feasible. With Spearian's Local Market Data Power Cache, the calculations take milliseconds.



Copyright © 2013-2017 Jiri Pik

Document Version: Sunday, May 7, 2017