Thank you Kishanji . This was very much required for me , as I am unable to remember the formulas and it was tedious to search at different places . You are doing us great favour. Thank you once again .
Sir, Bahut Achcha Kar rehe hoo aap... kiu ke Book keeping kitna important hain.. jada tar retail investor / trader ko pata nahin hota hain eh saab... Sir , Aapke paas google sheet se data lekar bina API ke zerodha kite mei Order (AMO) lagane ka koi Jugad (python ya java ka) hain ?
Thank you very much sir for making this series, Sir my question is can we track any stock's price by a particular date like previous day open, high, low, close ??
Hi sir, main aapke video dekhe Hain, jinmen se ek ETF ki dukaan Ka video dekha hai, main Google sheet mein copy paste Kiya to "kharida hua Mal" sheet mein problem aa rahi hai," Total invested" or "Total qty" me "#REF!" Likha hua aa raha hai. Is problem ko kaise solve Karen, formula mein kuchh dikkat aa rahi hai, mein samajh nahin pa raha hun, please sir, meri Google sheet mein kya problem hai mujhe samjhae.
The most common reason for this error is manual entry in the cells which are not under Yellow colour in KHM sheet, because that stops the formulas from functioning. Hover your mouse over the #ref! error to see the cause of the error and take action accordingly
Sir please share formula of "Open" and "close"...when I used formula from google finance docs then its showing error... please guide... also is their any way to save daily google finance data in the same sheet or take automatic data to our normal excel sheet
@@FIREinIndia thanks sir... Please guide about to take Google finance data automatic to our normal Excel...or we can save any data at Google finance sheet...
Much awaited series. Thank you so much
Bohot Bohot Shukriya Guruji Aapka...Dil SE Pranaam Aapko...
Thank you Kishanji .
This was very much required for me , as I am unable to remember the formulas and it was tedious to search at different places . You are doing us great favour.
Thank you once again .
You are welcome!
Very Informative and useful. Thanks
Very nice initiative bhai 🙏
Keep it up 👍
Nice Sir....keep it up...
Thanks a lot🙏
Very good and helpful. Please do continue and ignore negative comments. They are useless people
Thanks Nadir.
I always ignore those comments
Thanks a lot Really it's help lot
Very useful thanks
Thank you..Krish'n 👍👍👍
Thank You
Amazing sir...plz continue this series
Sure, will do
Thanks 👍
Good content 👍
Thanks bhai,
Pls continue
Very nice bhai 🙏🙏🙏🙏🙏
Dear sir any formula in Google sheet for list of stock with monthly. High close low for particular month June 2022
Sir, Bahut Achcha Kar rehe hoo aap... kiu ke Book keeping kitna important hain.. jada tar retail investor / trader ko pata nahin hota hain eh saab... Sir , Aapke paas google sheet se data lekar bina API ke zerodha kite mei Order (AMO) lagane ka koi Jugad (python ya java ka) hain ?
Abhi to aisa koi tarika mene explore nahin kiya, par jaldi hi me algo trading sikhna shuru karne wala hu
Good job Sir 👌
Please make one video on GANN Cycle
Grt
how to get "change %" for n number of day.?
Great Sir.. Can U Teach How to Calculate SWING high or low,
How to fetch total traded value of any stock for today.
Kisi stock list ka kisi date ka price of all share
Dekha ja sakta h kya sir
Of yes
How
Sir 50 days Ka Volume Average kaisa Nikalte hai sir.... Iska formula share kariyega sir please
Does it work in google sheets mobile app?
Thank you very much sir for making this series, Sir my question is can we track any stock's price by a particular date like previous day open, high, low, close ??
You are welcome!
Yes we can track the prices based on particular dates as well. I will make a video on that in future
@@FIREinIndia please sir make a video regarding this
YESTERDAY HIGH AND LOW
Good work thankyou, but u advise how to option data pull
Option data history can't be pulled in Googlesheet
Hi Sir, i am unable to extract the "Adj close" price of a stock as there is no such attribute in googlefinance. Could you please help me with this?
No there isn't any option available in Google finance formula
Bose avg 3 years pe ratio nu formula muko ni saheb
Sir Pl Make enhanced sheet Swing Trading in mutual fund by mahesh kaushik sir.
Sure, will try
Hi sir, main aapke video dekhe Hain, jinmen se ek ETF ki dukaan Ka video dekha hai, main Google sheet mein copy paste Kiya to "kharida hua Mal" sheet mein problem aa rahi hai," Total invested" or "Total qty" me "#REF!" Likha hua aa raha hai. Is problem ko kaise solve Karen, formula mein kuchh dikkat aa rahi hai, mein samajh nahin pa raha hun, please sir, meri Google sheet mein kya problem hai mujhe samjhae.
The most common reason for this error is manual entry in the cells which are not under Yellow colour in KHM sheet, because that stops the formulas from functioning. Hover your mouse over the #ref! error to see the cause of the error and take action accordingly
Sir please share formula of "Open" and "close"...when I used formula from google finance docs then its showing error...
please guide...
also is their any way to save daily google finance data in the same sheet or take automatic data to our normal excel sheet
These formulas are already there in the sheet. Please watch the video again to check the correct way of using the formula
@@FIREinIndia thanks sir... Please guide about to take Google finance data automatic to our normal Excel...or we can save any data at Google finance sheet...
The data in Googlesheet populates automatically everytime you open it online, so no need to download the data
@@FIREinIndia ok sir thanks...may I have your email ID...to learn more
@@sachinmahadik3081 it's better to join my Telegram group than communicating over email as many others can also answer general questions
Google finance is delayed...can we fix it
We can't, it's controlled by Google. And other databases are not available for free use
@@FIREinIndia hmmm....ok...will the live data delay in ms excel sheets
Hii
900
EMAIL ACCOUNT
Not open to digest criticism hence moved from telegram channel.
Keep fooling the innocent traders good luck
It wasn't the criticism at all which made you eligible for removal. It was the useless inputs you were trying to force upon others in the TG group
Faku BAKWAS
Great Sir.. Can U Teach How to Calculate SWING high or low,