Use FXMacroData in Looker Studio
Connect reports to official-source macroeconomic indicators, FX spot rates, and commodity prices through the FXMacroData Community Connector.
Secure key auth
The connector uses Looker Studio key authorization. Your FXMacroData key is stored for your Google user in Apps Script user properties.
Report controls
Date range controls are passed through to the API as `start_date` and `end_date` for chart-specific windows.
Official-source data
Macro series are backed by central banks, statistics offices, and other official publishers, then served from FXMacroData.
Connect from Looker Studio
- Open Looker Studio and choose Create > Data source.
- Select FXMacroData from the connector gallery.
- Authorize with your FXMacroData API key.
- Choose an API endpoint: announcements, forex, or commodities.
- For announcements, choose all announcement series or one currency/indicator series. For targeted endpoints, configure the currency, indicator slug, FX pair, or commodity.
- Click Connect, then create a report or chart.
Public REST endpoints such as USD indicators and FX spot rates can be called without a key outside Looker Studio. The published connector asks for a key so every connector mode uses one secure credential flow.
Connector datasets
| API endpoint | Connector mode | Fields | REST path |
|---|---|---|---|
| Announcements | All announcement series; filter by currency and indicator in Looker Studio | date, currency, indicator, indicator_name, unit, frequency, source, value, announcement_datetime |
https://fxmacrodata.com/api/announcements/{currency}/{indicator} |
| Announcements | Single currency and indicator slug | date, value, announcement_datetime |
https://fxmacrodata.com/api/announcements/{currency}/{indicator} |
| Forex | Base currency and quote currency | date, rate |
https://fxmacrodata.com/api/forex/{base}/{quote} |
| Commodities | Commodity slug | date, price |
https://fxmacrodata.com/api/commodities/{indicator} |
Example source requests
The connector calls the production FXMacroData API and sends your authorized key as an `api_key` query parameter.
https://fxmacrodata.com/api/announcements/usd/inflation?api_key=YOUR_API_KEY https://fxmacrodata.com/api/forex/eur/usd?api_key=YOUR_API_KEY https://fxmacrodata.com/api/commodities/gold?api_key=YOUR_API_KEY