Recent DiscussionsMost RecentNewest TopicsMost LikesSolutionsTagged:TagRe: Excel and the NYSEYou're not missing anything. We currently have an extremely inconvenient bug for all Stocks that have IPOed with SPAC. UWMC is one example of such an instrument. We have all the data, but the 'search' is failing. The work-around is to lookup the stock by its "old" ticker. In this case GHIV. Converting GHIV to a stock, will give you UWM Holdings Corp, and all the current data. Let me know if this isn't working for you.Re: Stockhistory Mutual Fund Performance AccuracyI'm asking around internally to see what's up. That number 15.03% matches what I'm seeing Google, and Bing report from Refinitiv. But like you I see different numbers from other sources, and doing my own calculation it should be closer to like 20%? I'm not an expert, but I'm looking into if this is a data discrepancy.Re: Community Question - How have you been using the new Stocks and Geography Data Types? 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. Re: Community Question - How have you been using the new Stocks and Geography Data Types? 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. Re: Community Question - How have you been using the new Stocks and Geography Data Types? 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.
Recent Blog ArticlesNewest TopicsMost LikesTagged:TagColor, Conditions, and Copilot: How to save time using conditional formatting with Copilot in Excel Learn how to save time using conditional formatting with Copilot in Excel. Additional Language Support for Stocks and Geography Data Types French, German, Italian, Portuguese, and Spanish language data types are now supported for Stocks and Geography! Announcing STOCKHISTORY Now you can analyze historical finance data for stocks, funds, bonds, and currency pairs in Excel by using the new built-in service-backed STOCKHISTORY function!
MicrosoftMicrosoftMicrosoftMicrosoft
