Forum Discussion
Excel FIELDVALUE function
VTV is the ticker for a Vanguard ETF. I use tickers in tables populated by the FIELDVALUE function.
When I select VTV and Select Data/Data Types/Stocks, then the FIELDVALUE finds VTV Theraputics and does not offer a dropdown list of other possibilities to select from. How can I get VTV ETF into my table?
VTV is the only ticker in my table that has this problem. The VTV ETF is not new, been around for years.
The Stocks data type works fine on all the other ETFs in my table.
If data is in table and we use FIELDVALUE() Excel automatically converts text to most close from its point of view data type, and if only nothing is close opens data selector.
For example, having
with applying Stock data type we have
If we see that something is converted wrongly, we may right click on data type and initiate data selector by
Here change name if necessary and select correct data type
Finally
Automatic conversion is applied by default for bulk conversion (i.e. for column in table or for the range). If try to convert text in separate cell, default will be Data Selector.
I'm not sure if we may change such behaviour.
8 Replies
SergeiBaklan Sergei, Thank you for responding, especially at 4:42 am. Your suggestion works. VTV is now correct in my table. If you did not know the precise text to put in column 1, then the function will fail (as I did). How did you know about the need for the semicolon and space? See below the best description available from my broker's website for GFOF. The function fails even when I add the semicolon before ETF. Again, thanks for helping.
Thank you for your prompt response. That image is what I would expect to see. But no such option appeared on screen. The result "VTV Therapeutics" with no further options. How did you "force" it to present options? Is there a setting somewhere?
If data is in table and we use FIELDVALUE() Excel automatically converts text to most close from its point of view data type, and if only nothing is close opens data selector.
For example, having
with applying Stock data type we have
If we see that something is converted wrongly, we may right click on data type and initiate data selector by
Here change name if necessary and select correct data type
Finally
Automatic conversion is applied by default for bulk conversion (i.e. for column in table or for the range). If try to convert text in separate cell, default will be Data Selector.
I'm not sure if we may change such behaviour.
