Forum

Notifications
Clear all

How to get the Text of Stock Names?

6 Posts
4 Users
0 Reactions
253 Views
(@rl)
Posts: 5
Active Member
Topic starter
 

I would like get the Name of each and without the text in bracket with formulation. Without using the hover over option on stock name to get the official name of stock. Spreadsheet is attached for reference.rnI'm using MS O365 on Windows.

 
Posted : 24/02/2024 10:45 am
Anders Sehlstedt
(@sehlsan)
Posts: 972
Prominent Member
 

Hello,

Unfortunately, no file attached.

Br,
Anders

 
Posted : 24/02/2024 8:34 pm
Alan Sidman
(@alansidman)
Posts: 223
Member Moderator
 

Since you are using O365

Create your list of stock symbols.

Highlight and click on stocks

In an adjacent column, click on the little box that is adjacent to the first entry.  Select "Name"

 
Posted : 24/02/2024 8:53 pm
(@rl)
Posts: 5
Active Member
Topic starter
 

Sheet attached again. @Anders Sehlstedt

@ Alan Sidman - That's what I'm trying to avoid and want to understand if there's a way to get the result through a function.

 
Posted : 25/02/2024 1:08 am
Riny van Eekelen
(@riny)
Posts: 1196
Member Moderator
 

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.

 
Posted : 26/02/2024 6:18 am
(@rl)
Posts: 5
Active Member
Topic starter
 

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.

 
Posted : 27/02/2024 2:42 am
Share: