Community Question - How have you been using the new Stocks and Geography Data Types?

%3CLINGO-SUB%20id%3D%22lingo-sub-218444%22%20slang%3D%22en-US%22%3ECommunity%20Question%20-%20How%20have%20you%20been%20using%20the%20new%20Stocks%20and%20Geography%20Data%20Types%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-218444%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20have%20you%20been%20using%20the%20new%20%3CSPAN%3E%3CA%20href%3D%22http%3A%2F%2Faka.ms%2FstockgeoXL%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EStocks%20and%20Geography%20data%20types%3C%2FA%3E%3C%2FSPAN%3E%20in%20Excel%3F%20Since%20the%20new%20Stocks%20and%20Geography%20data%20types%20in%20Excel%20have%20been%20available%20to%20Insiders%20for%20a%20little%20while%20now%2C%20we%20want%20to%20hear%20from%20you!%20How%20have%20you%20been%20using%20them%20so%20far%3F%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F31475iBEDB35C1A6BC9FB4%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20border%3D%220%22%20alt%3D%22The%20dot%20operator%20and%20autocomplete%20are%20how%20you%20use%20fields%20in%20a%20formula%22%20title%3D%22Image5.png%22%20%2F%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELeave%20a%20comment%20here%20with%20your%20favorite%20examples%20and%20samples%2C%20if%20you'd%20like%20to%20share.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-218444%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-740817%22%20slang%3D%22en-US%22%3ERe%3A%20Community%20Question%20-%20How%20have%20you%20been%20using%20the%20new%20Stocks%20and%20Geography%20Data%20Types%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-740817%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F3321%22%20target%3D%22_blank%22%3E%40Blake%20T%20Walsh%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20a%20longtime%20MSFT%20office%20user%20on%20Windows%20and%20about%20ten%20years%20ago%20switched%20to%20the%20Apple%20Mac%20platform.%20I%20use%20Bloomberg%20professionally%20but%20wanted%20to%20have%20a%20portable%20copy%20of%20my%20portfolio%20that%20I%20could%20use%20away%20from%20my%20Bloomberg%20terminal.%20I%20was%20very%20excited%20to%20hear%20that%20real-time%20global%20securities%20pricing%20was%20added%20to%20Excel.%20But%20then%20I%20was%20shocked%20to%20discover%20that%20this%20functionality%20was%20only%20available%20on%20the%20Windows%20version%20of%20excel%20not%20the%20MAC%20version.%20There%20is%20absolutely%20no%20technical%20reason%20why%20this%20should%20be%20so%2C%20so%20I%20must%20assume%20that%20the%20reason%20is%20political%20-%20to%20deprive%20functionality%20to%20MAC%20users%20in%20order%20to%20drive%20them%20toward%20adopting%20Windows%20instead.%20Is%20any%20of%20this%20true%20and%20is%20there%20a%20work-round%20to%20getting%20real-time%20securities%20pricing%20in%20excel%20on%20the%20MAC%20or%20do%20I%20need%20to%20drop%20excel%20all%20together%3F%20Thanks%20in%20advance%20for%20responding%20if%20you%20can...%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-358516%22%20slang%3D%22en-US%22%3ERe%3A%20Community%20Question%20-%20How%20have%20you%20been%20using%20the%20new%20Stocks%20and%20Geography%20Data%20Types%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-358516%22%20slang%3D%22en-US%22%3E%3CP%3EHey%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F284891%22%20target%3D%22_blank%22%3E%40TampaTrader%3C%2FA%3E%2C%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20understand%20this%20isn't%20an%20ideal%20option%2C%20but%20I%20found%20out%20that%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3EItems%2C%20including%20packaged%20software%2C%20purchased%20directly%20from%20Microsoft%20Store%20on%20the%20web%2C%20on%20Xbox%2C%20on%20Windows%20or%20retail%20fall%20under%20the%20One%20Microsoft%20Refund%20%3CA%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fsupport.microsoft.com%252Fen-us%252Fhelp%252F10558%252Fmicrosoft-store-returning-items-bought-for-exchange-refund%26amp%3Bdata%3D04%257C01%257CKaycee.Anderson%2540microsoft.com%257C6e5cbefde2bd4201e00208d69d0e9c0f%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C636869083420097526%257CUnknown%257CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%253D%257C-1%26amp%3Bsdata%3D3Z%252B67GPdeEbNICuZM1IEBF5tTUKikMerNCoMxOgwMgY%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Epolicy%3C%2FA%3E%20and%20can%20be%20returned.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3EAgain%2C%20sorry%20for%20the%20confusion%20when%20purchasing%20Office%2C%20we%20are%20hoping%20to%20address%20this%20issue%20in%20the%20future.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-355018%22%20slang%3D%22en-US%22%3ERe%3A%20Community%20Question%20-%20How%20have%20you%20been%20using%20the%20new%20Stocks%20and%20Geography%20Data%20Types%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-355018%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20TampaTrader%2C%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETo%20further%20clarify%2C%20no%20MS%20Office%20Professional%202016%20does%20not%20include%20Data%20Types.%20We%20have%20commercial%20and%20consumer%20versions%20of%20Office%20365%20that%20include%20this%20feature%2C%20but%20the%20consumer%20or%20commercial%20%22perpetual%22%20licensed%20versions%20%22Office%20%5Byear%5D%22%20will%20not%20have%20them.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20might%20have%20access%20to%20Data%20Types%20in%20Excel%20online%20now%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.office.com%2Flaunch%2Fexcel%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.office.com%2Flaunch%2Fexcel%3C%2FA%3E%26nbsp%3Bsign%20in%2C%20and%20open%20a%20new%20workbook%20then%20go%20to%20the%20Data%20Tab.%20If%20you%20see%20Data%20Types%20you%20are%20good%20to%20go.%20If%20you%20don't%20see%20it%20yet%2C%20my%20apologies.%20On%20the%20web%20with%20big%20features%20we%20roll%20out%20to%20a%20percentage%20at%20a%20time%20to%20make%20sure%20everything%20is%20working.%20Right%20now%20we%20are%20only%20at%2010%25%20of%20our%20online%20customers.%20The%20percentage%20will%20increase%20and%20we%20hope%20to%20be%20at%20100%25%20in%20a%20couple%20months.%20Sorry%20for%20the%20inconvenience.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EI%20work%20on%20the%20product%20team%2C%20but%20am%20passing%20along%20your%20last%20feedback%20about%202019%20to%20the%20appropriate%20parties.%20Hopefully%20we%20can%20make%20this%20less%20confusing%20in%20the%20future.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-354756%22%20slang%3D%22en-US%22%3ERe%3A%20Community%20Question%20-%20How%20have%20you%20been%20using%20the%20new%20Stocks%20and%20Geography%20Data%20Types%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-354756%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20for%20responding.%20Just%20to%20clarify%2C%20since%20you%20mentioned%20%22commercial%20users%22%20does%20%3CSTRONG%3EMS%20Office%20Professional%202016%3C%2FSTRONG%3E%20include%20this%20feature%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20Excel%20online%20integrate%20at%20all%20with%20Excel%202019%3F%20When%20might%20online%20version%20have%20the%20stocks%20feature%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20seems%20as%20if%20I%20wasted%20money%20purchasing%20Office%202019.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-354246%22%20slang%3D%22en-US%22%3ERe%3A%20Community%20Question%20-%20How%20have%20you%20been%20using%20the%20new%20Stocks%20and%20Geography%20Data%20Types%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-354246%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20TampaTrader%2C%20So%20sorry%20for%20the%20frustration%20you%20are%20feeling%20with%20your%20new%20Office%202019.%20%3CBR%20%2F%3EUnfortunately%2C%20features%20like%20Ideas%20and%20new%20data%20types%20are%20services-backed%20features%20that%20will%20only%20be%20available%20for%20Office%20365%2C%20commercial%20users%20and%20consumers.%20Those%20features%20are%20not%20going%20to%20be%20available%20in%20Office%202019%2C%20or%20any%20other%26nbsp%3B%20%22Office%20%5BYear%5D%22%26nbsp%3B%3CSPAN%20style%3D%22font-family%3A%20inherit%3B%22%3Eversions%20of%20Office.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EHowever%2C%20soon%20you%20will%20have%20access%20to%20Stocks%20data%20types%20in%20Excel%20Online%20which%20will%20be%20available%20to%20anyone%20who%20is%20signed%20in%20at%20office.com.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-342249%22%20slang%3D%22en-US%22%3ERe%3A%20Community%20Question%20-%20How%20have%20you%20been%20using%20the%20new%20Stocks%20and%20Geography%20Data%20Types%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-342249%22%20slang%3D%22en-US%22%3E%3CP%3EFrom%20what%20I%20see%2C%20this%20Stocks%20feature%20became%20available%20around%20March%202018.%26nbsp%3B%3C%2FP%3E%3CP%3EOffice%202019%20came%20out%20around%20October%202018%2C%20correct%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhy%20is%20this%20feature%20absent%20from%20Office%202019%20which%20I%20recently%20purchased%3F%20Consumers%20expect%20the%20latest%20features%20to%20be%20in%20the%20latest%20software%20version.%20If%20you%20bought%20a%20new%20car%20yesterday%2C%26nbsp%3Bwouldn't%20you%20expect%20it%20to%20include%20features%20that%20were%20in%20the%20previous%20year's%20model%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20seems%20%3CSTRONG%3Emisleading%20and%20deceptive%3C%2FSTRONG%3E%20to%20exclude%20this%20from%20Excel%202019%20and%20to%20only%20include%20it%20in%20the%20365%20version%2C%20especially%20so%20when%20the%20feature%20became%20active%20in%20March%20(in%20365)%20and%20the%20Excel%202019%20was%20released%20many%20months%20later.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20does%20Microsoft%20say%3F%26nbsp%3B%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-321393%22%20slang%3D%22en-US%22%3ERe%3A%20Community%20Question%20-%20How%20have%20you%20been%20using%20the%20new%20Stocks%20and%20Geography%20Data%20Types%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-321393%22%20slang%3D%22en-US%22%3E%3CP%3EStock%20quotes%20is%20really%20good.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EI%20only%20wish%20there%20were%20more%20fields.%20The%20spreadsheet%20could%20get%20really%20useful%20if%20we%20could%20add%20more%20data%20from%20Morningstar%20such%20as%20short%20interest%2C%20fully%20diluted%20share%20count%2C%20float%2C%20free%20cash%20flow%2C%20ev%2Fdebt.%20debt%2Fequity%2C%20revenue%20and%20other%20valuation%20and%20ownership%20information.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20am%20aware%20the%20above%20data%20could%20be%20categorized%20monthly%2C%20quarterly%20or%20annually%20for%20different%20years%20so%20it%20may%20be%20cumbersome.%20But%20perhaps%20we%20could%20write%20our%20own%20syntax%20to%20retrieve%20the%20information%20we%20need%3F%3CBR%20%2F%3E%3CBR%20%2F%3EI%20tried%20%3DA2.%5Bshort%20interest%5D%20and%2C%20understandably%2C%20nothing%20came%20up.%20I%20guess%20a%20time%20period%20needs%20to%20be%20identified.%20Or%20something%20else%20is%20missing.%3CBR%20%2F%3E%3CBR%20%2F%3EIs%20there%20a%20way%20to%20make%20progress%20on%20this%3F%3CBR%20%2F%3EThank%20you%20for%20making%20this%20tool%20available.%3CBR%20%2F%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-321146%22%20slang%3D%22en-US%22%3ERe%3A%20Community%20Question%20-%20How%20have%20you%20been%20using%20the%20new%20Stocks%20and%20Geography%20Data%20Types%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-321146%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20James%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20taking%20time%20to%20be%20so%20helpful.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20to%20implement%20the%20macro%20to%20the%20best%20of%20my%20knowledge%2C%20but%20seems%20something%20is%20amiss.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20get%20this%20error..%3C%2FP%3E%3CP%3E*****%3C%2FP%3E%3CP%3ECannot%20run%20macro....%20The%20Macro%20may%20not%20be%20available%20in%20this%20workbook%20or%20all%20macros%20maybe%20disabled.%3C%2FP%3E%3CP%3E******%3C%2FP%3E%3CP%3EI%20modified%20the%20timer%20by%20a%20minute%20and%20I%20get%20this%20error%20after%20a%20minute%2C%20when%20it%20is%20trying%20to%20re%20run%20macro.%20After%20some%20search%20for%20solution%2C%20I%20tried%20the%20following%20but%20it%20the%20error%20persist.%3C%2FP%3E%3CP%3EI%20have%20enabled%20(%20Trust%20access%20to%20the%20VBA%20project%20model%20)%3CBR%20%2F%3EI%20have%20enabled%20(%20Enable%20all%20macros%20)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20any%20case%2C%20I%20am%20happy%20to%20know%20that%20Refresh%20will%20be%20automated%20in%20the%20near%20future.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%26nbsp%3B%3C%2FP%3E%3CP%3EUtpaal%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-320976%22%20slang%3D%22en-US%22%3ERe%3A%20Community%20Question%20-%20How%20have%20you%20been%20using%20the%20new%20Stocks%20and%20Geography%20Data%20Types%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-320976%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Utpaal%2C%3C%2FP%3E%0A%3CP%3EYou%20are%20not%20alone%20in%20wanting%20your%20stock%20data%20types%20to%20automatically%20refresh%20-%20we%20have%20heard%20the%20feedback%20from%20users%20like%20you%20and%20we're%20working%20on%26nbsp%3Bplans%20to%20support%20it%20now.%26nbsp%3B%20As%20you've%20noticed%2C%20the%20stock%20data%20types%20are%20not%20integrated%20with%20the%20query%20properties%20that%20you%20were%20trying%20to%20set%20-%20that%20feature%20is%20for%20queries%20like%20those%20to%20SQL%20Server%20databases%2C%20OLAP%20cubes%2C%20or%20Excel%20workbooks.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20refresh%20data%20types%20automatically%20using%20VBA%20today%20-%20the%20one%20line%20you%20need%20is%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3E%20%20%20%20%20%20%20%20ActiveWorkbook.RefreshAll%3C%2FPRE%3E%0A%3CP%3Ewhich%20can%20then%20be%20wrapped%20in%20a%20timer.%26nbsp%3B%20My%20full%20code%20is%20here%20-%20you%20can%20easily%20assign%20StartTimer%20and%20StopTimer%20to%20Excel%20shapes%20to%20create%20buttons.%3C%2FP%3E%0A%3CPRE%3EOption%20Explicit%0APrivate%20Declare%20Function%20GetSystemTimeAdjustment%20Lib%20%22kernel32%22%20(lpTimeAdjustment%20As%20Long%2C%20lpTimeIncrement%20As%20Long%2C%20lpTimeAdjustmentDisabled%20As%20Long)%20As%20Long%0A%0ADim%20TimerActive%20As%20Boolean%0ASub%20StartTimer()%0A%20%20%20%20Start_Timer%0AEnd%20Sub%0A%0ASub%20StopTimer()%0A%20%20%20%20Stop_Timer%0AEnd%20Sub%0A%0APrivate%20Sub%20Start_Timer()%0A%20%20%20%20TimerActive%20%3D%20True%0A%20%20%20%20Application.OnTime%20Now()%20%2B%20TimeValue(%2200%3A00%3A03%22)%2C%20%22Timer%22%0A%20%20%20%20Range(%22C3%22).Value%20%3D%20%22Auto-refresh%20enabled%22%0AEnd%20Sub%0A%0APrivate%20Sub%20Stop_Timer()%0A%20%20%20%20TimerActive%20%3D%20False%0A%20%20%20%20Range(%22C3%22).Value%20%3D%20%22Auto-refresh%20disabled%22%0AEnd%20Sub%0A%0APrivate%20Sub%20Timer()%0A%20%20%20%20If%20TimerActive%20Then%0A%20%20%20%20%20%20%20%20ActiveWorkbook.RefreshAll%0A%20%20%20%20%20%20%20%20Application.OnTime%20Now()%20%2B%20TimeValue(%2200%3A01%22)%2C%20%22Timer%22%0A%20%20%20%20End%20If%0AEnd%20Sub%0A%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-320908%22%20slang%3D%22en-US%22%3ERe%3A%20Community%20Question%20-%20How%20have%20you%20been%20using%20the%20new%20Stocks%20and%20Geography%20Data%20Types%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-320908%22%20slang%3D%22en-US%22%3EHope%20someone%20can%20share%20the%20macro%20code%20((%20write%20a%20macro%20for%20every%20N%20minutes%20to%20update%20it%20themselves.))%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-320867%22%20slang%3D%22en-US%22%3ERe%3A%20Community%20Question%20-%20How%20have%20you%20been%20using%20the%20new%20Stocks%20and%20Geography%20Data%20Types%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-320867%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20James%20%2C%20The%20stock%20prices%20are%20required%20to%20be%20refreshed%20manually%20and%20understand%20I%20can%20auto%20refresh%20thru%20connection%20properties%20and%20also%20able%20to%20select%20time%20interval.%20However%20%2C%20the%20properties%20in%20data%20is%20not%20active.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20read%20the%20following%20in%20Help%20..%3C%2FP%3E%3CP%3E((Refresh%20every%20n%20minutes%20Select%20this%20check%20box%20to%20enable%20automatic%20external%20data%20refresh%20at%20regular%3CBR%20%2F%3Etime%20intervals%2C%20and%20then%20enter%20the%20number%20of%20minutes%20between%20each%20refresh%20operation.%20Clear%20this%20check%3CBR%20%2F%3Ebox%20to%20disable%20automatic%20external%20data%20refresh.))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%20%2C%20the%20properties%20link%20is%20inactive.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20437px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F69023i380C19DE37660174%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22data%20properties%20Excel.png%22%20title%3D%22data%20properties%20Excel.png%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EAutoRefresh%20issue%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-290153%22%20slang%3D%22en-US%22%3ERe%3A%20Community%20Question%20-%20How%20have%20you%20been%20using%20the%20new%20Stocks%20and%20Geography%20Data%20Types%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-290153%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20James%3CBR%20%2F%3E%3CBR%20%2F%3ENo%20worries%20about%20the%20data%2C%20I%20like%20that%20it%20has%20a%20good%20coverage%20already.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegarding%20the%20table%20headers%2C%20it%20was%20not%20copied%20over%20from%20a%20cell%20that%20previously%20had%20a%20Data%20Type.%3CBR%20%2F%3EI%20also%20cannot%20convert%20the%20cells%20back%20-%20right%20clicking%20on%20the%20cell%20does%20not%20show%20a%20'Data%20Type'%20or%20'Convert%20To%20Text'%20option.%20The%20only%20options%20I%20see%20are%20the%20same%20as%20a%20normal%20cell.%20The%20table%20is%20in%20a%20separate%20worksheet%20from%20that%20of%20the%20ones%20I%20use%20to%20test%20the%20Data%20Types%2C%20so%20it%20did%20seem%20to%20appear%20out%20of%20nowhere.%3CBR%20%2F%3E%3CBR%20%2F%3EOther%20than%20unable%20to%20hide%20the%20customization%2C%20is%20there%20a%20way%20to%20turn%20it%20off%20for%20the%20time%20being%3F%3CBR%20%2F%3EThe%20computation%20seems%20to%20occur%20when%20the%20Data%20Types%20seem%20to%20query%20Knowledge%20Graph%2FBing%20for%20the%20probabilistic%20result%20(i.e.%2C%20Strike%20becoming%20Strike%20Energy%2C%20msft%20becoming%20Microsoft).%20I%20am%20also%20using%26nbsp%3BLast%20Traded%20Time%20and%20Last%20Close%20fields.%3CBR%20%2F%3E%3CBR%20%2F%3EAdditionally%2C%20we%20do%20have%20Bloomberg%20fields%20getting%20data%20feed%20in%20other%20sheets.%20No%20volatile%20functions%20are%20being%20used%2C%20with%20exception%20of%20one%20Cell%20function%20to%20retrieve%20the%20filepath.%3CBR%20%2F%3E%3CBR%20%2F%3EOn%20save%2C%26nbsp%3Bthe%20Excel%20does%20do%20a%20%22Refresh%20All%22.%20With%20bloomberg%20on%20at%20the%20same%20time%2C%20the%20%22Calculating..%20x%25%22%20on%20the%20bottom%20right%20shows%20-%20it%20previously%20did%20not%20do%20that.%20Perhaps%20a%20way%20to%20toggle%20auto-refresh%20for%20some%20of%20the%20data%20feeds%3F%3CBR%20%2F%3E%3CBR%20%2F%3EI%20think%20one%20or%20some%20of%20the%20users%20have%20suggested%20refreshing%20in%20N%20intervals%2C%20but%20I%20would%20guess%20that%20would%20be%20a%20big%20workaround%20on%20the%20queuing%2Fscheduling%20for%20data%20feeds.%20Better%20if%20users%20can%20have%20a%20toggle%2C%20then%20write%20a%20macro%20for%20every%20N%20minutes%20to%20update%20it%20themselves.%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20high%20computation%20only%20happened%20once%20Data%20Types%20were%20introduced%20-%20I%20also%20checked%20with%20other%20colleagues%20which%20had%20the%20feature%20pushed%20(without%20Bloomberg)%20that%20their%20worksheets%20were%20taking%20some%20time%20to%20compute%20as%20well.%20Thus%20until%20then%2C%26nbsp%3B%20should%20we%20encounter%20any%20issues%20(e.g.%20not%20sure%20if%20its%20a%20Data%20Type%20or%20bloomberg%20or%20other%20data%20source%20affecting%20it)%2C%20we%20can%20do%20some%20A%2FB%20testing%20to%20identify%20which%20one%20is%20causing%20it%20correctly.%3CBR%20%2F%3E%3CBR%20%2F%3ECheers%3CBR%20%2F%3EThomas%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-290114%22%20slang%3D%22en-US%22%3ERe%3A%20Community%20Question%20-%20How%20have%20you%20been%20using%20the%20new%20Stocks%20and%20Geography%20Data%20Types%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-290114%22%20slang%3D%22en-US%22%3E%3CP%3EIt's%20correct%20that%20we%20have%20data%20for%20US%2C%20Hong%20Kong%2C%20and%20Vietnam%20stock%20exchanges%2C%20but%20not%20Thailand%20or%20Malaysia.%26nbsp%3B%20You%20can%20see%20our%20full%20list%20of%20supported%20exchanges%20%3CA%20title%3D%22About%20our%20Data%20sources%22%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fabout-our-data-sources-98a03e23-37f6-4776-beea-c5a6c8e787e6%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehere%3C%2FA%3E.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ERegarding%20table%20headers%20being%20converted%2C%20we%20do%20not%20allow%20Data%20types%20to%20exist%20in%20the%20headers%20of%20Ctrl%2BT%20Tables%2C%20but%20it%20looks%20like%20in%20your%20example%20they%20may%20exist%20in%20the%20cell%20that%20holds%20an%20autofilter%26nbsp%3Bfor%20the%20column%20below%20it.%26nbsp%3B%20If%20you%20would%20like%20to%20convert%20these%20cells%20back%20to%20text%2C%20you%20can%20right%20click%26nbsp%3B%26gt%3B%20Data%20types%20%26gt%3B%20Convert%20to%20Text.%26nbsp%3B%20Data%20types%20shouldn't%20%22appear%20out%20of%20nowhere%22%2C%20but%20if%20you%20copy%20a%20cell%20containing%20a%20data%20type%20and%20then%20type%20over%20it%2C%20we%20will%20try%20to%20convert%20the%20text.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELastly%20regarding%20the%20ribbon%20customization%2C%20I%20was%20able%20to%20reproduce%20this%20issue%20and%20have%20opened%20a%20bug.%26nbsp%3B%20Thanks%20for%20the%20report!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECan%20you%20share%20any%20more%20details%20on%20what%20you%20mean%20by%20%22add%20a%20lot%20more%20computations%2Frefreshes%22%3F%26nbsp%3B%20The%20formulas%20that%20reference%20data%20types%20should%20be%20very%20fast%20since%20the%20data%20is%20already%20in%20your%20workbook%2C%20and%20a%20refresh%20will%20only%20occur%20when%20the%20user%20chooses%20Refresh%20All%20on%20the%20Data%20tab.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks%20again%20for%20the%20feedback%2C%3C%2FP%3E%0A%3CP%3EJames%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-289632%22%20slang%3D%22en-US%22%3ERe%3A%20Community%20Question%20-%20How%20have%20you%20been%20using%20the%20new%20Stocks%20and%20Geography%20Data%20Types%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-289632%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%20I%20recently%20saw%20a%20new%20region%20of%20buttons%20in%20'Data'%20one%20day%20and%20gave%20it%20a%20try.%3C%2FP%3E%3CP%3E%3CU%3E%3CSTRONG%3E%3CBR%20%2F%3EGood%3C%2FSTRONG%3E%3C%2FU%3E%3C%2FP%3E%3CP%3EStock%20data%20seems%20fine%2C%20since%20we%20mostly%20use%20US%20and%20HK%20stocks%2C%20but%20does%20not%20seem%20to%20cover%20exchanges%20such%20as%20Thailand%20(e.g.%20thai%20oil)%20or%20Malaysia%20(e.g.%20berhad).%20Vietnam%20companies%20appear%20however.%3CBR%20%2F%3E%3CBR%20%2F%3EGeography%3A%20Useful%20to%20get%20macro%20data%20easily%2C%20but%20I%20dont%20know%20why%20obtaining%20a%20national%20anthem%20would%20be%20useful%2C%20but%20who%20knows.%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3CBR%20%2F%3E%3CU%3ENot%20so%20good%3C%2FU%3E%3C%2FSTRONG%3E%3CBR%20%2F%3EThe%20normal%20functions%20of%20getting%20data%20is%20fine%2C%20but%20it%20seems%20to%20add%20a%20lot%20more%20computation%2Frefreshes.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAdditionally%2C%20some%20of%20our%20table%20headers%20are%20getting%20converted%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F60403iF697F307E9228861%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22Table%20headers%20changing.PNG%22%20title%3D%22Table%20headers%20changing.PNG%22%20%2F%3E%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3EThis%20is%20a%20table%20of%20Trades%20for%20portfolio.%20%22Strike%22%20becomes%20a%20Data%20Type%2C%20and%20automatically%20becomes%20some%20company's%20name%20%22Strike%20Energy%22.%3CBR%20%2F%3E%3CBR%20%2F%3ETime%20becomes%20a%20name%20of%20an%20ETF.%20I%20did%20not%20put%20a%20Data%20Type%20in%20this%20worksheet%20at%20all%2C%20but%20it%20appear%20out%20of%20nowhere.%3CBR%20%2F%3E%3CBR%20%2F%3EAnyone%20facing%20the%20same%20issue%3F%20I%20like%20it%2C%20but%20I%20want%20to%20switch%20this%20off%20until%20it%20is%20fully%20stable%20-%20the%20Custom%20Ribbons%20tab%20in%20Options%20does%20not%20give%20me%20the%20option%20to.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%20to%20anyone%20who%20knows%20how%20to%20prevent%20this.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-252978%22%20slang%3D%22en-US%22%3ERe%3A%20Community%20Question%20-%20How%20have%20you%20been%20using%20the%20new%20Stocks%20and%20Geography%20Data%20Types%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-252978%22%20slang%3D%22en-US%22%3E%3CDIV%3EHello%20James%20Spotanski%2C%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3EI%20have%20been%20using%20excel%20for%20stock%20analysis%20since%20many%20years.%20Unfortunately%20I%20use%20i3%20Intel%20processor%20and%20required%20to%20open%2025%20excel%20files%20simultaneously%20and%20use%20macros%20to%20update%20EOD%20data%20of%20individual%20file%20from%20an%20excel%20dashboard%20file%20and%20return%20the%20updated%20results%20back%20to%20the%20dashboard%20file.%20This%20process%20is%20smooth%20in%20office%202007%2C%20but%20did%20not%20work%20well%20with%20office%20365.%20I%20need%20a%20better%20processor.%20So%20for%20temporarily%20%2C%20I%20have%20exited%20using%20office%20365.%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3EI%20have%20been%20using%20google%20spreadsheet%20for%20live%20trading%20decisions%2C%20but%20recently%20found%20issue%20with%20stock%20price%20updations.%20For%20sometime%20that%20I%20used%20office%20365%2C%20I%20found%20the%20Stock%20data%20types%20very%20useful.%20I%20think%2C%20the%20user%20should%20have%20an%20option%20to%20update%20prices%20at%20a%20certain%20interval%20and%20the%20refresh%20needs%20to%20be%20automatic.%20There%20should%20be%20a%20selection%20for%20data%20updation%20interval%20like%202%20min%2C%205%20min%2C%20real%20time%20and%20so%20on...I%20would%20combine%20my%20analysis%20with%20latest%20stock%20prices%20and%20accordingly%20trade%20with%20help%20of%20excel.%20I%20can%20only%20speak%20for%20stock%20feature%20and%20cannot%20comment%20on%20other%20data%20type.%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3EThanks%3C%2FDIV%3E%3CDIV%3EUtpaal%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-236851%22%20slang%3D%22en-US%22%3ERe%3A%20Community%20Question%20-%20How%20have%20you%20been%20using%20the%20new%20Stocks%20and%20Geography%20Data%20Types%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-236851%22%20slang%3D%22en-US%22%3E%3CP%3EThanks.%20I%20understand%20now%20why%20it%20was%20not%20showing%20unless%20I%20am%20on%20the%20Insiders%20channel.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20has%20been%202%20months%20since%20the%20post%20here%20-%20%26gt%3B%20which%20is%20why%20I%20thought%20it%20was%20ready%20now.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FStock-quotes-and-geographic-data-61a33056-9935-484f-8ac8-f1a89e210877%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FStock-quotes-and-geographic-data-61a33056-9935-484f-8ac8-f1a89e210877%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethis%20says...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%22%3CSTRONG%3ENote%3A%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3BJune%2012%2C%202018%3A%20This%20feature%20is%20being%20made%20available%20to%20customers%20on%20a%20gradual%20basis%20over%20several%20%3CSTRONG%3Edays%20or%20weeks%3C%2FSTRONG%3E.%20It%20will%20first%20be%20available%20to%20%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fproducts.office.com%2Foffice-insider%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EOffice%20Insider%3C%2FA%3E%3CSPAN%3E%20participants%2C%20and%20later%20to%20%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fproducts.office.com%2Fbuy%2Fcompare-microsoft-office-products%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EOffice%20365%3C%2FA%3E%3CSPAN%3E%20subscribers.%20If%20you%20are%20an%20Office%20365%20subscriber%2C%20%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fhow-do-i-upgrade-to-office-2016-ee68f6cf-422f-464a-82ec-385f65391350%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Emake%20sure%20you%20have%20the%20latest%20version%20of%20Office%3C%2FA%3E%3CSPAN%3E.%22%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-236357%22%20slang%3D%22en-US%22%3ERe%3A%20Community%20Question%20-%20How%20have%20you%20been%20using%20the%20new%20Stocks%20and%20Geography%20Data%20Types%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-236357%22%20slang%3D%22en-US%22%3EWhen%20will%20the%20Stocks%20and%20Geography%20Data%20be%20available%20to%20the%20general%20Office%20365%20users%3F%20I%20am%20using%20for%20the%20past%20year%20Google%20sheets%20and%20their%20functionality%20is%20simply%20superb.%20If%20you%20at%20Microsoft%20want%20to%20maintain%20your%20clients%2C%20you%20better%20move%20faster.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-236349%22%20slang%3D%22en-US%22%3ERe%3A%20Community%20Question%20-%20How%20have%20you%20been%20using%20the%20new%20Stocks%20and%20Geography%20Data%20Types%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-236349%22%20slang%3D%22en-US%22%3EHi%20Utpaal%2C%3CBR%20%2F%3EYou%20are%20correct%20that%20you%20are%20only%20able%20to%20update%20the%20values%20manually%20via%20Data%20%26gt%3B%20Refersh%20at%20this%20time.%20However%20you%20can%20write%20a%20macro%20to%20refresh%20automatically%20using%20the%20existing%20RefreshAll%20command.%20%20%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20we%20were%20to%20add%20an%20ability%20to%20refresh%20automatically%20in%20the%20future%2C%20can%20you%20share%20how%20you%20would%20like%20it%20to%20work%3F%20Some%20things%20to%20consider%20would%20be%20the%20interval%20at%20which%20we%20refresh%20and%20how%20you%20would%20like%20to%20switch%20back%20to%20manual%20refresh%2C%20and%20whether%20that%20needs%20to%20apply%20to%20everything%20or%20just%20some%20stocks.%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%20for%20your%20feedback!%3CBR%20%2F%3EJames%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-236347%22%20slang%3D%22en-US%22%3ERe%3A%20Community%20Question%20-%20How%20have%20you%20been%20using%20the%20new%20Stocks%20and%20Geography%20Data%20Types%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-236347%22%20slang%3D%22en-US%22%3EHi%20Sanjay%2C%3CBR%20%2F%3EThe%20feature%20is%20still%20only%20available%20to%20Office%20Insiders%20at%20this%20time.%20100%25%20of%20Insiders%20Fast%20should%20see%20the%20feature%2C%20while%20we%20are%20still%20only%20enabled%20for%2050%25%20of%20Insiders%20Slow%20(aka%20Monthly%20Channel%20-%20Targeted)%20right%20now.%20%20More%20information%20on%20the%20Insiders%20program%20can%20be%20found%20at%20%3CA%20href%3D%22http%3A%2F%2Faka.ms%2Fofficeinsider%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Faka.ms%2Fofficeinsider%3C%2FA%3E.%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20you%20have%20previously%20used%20the%20feature%20as%20an%20Insider%20and%20are%20unable%20to%20see%20it%20on%20your%20new%20computer%2C%20I%20recommend%20verifying%20that%20you%20have%20signed%20in%20with%20the%20same%20account%20that%20you%20registered%20for%20Office%20Insiders.%20If%20you%20want%20to%20guarantee%20the%20feature%20appears%2C%20you%20will%20need%20to%20join%20Insiders%20Fast%20due%20to%20the%20100%25%20availability%20there%20that%20I%20mentioned%20above.%3CBR%20%2F%3E%3CBR%20%2F%3EThanks!%3CBR%20%2F%3EJames%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-236345%22%20slang%3D%22en-US%22%3ERe%3A%20Community%20Question%20-%20How%20have%20you%20been%20using%20the%20new%20Stocks%20and%20Geography%20Data%20Types%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-236345%22%20slang%3D%22en-US%22%3EHi%20Ofer%2C%3CBR%20%2F%3EIt%20sounds%20like%20you%20might%20be%20referring%20to%20the%20Stock%20Connector%20Add-in%20available%20from%20the%20Office%20Store.%20That%20is%20an%20add-in%20created%20by%20a%20third%20party%20developer%2C%20where%20this%20is%20native%20functionality%20that%20will%20soon%20appear%20by%20default%20for%20all%20Office%20365%20subscribers.%20If%20you%20see%20buttons%20for%20%E2%80%9CStocks%E2%80%9D%20and%20%E2%80%9CGeography%E2%80%9D%20in%20the%20Data%20tab%20of%20your%20ribbon%2C%20then%20that%20is%20this%20feature.%20%3CBR%20%2F%3E%3CBR%20%2F%3EHope%20this%20helps!%3CBR%20%2F%3EJames%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-235697%22%20slang%3D%22en-US%22%3ERe%3A%20Community%20Question%20-%20How%20have%20you%20been%20using%20the%20new%20Stocks%20and%20Geography%20Data%20Types%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-235697%22%20slang%3D%22en-US%22%3E%3CP%3EI%20love%20it%20-%20set%20it%20up%20for%20keeping%20on%20top%20of%20my%20Stock%20Portfolio%20(%20the%20timing%20was%20perfect%2C%20as%20previously%20was%20getting%20data%20from%20Yahoo%20via%20WebService%20function%20but%20they%20turned%20off%20access).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ehowever%2C%20just%20installed%20my%20Office%20365%20Home%20on%20new%20Surface%20and%20the%20DATA%20TYPES%20are%20not%20there...%20not%20sure%20when%20they%20will%20appear%20or%20how%20I%20can%20force%20it...%20I%20clicked%20on%20File%20-%20%26gt%3B%20Account%20-%20%26gt%3B%20Update%20Options%20-%20%26gt%3B%20Update%20Now%20and%20it%20says%20I%20am%20up%20to%20date%20but%20NO%20DATA%20TYPES%20%3CLI-EMOJI%20id%3D%22lia_disappointed-face%22%20title%3D%22%3Adisappointed_face%3A%22%3E%3C%2FLI-EMOJI%3E%26nbsp%3B%20(Also%20Stock%2FGeo)%20is%20not%20there%20if%20I%20try%20going%20into%20Customise%20Ribbon.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ehow%20can%20I%20get%20them%20back%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-225761%22%20slang%3D%22en-US%22%3ERe%3A%20Community%20Question%20-%20How%20have%20you%20been%20using%20the%20new%20Stocks%20and%20Geography%20Data%20Types%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-225761%22%20slang%3D%22en-US%22%3E%3CP%3EExcel%20has%20been%20a%20fabulous%20tool%20for%20stock%20analysis%20and%20I%20really%20appreciate%20the%20Data%26gt%3BStock%20feature.%20I%20am%20just%20new%20and%20exploring.%20The%20properties%20for%20auto%20updating%20stock%20information%20is%20not%20active.%20I%20have%20to%20manually%20refresh%20the%20data%20connection.%20Maybe%20I%20am%20missing%20something%20%2C%20kindly%20guide%20me.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-219484%22%20slang%3D%22en-US%22%3ERe%3A%20Community%20Question%20-%20How%20have%20you%20been%20using%20the%20new%20Stocks%20and%20Geography%20Data%20Types%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-219484%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20tried%20using%20this%20feature.%20I%20have%20found%20it%20to%20be%20useless%20-%20the%20linkage%20between%20the%20stocks%20and%20the%20relevant%20spreadsheet%20cell%20is%20not%20fixed%2C%20and%20when%20one%20needs%20to%20move%2C%20add%20to%20delete%20data%20the%20whole%20spreadseet%20gets%20messy%20and%20inaccurate.%3C%2FP%3E%3CP%3EAdditionally%2C%20as%20long%20as%20there%20will%20not%20be%20an%20easy%20way%20to%20add%20multiple%20stock%20(as%20a%20list)%20building%20a%20portfolio%20of%20several%20hundreds%20of%20shares%20is%20very%20difficult.%3C%2FP%3E%3CP%3EThere%20was%20no%20link%20to%20other%20stock%20exchanges%20-%20Europe%2C%20London%2C%20Swiss%2C%20Tel%20Aviv%2C%20etc.%3C%2FP%3E%3CP%3EGenerally%20speaking%2C%20the%20Google%20spreadsheet%20solution%20(%3Dgooglefinance(....))%20is%20by%20far%20better.%3C%2FP%3E%3CP%3EI%20have%20removed%20the%20add-on%20from%20my%20system.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-218876%22%20slang%3D%22en-US%22%3ERe%3A%20Community%20Question%20-%20How%20have%20you%20been%20using%20the%20new%20Stocks%20and%20Geography%20Data%20Types%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-218876%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20non-insider%20Office%20365%20subscriber%2C%20so%20I%20didn't%20see%20it%20so%20far!%3C%2FP%3E%3CP%3EI'm%20looking%20forward%20to%20using%20these%20new%20datatypes!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-218476%22%20slang%3D%22en-US%22%3ERe%3A%20Community%20Question%20-%20How%20have%20you%20been%20using%20the%20new%20Stocks%20and%20Geography%20Data%20Types%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-218476%22%20slang%3D%22en-US%22%3E%3CP%3EBlake%2C%20when%20it%20appears%20back%20on%20my%20Insider%20Slow%20I'll%20give%20the%20feedback.%20I'm%20interesting%20mainly%20in%20Geography%20data%20types.%20First%20impression%20it%20works%20fine%20mainly%20for%20USA.%20I%20guess%20you%20are%20interesting%20more%20in%20scenarios%20-%20intention%20was%20to%20involve%20the%20new%20data%20types%20into%20market%20share%20stats.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-740849%22%20slang%3D%22en-US%22%3ERe%3A%20Community%20Question%20-%20How%20have%20you%20been%20using%20the%20new%20Stocks%20and%20Geography%20Data%20Types%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-740849%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F372002%22%20target%3D%22_blank%22%3E%40Centurion007%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIMHO%2C%20the%20only%20politics%20these%20days%20is%20to%20push%20users%20to%20use%20cloud%20infrastructure.%20Doesn't%20matter%20which%20on%20which%20client%20they%20are%20-%20Excel%20Windows%20Desktop%2C%20MacOS%2C%20Android%20or%20browser.%20In%20particular%2C%20new%20data%20types%20are%20available%20for%20Mac%20if%20you%20are%20Office365%20subscriber%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20800px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F122421iB8C895DF5C02EE7F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fexcel-data-types-stocks-and-geography-61a33056-9935-484f-8ac8-f1a89e210877%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fexcel-data-types-stocks-and-geography-61a33056-9935-484f-8ac8-f1a89e210877%3C%2FA%3E%3C%2FP%3E%0A%3CP%3EBy%20the%20way%2C%20same%20for%20Windows.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-831095%22%20slang%3D%22en-US%22%3ERe%3A%20Community%20Question%20-%20How%20have%20you%20been%20using%20the%20new%20Stocks%20and%20Geography%20Data%20Types%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-831095%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F3321%22%20target%3D%22_blank%22%3E%40Blake%20T%20Walsh%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20pretty%20pleased%20with%20this%20service.%20Data%20is%20reliable%20except%20for%20some%20funds%20in%20Europe%20where%20the%20price%20is%20lagging%20two%20days%20behind.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20Cannot%20find%20the%20right%20wording%20or%20ticker%20for%20the%20Euronext%20stockexchange%20indices%20like%20AEX%20Amsterdam%20XAMS%2C%20CAC40%20Paris%20XPAR%2C%20or%26nbsp%3B%20BEL20%20Brussels%20XBRU.%20I%20tried%20over%20a%20hunderd%20times%20but%20nothing%20seems%20to%20work.%20Any%20Idea%3F%3F%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Microsoft

How have you been using the new Stocks and Geography data types in Excel? Since the new Stocks and Geography data types in Excel have been available to Insiders for a little while now, we want to hear from you! How have you been using them so far? 

 

The dot operator and autocomplete are how you use fields in a formula

 

Leave a comment here with your favorite examples and samples, if you'd like to share.

 

Thanks!

27 Replies
Highlighted

From what I see, this Stocks feature became available around March 2018. 

Office 2019 came out around October 2018, correct? 

 

Why is this feature absent from Office 2019 which I recently purchased? Consumers expect the latest features to be in the latest software version. If you bought a new car yesterday, wouldn't you expect it to include features that were in the previous year's model?

 

It seems misleading and deceptive to exclude this from Excel 2019 and to only include it in the 365 version, especially so when the feature became active in March (in 365) and the Excel 2019 was released many months later. 

 

What does Microsoft say? 

 

 

Highlighted

Hey TampaTrader, So sorry for the frustration you are feeling with your new Office 2019.
Unfortunately, features like Ideas and new data types are services-backed features that will only be available for Office 365, commercial users and consumers. Those features are not going to be available in Office 2019, or any other  "Office [Year]" versions of Office.

However, soon you will have access to Stocks data types in Excel Online which will be available to anyone who is signed in at office.com. 

Highlighted

Thank you for responding. Just to clarify, since you mentioned "commercial users" does MS Office Professional 2016 include this feature? 

 

Does Excel online integrate at all with Excel 2019? When might online version have the stocks feature?

 

It seems as if I wasted money purchasing Office 2019. 

 

Thank you.

Highlighted

Hey TampaTrader, 

To further clarify, no MS Office Professional 2016 does not include Data Types. We have commercial and consumer versions of Office 365 that include this feature, but the consumer or commercial "perpetual" licensed versions "Office [year]" will not have them. 

You might have access to Data Types in Excel online now https://www.office.com/launch/excel sign in, and open a new workbook then go to the Data Tab. If you see Data Types you are good to go. If you don't see it yet, my apologies. On the web with big features we roll out to a percentage at a time to make sure everything is working. Right now we are only at 10% of our online customers. The percentage will increase and we hope to be at 100% in a couple months. Sorry for the inconvenience. 

I work on the product team, but am passing along your last feedback about 2019 to the appropriate parties. Hopefully we can make this less confusing in the future. 

Highlighted

Hey @TampaTrader

I understand this isn't an ideal option, but I found out that:

  • Items, including packaged software, purchased directly from Microsoft Store on the web, on Xbox, on Windows or retail fall under the One Microsoft Refund policy and can be returned.

Again, sorry for the confusion when purchasing Office, we are hoping to address this issue in the future.

Highlighted

@Blake T Walsh 

I am a longtime MSFT office user on Windows and about ten years ago switched to the Apple Mac platform. I use Bloomberg professionally but wanted to have a portable copy of my portfolio that I could use away from my Bloomberg terminal. I was very excited to hear that real-time global securities pricing was added to Excel. But then I was shocked to discover that this functionality was only available on the Windows version of excel not the MAC version. There is absolutely no technical reason why this should be so, so I must assume that the reason is political - to deprive functionality to MAC users in order to drive them toward adopting Windows instead. Is any of this true and is there a work-round to getting real-time securities pricing in excel on the MAC or do I need to drop excel all together? Thanks in advance for responding if you can...   

Highlighted

@Centurion007 

IMHO, the only politics these days is to push users to use cloud infrastructure. Doesn't matter which on which client they are - Excel Windows Desktop, MacOS, Android or browser. In particular, new data types are available for Mac if you are Office365 subscriber

image.png

https://support.office.com/en-us/article/excel-data-types-stocks-and-geography-61a33056-9935-484f-8a...

By the way, same for Windows.

Highlighted

@Blake T Walsh 

 

I am pretty pleased with this service. Data is reliable except for some funds in Europe where the price is lagging two days behind. 

 

I Cannot find the right wording or ticker for the Euronext stockexchange indices like AEX Amsterdam XAMS, CAC40 Paris XPAR, or  BEL20 Brussels XBRU. I tried over a hunderd times but nothing seems to work. Any Idea???