Hi, I'm trying to pull data from a page on Stockopedia onto my google sheet. For example, on page Barclays Share Price - BARC Share Price | Stockopedia I am trying to pull the text 'Turnaround' and Stock rank of '85'.
I am using =IMPORTXML(C2,"//*[@class='stk-text-keyword']") but am getting a vertical list in 3 cells of the text points before 'turnaround'. I am unable to get the data for the stockrank.
Can anyone help?
Many Thanks
I am using =IMPORTXML(C2,"//*[@class='stk-text-keyword']") but am getting a vertical list in 3 cells of the text points before 'turnaround'. I am unable to get the data for the stockrank.
Can anyone help?
Many Thanks
