When we access data of external site as table, we get complete table. Now, if we want to access data of specific quarter, we need to get data using QUERY that is available in Google Sheets. QUERY is demonstrated in some other video on this channel.
In this analysis, we rely on data provided by screener website. So, if for some stocks data is not displayed, we can check whether on created URL the data we are looking for exists or not. Possible reason could be data is not present on screener website for some stocks.
As this video was created a long time ago and it relies on screener's site, it is possible that structure or ordering of tables on screener's website might have got changed. So need to select accordingly.
The following formula should work; we need to replace value of Col1 =QUERY(IMPORTHTML(C4, "TABLE", 10,), "select * where Col1='Promoters +',0) =QUERY(IMPORTHTML(C4, "TABLE", 10,), "select * where Col1='FIIs +',0) =QUERY(IMPORTHTML(C4, "TABLE", 10,), "select * where Col1='DIIs +',0) =QUERY(IMPORTHTML(C4, "TABLE", 10,), "select * where Col1='Public +',0) =QUERY(IMPORTHTML(C4, "TABLE", 10,), "select * where Col1='Others +',0)
The following formula allows to get face values of all the listed stocks on NSE: =IMPORTDATA("archives.nseindia.com/content/equities/EQUITY_L.csv",",","en_US") It is explained in the following video: ruclips.net/video/3bmMUXF2oBg/видео.html
GoogleFinance() provides data for volume also; it is possible to calculate Volume-Weighted Average Price (VWAP). It is possible to plot a candle stick chart and a line chart in Google Sheet.
These slope and intercept are parameters to represent a line in form of an equation. In an equation of line, of best fit, y=mx+c, the c is y intercept, which tells at x=0, what is the value of Y.
Great job. I tried stocks on my own for a while.
Thank you for your feedback. Happy Investing.
hello Sir, My question is if we want only single quater data then what is the formula
When we access data of external site as table, we get complete table. Now, if we want to access data of specific quarter, we need to get data using QUERY that is available in Google Sheets. QUERY is demonstrated in some other video on this channel.
Very good Sir
Thank you for your feedback.
Awesome one brother. but i'm getting some issues. like, some of my stocks showing data, and some are unable to fetch. what could be the problem?
In this analysis, we rely on data provided by screener website. So, if for some stocks data is not displayed, we can check whether on created URL the data we are looking for exists or not. Possible reason could be data is not present on screener website for some stocks.
Unable to get data of Debt to equity, Pledged percentage & Int Coverage.
its not table, Tried with List but it doesn't show added ratios. Please help
As this video was created a long time ago and it relies on screener's site, it is possible that structure or ordering of tables on screener's website might have got changed. So need to select accordingly.
Please grant access for google sheet in other video@@ApplyIT2021
Sir, please tell me how i acn pull single report for all type of shareholders
The following formula should work; we need to replace value of Col1
=QUERY(IMPORTHTML(C4, "TABLE", 10,), "select * where Col1='Promoters +',0)
=QUERY(IMPORTHTML(C4, "TABLE", 10,), "select * where Col1='FIIs +',0)
=QUERY(IMPORTHTML(C4, "TABLE", 10,), "select * where Col1='DIIs +',0)
=QUERY(IMPORTHTML(C4, "TABLE", 10,), "select * where Col1='Public +',0)
=QUERY(IMPORTHTML(C4, "TABLE", 10,), "select * where Col1='Others +',0)
Can be available mutual fund scanner in excel?
Google Finance does not support for mutual fund.
Google sheets me spilt or dividend face value ko janne ke liye kaon sa formula use kare
The following formula allows to get face values of all the listed stocks on NSE: =IMPORTDATA("archives.nseindia.com/content/equities/EQUITY_L.csv",",","en_US")
It is explained in the following video: ruclips.net/video/3bmMUXF2oBg/видео.html
Please share this sheet link and formulas if possible
Kindly refer the following link docs.google.com/spreadsheets/d/1iJOJ1GTsrk1s6KVIBBK3kljpsFUH8VvcgjQegCMonsc/edit?usp=sharing
Not working for me! Can you share me the link to your google sheet excel!
Formula in H column is =QUERY(IMPORTHTML(C4,"TABLE",10,),"select * where Col1='Promoters +'",0)
Hello bro , anchored vwap excel sheet pe plot kar sakte ho …
GoogleFinance() provides data for volume also; it is possible to calculate Volume-Weighted Average Price (VWAP). It is possible to plot a candle stick chart and a line chart in Google Sheet.
Very nice can this be done on MS Excel
We can import a whole table from a webpage in excel, but I haven't tried with excel exactly what is available with ImportHtml() in Google Sheet
Thank you for responding, To be frank a very good Education video, was very useful ❤️❤️
सर जी गूगल शीट पर ONE DAY CANDLESTICK कैसे बनाते है ??
How to Create a Candlestick Chart using Google Sheets ruclips.net/video/6z3j6Z7EboU/видео.html
Pls share this sheet
The link for the sheet is docs.google.com/spreadsheets/d/1iJOJ1GTsrk1s6KVIBBK3kljpsFUH8VvcgjQegCMonsc/edit?usp=sharing
@@ApplyIT2021 आपका बहुत बहुत धन्यवाद भाई जी।
वैसे मैंने आपसे सीख लिया है।
बड़ा ही काम स्क्रीनर है।
आपका योगदान बड़े काम है
Could you please intercept
These slope and intercept are parameters to represent a line in form of an equation. In an equation of line, of best fit, y=mx+c, the c is y intercept, which tells at x=0, what is the value of Y.