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 — every 2 seconds.
No credit card. $2.50 PAYG credit on sign up.
One Request. Instant Data.
' 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 FunctionWhy Use TickAtlas?
Pre-Calculated, Sub-100ms
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 all symbols active on connected broker terminals.
Plug into any stack
- ChatGPT Custom GPTs
- Claude Tools
- Python / pandas
- Node.js
- Discord bots
- Slack webhooks
- n8n
- Zapier
- Google Sheets
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:
Simple Pricing
Unlimited calls. Auto-refresh your Excel dashboard as often as you want.
Get StartedMultiple simultaneous spreadsheets, high-frequency refresh, team sharing.
Get StartedFAQ
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. The API itself has a 2-second cache, so refreshing more often than every 2 seconds won't yield new data but 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.
Frequently Asked Questions
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. The API itself has a 2-second cache, so refreshing more often than every 2 seconds won't yield new data but 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.
Start Building in 5 Minutes
Sign up, grab your API key, make your first request.
Every new account gets $2.50 in free PAYG credits. No card required.