Share via

How long does it take to update new IPO listings in my Excel 365???

Eddie Tillman 45 Reputation points
2025-10-31T05:26:21.16+00:00

Microsoft Excel spreadsheets obtain stock data from Refinitiv or LSEG Data & Analytics, but this company doesn’t provide fundamental company data, historical data, real-time and delayed prices, and fund performance data for “all IPOs”, such as ticker symbols, MNTN, FTRK, CRCL, OMDA, JEM, VOYG, VNTG, SLDE, EGG, CAI, FMFC, JCAP, EMPG, KMRK, MGRT, CARL, CRE, TDIC, ARX, MH, FIG, AMBQ and much more.  These new stocks hit the market over four months ago.  Why do customers of Microsoft Office have to wait that long for information?  Many customers like me are very disappointed with this type of delayed service__.  Google Sheets have the required data for all IPOs, but I need to see this on the Excel spreadsheets as well.__  Thank you.

Microsoft 365 and Office | Excel | For home | Windows
0 comments

Answer accepted by question author

Emmanuel Santana 39,735 Reputation points Independent Advisor
2025-10-31T08:35:26.41+00:00

Hello. I saw you already asked this question in another thread and got some good replies. Just to add from my own experience, Excel’s stock data comes from a simplified version of Refinitiv’s feed, which focuses on verified and historical info. That means new IPOs don’t show up right away.

On Refinitiv’s professional platforms (like Datastream), new listings appear much faster, but in Excel they only show once all company details are fully checked and added to the database. Since there’s no fixed update schedule for IPOs, some new tickers, like MNTN, FTRK, CRCL, or VOYG, can take a few months to appear.

A workaround would be to get a free key from providers like IEX Cloud, Alpha Vantage, or Financial Modeling Prep.

  1. In Excel, go to Data > Get Data > From Web and paste an API URL such as: 
       https://financialmodelingprep.com/api/v3/quote/MNTN?apikey=YOUR_KEY
  2. Parse the JSON response and load it into a table.

Was this answer helpful?

1 person found this answer helpful.
0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.