Palanor Data has three ways in, and one API key works for all of them: the Palanor MCP for AI agents, the REST API at api.palanor.com/v1, and the Python client and Excel add-in described here. Get a free key at palanor.com/api-tokens. It includes 1,000 requests a month.
Python
Install the client, set your key, and read a series:
- pip install "palanor[pandas]" (the client is on PyPI; leave out [pandas] if you do not need DataFrames)
- export PALANOR_API_KEY="plnr_..."
- p = Palanor(), then p.signals.observations("rates.spread_2y10y", start="2020-01-01").to_pandas()
The client follows pages for you and retries brief failures. It covers signals, indices, Currents, guidance, risk factors, corporate events, insiders, ownership, pay, contracts, lobbying, patents, industries and the release calendar. When your monthly requests run out it stops with QuotaExceededError rather than retrying.
Excel
Download palanor.com/excel/manifest.xml and add it to Excel. In Excel on the web: Home, Add-ins, More add-ins, My add-ins, Upload my add-in. The steps for Windows and Mac are on palanor.com/developers. Then open Home, Palanor, paste your key and press Save.
- =PALANOR.LATEST("rates.spread_2y10y") gives the latest value.
- =PALANOR.SERIES("rates.spread_2y10y", "2024-01-01", "2024-12-31") spills dates and values down the sheet, oldest first. Dates can be cells or DATE().
- =PALANOR.INFO("rates.spread_2y10y", "attribution") gives a fact about the signal: name, unit, date, source, publisher, license, license_url, attribution, category or description.
Your key is kept with the add-in on your computer, not in the workbook, so sharing a file never shares your key. Answers are kept for 15 minutes, so many cells reading the same series cost one request. Refresh in the task pane fetches again.
Where the data comes from
Every value carries a provenance block: the source, the publisher, the license, and the credit line to show with it. In Python it is on each result and in the DataFrame's attrs. In Excel, select a cell with a PALANOR formula and the task pane shows its source. Add sources sheet writes every source used into the workbook.
What you won't get
Signals whose license allows display in Palanor but not redistribution, such as FRED series and licensed market prices, are not served. Python raises NotFoundError and Excel shows #N/A. First-reported values (vintage "first") are shown in the Terminal only for now.