Web Scraping Text/Numbers from Screener.in | IMPORTXML() | Google Sheets Tutorial

Поділитися
Вставка
  • Опубліковано 30 вер 2024

КОМЕНТАРІ • 10

  • @shamanaggarwal4696
    @shamanaggarwal4696 День тому

    A very useful video. I am trying to get RSI value the same way, but its giving #NA, other values like Mcap are coming as you explained

    • @nth.education
      @nth.education  День тому

      Thanks for your kind words and watching the video :)
      Please check if you are logged in your account on screener.in, If you are then that might be the case as you might have added RSI value for your personal login and its not present as a default.
      This is one of the issues or a limitation on WebScraping from screener. One can only scrape what is freely available to all without login.
      I'll definitely research more about it, but as of now I'm also unable to get those ratios post login on screener.in.
      Please let me know if I understood the case incorrectly, more than happy to chat on this :)

  • @ankitrastogi9870
    @ankitrastogi9870 8 днів тому +1

    Thankyou for the information. however i am not able to extract INDUSTRY PE by the mentioned process

    • @nth.education
      @nth.education  7 днів тому

      Are you by any chance logged in your account profile ? If that is the case then it might not work as scraping only works on default available data. Hence the reason I used non-login screener.in in the video.
      If you are logged out and its public free information, I can try at my end. Feel free to mail me the sheet and snapshot of the website where you are trying to get industry PE from. I was somehow unable to get Industry PE from screener.in.
      Feel free to reach out to me on twitter : twitter.com/Aneja284

    • @nth.education
      @nth.education  День тому

      Hello, Can you please see if you are logged in the Screener platform ? I can see Industry PE is a specific ratio only allowed for logged in users. As mentioned in the video, scraping will work on freely available ratios without login as those data points are easily scrapable. Post login, there are a lot of data points which unfortunately I haven't yet explored how to get to. Will certainly give more information when I figure that out.
      Really appreciate you watching the video :)

  • @aniruddhabhattacharyya398
    @aniruddhabhattacharyya398 7 днів тому

    Thanks for such an informative video. I am trying to do this for all stocks under a sector for comparison purposes, however data is getting stuck in 'loading'. I think this is due to google's rate limit. Any workaround for this would be really helpful, from an expert like you!!

    • @nth.education
      @nth.education  7 днів тому

      I have faced a similar issue on this with "loading" and this can be a server issue on website end. I don't have a fix for this to be really honest, All i can say is make your google sheet as light as possible and don't merge it with other analysis heavy sheets if you can. Server end issues on website end we are unable to do anything about that.
      Give it some time, check again in 15-20 minutes, It generally gets solved for me. Do let me know if it gives you consistent issues, I'll try to see if there is a better solution for the same. :)

  • @luciifer7741
    @luciifer7741 7 днів тому

    Love from nepal Brother

    • @nth.education
      @nth.education  7 днів тому

      Thanks a lot for taking the time out and watching the videos. :)