STOCKHISTORY
Quirk foundCategory: Information · Last tested 2026-09-01
Real compatibility results for the STOCKHISTORY function: executed in Excel for the web, Google Sheets and LibreOffice Calc, with desktop Excel behavior from Microsoft’s official documentation (we do not run desktop Excel — Excel for the web is a different application and is executed separately). Syntax and links to that documentation are below.
Support matrix
| Engine | Documented | Live-tested | Verdict |
|---|---|---|---|
| Excel (desktop) | Yes | No — documented only | n/a |
| Excel for the web | — | Yes (recalc, 2026-09-01) | Quirk found |
| Google Sheets | No | Yes (Drive import, 2026-08-31) | Unsupported (not recognized) |
| LibreOffice Calc | No | Yes (25.8.7.3, 2026-08-31) | Unsupported (not recognized) |
LibreOffice version history
We executed the same test cases under each LibreOffice release to show exactly when STOCKHISTORY’s support changed — not documentation claims, real results.
| LibreOffice version | Verdict | Tested |
|---|---|---|
| 24.2.0.3 | Unsupported (not recognized) | 2026-08-31 |
| 24.8.7.2 | Unsupported (not recognized) | 2026-08-31 |
| 25.2.0.3 | Unsupported (not recognized) | 2026-08-31 |
| 25.8.7.3 | Unsupported (not recognized) | 2026-08-31 |
Why isn't STOCKHISTORY working in LibreOffice?
LibreOffice Calc does not implement STOCKHISTORY as of 25.8.7.3 — in our
executed tests it returns a #NAME? (unrecognized function) error. This is not a typo or a
settings problem, and saving the file as .xlsx does not change it: the function simply isn’t
available yet.
The same formula is documented for Excel.
Watch the LibreOffice version support page —
we re-run every test on each new release, so it will flip to Supported here as soon as it lands.
Why isn’t STOCKHISTORY working in Google Sheets?
Google Sheets does not implement STOCKHISTORY: we imported the formula into
Sheets on 2026-08-31 and every case came back #NAME?
(unrecognized function). Sheets is a rolling service with no version to pin, so this is a
statement about the service on that date, and Google’s own
function list does not document it either. Rewrite the formula with a documented
Sheets equivalent — see the
Excel ↔ Sheets equivalents table.
Executed test cases
Excel for the web (executed 2026-09-01 via OneDrive recalculation)
These values come from Excel for the web, not from desktop Excel. They are two different implementations of the calculation engine, and this run measured only the web one: the corpus was uploaded to OneDrive as .xlsx, recalculated by Excel for the web on open, and downloaded again for readback. Excel for the web is a rolling service with no pinnable version, so the run is identified by its date. Where a value here disagrees with the Expected column — which is Microsoft’s documentation of the desktop product — we cannot tell you whether the web engine diverges from the desktop one or the documentation is wrong about both, because we do not run desktop Excel.
| Formula | Description | Result | Expected | Verdict |
|---|---|---|---|---|
| =STOCKHISTORY("MSFT",DATE(2020,1,1)) | Existence probe only: STOCKHISTORY returns historical market data from a Microsoft-selected provider, so its output is neither offline-reproducible nor stable over time | #VALUE! | ProvenanceNOT DETERMINISTICALLY ASSERTABLE, and deliberately recorded as a probe rather than a support claim. THE PAGE HAS NO EXAMPLE SECTION, NO EXAMPLE TABLE AND NO REMARKS AT ALL -- its only sections are Technical details, Notes and Tips, and a search of the whole article for every Excel error token (#VALUE!, #NUM!, #N/A, #NAME?, #BUSY!, #CONNECT!, #BLOCKED!, #FIELD!, #REF!, #DIV/0!) returns zero hits, so Microsoft publishes neither a value nor an error code that any engine could be held to. What it does publish is why: "The STOCKHISTORY function requires a Microsoft 365 Personal, Microsoft 365 Family, Microsoft 365 Business Standard, or Microsoft 365 Business Premium subscription"; "This will pull data from the default exchange for the instrument"; "while some financial instruments may be available as Stocks data types, the historical information will not be available"; "STOCKHISTORY... generally only updates after a trading day completes... you cannot use STOCKHISTORY to get data for today's trading details until after the market has closed"; and "Date returned may be earlier than the date provided." A function whose answer depends on a paid subscription, an exchange's choice of default, and what time of day the sheet is recalculated has no value a compatibility corpus can assert. What the run does establish is recorded separately: probing all four pinned LibreOffice builds (24.2.0.3, 24.8.7.2, 25.2.0.3, 25.8.7.3) with the plain name, the _xlfn. storage form, the COM.MICROSOFT. add-in form, the ORG.OPENOFFICE. form and the _xlfn.ORG.OPENOFFICE. form returned #NAME? for ALL FIVE spellings on every build, which is the signature of a name the engine does not implement at all. Microsoft's page was read live on 2026-08-31 at https://support.microsoft.com/en-us/excel/functions/stockhistory-function. FETCH NOTE FOR THIS BATCH: batch F recorded every /en-us/office/<name>-function-<guid> URL returning Microsoft's 'Sorry, the page you're looking for can't be found' body; today BOTH paths serve the article again -- the GUID form redirects to /en-us/excel/functions/<slug>-function -- and every page cited in this batch came back complete (217-223 KB) in one or two attempts, with no 87 KB stub responses. Nothing here is sourced from a search snippet or a mirror. |
Error |
Google Sheets (executed 2026-08-31 via Drive import)
Google Sheets is a rolling service with no pinnable version, so this run is identified by its date. The corpus was imported to Drive as .xlsx, recalculated by Sheets, and exported back for readback.
| Formula | Description | Result | Expected | Verdict |
|---|---|---|---|---|
| =STOCKHISTORY("MSFT",DATE(2020,1,1)) | Existence probe only: STOCKHISTORY returns historical market data from a Microsoft-selected provider, so its output is neither offline-reproducible nor stable over time | #NAME? | ProvenanceNOT DETERMINISTICALLY ASSERTABLE, and deliberately recorded as a probe rather than a support claim. THE PAGE HAS NO EXAMPLE SECTION, NO EXAMPLE TABLE AND NO REMARKS AT ALL -- its only sections are Technical details, Notes and Tips, and a search of the whole article for every Excel error token (#VALUE!, #NUM!, #N/A, #NAME?, #BUSY!, #CONNECT!, #BLOCKED!, #FIELD!, #REF!, #DIV/0!) returns zero hits, so Microsoft publishes neither a value nor an error code that any engine could be held to. What it does publish is why: "The STOCKHISTORY function requires a Microsoft 365 Personal, Microsoft 365 Family, Microsoft 365 Business Standard, or Microsoft 365 Business Premium subscription"; "This will pull data from the default exchange for the instrument"; "while some financial instruments may be available as Stocks data types, the historical information will not be available"; "STOCKHISTORY... generally only updates after a trading day completes... you cannot use STOCKHISTORY to get data for today's trading details until after the market has closed"; and "Date returned may be earlier than the date provided." A function whose answer depends on a paid subscription, an exchange's choice of default, and what time of day the sheet is recalculated has no value a compatibility corpus can assert. What the run does establish is recorded separately: probing all four pinned LibreOffice builds (24.2.0.3, 24.8.7.2, 25.2.0.3, 25.8.7.3) with the plain name, the _xlfn. storage form, the COM.MICROSOFT. add-in form, the ORG.OPENOFFICE. form and the _xlfn.ORG.OPENOFFICE. form returned #NAME? for ALL FIVE spellings on every build, which is the signature of a name the engine does not implement at all. Microsoft's page was read live on 2026-08-31 at https://support.microsoft.com/en-us/excel/functions/stockhistory-function. FETCH NOTE FOR THIS BATCH: batch F recorded every /en-us/office/<name>-function-<guid> URL returning Microsoft's 'Sorry, the page you're looking for can't be found' body; today BOTH paths serve the article again -- the GUID form redirects to /en-us/excel/functions/<slug>-function -- and every page cited in this batch came back complete (217-223 KB) in one or two attempts, with no 87 KB stub responses. Nothing here is sourced from a search snippet or a mirror. |
Error |
LibreOffice Calc 25.8.7.3 (tested 2026-08-31)
| Formula | Description | Result | Expected | Verdict |
|---|---|---|---|---|
| =STOCKHISTORY("MSFT",DATE(2020,1,1)) | Existence probe only: STOCKHISTORY returns historical market data from a Microsoft-selected provider, so its output is neither offline-reproducible nor stable over time | #NAME? | ProvenanceNOT DETERMINISTICALLY ASSERTABLE, and deliberately recorded as a probe rather than a support claim. THE PAGE HAS NO EXAMPLE SECTION, NO EXAMPLE TABLE AND NO REMARKS AT ALL -- its only sections are Technical details, Notes and Tips, and a search of the whole article for every Excel error token (#VALUE!, #NUM!, #N/A, #NAME?, #BUSY!, #CONNECT!, #BLOCKED!, #FIELD!, #REF!, #DIV/0!) returns zero hits, so Microsoft publishes neither a value nor an error code that any engine could be held to. What it does publish is why: "The STOCKHISTORY function requires a Microsoft 365 Personal, Microsoft 365 Family, Microsoft 365 Business Standard, or Microsoft 365 Business Premium subscription"; "This will pull data from the default exchange for the instrument"; "while some financial instruments may be available as Stocks data types, the historical information will not be available"; "STOCKHISTORY... generally only updates after a trading day completes... you cannot use STOCKHISTORY to get data for today's trading details until after the market has closed"; and "Date returned may be earlier than the date provided." A function whose answer depends on a paid subscription, an exchange's choice of default, and what time of day the sheet is recalculated has no value a compatibility corpus can assert. What the run does establish is recorded separately: probing all four pinned LibreOffice builds (24.2.0.3, 24.8.7.2, 25.2.0.3, 25.8.7.3) with the plain name, the _xlfn. storage form, the COM.MICROSOFT. add-in form, the ORG.OPENOFFICE. form and the _xlfn.ORG.OPENOFFICE. form returned #NAME? for ALL FIVE spellings on every build, which is the signature of a name the engine does not implement at all. Microsoft's page was read live on 2026-08-31 at https://support.microsoft.com/en-us/excel/functions/stockhistory-function. FETCH NOTE FOR THIS BATCH: batch F recorded every /en-us/office/<name>-function-<guid> URL returning Microsoft's 'Sorry, the page you're looking for can't be found' body; today BOTH paths serve the article again -- the GUID form redirects to /en-us/excel/functions/<slug>-function -- and every page cited in this batch came back complete (217-223 KB) in one or two attempts, with no 87 KB stub responses. Nothing here is sourced from a search snippet or a mirror. |
Error |
Docs & syntax
- Excel (desktop): official documentation