0

I've been trying to grab some data from this webpage: https://seekingalpha.com/symbol/BZUN. I want to import the follower count (under the add to portfolio button) into a cell on google sheets. For example, the data I'd try to import under this page would be the (22,201 followers).

I think that I need to use =importXML with this. However, it's not working. From the research that I've done, it's because that value isn't static and comes from another source.

I believe that the remedy to my problem is do use Regex Extract, but I have no idea how to do this.

2 Answers 2

0

From the research that I've done, it's because that value isn't static and comes from another source

You are not wrong there. after disabling JavaScript you can observe that followers count case to exist, and therefore not even regex will help.

0

REGEXTRACT isn't the replacement of IMPORTXML. It uses a regular expression to extract text from a value.

If the content is dynamic I don't think that it's possible to use Google Sheets to get that content, instead you will have to use a tool similar or based on a web browser that executes the client side code to generate the dynamic content.

1
  • Thank you very much for the response! Feb 26, 2019 at 22:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.