CaptainCsaba
Board Regular
- Joined
- Dec 8, 2017
- Messages
- 78
Hi!
I am trying to get a path in the online Excel on Google Drive. Basically what i am trying to do is for it to return the ISIN code for a certain company on the London Stock Exchange Website. I am trying to do this for all of them and I am really close but can't seem to find the last part. This is what my code looks like (this is for the company "Ashmore group plc"):
This returns the ISIN code but also 22 other cells because there are multiple "name classes" under the "Trading Information Table". So my question is how can I get only the one I want? Is there a way to tell it that only return the 16th thing it finds? Maybe what could be better if I could tell it to only return the thing that contains the substring "GB00" since every ISIN code starts with that and I would like to use this for multiple companies.
I am trying to get a path in the online Excel on Google Drive. Basically what i am trying to do is for it to return the ISIN code for a certain company on the London Stock Exchange Website. I am trying to do this for all of them and I am really close but can't seem to find the last part. This is what my code looks like (this is for the company "Ashmore group plc"):
Code:
[COLOR=black][FONT=Inconsolata]=[/FONT][/COLOR][COLOR=black][FONT=Inconsolata]importxml[/FONT][/COLOR][COLOR=black][FONT=Inconsolata]([/FONT][/COLOR][COLOR=green][FONT=Inconsolata]"https://www.londonstockexchange.com/exchange/prices-and-markets/stocks/summary/company-summary/GB00B132NW22GBGBXSTMM.html?lang=en"[/FONT][/COLOR][COLOR=black][FONT=Inconsolata],[/FONT][/COLOR][COLOR=black][FONT=Inconsolata] [/FONT][/COLOR][COLOR=green][FONT=Inconsolata]"//div[@id='pi-colonna2']//div[@class='table-responsive']//table[@summary='Trading Information']//td[@class='name']"[/FONT][/COLOR][COLOR=black][FONT=Inconsolata])[/FONT][/COLOR]
This returns the ISIN code but also 22 other cells because there are multiple "name classes" under the "Trading Information Table". So my question is how can I get only the one I want? Is there a way to tell it that only return the 16th thing it finds? Maybe what could be better if I could tell it to only return the thing that contains the substring "GB00" since every ISIN code starts with that and I would like to use this for multiple companies.