Stock Data function

[rsd007]

Hello,

I have EXCEl 365 workbook, and consolidating and (removing duplicates) all stock tickers on 1 page in column B
(Column A is blank ) then using another formula =IF(B14<>"",B14,"") transfer tickers to column C.
From column C ticker i will like to get Stock Name using EXCEL 365 Stock function in Column D.
Can someone help me please.

 

[rsd007]

Any help.
Thanks

 

[alansidman]

If you are still using 2019 then this option is not available to you. It is a 365 function. If you are looking for an alternative then maybe this will help.

Stock Connector add-in for Excel

www.michael-saunders.com

 

[JoeMo]

What did you do in D24:D25 which appears to give you what you are asking for?

 

[rsd007]

What did you do in D24:D25 which appears to give you what you are asking for?

I enter tickers manually and then selected Stock option to get
D24 and D25 is the End result I am trying to do

 

[JoeMo]

Why can't you do that for the other rows?

 

[rsd007]

I am trying to automate collecting all the tickers from various sheets in workbook and remove duplicates and then get the information

 

[JoeMo]

I'd start with gathering a list of the Tickers you want in Column B starting in B2. Then eliminate duplicates from that list using Data>Data Tools>Remove Duplicates. Next, convert the tickers to stock names by selecting all the tickers and then converting them to stock names using Data>Data Types>Stocks.

 

[MARK858]

Why can't you copy paste the tickers in column B, select them all and click Stocks (and record yourself doing so)?

Not a recorded macro but does the same for myself in England

Sub Macro2()

    With Range("A2:A" & Range("A" & Rows.Count).End(xlUp).Row)
        Range("B2").Resize(.Rows.Count, .Columns.Count).Value = .Value
        Range("B2").Resize(.Rows.Count, .Columns.Count).ConvertToLinkedDataType ServiceID:=268435456, LanguageCulture:="en-GB"
    End With
    
End Sub

 

[rsd007]

IN column A my tickers are changing based on selling some stocks and then buying new stocks