Get historical prices

Use a historical-price function when you need a value from a specific date. Keep the symbol and date in separate input cells so that you can reuse the analysis.

Return the closing price for one date

1. Enter a symbol in A2, such as MSFT.
2. Enter a date in B2. Use an Excel date value, not unstructured text.
3. Enter the formula:
   • Windows: =Close_Historical(A2,B2)
   • Mac or Excel for the web: =mxls.Close_Historical(A2,B2)
4. Press Enter.
5. Copy the formula down if you have more symbol-and-date pairs.

Screenshot needed · WORKFLOW-HISTORY-01

Capture symbols, valid Excel dates, and Close_Historical results in a clean three-column table.

/images/docs/shared/historical-price-inputs.webp

Choose the correct price field

Use the matching historical function for open, high, low, close, or volume. Search the formula reference for the field, and check its platform label before you build a shared workbook.

Historical data follows exchange calendars. A weekend or market holiday might return the previous session, no value, or a result controlled by the function's optional holiday argument. Check the exact formula page before relying on holiday behavior.

Build a time series

1. Put the first date in a date column.
2. Fill down a daily, weekly, or monthly sequence with Excel.
3. Add the historical formula beside the date.
4. Copy the formula down.
5. Convert the range to an Excel table or chart when the values finish loading.

Screenshot needed · WORKFLOW-HISTORY-02

Capture a clean MSFT date-and-close series with a simple Excel line chart.

/images/docs/shared/historical-price-series.webp

If values look old or incomplete, read Understand data coverage and delays and Fix stale or incorrect data.