VIP
Trusted Members
December 7, 2016
Trusted Members
October 18, 2018
Moderators
January 31, 2022
Doing what Alan suggests created the functions in B2 and C2 (i.e. =A2.Name and =A2.[Official name], respectively).
A2 is a relative cell reference and works just like any other relative reference in Excel. And if A2 contains a value of the Stocks data type, the .Name and .[Official name] parts will be recognized automatically.
Now you can copy them down without the need to hover over every stock name in column A.
Active Member
February 23, 2024
Absolutely, I get that and know it can work for entire list of stocks with a single click.
But, what I was wondering to get the name of stock with some of defined functions. Secondly, trying to understand what logic was put behind .Name and .Official Name. Although, this may not be in our scope however, would like to see what functions can be mixed to get the name of a stock.
1 Guest(s)