Excel में FXMacroData का उपयोग करें

Power Query, direct API URLs और Excel-ready API patterns का उपयोग करके macro indicators, policy rates, FX rates और release-calendar data को Microsoft Excel में लाएँ। localized routes पर source value, local numbering और unit or currency comparison को साथ दिखाएँ।

Power Query from Web

In Excel, open Data > Get Data > From Other Sources > From Web, then paste one of these URLs. Use the Power Query editor to expand the JSON rows into a table.

Latest USD inflation series

https://api.fxmacrodata.com/announcements/usd/inflation?api_key=YOUR_API_KEY

Upcoming AUD release calendar

https://api.fxmacrodata.com/calendar/aud?api_key=YOUR_API_KEY

EUR/USD FX history

https://api.fxmacrodata.com/forex/eur/usd?start_date=2026-01-01&api_key=YOUR_API_KEY

Localized value example for /hi/

Locale routes should preserve the source value and add a locally familiar number system such as lakh/crore where it improves comprehension.

Power Query M pattern

let
    Source = Json.Document(Web.Contents("https://api.fxmacrodata.com/announcements/usd/inflation")),
    Rows = Source[data],
    TableRows = Table.FromRecords(Rows)
in
    TableRows

Excel add-in workflow

Power Query आज supported path है। Packaged add-in custom worksheet functions और repeatable analyst workflows के लिए natural next step है।

=FXMACRODATA.CATALOGUE("usd")
=FXMACRODATA.INDICATOR("usd","inflation")
=FXMACRODATA.CALENDAR("aud")
=FXMACRODATA.FOREX("eur","usd")