BRINGING IN DATA

How to use your API keys

Plenty of the terminal runs without one. Quotes, filings, rates and fundamentals need no key, no account and no card. Everything past that is a key you own: free ones that take a few minutes each, and paid ones you may already hold.

Cboe
SEC EDGAR
Yahoo Finance
FINRA
Federal Reserve
IMF

Works the moment you open it

NO SIGNUP, NO CARD

Nothing to paste. Open it for the first time and you already have quotes for your tickers, the whole Treasury yield curve, every filing a company has made, and a full profile of any listed company.

Each card lists the panel codes it switches on. A code is what you type to open a panel: WATCH is your watchlist, OMON the option chain, MKT the market board. The user guide names every one.

Cboe

No signup

One of the main US options exchanges. Delayed two-sided quotes and full option chains with greeks, refreshed as often as you like. Most of your prices come from here before you add anything.

PowersWATCHOMONALLQMKT

Yahoo Finance

No signup

Daily and intraday bars, quotes, company profiles, fundamentals and news, plus the screener you search names with.

PowersWATCHGPMKTRAIL

SEC EDGAR

No signup

Every filing any US public company has ever made, every form type, searchable in full, plus who owns the shares and who is buying and selling. Ten requests a second, and no daily cap.

PowersSECFINSDOWNCFFA

FINRA

No signup

Weekly off-exchange and dark-pool volume, and short interest. No paid plan gets it any sooner.

PowersEDGETAPE

Federal Reserve

No signup

Treasury rates, the yield curve, and the Fed’s own balance sheet.

PowersYASBTMMECO

IMF

No signup

Economic data for most countries in the world, plus a daily count of ships calling at the major ports.

PowersPORTSECO

Your portfolios, watchlists, layouts, alerts and chat rooms are saved and follow you to another Mac. Signing in is free, and there is nothing to paste for it.

Free keys worth getting

A FEW MINUTES EACH

A key is a short code a provider gives you when you sign up, so they know the data is going to you. Each of these takes a form, an email and a few minutes. Nothing to cancel, and each one lights up panels that sit empty without it.

FRED

Free key

The St. Louis Fed’s 800,000-plus macro series, with no daily cap. It is the backbone of everything economic here. Sharpe and Sortino need it too, for the risk-free rate behind them.

PowersECOHSNGBTMMYAS

Get a FRED key

Alpaca Markets

Free key

The strongest free market data here. Free gives you prices from every US exchange (the full consolidated tape) 15 minutes delayed, at 200 requests a minute with no daily cap. Alpaca issues two values, a key and a secret, and Settings has a row for each. The account also includes paper trading, and AUM shows those positions without ever placing an order.

PowersMKTRAILWATCHTAPETAS

Get an Alpaca key

Finnhub

Free key

Quotes, company news and a live trade stream, at 60 requests a minute with no daily cap. Analyst price targets and earnings-call transcripts are not on the free tier.

PowersWATCHNEWSRESINSDIPOFA

Get a Finnhub key

EIA

Free key

The US Energy Information Administration: oil, natural gas, the power grid and renewables. Every series, no daily cap.

PowersNRGCMDTY

Get an EIA key

Bureau of Labor Statistics

Free key

Inflation (CPI) and the monthly jobs report. Registering is the whole upgrade: it lifts you from 25 to 500 queries a day and opens 20 years of history on each series.

PowersECOECAL

Get a BLS key

Tiingo

Free key

Daily and intraday price history, crypto, and a live price stream, at 500 requests an hour. On the free tier, fundamentals cover the Dow 30 only and news is not included.

PowersFAGPFXC

Get a Tiingo key

One to leave until later: Financial Modeling Prep is the only key here capped per day, so once a free day is spent it stays spent until midnight UTC. Get the free keys above first.

Adding a key

FOUR STEPS

  1. Open Settings

    Type SET in the command line at the top of the window, then choose the Data tab.

  2. Find the source

    Every source that takes a key has a row. Rows without one say Not set and sit at the top. The sources that need no key are not listed, because there is nothing to enter. If you do not have a key yet, Get a key opens that provider’s signup page for you.

  3. Paste it and save

    Paste the key into that row’s box and press Save. A few providers give you two values rather than one: Alpaca is the common case, and it has a second row labelled API secret that has to be saved too. The key takes effect at once, and a panel that was waiting on it fills in on its next refresh.

  4. Check it

    Check tests the key against the provider and shows the answer beside the button: OK, or INVALID KEY, PLAN LIMIT or QUOTA SPENT with the reason underneath. It only runs when you click it, so nothing is spent from your allowance in the background.

Where your keys live

On your Mac, in the app’s own settings folder. They are never sent to us and they never leave the machine. Nothing in the app can read a saved key back, not even the settings screen. It shows the last four characters and nothing more. Show in Finder opens the folder.

A key goes to that one provider and nowhere else. To remove one, press Clear and then Confirm clear.

When a key is missing

IT TELLS YOU

When a number is not available, you get the reason instead of the number. Never a zero, never a stand-in, never a guess. Ask an economics panel for something it has no key for, and this is exactly what it says:

FRED needs an API key. Add one in Settings, on the Data tab.

EIA Open Data needs an API key. Add one in Settings, on the Data tab.

A missing key never empties a whole panel. Open the economics dashboard without a FRED key and the Treasury, New York Fed and Federal Reserve Board figures are all still there. Only the series that need FRED sit blank, each one saying so, so you always know which key would fill them.

Every key stays yours

A panel that needs a key tells you which one, so you only ever add the ones you actually use. Nothing here expires. Any key you get is your own account with that provider, and it keeps working everywhere else you use it.

Read the user guideAsk for a number with EqueryPricing

Every source in the terminal, and what each one is doing right now, is listed under SYS inside the app.