Excel Forex API — Live Data in Spreadsheets

Use Power Query for refreshable workbooks or a VBA function for cell-level formulas. Live RSI, MACD, prices — refreshed every minute.

Get $2.50 free credit

No credit card$2.50 PAYG credit on sign up

claw-rates.xlsx · Sheet1 Illustration

=CLAW("EURUSD","RSI_14","H1") → 62.48 Live

15+API endpoints

42Indicator series

M1–D17 timeframes

$2.50PAYG starting credit

Why TickAtlas

Why Use TickAtlas?

Pre-Calculated, Redis-Cached

Indicator values are computed server-side on every new candle. Your app queries the result — no TA library, no candle history needed.

7 Timeframes

M1, M5, M15, M30, H1, H4, D1 — the same endpoint serves scalpers and position traders alike.

Forex, Crypto, Commodities

EURUSD, GBPUSD, XAUUSD, BTCUSD, USDJPY — data available for every symbol in our data.

One Request. Instant Data.

REQUEST

' VBA: =CLAW("EURUSD", "RSI_14", "H1")
Function CLAW(symbol As String, indicator As String, timeframe As String) As Variant
    Dim http As Object
    Set http = CreateObject("MSXML2.XMLHTTP")
    http.Open "GET", "https://tickatlas.com/v1/indicator?symbol=" & symbol _
        & "&indicator=" & indicator & "&timeframe=" & timeframe, False
    http.setRequestHeader "X-API-Key", "YOUR_API_KEY"
    http.Send
    ' parse response.value ...
End Function

Two Ways to Pull Data into Excel

Option 1 Power Query (Recommended)

Power Query's Web.Contents function supports custom headers. Use it to fetch JSON data and transform it into a table. Refresh manually or set automatic refresh intervals.

Option 2 VBA Macro

A simple VBA macro using MSXML2.XMLHTTP can fetch the API and write values directly to cells. Bind it to a button or run on a timer with Application.OnTime.

Test the API First

Before building your Excel integration, verify the API works from your machine:

curl -H "X-API-Key: YOUR_KEY" "https://tickatlas.com/v1/quote?symbol=EURUSD"

# Response:
{
  "success": true,
  "data": {
    "symbol": "EURUSD",
    "bid": 1.08543,
    "ask": 1.08556,
    "spread": 1.3,
    "timestamp": "2026-03-28T10:00:00Z"
  }
}

Every new account gets $2.50 in free API credits

Simple Pricing

Pay-As-You-Go

$2.50 free to start

From $0.005 per standard call. Great for occasional manual refreshes.

Start Free

FAQ

Can I use WEBSERVICE() in Excel to call the API?

WEBSERVICE() doesn't support custom headers, so you can't pass the X-API-Key via that function. Use Power Query (Web.Contents with Headers parameter) or VBA (MSXML2.XMLHTTP with setRequestHeader) instead. Both support the required authentication header.

How often can I refresh the data?

Power Query supports auto-refresh as frequent as every 1 minute, which lines up well with the API: our data updates about every 60 seconds, so refreshing more often than that won't yield new data, though it won't cause errors either. For Starter and Pro plans, there's no refresh rate limit on your end.

Does this work with Google Sheets?

Yes. Use Google Apps Script's UrlFetchApp.fetch() with the X-API-Key header. You can write a custom function or a timed trigger to refresh data into cells. Google Sheets also works with the same Power Query-equivalent approach via its own data connectors.

Plug into any stack

ChatGPT Custom GPTs
Claude Tools
Python / pandas
Node.js
Discord bots
Slack webhooks
n8n
Zapier
Google Sheets

Docs and implementation

Every next step is one click away.

Landing pages convert; documentation closes the loop. These are the routes a developer usually needs next.

Frequently asked questions

What developers ask first.

Straight answers on limits, coverage and how the endpoint behaves in production.

Can I use WEBSERVICE() in Excel to call the API?

How often can I refresh the data?

Does this work with Google Sheets?

Start building

Start Building in 5 Minutes

Every new account starts with $2.50 of pay-as-you-go credit. No card required.

Get $2.50 free credit Read the Docs