parsing - How do I derive stock/company ticker code using the company name in Google Sheets?

Question

I want to be able validate the performance figures of a Managed Investment portfolio fund i.e. Spaceship-Universe

The fund provides info about the various companies/stocks that it holds across the globe, for example 273 different companies in the Universe portfolio. An investor can invest say $1,000 and this is invested across the 273 companies on a fractional basis. For example 0.26% of the investment is held in Abbott Laboratories stock.

I know all 273 company names that and example amount $1000 is invested into, but I would like to all track the companies in Google Sheets, to validate Spaceship's performance figures.

Is there a way I can parse/scrape global stock exchange data to determine the company/stock ticker and which I can then track using the GoogleFinance function in Google Sheets?

Obiviously, I can manually Google search each security to determine the stock ticker. For example Abbott Laboratories's ticker is 'ABT' on the NYSE. However, it would be nice to have a more elegant, automated and ever-green solution.

Thanks

question from:https://stackoverflow.com/questions/65948881/how-do-i-derive-stock-company-ticker-code-using-the-company-name-in-google-sheet

Answer 1

Waitting for answers