Does anybody know how to use Excel's data selector search in such a way that it will actually find funds?
I've found the stock data type potentially useful but hampered by the fact Excel fails to find many investments - particularly funds. With at least a 20-50% failure rate, it makes it effectively useless to build any kind of portfolio tracking spreadsheet
(Of the 40 or so funds I've tried to find, it failed to find 23)
Trial and error with keywords from the name sometimes brings success, but it's not obvious [to me] what search rules / logic there is that helps return any results (let alone the correct one).
For example it fails to find a fund called:
"Fidelity Global Special Situations Fund W-Accumulation".
If I look at the fund's homepage, I see a slightly abbreviated title:
"Fidelity Global Special Situations Fund W Acc", but typing that into the data selector search, fails to find a match.
I notice it says 'powered' by Bing, so I try Bing, which finds it as the 2nd hit:
...So why can't Excel?
So I shorten the title to "Fidelity Global Special Situations", and data selector search lists it as the 3rd hit, but when I select it, it fills in the name as
"Fidelity Global Special Situations W Acc" - which it failed to find when I typed it as exactly that!
So I try to find another fund that Excel can't find by it's full name called:
"Fidelity Funds - Sustainable Health Care Fund W-Acc-GBP"
Using the same approach, I try:
"Fidelity Funds - Sustainable Health Care Fund"
"Fidelity Funds - Sustainable Health Care"
"Fidelity Sustainable Health Care"
"Fidelity Sustainable Health"
Excel's data selector search returns nothing for each.
So I tried the Fund Code: WGHFA; SEDOL: BJVDYK8; ISIN: LU1033663300 - 3 supposedly definitive ways to identify the fund that in theory should mean you don't need to try to guess what - if any - abbreviation any 3rd party database has used instead of the full fund name.
It turns out Excel's data selector search doesn't recognise any form of code (WTH!)
So I go back to the original fund search results and notice when it found the first fund, this time it said Powered by Refinitiv
So my understanding is that the Microsoft is using a database from a 3rd party Refinitiv (actually now LSEG Data & Analytics), but I'm not sure whether it is Excel / Bing or some third party software which tries to match the name with a data set provided by Refinitiv/LSEG.
I went to the LSEG website thinking they might have a stocks/funds search tool that I could use to find the fund, for example using the SEDOL / ISIN / Fund code. Nope.
So I raised a support request with LSEG, asking how we are supposed to guess what they provide Microsoft with as the names it recognises as a fund name or whether there is any kind of rule they apply for abbreviation. The response was "I am afraid that Refinitiv helpdesk does not support this. You may reach out to the Microsoft/Excel Support for assistance."
It seems the only support Microsoft provides is a page describing the feature.
Does anybody know how to use Excel's data selector search in such a way that it will actually find funds?
For reference, these are the latest 23 that I failed to find:
Pictet - Global Envir Opps I dy GBP (FUND:B4YWL06)
RobecoSAM Smart Energy Eqs G GBP (FUND:BMF7CH0)
Sanlam Glb Artfcll Intlgc I GBP Bs Acc (FUND:BNYN9Q4)
XBT Provider Bitcoin Tracker One ETN (OSTO:BITCOIN XBT)
Aegon Global Sustainable Eq GBP C Acc (FUND:BYZJ377)
AXA Framlington Health Fund Z Acc (FUND:B6WZJX0)
Fidelity India Focus Y-GBP (FUND:B51RZC1)
Guinness Global Money Managers Y GBP Acc (FUND:B7MJHM4)
L&G Global Technology Index I Acc (FUND:B0CNH16)
Vanguard LifeStrategy 60% Equity A Acc (FUND:B3TYHH9)
Allianz Global Artfcl Intlgc PT GBP (FUND:BDHSN20)
BNY Mellon Long-Term Global Eq Int W Acc (FUND:B8K6W52)
CT Pan Eurpean Focus Z Acc GBP (FUND:B60L2M0)
Fidelity FAST Global Y-ACC-GBP (FUND:BDD2Q50)
Guinness Global Innovators Y GBP ACC (FUND:BQXX3K8)
Jupiter Merian Glb Eq AbsRet I USD Acc (FUND:BLP5S68)
Liontrust Sust Fut Glbl Gr 2 Net Acc (FUND:3003006)
Sanlam Glb Artfcll Intlgc I GBP Bs Acc (FUND:BNYN9Q4)
Schroder European Recovery Z Acc (FUND:0722188)
Stewart Inv APAC and Jpn Sstby B GBP Acc (FUND:3018408)
VanEck Sust Eur Equal Weight UCITS ETF GBP (LSE:TEGB)
Vanguard LifeStrategy 100% Equity A Acc (FUND:B41XG30)
WS Guinness Global Innovtr Y GBP Acc (FUND:BP5J5Y5)
I've found the stock data type potentially useful but hampered by the fact Excel fails to find many investments - particularly funds. With at least a 20-50% failure rate, it makes it effectively useless to build any kind of portfolio tracking spreadsheet
(Of the 40 or so funds I've tried to find, it failed to find 23)
Trial and error with keywords from the name sometimes brings success, but it's not obvious [to me] what search rules / logic there is that helps return any results (let alone the correct one).
For example it fails to find a fund called:
"Fidelity Global Special Situations Fund W-Accumulation".
If I look at the fund's homepage, I see a slightly abbreviated title:
"Fidelity Global Special Situations Fund W Acc", but typing that into the data selector search, fails to find a match.
I notice it says 'powered' by Bing, so I try Bing, which finds it as the 2nd hit:
...So why can't Excel?
So I shorten the title to "Fidelity Global Special Situations", and data selector search lists it as the 3rd hit, but when I select it, it fills in the name as
"Fidelity Global Special Situations W Acc" - which it failed to find when I typed it as exactly that!
So I try to find another fund that Excel can't find by it's full name called:
"Fidelity Funds - Sustainable Health Care Fund W-Acc-GBP"
Using the same approach, I try:
"Fidelity Funds - Sustainable Health Care Fund"
"Fidelity Funds - Sustainable Health Care"
"Fidelity Sustainable Health Care"
"Fidelity Sustainable Health"
Excel's data selector search returns nothing for each.
So I tried the Fund Code: WGHFA; SEDOL: BJVDYK8; ISIN: LU1033663300 - 3 supposedly definitive ways to identify the fund that in theory should mean you don't need to try to guess what - if any - abbreviation any 3rd party database has used instead of the full fund name.
It turns out Excel's data selector search doesn't recognise any form of code (WTH!)
So I go back to the original fund search results and notice when it found the first fund, this time it said Powered by Refinitiv
So my understanding is that the Microsoft is using a database from a 3rd party Refinitiv (actually now LSEG Data & Analytics), but I'm not sure whether it is Excel / Bing or some third party software which tries to match the name with a data set provided by Refinitiv/LSEG.
I went to the LSEG website thinking they might have a stocks/funds search tool that I could use to find the fund, for example using the SEDOL / ISIN / Fund code. Nope.
So I raised a support request with LSEG, asking how we are supposed to guess what they provide Microsoft with as the names it recognises as a fund name or whether there is any kind of rule they apply for abbreviation. The response was "I am afraid that Refinitiv helpdesk does not support this. You may reach out to the Microsoft/Excel Support for assistance."
It seems the only support Microsoft provides is a page describing the feature.
Does anybody know how to use Excel's data selector search in such a way that it will actually find funds?
For reference, these are the latest 23 that I failed to find:
Pictet - Global Envir Opps I dy GBP (FUND:B4YWL06)
RobecoSAM Smart Energy Eqs G GBP (FUND:BMF7CH0)
Sanlam Glb Artfcll Intlgc I GBP Bs Acc (FUND:BNYN9Q4)
XBT Provider Bitcoin Tracker One ETN (OSTO:BITCOIN XBT)
Aegon Global Sustainable Eq GBP C Acc (FUND:BYZJ377)
AXA Framlington Health Fund Z Acc (FUND:B6WZJX0)
Fidelity India Focus Y-GBP (FUND:B51RZC1)
Guinness Global Money Managers Y GBP Acc (FUND:B7MJHM4)
L&G Global Technology Index I Acc (FUND:B0CNH16)
Vanguard LifeStrategy 60% Equity A Acc (FUND:B3TYHH9)
Allianz Global Artfcl Intlgc PT GBP (FUND:BDHSN20)
BNY Mellon Long-Term Global Eq Int W Acc (FUND:B8K6W52)
CT Pan Eurpean Focus Z Acc GBP (FUND:B60L2M0)
Fidelity FAST Global Y-ACC-GBP (FUND:BDD2Q50)
Guinness Global Innovators Y GBP ACC (FUND:BQXX3K8)
Jupiter Merian Glb Eq AbsRet I USD Acc (FUND:BLP5S68)
Liontrust Sust Fut Glbl Gr 2 Net Acc (FUND:3003006)
Sanlam Glb Artfcll Intlgc I GBP Bs Acc (FUND:BNYN9Q4)
Schroder European Recovery Z Acc (FUND:0722188)
Stewart Inv APAC and Jpn Sstby B GBP Acc (FUND:3018408)
VanEck Sust Eur Equal Weight UCITS ETF GBP (LSE:TEGB)
Vanguard LifeStrategy 100% Equity A Acc (FUND:B41XG30)
WS Guinness Global Innovtr Y GBP Acc (FUND:BP5J5Y5)
