Announcing STOCKHISTORY

Published Jun 10 2020 10:17 AM 116K Views
Microsoft

Disclaimer
STOCKHISTORY requires a Microsoft 365 Personal, Microsoft 365 Family, Microsoft 365 Business Standard, or Microsoft 365 Business Premium subscription. 

 

Excel is introducing a dynamically updating service-backed function that builds on the flexibility of dynamic arrays and fills a gap in the Stocks data type by providing access to historical data. 

 

We have added many needed improvements to support service-side errors and data retrieval, including new errors like #BUSY! that show in Excel while data is being processed. We also added a way for the function to spill formats dynamically instead of stamping a format on a cell.

 

Introducing STOCKHISTORY

 

StockHistoryChart1.png

 

Easily pulling stock prices into Excel has been one of the most requested features on UserVoice. The Stocks data type began this journey by enabling refreshable quotes for stocks, bonds, funds, and currency pairs. We know that this wasn’t enough to complete the goals you have for analyzing your portfolio in Excel. Getting the history of a financial instrument over time is crucial information you need. We are thrilled to be able to bring this functionality into Excel.

 

Getting started is simple

 

StockHistoryFunction1.png

 

Let’s look at an overview of the function signature:

 

STOCKHISTORY(stock, start_date, [end_date],[interval],[headers], [property0], [property1] [property2], [property3], [property4], [property5])

 

  • stock: The identifier for the financial instrument targeted. This can be a ticker symbol or a Stocks data type.
  • start_date: The earliest date for which you want information.
  • end_date (optional): The latest date for which you want information.
  • interval (optional): Daily (0), Weekly (1), or Monthly (2) interval options for data
  • headers (optional): Specifies if additional header rows are returned with the array.
  • property0 – property5 (optional): Specifies which information should be included in the result, Date (0), Close (1), Open (2), High (3), Low (4), Volume (5).

You can find more detailed explanations of these arguments on the STOCKHISTORY support page.

 

Examples

 

Using Basic Text Inputs

 

=STOCKHISTORY("MSFT", "6/1/2020", "6/5/2020")

You can get started by using the ticker symbol as a textual representation of the stock. The start_date and end_date input will be interpreted by Excel the same way the DATEVALUE function would interpret date_text today. This means that the date inputs respect your system settings for datetime.

StockHistoryTextExample.png

 

Debugging Tip: Make sure you have any text values surrounded with quotation marks in your function inputs.

 

Choosing a Specific Exchange

If the ticker symbol is used as input without an exchange specified, the values will normally default to the XNAS (NASDAQ) stock exchange. There are two ways to help Excel know which financial instrument you are targeting. 

 

Using prepended text

First, you can use the Market Identifier Code, followed by a colon, followed by the ticker symbol to get data from a specific exchange.

 

=STOCKHISTORY(“XMIL:MSFT”, TODAY()-7, TODAY())

In this example, I am specifying the MSFT symbol on the Borsa Italiana Exchange ("XMIL:MSFT") and I am requesting the last 7 days of data using the TODAY() function. This function updates when the date changes and so as a part of calculation the dates shown in the grid will update as well. Notice how the dates shown skip non-trading days like weekends, and the prices shown are in euros.

 

StockHistoryExchangeExample.png

 

Using a Stocks data type

Second, you can use a cell containing a Stocks data type as a reference in the function, just like any other cell references.

 

=STOCKHISTORY(B1, B3, B4)

Below I have converted MSFT to a Stocks data type and chosen the data type for Microsoft from the Mexican Stock Exchange. I passed the cell containing the data type to the STOCKHISTORY function (B1). I also passed in references to cells containing dates (B3, and B4). If I edit any of these cells (B1, B3, or B4) the STOCKHISTORY function will recalculate based on the new values in the cells.

StockHistoryReferenceExample.png

 

Additional benefits to using a Stocks data type includes allowing you to see which currency the prices represent. Try the formula ‘=B1.Currency’ where B1 references a cell containing a Stocks data type.

 

CurrencyExample.png

 

Debugging Tip: To verify what exchange your stock history values are coming from, input the [header] argument of “2” (Show instrument identifier and header) into the formula.

HeaderArgumentExample.png

 

Getting Fancy

Let’s see an example using every argument and property in the function.

 

STOCKHISTORY("MSFT","1/1/2019","12/31/2019",2,2,0,5,2,3,4,1)

This function uses every input field to create a wonderful 2D array of data for me to analyze. This data represents Microsoft stock from January to December 2019 in a monthly overview for the Volume, Open, High, Low, and Close for that month. My goal is to chart this data in Excel.

 

Let me give a refresher on what this signature represents:

“MSFT” – The Microsoft ticker symbol,

“1/1/2019” – The start date,

“12/31/2019” – The end date,

2 – Indicates a choice to show the Monthly overview,

StockHistoryLongExample-Interval.png

 

2 – Indicates a choice to include both the ticker symbol and the label row in the resulting array,

StockHistoryLongExample-Header.png

 

0,5,2,3,4,1 – Indicates the properties I want, in the order I want them in the resulting array. In this case, Date, Volume, Open, High, Low, Close.

StockHistoryLongExample-Properties.png

 

All together this is the resulting formula in Excel with the data spilled into the grid.

StockHistoryLongExample.png

 

Then I can select this data, go to the Insert tab, click Recommended Charts >All Charts>Stock and insert a Volume-Open-High-Low-Close chart.

StockHistoryInsertChart.png

 StockHistoryChart2.png

I can use this function to produce many charts and graphs, as well as use the data as inputs into other Excel functions. Try out different uses and combinations and let me know what you think!

 

About our Data Sources

As with Excel’s Stocks data type we are sourcing the historical data from Refinitiv. You can read more about what exchanges are currently supported in Excel. While Stocks data type values can mostly be refreshed intraday on minor delay, STOCKHISTORY values are updated once daily for all supported exchanges at a minor delay after market close.

 

The STOCKHISTORY function also supports inputs of Currency Pairs, ETFs, Index Funds, Mutual Funds, and Bonds. The easiest way to specify these inputs is to convert them to the Stocks data type and use them as references to the function.

 

Please note that while some financial instruments may be available as Stocks data types, the historical information will not yet be available. For example, this is the case for most popular Index Funds including the S&P 500.

 

Numbers with Format Hints

STOCKHISTORY is the first function that provides formatting hints for its number. It does so by returning an enhanced number type that we refer to as a Formatted Number Value (“FNV”). FNVs are just like any other number in Excel but they are accompanied by a helpful formatting hint. Excel uses this format hint when the value lands in a cell with “General” number formatting applied, the default for unformatted cells.

 

In the example below, the STOCKHISTORY function is being used to retrieve the exchange rate for a currency pair between Jan 1st and Jan 7th, 2020. All the cells have the default “General” number format applied. Notice how the FNV’s (indicated with colored overlays) allow the Close column to seamlessly change from Pound (£) to Dollar ($) to Rand (R). In the example, FNVs are also used to have date serials (e.g. 43831) show using date formatting (e.g. 1/1/2020).

 

=STOCKHISTORY(C2, "1/1/2020", "1/7/2020")

FormattedNumberValueGIF.gif

 

 FNVs can pass through lookup style functions such as XLOOKUP, INDEX, IF, CHOOSE, or simple references (e.g. =A1) but the hint is simply ignored by other function which just see them as their number value.

 

Learn More

You can learn more about STOCKHISTORY by reviewing the STOCKHISTORY support article. This article goes in depth on the function definition and clarifies how monthly and weekly intervals are determined.

 

Availability Notes

STOCKHISTORY is now available to 100% of Microsoft 365 Subscribers, on Mac, Windows, and Excel Online.

 

Please continue to provide feedback either in the comments below or through our in-app feedback. Please let us know what you think!


To stay connected to Excel and its community, read the Excel blog posts and send us ideas and suggestions via UserVoice. You can also follow Excel on Facebook and Twitter

 

Kaycee Reineke (@KayceeSue)
Program Manager, Excel

83 Comments
%3CLINGO-SUB%20id%3D%22lingo-sub-1454466%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1454466%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F70934%22%20target%3D%22_blank%22%3E%40Kaycee%20Anderson%3C%2FA%3E%26nbsp%3B%2C%20thank%20you!%20That's%20really%20great%20function%20itself%20and%20introduction%20of%20FNV%20is%20even%20more%20great.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1454549%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1454549%22%20slang%3D%22en-US%22%3E%3CP%3ESome%20difference%20with%20Data%20Type%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20864px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F197954iDAB55362DD981101%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1454607%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1454607%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3Bgreat%20observation.%20I%20can%20add%20some%20clarity%20on%20how%20this%20currently%20works.%20The%20historical%20data%20is%20added%20at%20the%20end%20of%20the%20trading%20day%20when%20the%20market%20closes.%20Typically%20within%20a%20couple%20hours%20of%20that%20close.%20The%20Stock%20data%20type%20shows%20'real-time'%20data%20according%20to%20the%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fabout-the-stocks-financial-data-sources-98a03e23-37f6-4776-beea-c5a6c8e787e6%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Edelay%20agreement%20we%20have%20with%20the%20data%20provider%3C%2FA%3E.%20Currently%20intraday%20history%20isn't%20supported%20in%20our%20licensing%20of%20the%20data%20for%20Excel.%20What%20impact%20does%20intraday%20history%20play%20in%20your%20analysis%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1454654%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1454654%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F70934%22%20target%3D%22_blank%22%3E%40Kaycee%20Anderson%3C%2FA%3E%26nbsp%3BAre%20the%26nbsp%3B%3CSPAN%3EFormatted%20Number%20Values%20(%22FNV%22)%20available%20to%20third-party%20developers%20writing%20custom%20Excel%20functions%3F%20We%20have%20started%20leveraging%20the%20dynamic%20arrays%20feature%20in%20Excel%20with%20our%20custom%20functions%20and%20are%20exposing%20tabular%20data%20similar%20to%20how%20you%20implemented%20STOCKHISTORY.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThe%20top%20requirements%20I%20have%20at%20this%20point%20are%20to%20provide%20formatting%20for%20the%20column%20headers%20(bold!)%20and%20to%20do%20something%20with%20date%2Fcurrency%20values%20we%20return.%20Where%20can%20I%20find%20technical%20information%20on%20this%20feature%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1454676%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1454676%22%20slang%3D%22en-US%22%3E%3CP%3EI%20can%20confirm%20that%20STOCKHISTORY%20has%20been%20flighted%20to%20my%20system%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EKudos%20to%20you%20all%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECheers%3C%2FP%3E%0A%3CP%3EAbiola%20David%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1454765%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1454765%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F70934%22%20target%3D%22_blank%22%3E%40Kaycee%20Anderson%3C%2FA%3E%26nbsp%3B%2C%20it's%20more%20clear%20now%2C%20thank%20you%20for%20the%20clarification.%20So%20far%20I%20don't%20how%20critical%20this%20day%2C%20depends%20on%20how%20to%20use%20this%20function%20in%20application.%20Dates%20without%20sales%20are%20also%20missed%2C%20in%20some%20cases%20it's%20much%20better%20to%20have%20all%20dates.%20Will%20see%2C%20need%20to%20play%20more.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1454824%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1454824%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20is%20a%20wonderful%20update%2C%20thanks%20team!%26nbsp%3B%3C%2FP%3E%3CP%3ECan't%20wait%20to%20get%20a%20chance%20to%20try%20it%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3EJeff%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1454927%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1454927%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F259203%22%20target%3D%22_blank%22%3E%40GabrM%3C%2FA%3E%26nbsp%3BThanks%20for%20the%20feedback!%20FNV's%20are%20not%20yet%20available%20to%203rd%20party%20UDF%20providers%2C%20but%20this%20is%20something%20we%20are%20keeping%20an%20eye%20on.%20To%20ensure%20we%20have%20the%20right%20design%2C%20we%20wanted%20to%20first%20pilot%20FNV's%20with%20a%201st%20party%20function%20(STOCKHISTORY)%20before%20broadening%20out%20the%20feature%20based%20on%20user%20demand.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1454976%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1454976%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9664%22%20target%3D%22_blank%22%3E%40Joe%20McDaid%3C%2FA%3E%26nbsp%3Bthanks%20for%20your%20reply.%20This%20is%20a%20great%20improvement%20and%20I'm%20happy%20to%20see%20that%20dynamic%20arrays%20being%20leveraged%20by%20Microsoft%20in%20this%20way.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1455019%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1455019%22%20slang%3D%22en-US%22%3E%3CP%3EGreat%20work%20Kaycee%20and%20Team%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1455754%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1455754%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22RasnaSaini_0-1591858665812.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F198047iE23CAFDD26BA9103%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22RasnaSaini_0-1591858665812.png%22%20alt%3D%22RasnaSaini_0-1591858665812.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThat's%20my%20version%20and%20I%20just%20updated%20my%20office.%20I%20thought%20I%20should%20be%20able%20to%20use%20the%20stockhistory%20function%2C%20but%20it%20doesn't%20show%20up.%20What%20can%20I%20do%3F%26nbsp%3B%3CBR%20%2F%3EThis%20function%20is%20going%20to%20be%20a%20game%20changer%20in%20my%20industry%20and%20I%20cannot%20wait%20to%20use%20it!%20(You%20should%20be%20able%20to%20smell%20my%20excitement!!!)%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1455824%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1455824%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F696056%22%20target%3D%22_blank%22%3E%40RasnaSaini%3C%2FA%3E%26nbsp%3Byou're%20not%20in%20the%20lucky%2050%25%20sorry%26nbsp%3B%20(if%20it's%20any%20consolation%20neither%20am%20I).%26nbsp%3B%20%26nbsp%3BWe%20have%20to%20wait%20a%20little%20longer%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CDIV%20id%3D%22tinyMceEditorWyn%20Hopkins_0%22%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F198058i331C8DE79B8890A4%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1455865%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1455865%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F70934%22%20target%3D%22_blank%22%3E%40Kaycee%20Anderson%3C%2FA%3E%2C%3C%2FP%3E%0A%3CP%3Ethat's%20awesome%20-%20thank%20you%20and%20thanks%20to%20the%20team%20%3A%20-)%3C%2FP%3E%0A%3CP%3EI%20have%20seen%2C%20that%20the%20German%20translation%20for%20this%20function%20is%20B%C3%96RSENHISTORIE%20-%20I%20love%20it%20%3A%20-)%3C%2FP%3E%0A%3CP%3EBest%2C%3C%2FP%3E%0A%3CP%3EMourad%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1455959%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1455959%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9832%22%20target%3D%22_blank%22%3E%40Wyn%20Hopkins%3C%2FA%3E%26nbsp%3B-%20I%20did%20read%20that%2050%25%20thing%2C%20but%20didn't%20want%20to%20acknowledge%20that%20I%20lost%20in%20the%20excel%20lottery.%20I%20am%20hoping%20that%20there%20is%20someway%20to%20get%20on%20to%20the%20other%20side%20-%20I%20really%20can't%20wait%20to%20use%20it!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1459974%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1459974%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F696056%22%20target%3D%22_blank%22%3E%40RasnaSaini%3C%2FA%3E%26nbsp%3B%2C%20I%20understand%20your%20disappointment%20at%20not%20yet%20having%20access%20to%20the%20feature%20even%20though%20you%20are%20in%20the%20beta%20channel.%20Be%20assured%20we%20are%20trying%20to%20get%20to%20the%20next%20release%20as%20soon%20as%20possible%20and%20will%20update%20this%20thread%20once%20that%20happens.%20In%20the%20meantime%20is%20there%20anything%20in%20this%20blog%20or%20from%20other%20online%20posts%20that%20stands%20out%20as%20something%20you%20expect%20that%20isn't%20covered%2C%20or%20some%20behavior%20described%20that%20doesn't%20make%20sense%3F%20I%20know%20you%20will%20have%20to%20try%20it%20to%20see%20how%20it%20feels%2C%20but%20if%20there%20are%20any%20red%20flags%2C%20that%20is%20what%20we%20are%20trying%20to%20address%20right%20away.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1461039%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1461039%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3E%F0%9F%A7%AA%20%F0%9F%A7%AB%20Experimenting%20with%20the%20new%20%23S%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fwww.linkedin.com%2Ffeed%2Fhashtag%2F%3Fkeywords%3Dstockhistory%26amp%3BhighlightedUpdateUrns%3Durn%253Ali%253Aactivity%253A6677227861948026881%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3ETOCKHISTORY%20f%3C%2FA%3E%3CSPAN%3Eunction%20%26amp%3B%20%3C%2FSPAN%3E%3CSPAN%3EI%20found%20very%20interesting.%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3ESo%20I%20have%20an%20idea%20%3Alight_bulb%3A%20hope%20you%20will%20support%20%3Ahandshake%3A%20by%20voting%20%F0%9F%97%B3%20and%20make%20it%20happen.%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3ESTOCKHISTORY%20function%20currently%20accepts%20only%20the%20numeric%20values%20in%20the%20properties%20it%26nbsp%3Bwould%26nbsp%3Bbe%20great%20to%20see%20if%20it%20accepts%20the%20string%20values%20and%20make%20it%20more%20flexible%20for%20the%20users.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921-excel-for-windows-desktop-application%2Fsuggestions%2F40652983-stockhistory-function-properties-fields-to-accept%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921-excel-for-windows-desktop-application%2Fsuggestions%2F40652983-stockhistory-function-properties-fields-to-accept%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%220.jpeg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F198588iCAA6F3234C5A392B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%220.jpeg%22%20alt%3D%220.jpeg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3ERegards%2C%20Faraz%20Shaikh%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1461532%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1461532%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F70934%22%20target%3D%22_blank%22%3E%40Kaycee%20Anderson%3C%2FA%3E%26nbsp%3BThank%20you%20so%20much%20for%20your%20response.%20One%20of%20the%20things%20that%20I%20wanted%20to%20check%2C%20but%20couldn't%20find%20further%20information%20to%2C%20is%20how%20are%20stock%20splits%20(reverse%20splits)%20handled%20by%20this%20function%3F%20For%20eg%3A%20Let's%20assume%20Amazon%20stock%20is%20currently%20at%20%242%2C500%20and%20they%20decide%20to%20do%205%20for%201%20stock%20split.%20The%20share%20price%20would%20fall%20to%20%24500%20(and%20would%20perhaps%20settle%20a%20little%20over%20it%20reflecting%20wider%20market%20participation%20at%20lower%20price%20hence%20pushing%20the%20share%20price%20up).%20What%20would%20the%20output%20look%20like%20using%20%23Stockhistory%3F%20Would%20it%20index%20the%20price%20and%20volume%20prior%20to%20the%20split%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENext%2C%20ex-dividend%20date%20-%20any%20possibility%20of%20showing%20that%20through%20the%20function%3F%20This%20is%20when%20share%20price%20typically%20falls%20to%20reflect%20the%20dividend%20cash%20outflow.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20third%20suggestion%20is%20the%20same%20as%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F156456%22%20target%3D%22_blank%22%3E%40Faraz%20Shaikh%3C%2FA%3E%26nbsp%3B-%20to%20have%20string%20values%20for%20properties%20to%20make%20the%20function%20more%20user%20friendly%20during%20audits.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1462673%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1462673%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%0A%3CP%3Ethe%20idea%20for%20having%20the%20arguments%20(also)%20available%20as%20text%20strings%20is%20attractive.%20In%20a%20such%20case%2C%20I%20think%2C%20that%20they%20should%20then%20also%20be%20localized%2C%20because%20it%20makes%20not%20too%20much%20sense%20for%20example%20for%20a%20German%2C%20French%20or%20Spanish%20user%20to%20use%20English%20named%20text%20arguments.%3CBR%20%2F%3EHowever%2C%20assuming%20that%20these%20text%20arguments%20would%20not%20be%20%3CEM%3Eautomatically%3C%2FEM%3E%20translated%20by%20Excel%20from%20one%20language%20to%20another%2C%20this%20could%20lead%20to%20problems%20when%20sharing%20the%20workbook%20with%20collegues%20in%20other%20countries.%20In%20current%20(and%20past)%20versions%20of%20Excel%2C%20CELL%20is%20an%20example%20of%20a%20function%20showing%20this%20behaviour.%3CBR%20%2F%3ETherefore%2C%20I%20would%20personally%20prefer%20to%20keep%20the%20arguments%20as%20values%20for%20avoiding%20compatibility%20problems%20when%20using%20Excel%20in%20different%20languages.%3C%2FP%3E%0A%3CP%3EBest%2C%3C%2FP%3E%0A%3CP%3EMourad%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1468809%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1468809%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F61451%22%20target%3D%22_blank%22%3E%40Mourad%20Louha%3C%2FA%3E%26nbsp%3B%2C%20fully%20support%20you.%20We%20have%20enough%20other%20issues%20working%20in%20international%20environment%2C%20not%20necessary%20to%20add%20more.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1469452%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1469452%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F696056%22%20target%3D%22_blank%22%3E%40RasnaSaini%3C%2FA%3E%26nbsp%3B%20Dividend%20dates%20and%20Ex-dividend%20dates%20are%20not%20something%20currently%20licensed%20to%20us%20by%20our%20data%20provider.%20It%20is%20one%20of%20the%20top%20asks%20from%20customers%20like%20you%20though%2C%20so%20I%20understand%20how%20it%20would%20make%20sense%20as%20a%20factor%20for%20historical%20analysis.%20I%20encourage%20you%20to%20vote%20for%20the%20item%20here%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921-excel-for-windows-desktop-application%2Fsuggestions%2F35122639-add-dividend-data-to-stock-data-type%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921-excel-for-windows-desktop-application%2Fsuggestions%2F35122639-add-dividend-data-to-stock-data-type%3C%2FA%3E%26nbsp%3Bon%20UserVoice.%20I%20can't%20make%20any%20promises%20about%20when%2Fif%20we%20can%20get%20the%20data%2C%20but%20it%20is%20on%20my%20radar.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EFor%20Stock%20Splits%2C%20when%20the%20stock%20split%20data%20flows%20through%20to%20our%20system%2C%20there%20is%20a%20latency%20period%2C%20on%20the%20next%20recalculation%20of%20the%20StockHistory%20function%20(this%20could%20be%20on%20file%20open%2C%20function%20edit%2C%20or%20because%20the%20function%20is%20volatile%20with%20the%20Today()%20argument%20etc)%2C%20the%20results%20will%20update%20to%20show%20the%20historical%20prices%20calculated%20to%20reflect%20the%20split.%20This%20will%20feel%20very%20similar%20to%20what%20you%20may%20see%20on%20websites%20like%20MSN%2C%20Google%2C%20and%20Bing%20when%20showing%20historical%20prices%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.msn.com%2Fen-us%2Fmoney%2Fstockdetails%2Fnas-msft%2Ffi-a1xzim%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.msn.com%2Fen-us%2Fmoney%2Fstockdetails%2Fnas-msft%2Ffi-a1xzim%3C%2FA%3E%3CBR%20%2F%3EThere%20wouldn't%20be%20a%20way%20to%20%22freeze%22%20the%20numbers%20from%20the%20result%20unless%20you%20performed%20a%20copy%20and%20paste%20as%20values%20for%20the%20data%20before%20the%20Split.%20Does%20that%20make%20sense%3F%20What%20do%20you%20think%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1469470%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1469470%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F61451%22%20target%3D%22_blank%22%3E%40Mourad%20Louha%3C%2FA%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F156456%22%20target%3D%22_blank%22%3E%40Faraz%20Shaikh%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3EThis%20is%20some%20great%20discussion%20about%20how%20Excel%20can%20explore%20being%20more%20user-friendly%20for%20function%20arguments%20to%20aid%20in%20audits%20and%20clarity%20for%20laying%20out%20your%20data.%20For%20some%20context%20on%20our%20choices%2C%20Excel%20will%20typically%20NOT%20change%20arguments%20to%20your%20formulas%20when%20input%20as%20strings%2C%20so%20if%20you%20put%20in%20%221%2F2%2F20%22%20as%20a%20string%20into%20this%20function%20in%20the%20UK%20that%20would%20be%20February%201st%20and%20in%20the%20US%20it%20would%20be%20January%202nd.%20But%20if%20you%20put%20%221%2F2%2F20%22%20in%20a%20cell%20from%20the%20US%20and%20then%20referenced%20it%20in%20your%20formula%2C%20Excel%20doesn't%20'see'%20the%20date%20formatting%2C%20it%20sees%20the%20number%26nbsp%3B43832%20and%20so%20you%20and%20the%20person%20in%20the%20UK%20would%20see%20the%20same%20data.%20In%20the%20same%20vein%2C%20Excel%20typically%20uses%20numbers%20to%20represent%20defined%20properties%20as%20inputs%20to%20formulas%20(sometimes%20called%20ENUMs)%20to%20simplify%20these%20cross%20international%20concerns.%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20will%20notice%20that%20the%20%22headers%22%20(or%20other%20information%20that%20is%20returned%20as%20a%20result%20of%20formulas)%20will%20be%20'translated'%20to%20show%20in%20the%20language%20your%20Excel%20is%20in.%20This%20is%20often%20what%20happens%20for%20the%20outputs%20of%20formulas%20or%20for%20things%20Excel%20controls.%20We%20like%20to%20give%20you%20control%20over%20the%20input%2C%20but%20we%20can%20sometimes%20be%20smart%20about%20the%20output.%20So%20this%20isn't%20to%20say%20that%20we%20couldn't%20include%20textual%20inputs%20for%20properties%2C%20we%20just%20haven't%20added%20the%20additional%20translation%20layer%20into%20the%20system%2C%20and%20would%20introduce%20complexity%20for%20sure.%20Thanks%20for%20suggestion%20and%20the%20UserVoice%2C%20if%20this%20gets%20traction%2C%20we%20could%20revisit%20it.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESorry%20for%20the%20long-winded%20explanation.%20Hope%20some%20of%20that%20helps.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1485557%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1485557%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20impressed%2C%20I%20don't%20suppose%20I%E2%80%99ve%20met%20everybody%20who%20knows%20as%20a%20great%20deal%20just%20extra%20or%20much%20less%20this%20situation%20as%20you%20reach.%20You%20are%20in%20aspiration%20of%20truth%20skillfully%20knowledgeable%20and%20tremendously%20glowing.%20%3CA%20href%3D%22https%3A%2F%2Fwww.fitjackets.com%2Fproducts%2FTyler-Joseph-Twenty-One-Pilots-Green-Jumpsuit-Jacket-Hoodie-.html%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3ETwenty%20one%20pilots%20jacket%3C%2FA%3E%20you%20wrote%20something%20that%20human%20beings%20should%20obtain%20and%20made%20the%20difficulty%20exciting%20for%20all%20of%20us.%20Certainly%2C%20gratifying%20blog%20you%20have%20got%20came.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1504477%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1504477%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9664%22%20target%3D%22_blank%22%3E%40Joe%20McDaid%3C%2FA%3E%20Definitely%20%2B1%20for%20please%20adding%20FNVs%20to%20the%20C%20API%20too%20-%20so%20that%20.xll-based%20UDFs%20can%20use%20these%20too.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1590361%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1590361%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20an%20insider%20but%20still%20do%20not%20have%20the%20function.%20When%20is%20it%20scheduled%20to%20be%20available%20for%20all%20insiders%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%20Mike%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1596749%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1596749%22%20slang%3D%22en-US%22%3E%3CP%3EMeanwhile%20arrived%20at%20the%20132%2012%2020%20000%20build%20but%20still%20not%20available.%20Any%20possibility%20I%20can%20force%20this%20function%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1597656%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1597656%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F18377%22%20target%3D%22_blank%22%3E%40Mike%3C%2FA%3E%26nbsp%3BThere%20isn't%20a%20way%20to%20override%20into%20the%2050%25%20of%20Beta%20channel.%20The%20good%20news%20is%20while%20I%20can't%20give%20you%20a%20date%2C%20we%20are%20working%20hard%20to%20move%20to%20the%20next%20percent%20of%20customers%20hopefully%20within%202%20months.%20At%20that%20time%20100%25%20of%20Beta%20channel%20will%20have%20access.%20I%20will%20update%20this%20post%20at%20that%20time.%20Fingers%20crossed%20for%20smooth%20sailing%20between%20now%20and%20then.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1598056%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1598056%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F70934%22%20target%3D%22_blank%22%3E%40Kaycee%20Anderson%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3EThanks%20a%20lot%20for%20your%20answer.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1650056%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1650056%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20Everyone%2C%20we%20have%20move%20ahead%20with%20our%20next%20ring%20of%20release%2C%20and%20so%20anyone%20in%20the%20Beta%20Channel%20of%20Office%20Insiders%20should%20100%25%20have%20the%20StockHistory%20function%20available.%20If%20you%20do%20not%2C%20please%20let%20me%20know!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1650115%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1650115%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F70934%22%20target%3D%22_blank%22%3E%40Kaycee%20Anderson%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGot%20it%2C%20thanks%20a%20lot!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1655690%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1655690%22%20slang%3D%22en-US%22%3E%3CP%3EIt's%20not%20working%20on%20mine%20yet%2C%20what%20can%20I%20do%20to%20get%20it%20to%20work%3F%20I%20have%20beta.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F70934%22%20target%3D%22_blank%22%3E%40Kaycee%20Anderson%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ebuild%2013304.20000%20(if%20that%20matters)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1655691%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1655691%22%20slang%3D%22en-US%22%3E%3CDIV%3EWas%20awaiting%20this%20release%20to%20try%20out%20the%20function.%20Thanks%20for%20the%20wider%20release!%3C%2FDIV%3E%3CDIV%3EHere%E2%80%99s%20what%20I%20wrote%20on%20LinkedIn%20today%20about%20Stockhistory%20-%20explaining%20the%20function%20in%20simplified%20colloquial%20language%20and%20then%20building%20complexity%20over%20it.%26nbsp%3B%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CA%20href%3D%22https%3A%2F%2Fwww.linkedin.com%2Fposts%2Frasna-saini-15b2573_amtinspires-exceltips-stockhistory-activity-6709800897771372544-_jQ0%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.linkedin.com%2Fposts%2Frasna-saini-15b2573_amtinspires-exceltips-stockhistory-activity-6709800897771372544-_jQ0%3C%2FA%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1685338%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1685338%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20found%20that%20STOCKHISTORY%20has%20limits.%20For%20example%20it%20only%20goes%20back%20as%20far%20as%202017%20for%20some%20European%20stocks.%20Only%20as%20far%20as%202014%20for%20GOOG%20as%20another%20example.%20Is%20that%20the%20way%20it%20should%20be%3F%20Is%20that%20the%20permanent%20plan%3F%20Will%20more%20history%20be%20available%20in%20future%3F%20...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1804826%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1804826%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F70934%22%20target%3D%22_blank%22%3E%40Kaycee%20Anderson%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20Office%20365%20Excel%20beta%20version%202011%20(Build%2013415.20002%20)%20but%20don't%20have%20this%20function%20yet.%20Eager%20to%20chart%20historic%20data%2C%20what%20can%20i%20do%20to%20get%20it%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1804851%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1804851%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F841046%22%20target%3D%22_blank%22%3E%40Rutu_J%3C%2FA%3E%26nbsp%3BCan%20you%20confirm%20that%20your%20channel%20is%20set%20to%20Beta%20Channel%20on%20your%20accounts%20page%3F%20It%20is%20possible%20you%20signed%20up%20for%20Office%20Insider%20but%20still%20need%20to%20switch%20the%20Insider%20Level.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20that%20does%20say%20Beta%2C%20what%20is%20your%20language%2C%20it%20is%20possible%20the%20function%20is%20translated.%26nbsp%3B%3C%2FP%3E%0A%3CDIV%20id%3D%22tinyMceEditorKaycee%20Anderson_0%22%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CDIV%20id%3D%22tinyMceEditorKaycee%20Anderson_1%22%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CDIV%20id%3D%22tinyMceEditorKaycee%20Anderson_2%22%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CDIV%20id%3D%22tinyMceEditorKaycee%20Anderson_3%22%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CDIV%20id%3D%22tinyMceEditorKaycee%20Anderson_4%22%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CDIV%20id%3D%22tinyMceEditorKaycee%20Anderson_5%22%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CDIV%20id%3D%22tinyMceEditorKaycee%20Anderson_6%22%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Beta%20Channel.png%22%20style%3D%22width%3A%20479px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F228322i7433F9F3D3A6E37F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Beta%20Channel.png%22%20alt%3D%22Beta%20Channel.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1805095%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1805095%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F70934%22%20target%3D%22_blank%22%3E%40Kaycee%20Anderson%3C%2FA%3E%26nbsp%3B%2C%20by%20the%20way%2C%20how%20is%20version%202007%20on%20Beta%20channel%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1805175%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1805175%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F70934%22%20target%3D%22_blank%22%3E%40Kaycee%20Anderson%3C%2FA%3E%26nbsp%3B%20Hi%20Kaycee%26nbsp%3B%20Yes%20it%20shows%20beta%20just%20like%20your%20image.%3C%2FP%3E%3CP%3EIt's%20working%20now.%20I%20shut%20down%20my%20PC%20and%20then%20started%20it%20again.%20And%20it%20started%20working.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%20It%20now%20shows%20version%202011%20(Build%2013415.20002)%20after%20shutting%20down%20and%20starting%20again..%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20using%20STOCKHISTORY%20with%20Sparklines%20%2C%20it's%20such%20a%20useful%20combination!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1816908%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1816908%22%20slang%3D%22en-US%22%3E%3CP%3EI%20just%20want%20to%20say%20THANK%20YOU!%20For%20months%2C%20I%20would%20manually%20build%20my%20weekly%20day%20trade%2Fswing%20trade%20stock%20scanner%20in%20excel%2C%20by%20analyzing%20the%20highs%20and%20lows%20of%20my%20stocks%20of%20interest%20from%20the%20last%20week%20and%20month.%20Sometimes%20this%20would%20take%20HOURS!%20But%20now%20with%20a%20combination%20of%20STOCKHISTORY%2C%20MIN%2C%20and%20MAX%2C%20I%20can%20set%20up%20my%20scanner%20in%20a%20matter%20minutes!%20Good%20job%20and%20thank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1822534%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1822534%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F70934%22%20target%3D%22_blank%22%3E%40Kaycee%20Anderson%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20Stock%20history%20for%20shares%20that%20have%20undergone%20stock%20splits%20does%20not%20seem%20to%20be%20adjusted%20for%20the%20same%2C%20rendering%20the%20chart%20very%20different%20from%20what%20can%20be%20seen%20on%20other%20sites%20like%20Google%20etc.%20Is%20this%20expected%20behaviour%20%3F%20The%20stock%20i%20tried%20it%20for%20is%20this%26nbsp%3B%3C%2FP%3E%3CP%3EHCL%20TECHNOLOGIES%20LIMITED%20(XBOM%3A532281)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1887231%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1887231%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20-%20I%20really%20appreciate%20that%20you're%20adding%20this%20feature%20to%20excel.%20%26nbsp%3BI%20currently%20use%20an%20add-in%20to%20perform%20the%20function%20and%20would%20really%20like%20to%20have%20a%20native%20function.%20%26nbsp%3BUnfortunately%20the%20function%20isn't%20useful%20for%20historical%20information%20unless%20it%20returns%20the%20price%20adjusted%20for%20dividends%20(and%20splits)%20-%20so%20sadly%20I%20have%20to%20keep%20using%20my%20add-in.%20%26nbsp%3BOthers%20in%20this%20thread%20have%20essentially%20asked%20for%20the%20same%20thing.%20%26nbsp%3BI'd%20go%20further%20and%20say%20that%20the%20function%20in%20it's%20current%20state%20is%20only%20useful%20for%20relatively%20short-term%20analysis%20where%20splits%20and%20dividends%20aren't%20relevant.%20%26nbsp%3BIf%20you%20don't%20realize%20this%20then%20you%20can%20be%20deceived%20by%20using%20this%20function%20-%20especially%20in%20the%20case%20of%20splits.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1894400%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1894400%22%20slang%3D%22en-US%22%3E%3CP%3EFEATURE%20REQUEST%3C%2FP%3E%3CP%3E1%20-%20It%20would%20be%20great%20you%20could%20could%20add%20a%20parameter%20to%20reverse%20the%20order%20the%20the%20data%20is%20written%20please!%20(i.e.%20most%20recent%20dates%20first).%20Most%20trading%20systems%20are%20use%20data%20this%20way.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2.%20As%20someone%20else%20commented%20above%2C%20an%20Adjusted%20Close%20price%20would%20also%20be%20good.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBig%20respect%20to%20you%20Microsoft%20for%20pushing%20in%20this%20area!!%20Getting%20Historical%20stock%20data%20from%20Google%20is%20not%20longer%20possible%20and%20pulling%20from%20Yahoo%20finance%20using%20their%20Cookie%20and%20Crumb%20routines%20is%20way%20over%20complicated%20for%20what%20it%20should%20be%20(I've%20spend%20hundreds%20of%20hours%20over%20the%20years%20fighting%20with%20VBA%20to%20get%20historical%20data%20into%20Excel)!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1920350%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1920350%22%20slang%3D%22en-US%22%3E%3CP%3EWhile%20Stockhistory%20sounds%20like%20a%20great%20function%2C%20it%20is%20useless%20without%20a%20column%20for%20dividend%20and%20split%20adjusted%20price.%26nbsp%3B%20Every%20other%20professional%20historical%20source%20provides%20this.%26nbsp%3B%20PLEASE%20INCLUDE%20ADJUSTED%20PRICE!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1959749%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1959749%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20purchased%20Office%20365%20today%20and%20was%20able%20to%20access%20the%20STOCKHISTORY%20function.%20However%20upon%20restarting%20my%20PC%2C%20I%20am%20no%20longer%20able%20to%20use%20it.%20I%20had%20already%20altered%20several%20files%20quite%20substantially%20using%20the%20STOCKHISTORY%20function%2C%20and%20those%20files%20are%20now%20not%20working%20as%20they%20should.%3CBR%20%2F%3E%3CBR%20%2F%3EIs%20access%20to%20the%20new%20formula%20temporary%20or%20is%20there%20some%20way%20I%20can%20get%20access%20again%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWade%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2004806%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2004806%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F70934%22%20target%3D%22_blank%22%3E%40Kaycee%20Anderson%3C%2FA%3EKudos%20on%20the%20Stockhistory%20function.%20I've%20been%20using%20a%203rd%20party%20add-in%20for%20%2B10%20yrs%20so%20this%20is%20a%20welcome%20feature%20for%20me%2C%20and%20I've%20signed%20up%20for%20Office365%20to%20test%20it%20out.%20Works%20great%2C%20but%20some%20markets%20like%20Japan%20(TSE)%20and%20Singapore%20(SGX)%20are%20unavailable.%20Any%20plans%20to%20roll%20out%20data%20for%20these%20markets%3F%20and%20will%20this%20likely%20happen%3F%20Thank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2026282%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2026282%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20it%20possible%20to%20include%20dividend%20information%20in%20this%20function%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2085088%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2085088%22%20slang%3D%22en-US%22%3E%3CP%3E%40All%20This%20feature%20is%20now%20available%20to%20all%20M365%20Subscribers%20using%20Mac%2C%20Windows%2C%20and%20Excel%20for%20the%20Web.%20Please%20try%20it%20out%20and%20continue%20to%20give%20feedback.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2089747%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2089747%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F70934%22%20target%3D%22_blank%22%3E%40Kaycee%20Anderson%3C%2FA%3E%26nbsp%3B%2C%20for%20Excel%20Online%20it's%20less%20informative.%20For%20example%2C%20typing%20such%20formula%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20443px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F248880i2008892CEA4AFC8C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EExcel%20Online%20doesn't%20suggest%20me%20an%20options%20for%20the%20intervals%20and%20other%20parameters%20and%2C%20in%20general%2C%20I%20have%20no%20idea%20what%20to%20use.%20Okay%2C%20I%20may%20check%20on%20desktop%20versions%20or%20perhaps%20on%20help%20page%2C%20but%20that's%20not%20suitable.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2089751%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2089751%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F70934%22%20target%3D%22_blank%22%3E%40Kaycee%20Anderson%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20possibility%20to%20also%20get%20this%20feature%20for%20treasury%20bills%3F%20Not%20exactly%20%22stock%20history%22%20-%20but%20a%20reliable%20source%20in%20Data%20for%20either%20current%20treasury%20bill%20rates%20or%20historical%20ones%20would%20be%20amazing.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAll%20this%20stock%20data%20in%20conjunction%20with%20Treasury%20yields%20(risk%20free%20rates)%20would%20simplify%20workflow%20and%20reduce%20the%20need%20for%20external%20data%20sources%20that%20tend%20to%20change%20in%20format%20over%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2092064%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2092064%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20announcement%20states%20that%26nbsp%3B%3CSPAN%3Ehistorical%20data%20is%20not%20available%20for%20stock%20indices%20such%20the%20S%26amp%3BP%20500%20and%20that%2C%20unfortunately%2C%20seems%20to%20be%20true.%26nbsp%3B%20%26nbsp%3BI'd%20like%20to%20ask%20you%20reconsider%20the%20omission%20because%20of%20the%20importance%20of%20the%26nbsp%3BS%26amp%3BP%20500%20(often%20with%20ticker%20symbol%20%3D%20.INX)%20for%20tracking%20portfolio%20performance.%20I%20can%20approximate%20the%20S%26amp%3BP%20500%20index%20value%20by%20taking%20the%20price%20of%20the%20SPY%20or%20similar%20exchange%20traded%20fund%20applying%20a%20scale%20factor%2C%20but%20the%20scale%20factor%20isn't%20necessarily%20constant.%26nbsp%3B%20Direct%20access%20to%20the%20historical%20data%20about%20the%20index%20itself%20would%20be%20very%20much%20appreciated.%26nbsp%3B%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2092430%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2092430%22%20slang%3D%22en-US%22%3E%3CP%3Eanyone%20using%20this%20function%20please%20know%20that%20you%20can't%20use%20it%20to%20compare%20performance%20of%20any%20instrument%20(stock%20or%20ETF)%20that%20has%20split%20or%20paid%20a%20dividend%20-%20it%20will%20yield%20incorrect%20results.%20%26nbsp%3BFor%20example%20just%20look%20at%202020%20performance%20of%20VYM%20-%20the%20stock%20history%20function%20will%20tell%20you%20that%20it%20achieved%20-2.35%25.%20%26nbsp%3BIn%20reality%2C%20if%20you%20take%20into%20account%20dividends%20paid%2C%20the%20ETF%20yielded%201.15%25.%20%26nbsp%3BThe%20more%20dividends%2C%20or%20splits%20that%20occurred%20the%20more%20%22off%22%20the%20stock%20history%20function%20will%20be%20-%20so%20a%203-year%2C%205-year%20assessment%20will%20be%20WAY%20off.%20%26nbsp%3BIMO%2C%20this%20function%20is%20worse%20than%20worthless%20until%20they%20correct%20this.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2095705%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2095705%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F869023%22%20target%3D%22_blank%22%3E%40pdxtony%3C%2FA%3E%26nbsp%3BI%20cannot%20replicate%20the%20issue%20you%20mention.%20Apple%20and%20Tesla%20both%20had%20splits%20and%20the%20stock%20history%20uses%20the%20adjusted%20pricing.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDividends%20are%20a%20different%20thing%20entirely%20-%20but%20%3Ddividendhistory%20and%20%3Dtbillhistory%20as%20functions%20would%20be%20incredibly%20useful%20alongside%20%3Dstockhistory.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2095973%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2095973%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F869023%22%20target%3D%22_blank%22%3E%40pdxtony%3C%2FA%3E%26nbsp%3BI%20am%20not%20familiar%20with%20the%20specific%20way%20of%20calculating%20you%20are%20describing.%20But%20I%20can%20confirm%20that%20Splits%20are%20accounted%20for%20in%20the%20history%20of%20the%20data%20over%20time.%20When%20the%20data%20flows%20into%20our%20system%20from%20Refinitiv%2C%20on%20the%20next%20recalculation%20of%20the%20data%20you%20will%20see%20%23BUSY%20and%20then%20the%20Split%20adjusted%20history%20will%20be%20shown.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20that%20is%20not%20what%20you%20are%20seeing%2C%20please%20let%20me%20know.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2096121%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2096121%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20stockhistory%20is%20handling%20splits%20then%20that's%20good%20-%20I%20didn't%20check%20that.%20%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20doesn't%20give%20dividend%20adjusted%20prices%20though.%20%26nbsp%3BTake%20a%20look%20here%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ffinance.yahoo.com%2Fquote%2FVYM%2Fhistory%3Fp%3DVYM%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Ffinance.yahoo.com%2Fquote%2FVYM%2Fhistory%3Fp%3DVYM%3C%2FA%3E%26nbsp%3Band%20you%20can%20see%20what%20that%20should%20look%20like.%20%26nbsp%3BIf%20you%20want%20to%20know%20the%20return%20of%20something%20you%20own%20you%20can%20take%20a%20look%20here%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.investopedia.com%2Farticles%2Fbasics%2F10%2Fguide-to-calculating-roi.asp%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.investopedia.com%2Farticles%2Fbasics%2F10%2Fguide-to-calculating-roi.asp%3C%2FA%3E.%20%26nbsp%3BKey%20thing%20though%20is%20that%20you%20need%20to%20use%20the%20dividend%20adjusted%20price%20in%20your%20calculation.%20%26nbsp%3BIf%20you%20don't%2C%20and%20the%20investment%20paid%20a%20dividend%2C%20then%20the%20answer%20will%20be%20wrong.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2099698%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2099698%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F869023%22%20target%3D%22_blank%22%3E%40pdxtony%3C%2FA%3E%26nbsp%3BDividends%20aren't%20included%20in%20a%20stock's%20price%20though%2C%20so%20accurate%20stock%20data%20wouldn't%20include%20the%20addition%20of%20any%20dividends%20as%20well.%20As%20someone%20else%20mentioned%20though%2C%20a%20%3Ddividendhistory%20kind%20of%20function%20would%20be%20really%20useful.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F70934%22%20target%3D%22_blank%22%3E%40KayceeSue%3C%2FA%3E%26nbsp%3Bechoing%20other's%20called%20for%20stock%20index%20data!%20e.g.%20being%20able%20to%20pull%20the%20history%20for%20the%20ASX200%20or%20S%26amp%3BP500%20index%20itself.%20as%20already%20mentioned%2C%20this%20is%20essential%20in%20order%20to%20track%20one's%20performance.%26nbsp%3B%3C%2FP%3E%3CP%3EApple's%20Numbers%20is%20able%20to%20do%20this%20-%20I'd%20love%20to%20see%20Microsoft%20offer%20it%20as%20well.%20For%20now%2C%20I%20need%20to%20rely%20on%20Numbers%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2099739%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2099739%22%20slang%3D%22en-US%22%3E%3CP%3EWithout%20dividend%20(and%20splits%20which%20apparently%20are%20included)%20adjusted%20price%20is%20unusable%20for%20those%20of%20us%20doing%20backtesting%20or%20total%20return%20calculations.%26nbsp%3B%20On%20Dec%2031%2C%201999%2C%20SPY%2C%20which%20has%20never%20split%2C%20had%20a%20closing%20price%20of%20%24146.88%20and%20a%20dividend%20adjust%20price%20of%20%2499.12%20(Yahoo)%20-%20a%20huge%20difference.%26nbsp%3B%20While%20an%20actual%20dividend%20report%20might%20be%20nice%2C%20most%20folks%20don't%20know%20how%20to%20factor%20it%20into%20adjusted%20close.%26nbsp%3B%20If%20Microsoft%20does%20not%20intend%20to%20provide%20dividend%20adjusted%20closes%20anytime%20in%20the%20near%20future%2C%20just%20tell%20us%20so.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2099753%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2099753%22%20slang%3D%22en-US%22%3E%3CP%3EI%20do%20want%20to%20add%20though%2C%20big%20ups%20to%20you%20Microsoft%20for%20adding%20Stock%20History.%20It%20really%20is%20a%20brilliantly%20useful%20feature%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2099761%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2099761%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F943789%22%20target%3D%22_blank%22%3E%40liamr25%3C%2FA%3E%20it%20can%20be%2C%20Yahoo%20does%20it%2C%20take%20a%20look%20at%20SPY%20here%3A%20%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ffinance.yahoo.com%2Fquote%2FSPY%2Fhistory%3Fp%3DSPY%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Ffinance.yahoo.com%2Fquote%2FSPY%2Fhistory%3Fp%3DSPY%3C%2FA%3E%26nbsp%3B%20They've%20got%20a%20column%20for%20close%20as%20well%20as%20adjusted%20close.%20%26nbsp%3BIf%20you%20want%20to%20know%20total%20performance%20you'd%20use%20adjusted%20close.%20%26nbsp%3BCertainly%20if%20there%20was%20a%20way%20to%20get%20actual%20dividends%20paid%20over%20the%20period%20of%20interest%20then%20you%20could%20factor%20that%20in%20yourself.%20%26nbsp%3BBut%20if%20Microsoft%20is%20going%20to%20have%20a%20%22stock%20history%22%20function%20then%20I%20don't%20see%20the%20use%20case%20for%20when%20you%20*wouldn't*%20take%20into%20account%20dividends%20-%20unless%20it's%20a%20stock%2Fetf%20that%20just%20doesn't%20pay%20a%20dividend.%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2099939%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2099939%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F943789%22%20target%3D%22_blank%22%3E%40liamr25%3C%2FA%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F869023%22%20target%3D%22_blank%22%3E%40pdxtony%3C%2FA%3E%20%2BOthers%2C%20Your%20requests%20are%20very%20valid.%20Thanks%20for%20sharing%20the%20other%20companies%20providing%20dividend%20data%20to%20you.%20I%20would%20love%20to%20say%20definitively%20that%20we%20will%20or%20won't%20provide%20dividend%20data%20in%20Excel%20in%20the%20future%2C%20but%20the%20truth%20is%20I%20don't%20know%20the%20answer%20to%20that.%20I%20know%20that%20we%20do%20revisit%20the%20conversation%20frequently%2C%20and%20take%20your%20requests%20to%20heart.%20Dividend%20data%20(now%20including%20Dividend%20History)%20is%20our%20top%20request%20from%20customers%2C%20followed%20by%20more%20international%20market%20support%2C%20followed%20by%20(now%20that%20we%20have%20StockHistory)%20popular%20index%20fund%20history%20support.%20The%20reason%20we%20don't%20provide%20all%20these%20right%20now%20is%20a%20relatively%20boring%20one%2C%20they%20cost%20extra%20beyond%20what%20we%20have%20already%20paid%20and%20agreed%20to%20license.%20There%20is%20a%20lot%20Excel%20can%20give%20input%20into%20for%20these%20license%20agreements%2C%20but%20you%20can%20imagine%20the%20complexities%20that%20are%20involved%20we%20have%20when%20money%20comes%20into%20play.%20I%20hope%20that%20statement%20doesn't%20come%20across%20as%20dismissive%20to%20your%20request%2C%20or%20passing%20blame%20somewhere%20else.%26nbsp%3B%3CBR%20%2F%3EFor%20now%20keep%20making%20requests%20and%20get%20everyone%20to%20vote%20at%20UserVoice.com%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921-excel-for-windows-desktop-application%2Fsuggestions%2F35122639-add-dividend-data-to-stock-data-type%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EAdd%20Dividend%20Data%20to%20Stock%20Data%20Type%20%E2%80%93%20Welcome%20to%20Excel%E2%80%99s%20Suggestion%20Box!%20(uservoice.com)%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%0A%3CP%3EAlso%20keep%20discussion%20happening%2C%20any%20questions%20or%20problems%20you%20all%20run%20into%2C%20this%20is%20a%20good%20forum%20to%20get%20my%20attention%2C%20and%20I%20will%20try%20to%20address%20them.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2100002%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2100002%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F70934%22%20target%3D%22_blank%22%3E%40KayceeSue%3C%2FA%3E%20I%20appreciate%20your%20response%20and%20understand%20that%20even%20groups%20within%20Microsoft%20are%20burdened%20with%20budgets!%20%26nbsp%3BI%20will%20say%20that%20in%20my%20view%20the%20value%20returned%20by%20Stockhistory%20needs%20to%20be%20adjusted%20for%20dividends%20otherwise%20it's%20a%20error%20-%20or%20bug.%20%26nbsp%3BI%20hate%20to%20sound%20so%20extreme%20on%20this%20but%20I%20don't%20see%20any%20%22use%20case%22%20for%20a%20value%20returned%20that's%20not%20adjusted%20for%20splits%20*and*%20dividends.%20%26nbsp%3BSeems%20to%20me%20the%20only%20reason%20you'd%20want%20a%20historical%20price%20is%20to%20evaluate%20performance%20over%20time.%20%26nbsp%3BAs%20I've%20said%20before%20if%20the%20value%20isn't%20adjusted%20then%20it's%20just%20not%20just%20useful%20it's%20actually%20misleading.%20%26nbsp%3BCurrently%20I%20use%20a%20custom%20excel%20add-in%20to%20get%20price%20by%20date%20(and%20have%20for%20years)%20the%20add-in%20provides%20a%20function%20that%20essentially%20scrapes%20Yahoo's%20site%20and%20returns%20the%20adjusted%20value%20-%20and%20that's%20all%20it%20returns.%20%26nbsp%3BAt%20one%20point%20I%20remember%20a%20user%20asking%20for%20the%20non-adjusted%20price%20and%20the%20consensus%20answer%20was%20%22why%20would%20you%20want%20that%22%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don't%20really%20care%20so%20much%20about%20having%20the%20function%20return%20dividends%20as%20an%20option%20-%20that%20would%20be%20very%20cumbersome%20to%20factor%20that%20in%20-%20I'd%20probably%20keep%20using%20my%20add-in.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2111140%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2111140%22%20slang%3D%22en-US%22%3E%3CP%3EI%20think%20what%20people%20are%20asking%20for%20regarding%20inclusion%20if%20dividends%20is%20total%20return.%20For%20example%2C%20in%20Yahoo%20Finance%2C%20you%20can%20select%20the%20ticker%20%5ESP500TR%20to%20get%20a%20price%20vector%20that%20includes%20the%20dividend%20yield%20of%20the%20S%26amp%3BP%20500%20on%20a%20historical%20basis.%20%26nbsp%3BIf%20we%20could%20have%20the%20same%20type%20of%20price%20vector%20for%20the%20stocks%20in%20the%20Excel%20database%20STOCKHISTORY%20function%20then%20we%20could%20compare%20total%20returns%20of%20various%20investments%20over%20different%20time%20periods.%20%26nbsp%3BOtherwise%20we%20are%20comparing%20apples%20to%20oranges.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2113378%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2113378%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20this%20is%20interesting%20%2C%20although%20I%20have%20been%20trying%20to%20use%20stockhistory%20although%20I%20am%20getting%20errors.%20would%20you%20be%20able%20to%20help%3F%3C%2FP%3E%3CP%3Esometimes%20is%20shows%20%23N%2FA%20or%20%23Value!%3C%2FP%3E%3CP%3EI%20confirmed%20in%20yahoo%20finance%20and%20those%20days%20should%20have%20price%20data.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22msousa19imperial_0-1612392356479.png%22%20style%3D%22width%3A%20623px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F252123iE17A1D93BB38437C%2Fimage-dimensions%2F623x366%3Fv%3D1.0%22%20width%3D%22623%22%20height%3D%22366%22%20role%3D%22button%22%20title%3D%22msousa19imperial_0-1612392356479.png%22%20alt%3D%22msousa19imperial_0-1612392356479.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3Ethanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2116570%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2116570%22%20slang%3D%22en-US%22%3E%3CP%3EStill%20not%20available%20in%20my%20Online%20Excel%26nbsp%3B%3CIMG%20class%3D%22lia-deferred-image%20lia-image-emoji%22%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fhtml%2F%409839A717402516D64549B98324F4F0C1%2Fimages%2Femoticons%2Fsad_40x40_1.gif%22%20alt%3D%22%3Asad%3A%22%20title%3D%22%3Asad%3A%22%20%2F%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2117221%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2117221%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F954237%22%20target%3D%22_blank%22%3E%40msousa19imperial%3C%2FA%3E%26nbsp%3BI%20looked%20into%20the%20stocks%20from%20your%20book.%20According%20to%20MSN%20Money%2C%20most%20of%20the%20%23VALUE%20you%20are%20getting%20are%20because%20the%20first%20trade%20on%20record%20happens%20after%202%2F28%2F2020.%20So%20we%20should%20better%20adjust%20our%20error%20message%20in%20this%20instance%20to%20say%20%22The%20days%20between%20start_date%20and%20end_date%20are%20non-trading%20days%2C%20such%20as%20holidays%2C%20weekends%2C%20or%20days%20prior%20to%20the%20first%20trade%20of%20this%20instrument%22%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThen%20for%20the%20N%2FA%20errors%2C%20this%20represents%20a%20valid%20trading%20day%2C%20but%20the%20stock%20in%20question%20is%20not%20traded%20on%20those%20days.%20This%20is%20a%20common%20error%20for%20low%20volume%20stocks%20that%20are%20not%20traded%20daily.%20In%20other%20words%2C%20no%20data%20is%20available%20for%20that%20day%20even%20though%20it%20is%20a%20valid%20trading%20day.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELastly%2C%20we%20have%20some%20mutual%20funds%20and%20index%20funds%20that%20we%20do%20not%20have%20license%20to%20report%20on%20the%20History.%20This%20is%20commonly%20shown%20as%20a%20%22Stock%20argument%20not%20found%22%20error%2C%20and%20there%20isn't%20anything%20we%20can%20do%20to%20correct%20it%20at%20this%20time.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22KayceeSue_1-1612737457578.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F253136iB7A4B5E4F902694A%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22KayceeSue_1-1612737457578.png%22%20alt%3D%22KayceeSue_1-1612737457578.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHope%20that%20helps%2C%3C%2FP%3E%0A%3CP%3E--Kaycee%20Sue%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2117227%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2117227%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F957875%22%20target%3D%22_blank%22%3E%40steebn%3C%2FA%3E%26nbsp%3BI'm%20sorry%20to%20hear%20you%20are%20having%20trouble%20getting%20the%20function%20in%20Excel%20for%20the%20Web.%20I%20have%20some%20basic%20troubleshooting%20questions%20so%20I%20can%20help%20you.%20If%20you%20send%20feedback%20from%20Excel%20we%20can%20get%20more%20telemetry%20about%20your%20version%20as%20well.%20Got%20to%20Help-%26gt%3BFeedback%20and%20describe%20your%20Issue%20%22I%20cannot%20access%20StockHistory%20function%20in%20Excel%20Online.%20ATTN%3A%20KayceeR%22%20and%20check%20the%20box%20to%20include%20your%20email%20address.%20This%20will%20be%20the%20easiest%20way%20for%20us%20to%20find%20out%20what's%20going%20on.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22KayceeSue_1-1612738133947.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F253143i270F4B85B07397AF%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22KayceeSue_1-1612738133947.png%22%20alt%3D%22KayceeSue_1-1612738133947.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CBR%20%2F%3EAdditionally%3A%3C%2FP%3E%0A%3CP%3EAre%20you%20signed%20in%3F%20You%20can%20see%20your%20sign-in%20info%20in%20the%20top%20right%20of%20Excel%20Online%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22KayceeSue_0-1612737996176.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F253141i6DA454BDC2DB03B8%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22KayceeSue_0-1612737996176.png%22%20alt%3D%22KayceeSue_0-1612737996176.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EAre%20you%20using%20English%20or%20another%20Language%20-%20The%20function%20name%20may%20be%20translated%20and%20not%20appear%20in%20the%20autocomplete%20when%20typing%20%3DStockHistory.%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAre%20you%20on%20an%20Enterprise%20version%20of%20a%20subscription%20for%20Excel%20Online%3F%20There%20is%20a%20chance%20we%20have%20an%20issue%20rolling%20out%20to%20these%20tenets.%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDo%20you%20have%20a%20free%20consumer%20login%20or%20a%20paid%20subscription%3F%20For%20the%20moment%20this%20function%20is%20only%20available%20to%20subscribed%20customers.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELooking%20forward%20to%20hearing%20from%20you%3C%2FP%3E%0A%3CP%3E--Kaycee%20Sue%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2119891%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2119891%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHi%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F70934%22%20target%3D%22_blank%22%3E%40KayceeSue%3C%2FA%3E%3CSPAN%3E%26nbsp%3B%2C%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EI%20am%20on%20a%20University%20Microsoft%20365%20account.%20And%20I%20am%20still%20not%20be%20able%20to%20use%20the%20STOCKHISTORY%20function.%20I%20thought%20it%20has%20been%20rolled%20out%20100%25.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2131878%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2131878%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20data%20for%20Indexes%20such%20as%20the%20Dow%20Jones%20Industrial%20Average%20or%20the%20S%26amp%3BP%20500%20be%20accessed%20through%20this%20function%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2141478%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2141478%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F949499%22%20target%3D%22_blank%22%3E%40SLYoung%3C%2FA%3E%26nbsp%3Bunfortunately%20right%20now%20we%20only%20support%20'current%20values'%20for%20those%20funds%20through%20the%20Stocks%20data%20type.%20The%20StockHistory%20function%20will%20error%20out%20when%20attempting%20to%20get%20the%20history.%20Transparently%20we%20don't%20currently%20have%20licensed%20permissions%20to%20show%20that%20specific%20history%20data.%20Is%20that%20a%20dealbreaker%20for%20you%20where%20you%20will%20use%20a%20different%20software%3F%20Or%20an%20inconvenience%20where%20you%20are%20still%20going%20to%20use%20the%20function%20for%20other%20data%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E--Kaycee%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2141481%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2141481%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F961812%22%20target%3D%22_blank%22%3E%40Invisibletoe%3C%2FA%3E%26nbsp%3BI%20removed%20your%20image%20from%20your%20original%20comment%20to%20protect%20your%20privacy.%20From%20what%20I%20can%20tell%20based%20on%20your%20version%20number%2C%20you're%20version%20was%20last%20updated%20in%20July%20of%202020.%20This%20means%20that%20most%20likely%20your%20admin%20for%20your%20edu%20account%20has%20configured%20you%20for%20semi-annual%20updates%20of%20Office.%20This%20means%20that%20next%20July%20is%20likely%20the%20first%20time%20you%20will%20have%20access%20to%20StockHistory%20function%20on%20your%20Mac.%20If%20you%20are%20the%20admin%20for%20your%20subscription%20you%20can%20change%20to%20current%20channel%20and%20should%20get%20an%20update%20to%20Office%20that%20would%20include%20the%20function.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fdeployoffice%2Foverview-update-channels%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EOverview%20of%20update%20channels%20for%20Microsoft%20365%20Apps%20-%20Deploy%20Office%20%7C%20Microsoft%20Docs%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EOne%20thing%20you%20can%20try%20is%20going%20to%20Excel.office.com%20and%20trying%20to%20use%20the%20function%20in%20the%20Web%20browser.%20If%20you%20are%20still%20unable%20to%20use%20the%20function%20signed%20in%20with%20your%20edu%20email%20on%20the%20Web%2C%20we%20may%20have%20a%20bug.%20Please%20send%20feedback%20from%20the%20Help%20tab%20in%20Excel%20for%20the%20Web%20and%20include%20ATTN%3A%20KayceeR%20in%20the%20body%20of%20your%20problem%20report.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2149823%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2149823%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F70934%22%20target%3D%22_blank%22%3E%40KayceeSue%3C%2FA%3E%26nbsp%3BThank%20you%20for%20the%20reply%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CBLOCKQUOTE%3E%3CHR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F70934%22%20target%3D%22_blank%22%3E%40KayceeSue%3C%2FA%3E%26nbsp%3Bwrote%3A%3CBR%20%2F%3E%3CP%3E%3CSPAN%3EAre%20you%20on%20an%20Enterprise%20version%20of%20a%20subscription%20for%20Excel%20Online%3F%20There%20is%20a%20chance%20we%20have%20an%20issue%20rolling%20out%20to%20these%20tenets.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%3CP%3EI%20am%20using%20the%20Enterprise%20version%20of%20Excel.%20I%20did%20try%20it%20again%20today%2C%20and%20it%20is%20now%20working.%20YAY!!%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22steebn_0-1613755872189.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F256072i7434FEDF5DF45F7A%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22steebn_0-1613755872189.png%22%20alt%3D%22steebn_0-1613755872189.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThank%20you%20for%20the%20reply.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2152104%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2152104%22%20slang%3D%22en-US%22%3E%3CP%20class%3D%22p1%22%3EI%20have%20discovered%20a%20major%20problem%20that%20I%20believe%20is%20due%20to%20the%26nbsp%3BStockHistory%20function.%26nbsp%3B%20It%20breaks%20links%20between%20workbooks.%26nbsp%3B%20It's%20easy%20to%20replicate.%3C%2FP%3E%3CP%20class%3D%22p1%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22p1%22%3EMicrosoft%20Excel%20for%20Mac%20version%2016.46%3C%2FP%3E%3CP%20class%3D%22p1%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22p1%22%3EWorkbook%201%3A%20has%20named%20cells%20and%20uses%20the%20StockHistory%20function%3C%2FP%3E%3CP%20class%3D%22p1%22%3EWorkbook%202%3A%3CSPAN%20class%3D%22Apple-converted-space%22%3E%26nbsp%3B%20%3C%2FSPAN%3Ehas%20links%20to%20the%20named%20cells%20in%20Workbook%201%3C%2FP%3E%3CP%20class%3D%22p2%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22p1%22%3EWhen%20both%20workbooks%20are%20open%2C%20the%20links%20in%20Workbook%202%20display%20the%20correct%20values.%3C%2FP%3E%3CP%20class%3D%22p2%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22p1%22%3EClose%20both%20workbooks.%3CSPAN%20class%3D%22Apple-converted-space%22%3E%26nbsp%3B%20%3C%2FSPAN%3EThen%20reopen%20Workbook%202.%3CSPAN%20class%3D%22Apple-converted-space%22%3E%26nbsp%3B%20%3C%2FSPAN%3EThe%20links%20to%20the%20named%20cells%20show%20zeros%2C%20not%20the%20correct%20values.%3C%2FP%3E%3CP%20class%3D%22p2%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22p1%22%3ERemove%20the%20StockHistory%20function%20from%20Workbook%201%20and%20repeat%20the%20experiment%E2%80%A6%20Now%2C%20in%20Workbook%202%2C%20the%3CSPAN%20class%3D%22Apple-converted-space%22%3E%26nbsp%3B%20%3C%2FSPAN%3Elinks%20to%20the%20named%20cells%20work%20as%20expected.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2152850%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2152850%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22dawit75_0-1613883225017.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F256364iF211CA5C4BF7160D%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22dawit75_0-1613883225017.png%22%20alt%3D%22dawit75_0-1613883225017.png%22%20%2F%3E%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CPRE%3EPrivate%20Sub%20Worksheet_SelectionChange(ByVal%20Target%20As%20Range)%0A%20%20%20%20Dim%20var%20As%20Variant%0A%20%20%20%20var%20%3D%20ActiveCell.Address()%0A%20%20%20%20Range(%22M4%22).Value%20%3D%20Application.WorksheetFunction.StockHistory(var%2C%20%231%2F1%2F2021%23%2C%20Date%2C%200%2C%201%2C%200%2C%205%2C%202%2C%203%2C%204%2C%201)%0AEnd%20Sub%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2167766%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2167766%22%20slang%3D%22en-US%22%3E%3CP%3EFirst%2C%20the%20STOCKHISTORY%20function%20is%20greatly%20appreciated.%26nbsp%3B%20However%2C%20numerous%20users%20have%20commented%20about%20the%20need%20for%20a%20true%20split%20%3CU%3E%3CSTRONG%3EAND%3C%2FSTRONG%3E%3C%2FU%3E%20dividend%20Adjusted%20Price.%26nbsp%3B%20The%20prices%20in%20STOCKHISTORY%20are%20split%20adjusted%2C%20but%20not%20Dividend%20adjusted.%26nbsp%3B%20Yahoo%20provides%20Raw%20%3CU%3E%3CEM%3Eand%3C%2FEM%3E%3C%2FU%3E%20Adjusted%20data%20in%20their%20Historical%20Prices%20data%20streams%26nbsp%3B%20(eg.%20%3CFONT%20size%3D%221%202%203%204%205%206%207%22%3E%3CA%20href%3D%22https%3A%2F%2Ffinance.yahoo.com%2Fquote%2FMSFT%2Fhistory%3Fperiod1%3D511056000%26amp%3Bperiod2%3D1614211200%26amp%3Binterval%3D1d%26amp%3Bfilter%3Dhistory%26amp%3Bfrequency%3D1d%26amp%3BincludeAdjustedClose%3Dtrue%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Ffinance.yahoo.com%2Fquote%2FMSFT%2Fhistory%3Fperiod1%3D511056000%26amp%3Bperiod2%3D1614211200%26amp%3Binterval%3D1d%26amp%3Bfilter%3Dhistory%26amp%3Bfrequency%3D1d%26amp%3BincludeAdjustedClose%3Dtrue%3C%2FA%3E%26nbsp%3B%3C%2FFONT%3E).%26nbsp%3B%20With%20their%20fully%20adjusted%20price%2C%20one%20can%20then%20easily%20calculate%20Total%20Return%20by%20the%20ratios%20of%20Adjusted%20Price%20over%20a%20given%20time%20interval.%26nbsp%3B%20The%20downside%20of%20this%20method%20is%20the%20tedium%20of%20browsing%20into%20Yahoo's%20website%2C%20setting%20the%20correct%20settings%20for%20the%20SYMBOL%20of%20interest%2C%20downloading%20a%20file%2C%20importing%20it%20into%20Excel%2C%20and%20then%20using%20lookups%20or%20other%20means%20to%20find%20what%20we%20need.%26nbsp%3B%20Can%20we%20%3CU%3E%3CSTRONG%3EPLEASE%3C%2FSTRONG%3E%3C%2FU%3E%20get%20the%20following%20clear%20statement%20from%20Microsoft%20affirming%20the%20following%2C%20soon%20%3F%20%3A%3C%2FP%3E%3CP%3E1)%20Raw%20Price%20and%20Fully%20Adjusted%20Price%20Data%20are%20recognized%20as%20useful%20and%20necessary%20for%20any%20serious%20user%20of%20STOCKHISTORY%3C%2FP%3E%3CP%3E2)%20Feature%20enhancement%20work%20will%20be%20scheduled%20with%20an%20anticipated%20availability%20date%20of%20MM%2FDD%2FYYYY%3C%2FP%3E%3CP%3EThank%20you%20!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2168255%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2168255%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20don't%20seem%20to%20have%20access%20to%20the%20STOCKHISTORY%20function.%20I've%20looked%20online%20and%20this%20seems%20to%20be%20available%20to%20all%20365%20subscribers%20so%20I%20thought%20I'd%20have%20it%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jclahar_1-1614329308413.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F258304i731E948FAB3E42F8%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22jclahar_1-1614329308413.png%22%20alt%3D%22jclahar_1-1614329308413.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2169621%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2169621%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F979612%22%20target%3D%22_blank%22%3E%40jclahar%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20on%20semi-annual%20channel%20which%20has%20features%20update%20twice%20per%20year.%20Afraid%20STOCKHISTORY()%20is%20too%20early%20for%20it%20(release%20notes%20are%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fofficeupdates%2Fsemi-annual-enterprise-channel%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ERelease%20notes%20for%20Semi-Annual%20Enterprise%20Channel%20releases%20in%202020%20-%20Office%20release%20notes%20%7C%20Microsoft%20Docs%3C%2FA%3E%26nbsp%3B).%20That's%20only%20to%20wait%20or%20update%20on%20Current%20channel.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2172297%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2172297%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20I%20upgrade%20Semi-Annual%20Enterprise%20Channel%20subscription%2C%20so%20that%20I%20can%20get%20the%20STOCKHISTORY()%20function%3F%3C%2FP%3E%3CP%3EOr%20is%20that%20not%20possible%3F%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2172451%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2172451%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F981191%22%20target%3D%22_blank%22%3E%40Robls501%3C%2FA%3E%26nbsp%3B%2C%20if%20you%20have%20no%20admin%20right%20you%20shall%20ask%20your%20admins%20to%20do%20that.%20Instructions%20are%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fdeployoffice%2Fupdate-channels-changes%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EChanges%20to%20update%20channels%20for%20Microsoft%20365%20Apps%20-%20Deploy%20Office%20%7C%20Microsoft%20Docs%3C%2FA%3E%26nbsp%3B.%20I%20prefer%20Office%20Deployment%20Tool%2C%20but%20that's%20up%20to%20you.%20You%20may%20google%20for%20tricks%20with%20changing%20registry%20key%2C%20but%20admin%20right%20will%20be%20required%20in%20this%20case%20as%20well.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2177743%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2177743%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20I%20purchase%26nbsp%3B%3CSPAN%3EMicrosoft%20365%20Family%2C%20will%20I%20have%20access%20to%20the%20STOCKHISTORY()%20function%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EIf%20not%2C%20is%20there%20another%20Microsoft%20365%20product%20that%20has%20that%20function%20available%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EThanks.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERob%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2181628%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2181628%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20is%20very%20Valuable%20And%20Information%20site%2C%20And%20we%20are%20launching%20the%20Jackets%20industry%20with%20our%20best%20quality%20of%20leather%20jackets%2C%20Cotton%20Coat%2C%20Vest%20Jacket%2C%20and%20we%20are%20providing%20service%20from%20all%20over%20the%20world%20with%20shipping%20especially%20free%20shipping%20Worldwide%20we%20have%20our%20official%20website%20which%20is%20%3CA%20href%3D%22https%3A%2F%2Fwww.yellowstonemerch.com%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EYellowstone%20Merchandise%3C%2FA%3E%26nbsp%3BThanks%20for%20sharing%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2194090%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2194090%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F981191%22%20target%3D%22_blank%22%3E%40Robls501%3C%2FA%3E%26nbsp%3B%20-%20Yes%2C%20an%20M365%20Personal%20or%20Family%20account%20will%20allow%20you%20control%20over%20your%20build%20number%20when%20logged%20in%20with%20that%20account.%20If%20you're%20hesitant%2C%20you%20can%20always%20try%20M365%20for%2030%20days%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fmicrosoft-365%2Ftry%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EFree%20Trial%20-%20Try%20Microsoft%20365%20for%20a%20month%20-%20Microsoft%20Store%3C%2FA%3E.%20Let%20us%20know%20if%20you%20have%20trouble%20accessing%20the%20feature%20with%20this%20account.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E--Kaycee%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2216335%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2216335%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fexcel-stock-data-not-updated%2Fm-p%2F2214108%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fexcel-stock-data-not-updated%2Fm-p%2F2214108%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20fix%20the%20problem%20with%20excel%20stock%20data.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2239052%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2239052%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20using%20Stock%20Data%20Type%20and%20Stockhistory()%20for%20Currency%20data%2C%20what%20timezone%20are%20the%20timestamps%20expressed%20in%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20instance%2C%20I%20am%20location%20in%20GMT%2B8%20and%20the%20time%20stamp%20is%20showing%20probably%20GMT%20timestamp.%26nbsp%3B%20Is%20that%20right%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20worse%20with%20currency%20data%20returned%20with%20the%20StockHistory()%20function%20as%20only%20the%20Date%20is%20available.%26nbsp%3B%20What%20timezone%20is%20the%20historical%20currency%20data%20in%3F%26nbsp%3B%20I%20did%20a%20cross%20comparison%20of%20USD%2FHKD%2C%20USD%2FCNY%2CUSD%2FCHF%20with%20Yahoo%20finance%20(not%20exactly%20comparable%20I%20know%2C%20but%20close%20enough).%26nbsp%3B%20The%20data%20returned%20from%20StockHistory()%20seems%20to%20have%20a%20day%20offset%20by%201.%3C%2FP%3E%3CP%3EFor%20example%2C%20data%20returned%20from%20stockhistory()%20with%20a%20date%20of%20%22March%2025%2C2021%22%20will%20correspond%20(or%20have%20the%20lease%20difference)%20to%20currency%20data%20of%20date%20%22March%2026%2C2021%22%20on%20yahoo%20finance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20cross%20compared%20just%20the%20closing%20currency%20mark%20over%20a%20period%20of%202%20years%2C%20calculating%20the%20mean%20squared%20error%20between%20the%202%20data%20sources%2C%20and%20seems%20that%20in%20all%20cases%2C%20moving%20the%20stockhistory()%20date%20forward%20by%201%20day%20will%20result%20with%20least%20error%20with%20yahoo%20finance%20and%20other%20data%20sources.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20stock%20prices%2C%20it%20is%20less%20of%20an%20issue%20as%20the%20historical%20data%20can%20go%20by%20exchange%20dates%20but%20for%20currency%20data%20with%20different%20sources%2C%20detailed%20timezone%20information%20is%20necessary%20to%20ensure%20date%20correctness.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20at%20least%20let%20us%20know%20when%20and%20in%20what%20timezone%20Refinitiv%20does%20the%20currency%20mark%20for%20the%20currency%20data%20they%20provide%20to%20us%20via%20excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1404338%22%20slang%3D%22en-US%22%3EAnnouncing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1404338%22%20slang%3D%22en-US%22%3E%3CP%20style%3D%22border%3A%201px%3B%20border-style%3A%20solid%3B%20border-color%3A%20%23000000%3B%20padding%3A%201em%3B%22%3E%3CSTRONG%3EDisclaimer%3C%2FSTRONG%3E%3CBR%20%2F%3ESTOCKHISTORY%20requires%20a%20Microsoft%20365%20Personal%2C%20Microsoft%20365%20Family%2C%20Microsoft%20365%20Business%20Standard%2C%20or%20Microsoft%20365%20Business%20Premium%20subscription.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EExcel%20is%20introducing%20a%20dynamically%20updating%20service-backed%20function%20that%20builds%20on%20the%20%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fpreview-of-dynamic-arrays-in-excel%2Fba-p%2F252944%22%20target%3D%22_blank%22%3Eflexibility%20of%20dynamic%20arrays%3C%2FA%3E%3C%2FSPAN%3E%20and%20fills%20a%20gap%20in%20the%20%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fe5af3212-e024-4d4c-bea0-623cf07fbc54%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EStocks%20data%20type%3C%2FA%3E%3C%2FSPAN%3E%26nbsp%3Bby%20providing%20access%20to%20historical%20data.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWe%20have%20added%20many%20needed%20improvements%20to%20support%20service-side%20errors%20and%20data%20retrieval%2C%20including%20new%20errors%20like%20%23BUSY!%20that%20show%20in%20Excel%20while%20data%20is%20being%20processed.%20We%20also%20added%20%3CA%20href%3D%22%23h_82850462581591784362798%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ea%20way%20for%20the%20function%20to%20spill%20formats%20dynamically%3C%2FA%3E%20instead%20of%20stamping%20a%20format%20on%20a%20cell.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20style%3D%22margin%3A%200in%3B%20margin-bottom%3A%20.0001pt%3B%20background%3A%20white%3B%22%20id%3D%22toc-hId--1330456690%22%20id%3D%22toc-hId--1330456690%22%20id%3D%22toc-hId--1330456690%22%20id%3D%22toc-hId--1330456690%22%20id%3D%22toc-hId--1330456690%22%20id%3D%22toc-hId--1330456690%22%20id%3D%22toc-hId--1330456690%22%20id%3D%22toc-hId--1330456690%22%20id%3D%22toc-hId--1330456690%22%20id%3D%22toc-hId--1330456690%22%20id%3D%22toc-hId--1330456690%22%20id%3D%22toc-hId--1330456690%22%3E%3CSPAN%3EIntroducing%20STOCKHISTORY%3C%2FSPAN%3E%3C%2FH2%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22StockHistoryChart1.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F197809i2405F68A809610BE%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22StockHistoryChart1.png%22%20alt%3D%22StockHistoryChart1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EEasily%20pulling%20stock%20prices%20into%20Excel%20has%20been%20%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921-excel-for-windows-desktop-application%2Fsuggestions%2F32223604-pull-current-stock-prices-and-historical-data-into%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Eone%20of%20the%20most%20requested%20features%20on%20UserVoice%3C%2FA%3E.%20The%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fe5af3212-e024-4d4c-bea0-623cf07fbc54%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EStocks%20data%20type%3C%2FA%3E%20began%20this%20journey%20by%20enabling%20refreshable%20quotes%20for%20stocks%2C%20bonds%2C%20funds%2C%20and%20currency%20pairs.%20We%20know%20that%20this%20wasn%E2%80%99t%20enough%20to%20complete%20the%20goals%20you%20have%20for%20analyzing%20your%20portfolio%20in%20Excel.%20Getting%20the%20history%20of%20a%20financial%20instrument%20over%20time%20is%20crucial%20information%20you%20need.%20We%20are%20thrilled%20to%20be%20able%20to%20bring%20this%20functionality%20into%20Excel.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId-1157056143%22%20id%3D%22toc-hId-1157056143%22%20id%3D%22toc-hId-1157056143%22%20id%3D%22toc-hId-1157056143%22%20id%3D%22toc-hId-1157056143%22%20id%3D%22toc-hId-1157056143%22%20id%3D%22toc-hId-1157056143%22%20id%3D%22toc-hId-1157056143%22%20id%3D%22toc-hId-1157056143%22%20id%3D%22toc-hId-1157056143%22%20id%3D%22toc-hId-1157056143%22%20id%3D%22toc-hId-1157056143%22%3EGetting%20started%20is%20simple%3C%2FH2%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22StockHistoryFunction1.png%22%20style%3D%22width%3A%20444px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F197855iD4742F14E5AE01CB%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22StockHistoryFunction1.png%22%20alt%3D%22StockHistoryFunction1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELet%E2%80%99s%20look%20at%20an%20overview%20of%20the%20function%20signature%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22lia-indent-padding-left-30px%22%3E%3CSTRONG%3ESTOCKHISTORY(stock%2C%26nbsp%3Bstart_date%2C%20%5Bend_date%5D%2C%5Binterval%5D%2C%5Bheaders%5D%2C%20%5Bproperty0%5D%2C%20%5Bproperty1%5D%20%5Bproperty2%5D%2C%20%5Bproperty3%5D%2C%20%5Bproperty4%5D%2C%20%5Bproperty5%5D)%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%20class%3D%22lia-indent-padding-left-30px%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CSTRONG%3Estock%3C%2FSTRONG%3E%3A%20The%20identifier%20for%20the%20financial%20instrument%20targeted.%20This%20can%20be%20a%20ticker%20symbol%20or%20a%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fe5af3212-e024-4d4c-bea0-623cf07fbc54%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EStocks%20data%20type%3C%2FA%3E.%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3Estart_date%3C%2FSTRONG%3E%3A%20The%20earliest%20date%20for%20which%20you%20want%20information.%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3Eend_date%3C%2FSTRONG%3E%20(optional)%3A%20The%20latest%20date%20for%20which%20you%20want%20information.%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3Einterval%3C%2FSTRONG%3E%20(optional)%3A%20Daily%20(0)%2C%20Weekly%20(1)%2C%20or%20Monthly%20(2)%20interval%20options%20for%20data%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3Eheaders%3C%2FSTRONG%3E%20(optional)%3A%20Specifies%20if%20additional%20header%20rows%20are%20returned%20with%20the%20array.%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3Eproperty0%20%E2%80%93%20property5%3C%2FSTRONG%3E%20(optional)%3A%20Specifies%20which%20information%20should%20be%20included%20in%20the%20result%2C%20Date%20(0)%2C%20Close%20(1)%2C%20Open%20(2)%2C%20High%20(3)%2C%20Low%20(4)%2C%20Volume%20(5).%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3EYou%20can%20find%20more%20detailed%20explanations%20of%20these%20arguments%20on%20the%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2F1ac8b5b3-5f62-4d94-8ab8-7504ec7239a8%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ESTOCKHISTORY%20support%20page%3C%2FA%3E.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId--650398320%22%20id%3D%22toc-hId--650398320%22%20id%3D%22toc-hId--650398320%22%20id%3D%22toc-hId--650398320%22%20id%3D%22toc-hId--650398320%22%20id%3D%22toc-hId--650398320%22%20id%3D%22toc-hId--650398320%22%20id%3D%22toc-hId--650398320%22%20id%3D%22toc-hId--650398320%22%20id%3D%22toc-hId--650398320%22%20id%3D%22toc-hId--650398320%22%20id%3D%22toc-hId--650398320%22%3EExamples%3C%2FH2%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH3%20id%3D%22toc-hId-40163154%22%20id%3D%22toc-hId-40163154%22%20id%3D%22toc-hId-40163154%22%20id%3D%22toc-hId-40163154%22%20id%3D%22toc-hId-40163154%22%20id%3D%22toc-hId-40163154%22%20id%3D%22toc-hId-40163154%22%20id%3D%22toc-hId-40163154%22%20id%3D%22toc-hId-40163154%22%20id%3D%22toc-hId-40163154%22%20id%3D%22toc-hId-40163154%22%20id%3D%22toc-hId-40163154%22%3EUsing%20Basic%20Text%20Inputs%3C%2FH3%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3E%3DSTOCKHISTORY(%22MSFT%22%2C%20%226%2F1%2F2020%22%2C%20%226%2F5%2F2020%22)%3C%2FPRE%3E%0A%3CP%3EYou%20can%20get%20started%20by%20using%20the%20ticker%20symbol%20as%20a%20textual%20representation%20of%20the%20stock.%20The%20start_date%20and%20end_date%20input%20will%20be%20interpreted%20by%20Excel%20the%20same%20way%20the%20%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Farticle%2Fdf8b07d4-7761-4a93-bc33-b7471bbff252%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EDATEVALUE%20function%3C%2FA%3E%3C%2FSPAN%3E%20would%20interpret%20date_text%20today.%20This%20means%20that%20the%20date%20inputs%20respect%20your%20system%20settings%20for%20datetime.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22StockHistoryTextExample.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F197863iABC632317A93185D%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22StockHistoryTextExample.png%22%20alt%3D%22StockHistoryTextExample.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDebugging%20Tip%3A%20Make%20sure%20you%20have%20any%20text%20values%20surrounded%20with%20quotation%20marks%20in%20your%20function%20inputs.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH3%20id%3D%22toc-hId--1767291309%22%20id%3D%22toc-hId--1767291309%22%20id%3D%22toc-hId--1767291309%22%20id%3D%22toc-hId--1767291309%22%20id%3D%22toc-hId--1767291309%22%20id%3D%22toc-hId--1767291309%22%20id%3D%22toc-hId--1767291309%22%20id%3D%22toc-hId--1767291309%22%20id%3D%22toc-hId--1767291309%22%20id%3D%22toc-hId--1767291309%22%20id%3D%22toc-hId--1767291309%22%20id%3D%22toc-hId--1767291309%22%3EChoosing%20a%20Specific%20Exchange%3C%2FH3%3E%0A%3CP%3EIf%20the%20ticker%20symbol%20is%20used%20as%20input%20without%20an%20exchange%20specified%2C%20the%20values%20will%20normally%20default%20to%20the%20XNAS%20(NASDAQ)%20stock%20exchange.%20There%20are%20two%20ways%20to%20help%20Excel%20know%20which%20financial%20instrument%20you%20are%20targeting.%3CSPAN%20style%3D%22font-family%3A%20inherit%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH5%20id%3D%22toc-hId-1421286102%22%20id%3D%22toc-hId-1421286102%22%20id%3D%22toc-hId-1421286102%22%20id%3D%22toc-hId-1421286102%22%20id%3D%22toc-hId-1421286102%22%20id%3D%22toc-hId-1421286102%22%20id%3D%22toc-hId-1421286102%22%20id%3D%22toc-hId-1421286102%22%20id%3D%22toc-hId-1421286102%22%20id%3D%22toc-hId-1421286102%22%20id%3D%22toc-hId-1421286102%22%20id%3D%22toc-hId-1421286102%22%3EUsing%20prepended%20text%3C%2FH5%3E%0A%3CP%3EFirst%2C%20you%20can%20use%20the%20%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Farticle%2F98a03e23-37f6-4776-beea-c5a6c8e787e6%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EMarket%20Identifier%20Code%3C%2FA%3E%3C%2FSPAN%3E%3CSPAN%3E%2C%3C%2FSPAN%3E%20followed%20by%20a%20colon%2C%20followed%20by%20the%20ticker%20symbol%20to%20get%20data%20from%20a%20specific%20exchange.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3E%3DSTOCKHISTORY(%E2%80%9CXMIL%3AMSFT%E2%80%9D%2C%20TODAY()-7%2C%20TODAY())%3C%2FPRE%3E%0A%3CP%3EIn%20this%20example%2C%20I%20am%20specifying%20the%20MSFT%20symbol%20on%20the%20Borsa%20Italiana%20Exchange%20(%22XMIL%3AMSFT%22)%20and%20I%20am%20requesting%20the%20last%207%20days%20of%20data%20using%20the%20%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Farticle%2F5eb3078d-a82c-4736-8930-2f51a028fdd9%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ETODAY()%20function%3C%2FA%3E%3C%2FSPAN%3E.%20This%20function%20updates%20when%20the%20date%20changes%20and%20so%20as%20a%20part%20of%20calculation%20the%20dates%20shown%20in%20the%20grid%20will%20update%20as%20well.%20Notice%20how%20the%20dates%20shown%20skip%20non-trading%20days%20like%20weekends%2C%20and%20the%20prices%20shown%20are%20in%20euros.%3C%2FP%3E%0A%3CDIV%20id%3D%22tinyMceEditorKaycee%20Anderson_1%22%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22StockHistoryExchangeExample.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F197870i25F0182C82D076A0%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22StockHistoryExchangeExample.png%22%20alt%3D%22StockHistoryExchangeExample.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH5%20id%3D%22toc-hId--386168361%22%20id%3D%22toc-hId--386168361%22%20id%3D%22toc-hId--386168361%22%20id%3D%22toc-hId--386168361%22%20id%3D%22toc-hId--386168361%22%20id%3D%22toc-hId--386168361%22%20id%3D%22toc-hId--386168361%22%20id%3D%22toc-hId--386168361%22%20id%3D%22toc-hId--386168361%22%20id%3D%22toc-hId--386168361%22%20id%3D%22toc-hId--386168361%22%20id%3D%22toc-hId--386168361%22%3EUsing%20a%20Stocks%20data%20type%3C%2FH5%3E%0A%3CP%3ESecond%2C%20you%20can%20use%20a%20cell%20containing%20a%20%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fe5af3212-e024-4d4c-bea0-623cf07fbc54%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EStocks%20data%20type%3C%2FA%3E%3C%2FSPAN%3E%20as%20a%20reference%20in%20the%20function%2C%20just%20like%20any%20other%20cell%20references.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3E%3DSTOCKHISTORY(B1%2C%20B3%2C%20B4)%3C%2FPRE%3E%0A%3CP%3EBelow%20I%20have%20converted%20MSFT%20to%20a%20Stocks%20data%20type%20and%20chosen%20the%20data%20type%20for%20Microsoft%20from%20the%20Mexican%20Stock%20Exchange.%20I%20passed%20the%20cell%20containing%20the%20data%20type%20to%20the%20STOCKHISTORY%20function%20(B1).%20I%20also%20passed%20in%20references%20to%20cells%20containing%20dates%20(B3%2C%20and%20B4).%20If%20I%20edit%20any%20of%20these%20cells%20(B1%2C%20B3%2C%20or%20B4)%20the%20STOCKHISTORY%20function%20will%20recalculate%20based%20on%20the%20new%20values%20in%20the%20cells.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22StockHistoryReferenceExample.png%22%20style%3D%22width%3A%20450px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F197862i7566594B758A34D7%2Fimage-dimensions%2F450x124%3Fv%3Dv2%22%20width%3D%22450%22%20height%3D%22124%22%20role%3D%22button%22%20title%3D%22StockHistoryReferenceExample.png%22%20alt%3D%22StockHistoryReferenceExample.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAdditional%20benefits%20to%20using%20a%20Stocks%20data%20type%20includes%20allowing%20you%20to%20see%20which%20currency%20the%20prices%20represent.%20Try%20the%20formula%20%E2%80%98%3DB1.Currency%E2%80%99%20where%20B1%20references%20a%20cell%20containing%20a%20Stocks%20data%20type.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22CurrencyExample.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F197851i6C87A6B37E590F42%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22CurrencyExample.png%22%20alt%3D%22CurrencyExample.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDebugging%20Tip%3A%20To%20verify%20what%20exchange%20your%20stock%20history%20values%20are%20coming%20from%2C%20input%20the%20%5Bheader%5D%20argument%20of%20%E2%80%9C2%E2%80%9D%20(Show%20instrument%20identifier%20and%20header)%20into%20the%20formula.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22HeaderArgumentExample.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F197852i1E44CD5A5327E3DE%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22HeaderArgumentExample.png%22%20alt%3D%22HeaderArgumentExample.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId--1097736043%22%20id%3D%22toc-hId--1097736043%22%20id%3D%22toc-hId--1097736043%22%20id%3D%22toc-hId--1097736043%22%20id%3D%22toc-hId--1097736043%22%20id%3D%22toc-hId--1097736043%22%20id%3D%22toc-hId--1097736043%22%20id%3D%22toc-hId--1097736043%22%20id%3D%22toc-hId--1097736043%22%20id%3D%22toc-hId--1097736043%22%20id%3D%22toc-hId--1097736043%22%20id%3D%22toc-hId--1097736043%22%3EGetting%20Fancy%3C%2FH2%3E%0A%3CP%3ELet%E2%80%99s%20see%20an%20example%20using%20every%20argument%20and%20property%20in%20the%20function.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3ESTOCKHISTORY(%22MSFT%22%2C%221%2F1%2F2019%22%2C%2212%2F31%2F2019%22%2C2%2C2%2C0%2C5%2C2%2C3%2C4%2C1)%3C%2FPRE%3E%0A%3CP%3EThis%20function%20uses%20every%20input%20field%20to%20create%20a%20wonderful%202D%20array%20of%20data%20for%20me%20to%20analyze.%20This%20data%20represents%20Microsoft%20stock%20from%20January%20to%20December%202019%20in%20a%20monthly%20overview%20for%20the%20Volume%2C%20Open%2C%20High%2C%20Low%2C%20and%20Close%20for%20that%20month.%20My%20goal%20is%20to%20chart%20this%20data%20in%20Excel.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELet%20me%20give%20a%20refresher%20on%20what%20this%20signature%20represents%3A%3C%2FP%3E%0A%3CP%20class%3D%22lia-indent-padding-left-30px%22%3E%E2%80%9CMSFT%E2%80%9D%20%E2%80%93%20The%20Microsoft%20ticker%20symbol%2C%3C%2FP%3E%0A%3CP%20class%3D%22lia-indent-padding-left-30px%22%3E%E2%80%9C1%2F1%2F2019%E2%80%9D%20%E2%80%93%20The%20start%20date%2C%3C%2FP%3E%0A%3CP%20class%3D%22lia-indent-padding-left-30px%22%3E%E2%80%9C12%2F31%2F2019%E2%80%9D%20%E2%80%93%20The%20end%20date%2C%3C%2FP%3E%0A%3CP%20class%3D%22lia-indent-padding-left-30px%22%3E2%20%E2%80%93%20Indicates%20a%20choice%20to%20show%20the%20Monthly%20overview%2C%3C%2FP%3E%0A%3CP%20class%3D%22lia-indent-padding-left-30px%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22StockHistoryLongExample-Interval.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F197860iA6157966823362A2%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22StockHistoryLongExample-Interval.png%22%20alt%3D%22StockHistoryLongExample-Interval.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22lia-indent-padding-left-30px%22%3E2%20%E2%80%93%20Indicates%20a%20choice%20to%20include%20both%20the%20ticker%20symbol%20and%20the%20label%20row%20in%20the%20resulting%20array%2C%3C%2FP%3E%0A%3CP%20class%3D%22lia-indent-padding-left-30px%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22StockHistoryLongExample-Header.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F197859i5A773C516C772692%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22StockHistoryLongExample-Header.png%22%20alt%3D%22StockHistoryLongExample-Header.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22lia-indent-padding-left-30px%22%3E0%2C5%2C2%2C3%2C4%2C1%20%E2%80%93%20Indicates%20the%20properties%20I%20want%2C%20in%20the%20order%20I%20want%20them%20in%20the%20resulting%20array.%20In%20this%20case%2C%20Date%2C%20Volume%2C%20Open%2C%20High%2C%20Low%2C%20Close.%3C%2FP%3E%0A%3CP%20class%3D%22lia-indent-padding-left-30px%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22StockHistoryLongExample-Properties.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F197861i03CDA74DD632DE09%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22StockHistoryLongExample-Properties.png%22%20alt%3D%22StockHistoryLongExample-Properties.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAll%20together%20this%20is%20the%20resulting%20formula%20in%20Excel%20with%20the%20data%20spilled%20into%20the%20grid.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22StockHistoryLongExample.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F197858iE059A351A7D9A8E0%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22StockHistoryLongExample.png%22%20alt%3D%22StockHistoryLongExample.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThen%20I%20can%20select%20this%20data%2C%20go%20to%20the%20%3CEM%3EInsert%3C%2FEM%3E%20tab%2C%20click%20%3CEM%3ERecommended%20Charts%20%26gt%3BAll%20Charts%26gt%3BStock%3C%2FEM%3E%20and%20insert%20a%20Volume-Open-High-Low-Close%20chart.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22StockHistoryInsertChart.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F197857i4F3D9C9A95071B5D%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22StockHistoryInsertChart.png%22%20alt%3D%22StockHistoryInsertChart.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22StockHistoryChart2.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F197853iC467B6EE6E5758CD%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22StockHistoryChart2.png%22%20alt%3D%22StockHistoryChart2.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EI%20can%20use%20this%20function%20to%20produce%20many%20charts%20and%20graphs%2C%20as%20well%20as%20use%20the%20data%20as%20inputs%20into%20other%20Excel%20functions.%20Try%20out%20different%20uses%20and%20combinations%20and%20let%20me%20know%20what%20you%20think!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId-1389776790%22%20id%3D%22toc-hId-1389776790%22%20id%3D%22toc-hId-1389776790%22%20id%3D%22toc-hId-1389776790%22%20id%3D%22toc-hId-1389776790%22%20id%3D%22toc-hId-1389776790%22%20id%3D%22toc-hId-1389776790%22%20id%3D%22toc-hId-1389776790%22%20id%3D%22toc-hId-1389776790%22%20id%3D%22toc-hId-1389776790%22%20id%3D%22toc-hId-1389776790%22%20id%3D%22toc-hId-1389776790%22%3EAbout%20our%20Data%20Sources%3C%2FH2%3E%0A%3CP%3EAs%20with%20Excel%E2%80%99s%20Stocks%20data%20type%20we%20are%20sourcing%20the%20historical%20data%20from%20%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fwww.refinitiv.com%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3ERefinitiv%3C%2FA%3E%3C%2FSPAN%3E.%20You%20can%20%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Farticle%2F98a03e23-37f6-4776-beea-c5a6c8e787e6%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Eread%20more%20about%20what%20exchanges%20are%20currently%20supported%3C%2FA%3E%3C%2FSPAN%3E%20in%20Excel.%20While%20Stocks%20data%20type%20values%20can%20mostly%20be%20refreshed%20intraday%20on%20minor%20delay%2C%20STOCKHISTORY%20values%20are%20updated%20once%20daily%20for%20all%20supported%20exchanges%20at%20a%20minor%20delay%20after%20market%20close.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20STOCKHISTORY%20function%20also%20supports%20inputs%20of%20Currency%20Pairs%2C%20ETFs%2C%20Index%20Funds%2C%20Mutual%20Funds%2C%20and%20Bonds.%20The%20easiest%20way%20to%20specify%20these%20inputs%20is%20to%20convert%20them%20to%20the%20Stocks%20data%20type%20and%20use%20them%20as%20references%20to%20the%20function.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20note%20that%20while%20some%20financial%20instruments%20may%20be%20available%20as%20Stocks%20data%20types%2C%20the%20historical%20information%20will%20not%20yet%20be%20available.%20For%20example%2C%20this%20is%20the%20case%20for%20most%20popular%20Index%20Funds%20including%20the%20S%26amp%3BP%20500.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId--417677673%22%20id%3D%22toc-hId--417677673%22%20id%3D%22toc-hId--417677673%22%20id%3D%22toc-hId--417677673%22%20id%3D%22toc-hId--417677673%22%20id%3D%22toc-hId--417677673%22%20id%3D%22toc-hId--417677673%22%20id%3D%22toc-hId--417677673%22%20id%3D%22toc-hId--417677673%22%20id%3D%22toc-hId--417677673%22%20id%3D%22toc-hId--417677673%22%20id%3D%22toc-hId--417677673%22%3ENumbers%20with%20Format%20Hints%3C%2FH2%3E%0A%3CP%3ESTOCKHISTORY%20is%20the%20first%20function%20that%20provides%20formatting%20hints%20for%20its%20number.%20It%20does%20so%20by%20returning%20an%20enhanced%20number%20type%20that%20we%20refer%20to%20as%20a%20Formatted%20Number%20Value%20(%E2%80%9CFNV%E2%80%9D).%20FNVs%20are%20just%20like%20any%20other%20number%20in%20Excel%20but%20they%20are%20accompanied%20by%20a%20helpful%20formatting%20hint.%20Excel%20uses%20this%20format%20hint%20when%20the%20value%20lands%20in%20a%20cell%20with%20%E2%80%9CGeneral%E2%80%9D%20number%20formatting%20applied%2C%20the%20default%20for%20unformatted%20cells.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20the%20example%20below%2C%20the%20STOCKHISTORY%20function%20is%20being%20used%20to%20retrieve%20the%20exchange%20rate%20for%20a%20currency%20pair%20between%20Jan%201%3CSUP%3Est%3C%2FSUP%3E%20and%20Jan%207%3CSUP%3Eth%3C%2FSUP%3E%2C%202020.%20All%20the%20cells%20have%20the%20default%20%E2%80%9CGeneral%E2%80%9D%20number%20format%20applied.%20Notice%20how%20the%20FNV%E2%80%99s%20(indicated%20with%20colored%20overlays)%20allow%20the%20Close%20column%20to%20seamlessly%20change%20from%20Pound%20(%C2%A3)%20to%20Dollar%20(%24)%20to%20Rand%20(R).%20In%20the%20example%2C%20FNVs%20are%20also%20used%20to%20have%20date%20serials%20(e.g.%2043831)%20show%20using%20date%20formatting%20(e.g.%201%2F1%2F2020).%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3E%3DSTOCKHISTORY(C2%2C%20%221%2F1%2F2020%22%2C%20%221%2F7%2F2020%22)%3C%2FPRE%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22FormattedNumberValueGIF.gif%22%20style%3D%22width%3A%20196px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F197854i79CFBA0AEA418800%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22FormattedNumberValueGIF.gif%22%20alt%3D%22FormattedNumberValueGIF.gif%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3BFNVs%20can%20pass%20through%20lookup%20style%20functions%20such%20as%20XLOOKUP%2C%20INDEX%2C%20IF%2C%20CHOOSE%2C%20or%20simple%20references%20(e.g.%20%3DA1)%20but%20the%20hint%20is%20simply%20ignored%20by%20other%20function%20which%20just%20see%20them%20as%20their%20number%20value.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId--551362397%22%20id%3D%22toc-hId--551362397%22%20id%3D%22toc-hId--551362397%22%20id%3D%22toc-hId--551362397%22%20id%3D%22toc-hId--551362397%22%20id%3D%22toc-hId--551362397%22%20id%3D%22toc-hId--551362397%22%20id%3D%22toc-hId--551362397%22%20id%3D%22toc-hId--551362397%22%20id%3D%22toc-hId--551362397%22%20id%3D%22toc-hId--551362397%22%20id%3D%22toc-hId--551362397%22%3ELearn%20More%3C%2FH2%3E%0A%3CP%3EYou%20can%20learn%20more%20about%20STOCKHISTORY%20by%20reviewing%20the%20%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2F1ac8b5b3-5f62-4d94-8ab8-7504ec7239a8%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ESTOCKHISTORY%20support%20article%3C%2FA%3E%3C%2FSPAN%3E.%20This%20article%20goes%20in%20depth%20on%20the%20function%20definition%20and%20clarifies%20how%20monthly%20and%20weekly%20intervals%20are%20determined.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId-1936150436%22%20id%3D%22toc-hId-1936150436%22%20id%3D%22toc-hId-1936150436%22%20id%3D%22toc-hId-1936150436%22%20id%3D%22toc-hId-1936150436%22%20id%3D%22toc-hId-1936150436%22%20id%3D%22toc-hId-1936150436%22%20id%3D%22toc-hId-1936150436%22%20id%3D%22toc-hId-1936150436%22%20id%3D%22toc-hId-1936150436%22%20id%3D%22toc-hId-1936150436%22%20id%3D%22toc-hId-1936150436%22%3EAvailability%20Notes%3C%2FH2%3E%0A%3CP%3ESTOCKHISTORY%20is%20now%20available%20to%26nbsp%3B100%25%20of%20%3CSTRONG%3EMicrosoft%3C%2FSTRONG%3E%3CSTRONG%3E%20365%20Subscribers%2C%26nbsp%3B%3C%2FSTRONG%3Eon%20Mac%2C%20Windows%2C%20and%20Excel%20Online.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20continue%20to%20provide%20feedback%20either%20in%20the%20comments%20below%20or%20%3CA%20href%3D%22https%3A%2F%2Finsider.office.com%2Fhandbook%2Fsend-feedback%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ethrough%20our%20in-app%20feedback%3C%2FA%3E.%20Please%20let%20us%20know%20what%20you%20think!%3C%2FP%3E%0A%3CP%3E%3CBR%20%2F%3ETo%20stay%20connected%20to%20Excel%20and%20its%20community%2C%20read%20the%20Excel%20blog%20posts%20and%20send%20us%20ideas%20and%20suggestions%20via%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EUserVoice%3C%2FA%3E.%20You%20can%20also%20follow%20Excel%20on%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.facebook.com%2Fmicrosoftexcel%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EFacebook%3C%2FA%3E%26nbsp%3Band%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftwitter.com%2Fmsexcel%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3ETwitter%3C%2FA%3E.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EKaycee%20Reineke%20(%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Ftwitter.com%2FKayceeSue%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3E%40KayceeSue%3C%2FA%3E%3C%2FSPAN%3E)%3CBR%20%2F%3EProgram%20Manager%2C%20Excel%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1404338%22%20slang%3D%22en-US%22%3E%3CP%3ENow%20you%20can%20analyze%20historical%20finance%20data%20for%20stocks%2C%20funds%2C%20bonds%2C%20and%20currency%20pairs%20in%20Excel%20by%20using%20the%20new%20built-in%20service-backed%20STOCKHISTORY%20function!%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1404338%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBlog%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2495091%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2495091%22%20slang%3D%22en-US%22%3E%3CP%3EI%20discovered%20STOCKHISTORY%20this%20morning%2C%20and%20have%20spent%20most%20of%20the%20day%20with%20it.%20It's%20great%20with%20one%20MAJOR%20exception%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEven%20with%20manual%20calculation%2C%20and%20with%20only%20two%20STOCKHISTORY%20formulas%20in%20my%20workspace%2C%20STOCKHISTORY%20takes%20over%20my%20computer%20every%20few%20minutes.%20This%20freezes%20my%20mouse%20for%2010%20to%2020%20seconds%2C%20at%20a%20time%2C%20and%20then%2C%20when%20it's%20momentarily%20free%20so%20that%20I%20can%20click%20on%20some%20other%20app%20in%20the%20taskbar%2C%20it%20degrades%20my%20mouse%20movements%20in%20the%20other%20app%2C%20as%20well.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20time%20between%20between%20opening%20the%20STOCKHISTORY%20workbook%20and%20having%20the%20problem%20can%20vary%20significantly.%26nbsp%3BThis%20problem%20occurs%20even%20when%20the%20history%20that%20the%20function%20is%20reporting%20is%20decades%20old%20and%20has%20no%20reason%20ever%20to%20recalc.%3CBR%20%2F%3E%3CBR%20%2F%3E(I%20just%20opened%20the%20two-formula%20workbook%20again%2C%20and%20it's%20now%20working%20with%20no%20problem.%20This%20is%20weird.%20Could%20it%20have%20anything%20to%20do%20with%20differing%20loads%20on%20Refinitiv's%20servers%3F)%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EEarlier%20today%2C%20I%20returned%20the%20closing%20price%20for%20the%20500%20companies%20that%20currently%20have%20the%20highest%20market%20cap.%20I%20didn't%20think%20that%20I'd%20ever%20again%20have%20enough%20control%20over%20my%20mouse%20again%20to%20close%20that%20workbook!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2749307%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2749307%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20and%20first%20of%20all%20thanks%20for%20the%20release%20of%20stockhistory.%26nbsp%3B%20I%20have%20a%20question.%20i%20can%20get%20the%20historical%20data%20of%20lets%20say%20MSFT.%26nbsp%3B%20As%20i%26nbsp%3B%20put%20%3Dstockhistory(MSFT)%20the%20first%20menu%20appears%20down.%20where%20i%20see%20i%20can%20get%20the%20daily%20%25%20change.%26nbsp%3B%20how%20can%20i%20get%20it%20historically.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2764358%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2764358%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22%22%3EThe%20function%20is%20perfect%20in%20the%20way%20it%20was%20designed.%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3EIt%20would%20be%20even%20more%20interesting%20and%20useful%20if%20it%20had%20the%20option%20to%20show%20the%20closing%20price%20of%20the%20stock%20without%20dividend%20adjustments.%20This%20could%20be%20done%20by%20creating%20the%20property6%20argument.%20%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2791087%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2791087%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20I%20would%20like%20to%20know%20how%20the%20function%20show%20Today's%20price%2C%20it's%20only%20showing%20prices%20upto%20yesterday%20even%20though%20I%20put%20end%20date%20as%20Today()%20or%20Date%20Function.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2792111%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20STOCKHISTORY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2792111%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1168633%22%20target%3D%22_blank%22%3E%40Suzzu%3C%2FA%3E%26nbsp%3B%22today%22%20you%20mean%20the%20latest%20price%2C%20or%20the%20current%20price%20when%20the%20trading%20is%20opened%20in%20your%20time%20zone%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Co-Authors
Version history
Last update:
‎Apr 09 2021 12:28 PM
Updated by: