Dear users, I advise to use the process of framing formula rather than copy paste XPath location shown in the video. As screener might have changed their UI, so XPath locations might have changed. If that is the case, we need to update XPath locations for one record and need to make them working; then copy paste those working formula for all other scrips. It should work. Let me know it works or not.
Yes UI might get changed, even i was thinking that. What is formula framing sir, can you give an example ? Or i can write an relative xpath using unique values something like //div[contains(@attribute, "attribute_Value")] ?
@@viralmedia8904 I have not tested much on XPath, but I am aware that XPath is very powerful tool. It should be possible to search a specific part based on some unique key.
@@ApplyIT2021 hi thanks for a good vid but all this data can be easily scanned on chartink. what i would like to learn is how we can segregate industry and sector wise stocks and see which sector is low which is high and which is growing since the last few months/days in graphic form....if we get graphical representation of various industries/sectors it would be a game changer for analysis. can you pls make a vid on that?
Very nicely explained in simple words. Can we find automatically Weekly ,monthly , quarterly, 6 monthly, YTD, 1Y, 2Y,3Y, 5Y price performance of stocks. I would like to see the video. Please make it. Thank you sir.
Thank you for your feedback. Yes, it is possible to retrieve historical data and to do analysis. You can watch the following video ruclips.net/video/Z1CqEREgzes/видео.html, which demonstrates how to find out 200 day moving average. Using similar approach, we can find price performance of stocks for any period.
very good video Bro, if possible please make a video to prepare heat map of mentioned stock list of excel & on click on that stock show its fundamental data like ROE, PE . pls make a video to import industry PE in excel
Very good video , no words..... can u tell me one thing we can add the said ratios, but while adding editted ratios from it like sales growth %, reserves etc all showing error can u check pls
Thanks for your feedback. This video demonstrates how to get data through use of xpath. I think you are looking for retrieving data from a table present on a webpage. For this you should try use of IMPORTHTML. The following video shows use of getting data from a table: ruclips.net/video/xn8AbXTcL50/видео.html. Hope this will help in solving your problem.
Thank you for prompt reply sir. I am working on Google Sheet only not xlsx - You assistance will be much appreciated. Sir Industry PE & Reserves ke case mein "Error Imported content is empty." error aa raha hai. Few heads are working and few are not sir.
Thank you for your interest. If you are tracking multiple scrips, kindly check for one scrip manually, by visiting generated screener's URL, whether the page displays that data or not. If the web page on screener's site displays data, but it is not coming in our Google Sheets, then it could be problem with our formula. There could some companies which are making loss. For all such companies PE will be empty, e.g., www.screener.in/company/TATAMOTORS/consolidated/. Hope this will help you.
@@ApplyIT2021 Thank you for the guidance. I cross-checked several patterns and methods. Screener is now able to fetch directly from the URL without coding. Scrips I tested out all have positive figures in PE section be it stock or Industry PE. Is it possible to request help from you via AnyDesk or direct support. It would be an honor and would like to setup deep analysis using your methods and would be happy to share with you the template so that you can pass it to your subscribers.
As we fetch data from third party website, if they change placement of data on their website, same XPath expression may not work. We need to update that expression. Regarding fetching data for more than 9, copy paste current row to the next row should work. The Google sheets is at the following location: docs.google.com/spreadsheets/d/1fmEzw46meNcLslGkIRhXlh0Ce_3t0KDuiV2Xr0JCWPs/edit?usp=sharing
Sir, I tried to retrieve other parameters, surprisingly I am not able to retrieve other parameters using same method. How can I reach you to discuss and resolve this issue?
No, not possible. All Google Finance formula gets executed on Google Server and Google Server will not have access of session that is present on our local computer.
MS Excel might have added. I do not use MS Excel as Google Sheets is available free of charge and Google Sheets is accessible from any computer, laptop, or even from mobile device.
It depends on what data Screener provides. If Screener does not provide certain data for certain scrips, it may not be possible to get that data in Google Sheets.
This option is available in both Google Chrome and Edge browser. I had used Edge browser for demonstration. But, it is also there in Google Chrome also. The steps are exactly same as shown in the video: right click the on desired value/text, select inspect, you see html tag () for that value on the right side, in split window, select that span tag, right click, go to copy, and select Copy full XPath, you get XPath link. Use this copied XPath link into IMPORTXML.
For BSE site, URLs for various scrips are not straight forward. For example, for WIPRO, the URL is www.bseindia.com/stock-share-price/wipro-ltd/wipro/507685/ . Apart from scrip name (WIPRO). They have added two other parameters (wipro-ltd) and their scrip number (507685). Need to have these data for all scrips in which we are interested. Then can be done.
To get XPath link, you need to select value (e.g., for ROE shown at 8:25, then right click, select inspect, you see html tag () for that value on the right side, in split window, select that span tag, right click, go to copy, and select Copy full XPath, you get XPath link. Use this copied XPath link into IMPORTXML. The video contains these detailed steps.
@@Travelindia159 This option is available in both Google Chrome and Edge browser. I had used Edge browser for demonstration. But, it is also there in Google Chrome also. The steps are exactly same: right click the on desired value/text, select inspect, you see html tag () for that value on the right side, in split window, select that span tag, right click, go to copy, and select Copy full XPath, you get XPath link. Use this copied XPath link into IMPORTXML.
I want that we learn by applying concepts. If we make mistakes, we should resolve them and that will make better understanding. I have covered all the details and required steps. If the sheet is provided, we tend to use it without understanding and that I do not want to happen.
![Kodak Black - Sharp Vibes [Official Music Video]](http://i.ytimg.com/vi/oEV0OoLJeIs/mqdefault.jpg)
Dear users,
I advise to use the process of framing formula rather than copy paste XPath location shown in the video. As screener might have changed their UI, so XPath locations might have changed. If that is the case, we need to update XPath locations for one record and need to make them working; then copy paste those working formula for all other scrips. It should work. Let me know it works or not.
Yes UI might get changed, even i was thinking that. What is formula framing sir, can you give an example ? Or i can write an relative xpath using unique values something like //div[contains(@attribute, "attribute_Value")] ?
@@viralmedia8904 I have not tested much on XPath, but I am aware that XPath is very powerful tool. It should be possible to search a specific part based on some unique key.
@@ApplyIT2021 hi thanks for a good vid but all this data can be easily scanned on chartink. what i would like to learn is how we can segregate industry and sector wise stocks and see which sector is low which is high and which is growing since the last few months/days in graphic form....if we get graphical representation of various industries/sectors it would be a game changer for analysis. can you pls make a vid on that?
@@Sanctimonious007 Will try that
😊Thankyou, its so useful , SUPERB, simple & step by step explanation.🔎
So nice of you
Awesome content.... someppl are selling stock analysis sheet for thousands of rupees. This is just amazing
Thanks for your feedback!
AMAZING CONTENT USING IT FOR MY PORTFOLIO ,THANK YOU
Thank you for your feedback. Happy that it helped you!
Excellent, i never ever seen like this simple step explanation knowledge video. Appreciate you and welcome more video like this.
Thank you for your kind feedback and also for motivation.
one of best gift to us from you ....Thank you so much bhai
Thank you for your feedback!
bahut badhiya n amazing
Thanks for your feedback!
Very nicely explained in simple words. Can we find automatically Weekly ,monthly , quarterly, 6 monthly, YTD, 1Y, 2Y,3Y, 5Y price performance of stocks. I would like to see the video. Please make it. Thank you sir.
Thank you for your feedback. Yes, it is possible to retrieve historical data and to do analysis. You can watch the following video ruclips.net/video/Z1CqEREgzes/видео.html, which demonstrates how to find out 200 day moving average. Using similar approach, we can find price performance of stocks for any period.
Thanks for reply
very good video Bro, if possible please make a video to prepare heat map of mentioned stock list of excel & on click on that stock show its fundamental data like ROE, PE . pls make a video to import industry PE in excel
Thank you for your feedback. And also suggestion of the topic on heat map and industry PE.
Thank you very much for sharing your knowledge with us ❤🙏
Welcome!
Int Coverage
Debt to equity
Pledged percentage
Make a video of these not being updated in Excel sheet please Sir
Thank you for your feedback. Will make a video on these parameters.
those Parameter dynamically Added will not show in above formulla,, static Element only shows.. Admin sir plz correct , might i m wrong..
Exceptionally well 🙏🙏🙏🙏🙏
Thank you for your feedback.
Thank you for such informative video
Thanks for your feedback.
Thanks
Welcome
Very good video , no words..... can u tell me one thing we can add the said ratios, but while adding editted ratios from it like sales growth %, reserves etc all showing error can u check pls
Thanks for your feedback. This video demonstrates how to get data through use of xpath. I think you are looking for retrieving data from a table present on a webpage. For this you should try use of IMPORTHTML. The following video shows use of getting data from a table: ruclips.net/video/xn8AbXTcL50/видео.html. Hope this will help in solving your problem.
Thank you , I was searching for
You're welcome 😊
Very informative video 👍🏻
Thank you for your feedback.
Very helpful video!! Anyways does it provide realtime data during market hours??
This analysis depends on screener's data. So could be some delay.
super sir. thank you.
Thanks for your feedback.
High and low add n less datr which formula use
EXELLENT INFORMATION SIR. SO I WANT 100 & 200 EMA IN WEELY BASIS, HOW FORMULA CREAT ? PLEASE PROVIDE ME.
bUT DEAR i am unable to retrieve data of EPS, PEG, Dept to equity or others also... can you help me out
Thank you for prompt reply sir. I am working on Google Sheet only not xlsx - You assistance will be much appreciated. Sir Industry PE & Reserves ke case mein "Error Imported content is empty." error aa raha hai. Few heads are working and few are not sir.
Thank you for your interest. If you are tracking multiple scrips, kindly check for one scrip manually, by visiting generated screener's URL, whether the page displays that data or not. If the web page on screener's site displays data, but it is not coming in our Google Sheets, then it could be problem with our formula. There could some companies which are making loss. For all such companies PE will be empty, e.g., www.screener.in/company/TATAMOTORS/consolidated/. Hope this will help you.
@@ApplyIT2021 Thank you for the guidance. I cross-checked several patterns and methods. Screener is now able to fetch directly from the URL without coding. Scrips I tested out all have positive figures in PE section be it stock or Industry PE. Is it possible to request help from you via AnyDesk or direct support. It would be an honor and would like to setup deep analysis using your methods and would be happy to share with you the template so that you can pass it to your subscribers.
Int Coverage
Debt to equity
Pledged percentage AND many more parameter
Make a video of these not being updated in Excel sheet please Sir
Will explore that and include these important parameters.
PLEASE LEARN US, HOW TO IMPORT DATA AFTER THESE 9 RATIO? LIKE DEBT TO EQUITY, ENTERPRISE VALUE ETC.
We can access only those values that are available on Screener without any login.
Very useful video Sir but it is not working when column value is greater then 9 please provide solution as I want Industry PE ratio in google sheet
As we fetch data from third party website, if they change placement of data on their website, same XPath expression may not work. We need to update that expression. Regarding fetching data for more than 9, copy paste current row to the next row should work. The Google sheets is at the following location:
docs.google.com/spreadsheets/d/1fmEzw46meNcLslGkIRhXlh0Ce_3t0KDuiV2Xr0JCWPs/edit?usp=sharing
Sir, I tried to retrieve other parameters, surprisingly I am not able to retrieve other parameters using same method. How can I reach you to discuss and resolve this issue?
Thanks sir important learned with practicality but I want for my watch list total number of equity revenue per year
Thank you for your feedback and suggestion.
can we add more ratio that gets added after login to screener for fetching it in importxml
No, not possible. All Google Finance formula gets executed on Google Server and Google Server will not have access of session that is present on our local computer.
sir this functionality of Google sheet ->IMPORTXML , is this available in MS Excel ? if yes then how we can achive this in MS Excel ?
MS Excel might have added. I do not use MS Excel as Google Sheets is available free of charge and Google Sheets is accessible from any computer, laptop, or even from mobile device.
👍
i tried to da same for PEG, EPS, 200 DMA, earning yield but no luck can u pl try and let me know
is it not working for all the values?
It depends on what data Screener provides. If Screener does not provide certain data for certain scrips, it may not be possible to get that data in Google Sheets.
hi, Copy full XPath option not seen ,only copy XPath , can u help on it ?
This option is available in both Google Chrome and Edge browser. I had used Edge browser for demonstration. But, it is also there in Google Chrome also. The steps are exactly same as shown in the video: right click the on desired value/text, select inspect, you see html tag () for that value on the right side, in split window, select that span tag, right click, go to copy, and select Copy full XPath, you get XPath link. Use this copied XPath link into IMPORTXML.
Thanks sir how to possible from bse sites
For BSE site, URLs for various scrips are not straight forward. For example, for WIPRO, the URL is www.bseindia.com/stock-share-price/wipro-ltd/wipro/507685/ . Apart from scrip name (WIPRO). They have added two other parameters (wipro-ltd) and their scrip number (507685). Need to have these data for all scrips in which we are interested. Then can be done.
I am not able to the html link, after clicking inspect
please could you help
To get XPath link, you need to select value (e.g., for ROE shown at 8:25, then right click, select inspect, you see html tag () for that value on the right side, in split window, select that span tag, right click, go to copy, and select Copy full XPath, you get XPath link. Use this copied XPath link into IMPORTXML. The video contains these detailed steps.
@@ApplyIT2021 hi, Copy full XPath option not seen ,only copy XPath , can u help on it ?
@@Travelindia159 This option is available in both Google Chrome and Edge browser. I had used Edge browser for demonstration. But, it is also there in Google Chrome also. The steps are exactly same: right click the on desired value/text, select inspect, you see html tag () for that value on the right side, in split window, select that span tag, right click, go to copy, and select Copy full XPath, you get XPath link. Use this copied XPath link into IMPORTXML.
Hello can i get this google sheet ?
I want that we learn by applying concepts. If we make mistakes, we should resolve them and that will make better understanding. I have covered all the details and required steps. If the sheet is provided, we tend to use it without understanding and that I do not want to happen.