I saw on twitter that Office365 now includes share data (and, yes, also for UK shares)
https://support.office.com/en-us/articl ... 3cf07fbc54
Should make portfolio sheets easier.
Stocks datatype in excel
-
- Lemon Quarter
- Posts: 1127
- Joined: November 4th, 2016, 9:05 pm
-
- 2 Lemon pips
- Posts: 199
- Joined: December 31st, 2016, 3:52 pm
Re: Stocks datatype in excel
I had a little play with that, but quite a few of my UK holdings did not come up with a match, and elsewhere I was not happy with some of the resulting quoted prices. But an interesting development all the same.
Ozyu
Ozyu
-
- Lemon Pip
- Posts: 54
- Joined: November 11th, 2016, 7:25 pm
Re: Stocks datatype in excel
Yes, lots of potential, but if you subscribe to the free Office Watch newsletter, you will see the many examples where it delivers rather less than it promises. This is the 'How To' link: https://office-watch.com/2018/getting-s ... data-type/
And this is the 'How to report problems to Microsoft' link: https://office-watch.com/2018/excel-365 ... -problems/
Gerard
And this is the 'How to report problems to Microsoft' link: https://office-watch.com/2018/excel-365 ... -problems/
Gerard