Vocordia

Get hands-on help with Vocordia

Employees can follow this guide step by step - or open a ticket and wait for support.

Or they can finish inside the app.

Vocordia gives voice and cursor guidance directly inside the tools they already use - just say what they need, and Vocordia shows them where to click, step by step, without leaving the window.

Start today for freeHow it works

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

  1. Type tickers in a column (e.g. AAPL, MSFT, GOOG).
  2. Select the cells, then Data → Stocks.
  3. 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.
  4. 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.

Still routing this to IT or HR?

There's a faster way.

Next time, employees can ask by voice and get step-by-step guidance inside the app - no manual, no ticket.

Start today for freeHow it works