The Scenario
You are a fund administrator managing a multi-currency portfolio. The fund holds equity positions across US, European, and Asian exchanges — tickers settled in USD, EUR, GBP, HKD, and a handful of others. Every month you produce a consolidated report in your base currency, which means every position value needs to be tagged with its settlement currency before the FX conversion step.
The first thing you need is a reference table: every currency code and name that Marketstack supports, so you can map each ticker's currency to the correct conversion rate. You have a Google Sheet ready to receive it.
The last person who built this reference pulled it manually from a financial data site, not Marketstack. It is six months old and missing three currency codes that appeared in last month's positions. You need the authoritative Marketstack list.
The bad version:
- Call Marketstack's currencies endpoint in a browser, inspect the JSON, and start copying currency code and name pairs into the sheet row by row
- Get through about 30 rows, realize the API response has 170 currencies, and decide this is a task for a script instead — but you do not have time to write one right now
- Find the 2024 version of this list from the previous admin in a shared folder, wonder if it is still complete, and use it anyway with a note that it needs verification
The FX conversion step cannot be trusted until the currency mapping is current and complete.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the sheet context and through its Marketstack integration it can fetch the complete currency list from Marketstack and write it into the sheet in one operation.
Fetch all supported currencies from Marketstack and write the currency code and full currency name into columns A and B of this sheet — one currency per row, sorted alphabetically by currency code
What You Get
- Every currency code Marketstack supports in column A
- Full currency name in column B
- Sorted alphabetically by code so lookups and VLOOKUP references are straightforward
- The complete list, not a subset — every page of the Marketstack response included
What If the Data Is Not Quite Ready
You want a third column with the currency symbol (dollar sign, euro sign, etc.)
Fetch all supported currencies from Marketstack and write the 3-letter currency code in column A, the full name in column B, and the currency symbol in column C if Marketstack provides it
You want to cross-reference against the currencies already in your positions table
Fetch all supported currencies from Marketstack and write the code and name into a tab called Currency Reference; then look at the Positions tab and in column D of that tab, write YES for each row where the settlement currency is in the Marketstack list and NO where it is not
You want the list deduplicated and flagged for any duplicate codes
Fetch all supported currencies from Marketstack and write code and name into this sheet; flag any row where the same currency code appears more than once in the response with a note in column C
Full pipeline: fetch currencies, map positions, calculate total exposure per currency
Fetch all Marketstack-supported currencies and write code and name into a Currency Reference tab; then look at the Positions tab where column E has the settlement currency code for each position and column D has the position value in local currency — add a Currency Exposure summary tab showing the total position value per currency code, sorted by total exposure descending
Doing the currency fetch and the exposure rollup in one prompt means the monthly report section is ready, not still being assembled.
Try It
Get the 7-day free trial of SheetXAI and open a Google Sheet set up for currency reference work, then ask it to pull the complete Marketstack currency list into the sheet. The Marketstack integration is included in every SheetXAI plan.
See also: enriching tickers with exchange metadata and looking up exchange details by MIC code.