The Scenario
You are a portfolio manager. Your trading plan for the next quarter starts Monday. You manage 40 positions and you want to see all upcoming earnings dates for your holdings alongside the IPO calendar for the next 90 days in one place before the week starts.
The manual version:
- You go to a financial site, search for ticker one's earnings date, write it into the sheet
- You search for ticker two, write it down
- You repeat for all 40 positions
- You find a separate site for the IPO calendar, cross-reference the names
- It is Sunday evening, you have spent two hours on a calendar that should have taken ten minutes, and you have already missed one earnings date that was tomorrow.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that fetches both the earnings and IPO calendars from Alpha Vantage and filters them to your portfolio in one pass.
Open the SheetXAI sidebar and type:
Fetch the earnings calendar from Alpha Vantage for the next 3 months and filter it to only show tickers that are in column A of my portfolio sheet, writing matched rows to columns D through G. Then pull the Alpha Vantage IPO calendar for the next 3 months and write company name, expected date, and exchange to this sheet, then highlight any IPOs with estimated market cap over $1B.
SheetXAI fetches the full earnings calendar from Alpha Vantage, filters it to your 40 holdings, writes the matched rows to columns D through G, and then fetches and writes the IPO calendar with the large-cap flag.
What You Get
Two calendar views in one sheet:
- Columns D-G — upcoming earnings dates filtered to your 40 holdings (ticker, earnings date, estimated EPS, actual EPS if reported)
- IPO calendar section — company name, expected date, and exchange for all upcoming IPOs over the next 90 days
- Large-cap highlight — any IPO with estimated market cap above $1B is flagged
You see the full trading calendar for your portfolio in one view. No cross-referencing. No missed dates.
Want a week-by-week view sorted by earnings date? Add "sort the earnings rows in columns D through G by date ascending and group them by week" to the prompt.
What If the Data Is Not Quite Ready
Earnings calendars have their own complications. SheetXAI handles them in the same prompt.
When the earnings dates include both confirmed and unconfirmed dates
Alpha Vantage marks some earnings dates as confirmed and others as estimated. You want to see the distinction.
Fetch the earnings calendar from Alpha Vantage for the next 3 months, filter to tickers in column A, and write matched rows to columns D through G. Add a column H that marks whether the earnings date is confirmed or estimated based on the Alpha Vantage data.
When you want to flag positions with earnings in the next two weeks separately
You want to know which holdings have imminent earnings so you can decide whether to hold or reduce before the report.
After filtering the earnings calendar to your holdings and writing it to columns D through G, add a column I that marks any ticker with an earnings date within the next 14 days as "IMMINENT." Sort the matched rows by date ascending.
When you want to add analyst EPS estimates alongside the calendar
Knowing the earnings date is useful. Knowing whether the street expects a beat or miss is better.
After writing the filtered earnings calendar to columns D through G, add the analyst consensus EPS estimate for each matched ticker from the Alpha Vantage earnings data into column H. If no estimate is available, write "N/A."
When you need the full pre-quarter trading calendar in one shot
Monday starts in three days. You need the filtered earnings calendar, the IPO calendar with large-cap flags, imminent earnings highlighted, EPS estimates, and a brief summary of the three highest-risk weeks based on the concentration of earnings dates.
Fetch the next 3 months of earnings dates from Alpha Vantage, filter to my 40 holdings in column A, write matched rows to columns D through H, and flag dates within 14 days as "IMMINENT." Add consensus EPS estimates to column I. Fetch the next 90 days of IPO data and write company, date, and exchange below the earnings section. Flag IPOs with estimated market cap over $1B. Identify the three calendar weeks with the most earnings events across my holdings and write a two-sentence risk note for each into cells D55 through D57.
The pattern: the two calendar pulls, the filtering, the flags, and the risk summary all happen before Monday morning.
Try It
Get the 7-day free trial of SheetXAI and open any portfolio tracking sheet, then ask it to pull the Alpha Vantage earnings and IPO calendars and filter them to your holdings. The Alpha Vantage integration is included in every SheetXAI plan. For related workflows, see how to scan news sentiment for portfolio holdings or the Alpha Vantage in Google Sheets overview.