The Excel Stock data type lets you track the largest companies market capitalization in real-time. It’s strangely compelling to watch the market caps change by billions in the blink of an eye. Excel 365’s Stock data type has the essential information to calculate market capitalization with changing values in real-time. Stock data type has fields […]
When the Stock and Geography data types disappear from the Data ribbon in Excel here’s how to fix and restore Linked Data Types. The Data ribbon is missing the entire ‘Data Types’ section. We’ve had several reports from Office-Watch.com readers who start Excel 365 and find that their Stock and Geography linked data worksheets won’t […]
Microsoft’s PR department must be laughing themselves silly this week. A press release for an existing Excel feature is getting wide coverage even though there’s nothing new and the feature is at least six months old. The blog posting on 5 June 2019 announces Microsoft is working with “Nasdaq and Refinitiv to pull current financial […]
Finding the right stock or index among the tens of thousands available in Excel’s Stock data type isn’t always easy. Here’s some stock search tips that might help with some advice about a changing situation. Stock data type is available in Excel 365 for Windows and coming to Excel 365 for Mac (currently only Insiders). […]
Our article Track the largest companies Market Caps in real time got a lot more interest than we expected. Maybe because Apple and Microsoft are so close in value at the moment. So we’ve made the worksheet available for Real Time Excel readers. Market Capitalizations.xlsx also includes an example of the upcoming function Sortby() which automatically re-sorts a […]