Connect your data
Try TEST for 10 CPI observations, or use your own API key.
When you test or fetch data, your API key and requested series codes are sent through BER’s relay to api.beranalytics.co.za. BER’s API supports usage logging. How your data is handled.
TEST is a public demo key: up to 10 CPI observations for P0141-CPS00000. Other series and multi-series examples require your own BER API key.
Your key determines which series you can access. In Excel, it is saved in the add-in’s shared runtime storage until you clear it.
Preview real data
Uses your saved key. Browser preview shows API results; table matching and frequency checks require Excel.
Up to 20 codes, separated by commas.
Keep it current
Pull the latest values into your formulas.
These controls require Excel. Use Fetch preview above to test data retrieval in this browser.
Whole-workbook refresh recalculates all open workbooks.
Refresh specific codes
Separate codes with commas. Searches all sheets, including codes in cell references.
Each matching formula refreshes in full. For named ranges, table references or calculated codes, use whole-workbook refresh.
Start with a formula
Enter this in an empty worksheet cell.
=BERDATA.GETDATA("P0141-CPS00000")Dates, values and metadata expand into the cells below. Leave room for the result.
More formula examples
Several series, side by side
=BERDATA.GETDATA("P0141-CPS00000", "KBP7008Q")Include up to 20 unique codes per call.
Start from a date
=BERDATA.GETDATA("KBP7096B", "2018-01-01")Put the date last, after all series codes. Includes that date and later observations. Leave it out for the full history. Use your own API key for this example.
Values beside existing dates
=BERDATA.GETVALUES("P0141-CPS00000", A10)A10 contains the first observation date. Place this beside the original formula, at the top of its metadata block.
Click the first date in GETDATA. Lower-frequency values leave blanks between observations; higher-frequency values require a higher-frequency base table.