Get hands-on help with Vocordia
You can do it the hard way - reading guides, switching tabs, figuring it out step by step.
Or you can do it the easy way.
Vocordia is your AI copilot across Excel and any software on your screen - just say what you want, and your cursor will guide you step by step, so you can get it done instantly without leaving your window.
How to Get Stock Prices in Excel
Microsoft 365 Excel has a built-in **Stocks** linked data type plus the `STOCKHISTORY` function. Together they let you pull current quotes and historical prices straight into a worksheet.
Use the Stocks data type for live data
- Type tickers in a column (e.g. AAPL, MSFT, GOOG).
- Select the cells, then Data → Stocks.
- Excel converts each into a linked record. Click the insert data icon next to a converted cell and pick fields like Price, Change, 52 week high.
- Refresh with Data → Refresh All to pull current quotes.
Pull historical prices with STOCKHISTORY
In any cell, use:
=STOCKHISTORY("AAPL", "1/1/2025", "12/31/2025", 0, 1, 0, 1)
Arguments: ticker, start, end, interval (0=daily, 1=weekly, 2=monthly), headers, and which fields to include (Date, Close, Open, High, Low, Volume).
Build a small dashboard
Combine the two: ticker cells with the Stocks data type for live pricing on top, and STOCKHISTORY filling a chart below.
Refresh and licensing
The Stocks data type and STOCKHISTORY need a Microsoft 365 subscription with internet access. Quotes are delayed by ~15 minutes for most exchanges.
Try it faster with guidance
Skip the menu maze—let Vocordia guide you through it with voice and on-screen cursor guidance so you can wire up tickers and history without misplacing arguments.
Had to scroll back or switch tabs a few times?
That's the hard way.
Next time, just say what you want - and let your cursor guide you step by step to the result.