The Scenario
You are a portfolio analyst. The quarterly earnings season ends tomorrow and your investment committee meets at 9 AM. You have 80 tickers in column A of the Holdings tab in an Excel workbook and you need Q1 through Q4 revenue, gross margin, and EPS for the last four quarters for every company before you walk in the door.
The bad version of the evening before:
- You copy ticker one, open the Alpha Vantage docs, find the income statement endpoint
- You paste the URL into the browser, wait for the JSON, find the fields you want
- You copy the four quarterly values for revenue, gross profit, EPS into the workbook manually
- You do it again for ticker two
- You are on ticker nine at 11 PM and there are 71 left
- You walk into the 9 AM meeting with data for twelve companies.
The fast version is one prompt before you go home.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your workbook that reads the ticker list and calls Alpha Vantage for you, so you do not have to touch the API documentation.
Open the SheetXAI sidebar and type:
For every ticker in column A of the Holdings tab, fetch the last 4 quarters of revenue, gross profit, and EPS from Alpha Vantage income statements and paste the results into columns B through M. Label the columns with the ticker and quarter reference in row 1.
SheetXAI reads all 80 rows, calls the Alpha Vantage income statement endpoint for each ticker, parses the quarterly JSON, and writes the data into the workbook. You come back in the morning to a complete table.
What You Get
A filled workbook with columns B through M populated across all 80 tickers in the Holdings tab:
- Revenue columns (B-E) — Q1 through Q4 revenue for each company
- Gross profit columns (F-I) — quarterly gross profit
- EPS columns (J-M) — quarterly EPS from reported financials
- Row 1 headers — labelled with ticker and quarter reference
The data comes straight from Alpha Vantage's reported financials, not estimates. What you see is what each company filed.
Want gross margin calculated inline? Add "calculate gross margin as gross profit divided by revenue for each quarter and write into columns N through Q" to the prompt. SheetXAI does both the fetch and the formula in one pass.
What If the Data Is Not Quite Ready
Financial data pulled at scale is rarely uniform. SheetXAI handles cleanup and the fetch in the same prompt.
When some tickers return no data
Not every ticker will have Alpha Vantage fundamentals coverage. ETFs, recent IPOs, and foreign listings often return empty responses.
For every ticker in column A of the Holdings tab, fetch the last 4 quarters of revenue, gross profit, and EPS from Alpha Vantage. If a ticker returns no data, write "NO DATA" in column B and skip the rest of that row. Write results for all other tickers into columns B through M.
When you also need to flag high-debt companies
The committee wants to know which companies have debt-to-equity above 2.0, alongside the income statement data.
For every ticker in column A of the Holdings tab, fetch the last 4 quarters of revenue, gross profit, and EPS from Alpha Vantage income statements and write them into columns B through M. Then pull annual balance sheet data for each ticker, calculate debt-to-equity, and flag any company where D/E exceeds 2.0 in column N.
When you only want companies in a specific sector
The list in column A has mixed sectors and you only want the technology names for this analysis.
For each ticker in column A of the Holdings tab, fetch the company overview from Alpha Vantage and check the sector field. Keep only tickers where sector is Technology. For those tickers, fetch the last 4 quarters of revenue, gross profit, and EPS and write them into columns B through M.
When you need the full analysis in one shot
The committee wants income statement data, margin trends, and a written summary for each company, and you have the tickers and nothing else.
For every ticker in column A of the Holdings tab, fetch the last 4 quarters of revenue, gross profit, and EPS from Alpha Vantage. Calculate gross margin for each quarter. Identify which quarter had the highest margin and which had the lowest. Write all values into columns B through P, then add a one-sentence trend summary per ticker into column Q describing whether margins are expanding, contracting, or flat.
The pattern: instead of fetching the data first and analyzing second, you ask for both in one prompt. SheetXAI handles the multi-step chain inline.
Try It
Get the 7-day free trial of SheetXAI and open any workbook with a ticker list, then ask it to pull Alpha Vantage income statement data for every row. The Alpha Vantage integration is included in every SheetXAI plan. For more workflows, see how to enrich a watchlist with fundamentals in Excel or the Alpha Vantage in Excel overview.