%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%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-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%20is%20currently%20available%20to%20100%25%20of%26nbsp%3BMicrosoft%20365%20Subscribers%20in%20the%20Beta%20Channel%2C%20and%2050%25%20of%20the%20Current%20Channel%20(Preview)%20of%20the%20%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Finsider.office.com%2Fjoin%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EOffice%20Insider%20program.%3C%2FA%3E%3C%2FSPAN%3E%26nbsp%3BThe%20behavior%20and%20signature%20of%20this%20function%20is%20subject%20to%20change.%20Releasing%20this%20way%20allows%20us%20to%20get%20early%20feedback%20to%20prepare%20for%20a%20broader%20release.%20This%20function%20will%20only%20be%20available%20to%20Microsoft%20365%20customers%20who%20are%20signed%20in.%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%20rel%3D%22noopener%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%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%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%3D1.0%26amp%3Bpx%3D999%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%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%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%3D1.0%26amp%3Bpx%3D999%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%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%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%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%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%3D1.0%26amp%3Bpx%3D400%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%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%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%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%3D1.0%26amp%3Bpx%3D400%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%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%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%3D1.0%22%20width%3D%22450%22%20height%3D%22124%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%3D1.0%26amp%3Bpx%3D400%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%3D1.0%26amp%3Bpx%3D400%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%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%3D1.0%26amp%3Bpx%3D400%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%3D1.0%26amp%3Bpx%3D400%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%3D1.0%26amp%3Bpx%3D400%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%3D1.0%26amp%3Bpx%3D400%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%3D1.0%26amp%3Bpx%3D400%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%3D1.0%26amp%3Bpx%3D999%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%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%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%22h_82850462581591784362798%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%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%3D1.0%26amp%3Bpx%3D999%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%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%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%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%3B50%25%20of%20%3CSTRONG%3EMicrosoft%3C%2FSTRONG%3E%3CSTRONG%3E%20365%20Subscribers%20in%20the%20Beta%20level%26nbsp%3B%3C%2FSTRONG%3Eand%20will%20be%20available%20to%20users%20of%20other%20channels%20later%20this%20year.%26nbsp%3BI%20will%20update%20this%20blog%20as%20STOCKHISTORY%20becomes%20more%20widely%20available.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20the%20meantime%2C%20please%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ethrough%20our%20in-app%20feedback%3C%2FA%3E.%20Please%20note%20the%20function%20signature%20and%20behavior%20is%20subject%20to%20change%20based%20on%20feedback%20from%20the%20community.%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%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-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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%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
Microsoft

Disclaimer
STOCKHISTORY is currently available to 100% of Microsoft 365 Subscribers in the Beta Channel, and 50% of the Current Channel (Preview) of the Office Insider program. The behavior and signature of this function is subject to change. Releasing this way allows us to get early feedback to prepare for a broader release. This function will only be available to Microsoft 365 customers who are signed in.

 

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 50% of Microsoft 365 Subscribers in the Beta level and will be available to users of other channels later this year. I will update this blog as STOCKHISTORY becomes more widely available. 

 

In the meantime, please provide feedback either in the comments below or through our in-app feedback. Please note the function signature and behavior is subject to change based on feedback from the community. 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

36 Comments

@Kaycee Anderson , thank you! That's really great function itself and introduction of FNV is even more great.

Some difference with Data Type

image.png

Microsoft

@Sergei Baklan great observation. I can add some clarity on how this currently works. The historical data is added at the end of the trading day when the market closes. Typically within a couple hours of that close. The Stock data type shows 'real-time' data according to the delay agreement we have with the data provider. Currently intraday history isn't supported in our licensing of the data for Excel. What impact does intraday history play in your analysis? 

Senior Member

@Kaycee Anderson Are the Formatted Number Values ("FNV") available to third-party developers writing custom Excel functions? We have started leveraging the dynamic arrays feature in Excel with our custom functions and are exposing tabular data similar to how you implemented STOCKHISTORY.

 

The top requirements I have at this point are to provide formatting for the column headers (bold!) and to do something with date/currency values we return. Where can I find technical information on this feature?

 

 

I can confirm that STOCKHISTORY has been flighted to my system

 

 

Kudos to you all

 

 

Cheers

Abiola David

 

@Kaycee Anderson , it's more clear now, thank you for the clarification. So far I don't how critical this day, depends on how to use this function in application. Dates without sales are also missed, in some cases it's much better to have all dates. Will see, need to play more.

Established Member

This is a wonderful update, thanks team! 

Can't wait to get a chance to try it

Thanks

Jeff

Microsoft

@GabrM Thanks for the feedback! FNV's are not yet available to 3rd party UDF providers, but this is something we are keeping an eye on. To ensure we have the right design, we wanted to first pilot FNV's with a 1st party function (STOCKHISTORY) before broadening out the feature based on user demand. 

Senior Member

@Joe McDaid thanks for your reply. This is a great improvement and I'm happy to see that dynamic arrays being leveraged by Microsoft in this way.

Great work Kaycee and Team 

Regular Visitor

RasnaSaini_0-1591858665812.png

That's my version and I just updated my office. I thought I should be able to use the stockhistory function, but it doesn't show up. What can I do? 
This function is going to be a game changer in my industry and I cannot wait to use it! (You should be able to smell my excitement!!!) 

@RasnaSaini you're not in the lucky 50% sorry  (if it's any consolation neither am I).   We have to wait a little longer

 

 

image.png

Hi @Kaycee Anderson,

that's awesome - thank you and thanks to the team : -)

I have seen, that the German translation for this function is BÖRSENHISTORIE - I love it : -)

Best,

Mourad 

Regular Visitor

Thanks @Wyn Hopkins - I did read that 50% thing, but didn't want to acknowledge that I lost in the excel lottery. I am hoping that there is someway to get on to the other side - I really can't wait to use it! 

Microsoft

@RasnaSaini , I understand your disappointment at not yet having access to the feature even though you are in the beta channel. Be assured we are trying to get to the next release as soon as possible and will update this thread once that happens. In the meantime is there anything in this blog or from other online posts that stands out as something you expect that isn't covered, or some behavior described that doesn't make sense? I know you will have to try it to see how it feels, but if there are any red flags, that is what we are trying to address right away.

Super Contributor

🧪 🧫 Experimenting with the new #STOCKHISTORY function & I found very interesting.

So I have an idea hope you will support by voting 🗳 and make it happen.

STOCKHISTORY function currently accepts only the numeric values in the properties it would be great to see if it accepts the string values and make it more flexible for the users.

https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/40652983...

0.jpeg

 

Regards, Faraz Shaikh

Regular Visitor

@Kaycee Anderson Thank you so much for your response. One of the things that I wanted to check, but couldn't find further information to, is how are stock splits (reverse splits) handled by this function? For eg: Let's assume Amazon stock is currently at $2,500 and they decide to do 5 for 1 stock split. The share price would fall to $500 (and would perhaps settle a little over it reflecting wider market participation at lower price hence pushing the share price up). What would the output look like using #Stockhistory? Would it index the price and volume prior to the split? 

 

Next, ex-dividend date - any possibility of showing that through the function? This is when share price typically falls to reflect the dividend cash outflow. 

 

My third suggestion is the same as @Faraz Shaikh - to have string values for properties to make the function more user friendly during audits. 

Hi,

the idea for having the arguments (also) available as text strings is attractive. In a such case, I think, that they should then also be localized, because it makes not too much sense for example for a German, French or Spanish user to use English named text arguments.
However, assuming that these text arguments would not be automatically translated by Excel from one language to another, this could lead to problems when sharing the workbook with collegues in other countries. In current (and past) versions of Excel, CELL is an example of a function showing this behaviour.
Therefore, I would personally prefer to keep the arguments as values for avoiding compatibility problems when using Excel in different languages.

Best,

Mourad

@Mourad Louha , fully support you. We have enough other issues working in international environment, not necessary to add more.

Microsoft

@RasnaSaini  Dividend dates and Ex-dividend dates are not something currently licensed to us by our data provider. It is one of the top asks from customers like you though, so I understand how it would make sense as a factor for historical analysis. I encourage you to vote for the item here: https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/35122639... on UserVoice. I can't make any promises about when/if we can get the data, but it is on my radar. 

For Stock Splits, when the stock split data flows through to our system, there is a latency period, on the next recalculation of the StockHistory function (this could be on file open, function edit, or because the function is volatile with the Today() argument etc), the results will update to show the historical prices calculated to reflect the split. This will feel very similar to what you may see on websites like MSN, Google, and Bing when showing historical prices https://www.msn.com/en-us/money/stockdetails/nas-msft/fi-a1xzim
There wouldn't be a way to "freeze" the numbers from the result unless you performed a copy and paste as values for the data before the Split. Does that make sense? What do you think?

 

Microsoft

@Sergei Baklan @Mourad Louha @Faraz Shaikh 
This is some great discussion about how Excel can explore being more user-friendly for function arguments to aid in audits and clarity for laying out your data. For some context on our choices, Excel will typically NOT change arguments to your formulas when input as strings, so if you put in "1/2/20" as a string into this function in the UK that would be February 1st and in the US it would be January 2nd. But if you put "1/2/20" in a cell from the US and then referenced it in your formula, Excel doesn't 'see' the date formatting, it sees the number 43832 and so you and the person in the UK would see the same data. In the same vein, Excel typically uses numbers to represent defined properties as inputs to formulas (sometimes called ENUMs) to simplify these cross international concerns. 

You will notice that the "headers" (or other information that is returned as a result of formulas) will be 'translated' to show in the language your Excel is in. This is often what happens for the outputs of formulas or for things Excel controls. We like to give you control over the input, but we can sometimes be smart about the output. So this isn't to say that we couldn't include textual inputs for properties, we just haven't added the additional translation layer into the system, and would introduce complexity for sure. Thanks for suggestion and the UserVoice, if this gets traction, we could revisit it.

 

Sorry for the long-winded explanation. Hope some of that helps. 

Senior Member

@Joe McDaid Definitely +1 for please adding FNVs to the C API too - so that .xll-based UDFs can use these too.

Regular Contributor

I am an insider but still do not have the function. When is it scheduled to be available for all insiders?

 

Thanks, Mike

Regular Contributor

Meanwhile arrived at the 132 12 20 000 build but still not available. Any possibility I can force this function?

Microsoft

@Mike There isn't a way to override into the 50% of Beta channel. The good news is while I can't give you a date, we are working hard to move to the next percent of customers hopefully within 2 months. At that time 100% of Beta channel will have access. I will update this post at that time. Fingers crossed for smooth sailing between now and then. 

Regular Contributor

Hi @Kaycee Anderson ,

Thanks a lot for your answer.

Microsoft

Hey Everyone, we have move ahead with our next ring of release, and so anyone in the Beta Channel of Office Insiders should 100% have the StockHistory function available. If you do not, please let me know!

Regular Contributor

Hi @Kaycee Anderson 

 

Got it, thanks a lot!

Visitor

It's not working on mine yet, what can I do to get it to work? I have beta. @Kaycee Anderson 

build 13304.20000 (if that matters)

Regular Visitor
Was awaiting this release to try out the function. Thanks for the wider release!
Here’s what I wrote on LinkedIn today about Stockhistory - explaining the function in simplified colloquial language and then building complexity over it.  
 
 
Occasional Visitor

I have found that STOCKHISTORY has limits. For example it only goes back as far as 2017 for some European stocks. Only as far as 2014 for GOOG as another example. Is that the way it should be? Is that the permanent plan? Will more history be available in future? ...

Occasional Visitor

Hi @Kaycee Anderson 

I have Office 365 Excel beta version 2011 (Build 13415.20002 ) but don't have this function yet. Eager to chart historic data, what can i do to get it?

Microsoft

@Rutu_J Can you confirm that your channel is set to Beta Channel on your accounts page? It is possible you signed up for Office Insider but still need to switch the Insider Level. 

If that does say Beta, what is your language, it is possible the function is translated. 

 
 
 
 
 
 
 

Beta Channel.png

@Kaycee Anderson , by the way, how is version 2007 on Beta channel?

Occasional Visitor

@Kaycee Anderson  Hi Kaycee  Yes it shows beta just like your image.

It's working now. I shut down my PC and then started it again. And it started working. 

 

@Sergei Baklan  It now shows version 2011 (Build 13415.20002) after shutting down and starting again..

 

I'm using STOCKHISTORY with Sparklines , it's such a useful combination!

Occasional Visitor

I just want to say THANK YOU! For months, I would manually build my weekly day trade/swing trade stock scanner in excel, by analyzing the highs and lows of my stocks of interest from the last week and month. Sometimes this would take HOURS! But now with a combination of STOCKHISTORY, MIN, and MAX, I can set up my scanner in a matter minutes! Good job and thank you!