Forum Discussion
Blake T Walsh
Jul 24, 2018Former Employee
Community Question - How have you been using the new Stocks and Geography Data Types?
How have you been using the new http://aka.ms/stockgeoXL 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 ...
Ofer Pillar
Jul 27, 2018Copper Contributor
I have tried using this feature. I have found it to be useless - the linkage between the stocks and the relevant spreadsheet cell is not fixed, and when one needs to move, add to delete data the whole spreadseet gets messy and inaccurate.
Additionally, as long as there will not be an easy way to add multiple stock (as a list) building a portfolio of several hundreds of shares is very difficult.
There was no link to other stock exchanges - Europe, London, Swiss, Tel Aviv, etc.
Generally speaking, the Google spreadsheet solution (=googlefinance(....)) is by far better.
I have removed the add-on from my system.
James Spotanski
Aug 23, 2018Former Employee
Hi Ofer,
It sounds like you might be referring to the Stock Connector Add-in available from the Office Store. That is an add-in created by a third party developer, where this is native functionality that will soon appear by default for all Office 365 subscribers. If you see buttons for “Stocks” and “Geography” in the Data tab of your ribbon, then that is this feature.
Hope this helps!
James
It sounds like you might be referring to the Stock Connector Add-in available from the Office Store. That is an add-in created by a third party developer, where this is native functionality that will soon appear by default for all Office 365 subscribers. If you see buttons for “Stocks” and “Geography” in the Data tab of your ribbon, then that is this feature.
Hope this helps!
James
- Pillar PillarAug 23, 2018Copper ContributorWhen will the Stocks and Geography Data be available to the general Office 365 users? I am using for the past year Google sheets and their functionality is simply superb. If you at Microsoft want to maintain your clients, you better move faster.