Not connected
Configuration
Enter your backend URL and API key, then Save.
Fetching
Active — SIR functions fetch when Excel recalculates.
Test a function
Run a SIR call against the backend and inspect the response — no spreadsheet cell needed.
How it works & limitations
- SIR.DP returns a single value; SIR.DH spills a dates + values range.
- Replace existing
BDP(/BDH(withSIR.DP(/SIR.DH(— keep the same arguments. - Values are the latest stored snapshot, not a live Bloomberg fetch — uncovered calls return
#N/A. - Calls are batched, so large workbooks make few API requests.
- Your key is stored locally (OfficeRuntime.storage) and sent as
X-API-Key.