The Scenario
You've been asked to contribute a regional economic comparison section to a research report due Thursday. The section needs GDP growth, CPI inflation, and unemployment rates for 15 countries over the past decade — organized in an Excel workbook the lead economist can hand off directly to the designer. The data exists on EODHD. What doesn't exist yet is the workbook.
The bad version:
- Pull up the EODHD macro data endpoint documentation, figure out which indicator codes map to GDP growth vs. GDP level, make a test API call to confirm the response structure.
- Write or adapt a script to loop over 15 country codes, call three separate indicator endpoints per country, and reshape 45 API responses into rows and columns that align by year.
- Discover partway through that two countries use fiscal-year reporting rather than calendar-year, which means the annual values land in the wrong column when you align by December.
The report deadline is Thursday. You've just spent most of Tuesday on data plumbing.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your country list, calls the EODHD macroeconomic endpoints for each indicator and country, and builds the annual comparison table — no endpoint documentation, no loop, no response reshaping required.
Fetch macroeconomic indicators from EODHD for all 15 countries in my Excel 'Country List' sheet — GDP per capita, CPI, and unemployment rate — and fill columns C, D, and E with the latest annual values.
What You Get
- Three indicator columns per country: GDP growth %, CPI %, unemployment %
- Years in descending order, matching how analysts typically scan the table
- Any country/year combination with missing data left blank rather than filled with a zero
- Values formatted as percentages where appropriate
What If the Data Is Not Quite Ready
The country list uses full names, not ISO codes
Column A has "Germany," "South Korea," "Brazil" — not "DEU," "KOR," "BRA."
Convert each country name in column A of my Excel 'Country List' worksheet to its ISO alpha-3 code and write it into column B, then use those codes to pull GDP growth, inflation, and unemployment from EODHD for the past 10 years.
You need currency-adjusted GDP per capita
The comparison needs GDP per capita in constant 2015 USD for comparability.
For each country in column A of my Excel 'Country List' worksheet, pull GDP per capita in constant 2015 USD from EODHD for each year in the past decade and write it into a new column alongside the existing indicators.
Some countries have gaps in the time series
A few emerging market countries have missing years in the EODHD dataset, which breaks the chart the designer is building.
For each country in column A of my Excel 'Country List' worksheet, pull the 10-year macro series from EODHD, and for any years where data is missing, interpolate the value as the average of the surrounding years and mark the interpolated cells in yellow.
Full report-ready prep: pull, normalize, flag outliers, build summary row
Pull GDP growth, inflation, and unemployment for all 15 countries in my Excel 'Country List' worksheet from EODHD for the past 10 years, normalize each indicator to a 0–100 index relative to the group, flag any country-year with a value more than 2 standard deviations from the group mean in red, and add a final row showing the unweighted average for each indicator by year.
One prompt. A clean comparison table ready for the designer.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with a country or region list, then ask it to pull the macro series from EODHD. You can also ask it to pull yield curve data for fixed-income analysis or return to the EODHD APIs hub.