You're really genuine.❤ Main as a software developer ye samjh sakta hun ke apne sheet prepare krne ke liye kitni mehnat ki hai. Kafi logic use hue hai jo apne user ko dhayan rakhte hue sheet prepare ki hai. Thanks to Mahesh sir as well jo itni achi achi Trading Technique hmlogo ke liye sochte hai.❤
Recently I joined your channel and Mahesh sir channel as well, after watching Mahesh sir Videos. The way you make this sheet in enhanced way..really this is appreciable. I learned a lot from both of you. Appreciate for your work and spreading knowledge freely in transparent way.
For anyone who wishes to invest using this method I would suggest you to first practice how to add and remove ETFs without breaking the formula in the Google Sheet. Try this with backdated data for at least 2-3 months so that you get a fair understanding of how to use this sheet . I would also suggest to pay and get the Backtesting datasheet otherwise you will not be able to test. Also it would be very tricky to maintain and update this sheet on a mobile phone. You would need a laptop to add and Delete entries. Cheers and happy investing. Thanks again to Krishan Ji. Being from tech background I know how tricky it is to create these sheets.
Thank you you sir....bht badi mushkil solve kardi.....poori excel sheet hill gai thi....kaafi shares mein current price hi ni aa raha tha......aapne sheet theek ki...ab jaake chain aaya....thank you so much sir ......aise hi baar baar check krte rehna...please....sheet ke formula hill jaaye toh thk kar dena please......thank youuu....
Sir you have done such a good work, you have accumulated so many blessings in your spiritual account Thank you sir for such a wonderfull explain like a brother.
Dear Sir....First time stumbled upon ur channel...Still surprised @ automation you have done....will try to follow you & decipher some way for this kind of investment journey...Thanks for effort....
I can imagine the amount of efforts gone in creating google sheet which is just a software. I hope many are getting benefitted from this videos. I started using from today and will share the results in next 2-3 months.
Kudos to you sir. Amazing work. I have been learning stock market for last 2 years but neither yours or Mahesh sir's video ever popped up. Thanx god! At last i could see your videos. Mind-boggling
Thank you for your efforts and for being patient enough to describe in detail all necessary criteria. That is really so nice of you. Truly , no words to express gratitude.
Thank you for your efforts and for being patient enough to describe in detail all necessary criteria. That is really so nice of you. Truly , no words to express gratitude. God bless !
@@FIREinIndia I wish I could do something like this some day. In the sense, help others. I have started learning Google sheets and I think I’m a slow learner.
You can surely help others in one or the other way, it need not be necessarily Google sheet or share market. It can be anything that you have expertise on and you enjoy doing
@@FIREinIndia I am so sorry, I mixed the 2 thoughts while writing. You are right, I can find ways to help. Google sheet issue was different. That I want to learn for my sake, trying with RUclips videos but haven't been much successful. You are so good at it.
Thanks sir. Things are explained in much details. For a person like me who is new to all this and wish to start investing, this video is very much helpful to understand ETF. Thanks a lot sir.
Thanks for your support. Please make a similar simple how to use video on SST. There may be a series of how to use videos on all strategies. I also feel the necessity of a video comparing advantages of different strategies you have shown.
Sir, It is very informative & important for people like me who are beginners in share market. In the above mentioned sheet option for entering date is not appearing. Kindly update/guide us in this regard
Thank you Krishna sir. Great effort. Though i am not well versed in the google sheets, understood very well because of your way of explaining. Thank you sir.
Thank you so much Krishnan sir for you efforts ❤..it is very useful for beginers like me. Initial Capital investment ke saat every month kuch amount SIP jaisa capital me add karna chahunga to iske liye aap formula add karke sheet update karetho most helpful hoga..thankyou
Thanks, this is something that I was looking for. I have a question. I have copied the google sheet but how do I know it is updated? Is there something I need to do to get the current updation. Because in your sheet you mentioned that it is updated as on December 2023.
Aap ke ye sheet bahoot aachi hai... Par jaise jaise profit hoga investment capital ke amount badhati jayegi.... Par aap ne to pura control he capital investment amount pe rakha hai "kharida hua maal" sheet mai
Very useful video.. i am watching it for fourth time now, its flawless work. Can you please make a video on the demo sheet, and how we can perform backtesting on different underlying asset.
very happy to inform you that i have conducted my first transaction based on this system today!! have seen your vidrro almost 15-20 times to understand. thanks so much for your effort. will keep updating you on my journey!!
Very informative very well explined please explain how to create google sheet whether online realitime rates are getting updated automatically and how can we use in the excel sheet provided by you
You don't have to create a new Google sheet, just make a copy of my sheet as shown in the video and start using it online. The sheet is updated automatically
Excellent efforts you made. My question is that Whether this strategy can be used on regular basis irrespective of any market trend ie uptrend or downtrend ? Please reply at the earliest. Thanks.
Sir if a person don't want to whitdraw the money in that case can he keep invested with buy on every dip? Will it beat the mutual fund return in long term. I am investing in ETF's to beat mutual funds profits. Please suggest
Sir, Thanks for making such an informative video. However, Please explain, how to open NSE, SELECT ETFs, copy the NSE ETF SHEET & EXPORT IT TO GOOGLE FINANCE SHEET, WHICH WE CAN SAVE AND EFIT. * TO START WITH, IS IT NECESSARY TO DOWNLOAD GOOGLE FINANCE SHEET IN OUR MOBILE/IPAD/PC ? THANKS.
good morning sir, i have gone through the video, which is well narrated. I have makeup mind to go for etf shop in gradual manner. your well teaching has encouraged me, in first phase I am thinking for dummy investment for first one month so that I can well know the whole procedure/system. Let us hope for best, is there any more upgraded sheet ? I am thankful to you, regards, RK Chandel
Please clarify that l am not so computer shabby so will use my android mobile to see the daily position of etf shopping and not to use for posting of any buy and sale. So, I think the first page of your Google sheet will fulfill my requirements ? Please reply at the earliest. Thanks.
Hello sir!! Ek query h jo investment amount h wo bich me kbi b change kr skte h kya?? N one more thing if i want to invest a particular amount let’s say 10000/- per month then in that case investment amount value kitna amount enter krna pdega?? Apne Bht hi achi and executable strategy with minimal efforts share ki h.. hope so profitable b ho in future.. I’ll execute this strategy from 1st of may 2023. And update you with the results.
Fantabulous work. You rightly said that the work involved was back-breaking. one thought emerged-having bought the ETF, will it be useful to place a sell GTD order.
As per the strategy, we fix a time to sell and buy ETFs. If you can follow that, it will be more fruitful than fixed 6% profit booking using GTT like features. Backtesting and my real trades are using the fixed time method
sir g namaskar and a big thank you, sir aapne jo google sheet banaya hai usme aapke bika hua maal me jo entry aapne banaya hua hai and usme jo formula lagake rakhkha hai usme thora sa modification chahiye, jaise ki aapne bataya ki column A4 se L9 ko delete kar do, lekin jab hum data ko delete kar dete hai tab total qty, total invested, avg price, sell price sell date isme automatically data fill nehi hota. delete k baad woh formulas v gayab ho rahe hai, Jab ki ab woh waqt abhi aaya nehi, ab toh shop ki taiyari chal raha hai saman bechne v hai. Aapka guidence ki jarurat hai. kripaya marg darshan kare. Even agar dubara etf add karne ki naubat aaye toh wah automatically add v nehi ho raha hai.
Can we buy/sell before 10 AM? Will this strategy work? I know it is not backtested. But, just a question as I am outside India and difficult for me to trade around 2:50 PM IST. Request you to suggest. Thanks in advance
After creating a portfolio of 5 ETF Can we repeat as per ranking indicated in excel sheet Or we need to wait until new ETF is reflecting in excel sheet Ranking.
Hi Sir, Really appreciate the efforts you have put to make the sheet. Very great learnings from your video. But in the sheet "Kharida Huya Maal" & "Bika Huya Maal", I am not able to find any formulas in the sheet. Can you please look into the matter? Please help us. 😊
Plz sir reply.....Sir agar hum sell hi nahi krna chahe long term tk like 1,2,3 etc years tk .tb ye etf k dukan ka formula thek rahega ?? Ya long term k investment k liye jo main ETF 4-5 unko hi buy krte jaye bar bar .??
Very useful information for all ETF traders provided with. I tried to use the Google sheet but that at most of places formulae are not being copied. Will you please help me in this issue.
आपके निस्वार्थ मेहनत और कठीन परिश्रम को दिल से सलाम ❤❤
Mahesh sir created gold n you made most precious jewellery from that gold and increased the value of that Gold. You r amazing.
You're really genuine.❤
Main as a software developer ye samjh sakta hun ke apne sheet prepare krne ke liye kitni mehnat ki hai. Kafi logic use hue hai jo apne user ko dhayan rakhte hue sheet prepare ki hai.
Thanks to Mahesh sir as well jo itni achi achi Trading Technique hmlogo ke liye sochte hai.❤
Thanks Vijay ji
Recently I joined your channel and Mahesh sir channel as well, after watching Mahesh sir Videos. The way you make this sheet in enhanced way..really this is appreciable. I learned a lot from both of you.
Appreciate for your work and spreading knowledge freely in transparent way.
Thank you 🙏
For me it is feels complicated , please mack it easy.
In the Era of trading and losing the money, this is something which looks promising. Thank you for your efforts.
Most Important thing you describe how to sell which was missing in Mahesh Sir video.Thanks a lot
Well explained I wasn't to say we all are following mashesh sir but your way of modification is excellent thanks
For anyone who wishes to invest using this method I would suggest you to first practice how to add and remove ETFs without breaking the formula in the Google Sheet. Try this with backdated data for at least 2-3 months so that you get a fair understanding of how to use this sheet . I would also suggest to pay and get the Backtesting datasheet otherwise you will not be able to test. Also it would be very tricky to maintain and update this sheet on a mobile phone. You would need a laptop to add and Delete entries. Cheers and happy investing. Thanks again to Krishan Ji. Being from tech background I know how tricky it is to create these sheets.
❤❤❤
Please send me the link of Google sheet
Hats-off to the efforts you have put in !!
You have literally done everything for us. Thanks a tonne sir. Hope to start investing soon with this technique.
Thank you you sir....bht badi mushkil solve kardi.....poori excel sheet hill gai thi....kaafi shares mein current price hi ni aa raha tha......aapne sheet theek ki...ab jaake chain aaya....thank you so much sir ......aise hi baar baar check krte rehna...please....sheet ke formula hill jaaye toh thk kar dena please......thank youuu....
Vow..you have done lots of hard work to get this sheet working....Wish you all the best
Thank you Krishan ji for your kind efforts and sharing your knowledge with us to make our life easier. God bless you ❤
Very nice & big effort sir... Great work.... Krishan sir ji.. Bahut bahut धन्यवाद.. 🙏
आपका प्रयास हमारे लिए अमूल्य है... Before watching vedio, its habit to like first.. So keep growing 🙏🏽🙏🏽🙏🏽
Thanks sir bahut accha samjhaya hai aapne phale google sheet dekhni nahi aa rahi thi ab samajh aa raha hai thnx
Sir you have done such a good work, you have accumulated so many blessings in your spiritual account Thank you sir for such a wonderfull explain like a brother.
sir Thank you to highlighted my comment
Dear Sir....First time stumbled upon ur channel...Still surprised @ automation you have done....will try to follow you & decipher some way for this kind of investment journey...Thanks for effort....
thank you very much kishan ji for your support I like your and mahesh sir efforts. you are the best follower of mahesh sir. thanks again my big salute
I can imagine the amount of efforts gone in creating google sheet which is just a software. I hope many are getting benefitted from this videos. I started using from today and will share the results in next 2-3 months.
Vv thànks
Really wonderful job AMIGO Krishan ji. Highly Appreciated.
O my god! You are impossible! How genious you are, no words Sir, to thank you.
Thanks Hemant ji
Kudos to you sir. Amazing work. I have been learning stock market for last 2 years but neither yours or Mahesh sir's video ever popped up. Thanx god! At last i could see your videos. Mind-boggling
Thank you Narayan ji
Thank you so much.The best investment sheets you make for the stocks. I you use almost all your investment sheets. Thank you so much for your support.
This looks promising. I have started from last Friday. Lets hope for the best
WHAT A GREAT WORK MAN. YOU ARE SIMPLY A GREAT MAN OFFERING GREATSUPPORT AND GUIDENCE TO INVESTORS. GOD BLESS YOU. JAY SHRIRAM
Very scientifically you did hard labour. I hope these sheets will be helpful for users thanks a lot.
Thank you for your efforts and for being patient enough to describe in detail all necessary criteria. That is really so nice of you. Truly , no words to express gratitude.
Thank you Sandip ji
Thank you for your efforts and for being patient enough to describe in detail all necessary criteria. That is really so nice of you. Truly , no words to express gratitude. God bless !
Thanks Mangal ji
@@FIREinIndia I wish I could do something like this some day. In the sense, help others. I have started learning Google sheets and I think I’m a slow learner.
You can surely help others in one or the other way, it need not be necessarily Google sheet or share market. It can be anything that you have expertise on and you enjoy doing
@@FIREinIndia I am so sorry, I mixed the 2 thoughts while writing. You are right, I can find ways to help. Google sheet issue was different. That I want to learn for my sake, trying with RUclips videos but haven't been much successful. You are so good at it.
Make a क्सपी
Thanks sir. Things are explained in much details. For a person like me who is new to all this and wish to start investing, this video is very much helpful to understand ETF. Thanks a lot sir.
Thanks for your support. Please make a similar simple how to use video on SST. There may be a series of how to use videos on all strategies. I also feel the necessity of a video comparing advantages of different strategies you have shown.
SST video and sheet is already available on my channel.
Comparison of all strategies is coming soon on my channel
Sir apne bahut mehant ki h .aapki mehanat ko salaam
Sir, It is very informative & important for people like me who are beginners in share market. In the above mentioned sheet option for entering date is not appearing. Kindly update/guide us in this regard
Very Good strategy and also You are the very great for all small investors. Thanks
बहुत अच्छे से समझाया सर आपने 🙏🏻🙏🏻
Appreciate your skill in making google sheets. Very detailed. Keep it up. God bless you
Thank you Krishna sir. Great effort. Though i am not well versed in the google sheets, understood very well because of your way of explaining. Thank you sir.
You are welcome Manne ji
Thank you so much Krishnan sir for you efforts ❤..it is very useful for beginers like me. Initial Capital investment ke saat every month kuch amount SIP jaisa capital me add karna chahunga to iske liye aap formula add karke sheet update karetho most helpful hoga..thankyou
You are welcome 🙏
ETF Shop 3.0 me ye feature bhi add kiya hai maine. Aap ETF Shop 3.0 mere channel par search kar sakte hain
very hardwork done for common investors. I appreciate your efforts friend
Thanks Sir, You and Mahesh Sir live long. Due to being busy now, watch after 8pm.
Grate work .for making this sheet You have done lot of hard work .Thanku very much for sharing sheet and all knowledge .😍
It's my pleasure
excellent work. Thank you Very much sir . Very good strategy sir. And sheets are excellent. Aapke Hardwork ko Salam
Thank you Rajendra ji
Thanks.for the back testing and your efforts we really appreciate yours efforts to educate the small retailers or working class for passive imcome
Hats off to your patience and knowledge.. Thanks for the video
Sir what a good automation of Google sheet! You are genius.
Thanks Pankaj ji
AMAZING WORK WITH THE SPREADSHEET
Thank You Krishan ji fir making such videos. Liked and commented
Sir, really you have don super work,it's very usefull to new inverters
fantastic tool I have notes of some key points from videos 1 & 2 hopefully will start soon thanks for your effort
Thanks, this is something that I was looking for. I have a question. I have copied the google sheet but how do I know it is updated? Is there something I need to do to get the current updation. Because in your sheet you mentioned that it is updated as on December 2023.
So much effort has been done by you for us....Hats off
Good knows from where you get so much energy to do such a great task god bless you sir
Thanks Kantilal ji
Thank you sir!! Dil se respect for the efforts.
Awesome work Krishan Ji ..... No words to express my gratitude ..... God Bless you ❤
This is Amazing. I am in love with your efforts and clarity of explanation.
Aap ke ye sheet bahoot aachi hai...
Par jaise jaise profit hoga investment capital ke amount badhati jayegi....
Par aap ne to pura control he capital investment amount pe rakha hai "kharida hua maal" sheet mai
Ye maine latest sheets me update kar diya hai, wahan growth amount bhi reinvest ho jata hai
Very useful video.. i am watching it for fourth time now, its flawless work.
Can you please make a video on the demo sheet, and how we can perform backtesting on different underlying asset.
🙏 thanks
I will show the backtesting sheet in next video
Such a knowledgeable content.
Thanks a lot Sir. Really appreciate.Hats off🙏🙏🙏❤❤❤
Thank you very much. Great work. No word to express. God bless you.
You are very hard worker sir , I highly salute you
Thank you Arif ji
Thanks for shearing this amazing sheet, You did really a commendable job.
Thanks Waseem ji
How to download the google sheet
बहुत मेहनत करी आपने सर
Highly appreciate your work and thanks for sharing
very happy to inform you that i have conducted my first transaction based on this system today!! have seen your vidrro almost 15-20 times to understand. thanks so much for your effort. will keep updating you on my journey!!
I wish you all the best Ravi ji
@@FIREinIndia the Google sheet is not recommending any ETF for almost 5 consecutive days now. Could there be any problem, please?
Can You Please Update About The Status of Your Profit or Loss. Were You able to do it consistently?
@FIREinIndia Many Thanks Kishan jee for enhancing this sheet...for non IT retail people like us... with original Thanks to Mahesh Chander Kaushik jee
Great modification....Though a bit complicated.
Very Good Work... God Bless you
Really Appreciate your work sir ❤🎉
hi sir, i really appriciate for ur hard work its really helpful , but what about brokage and tax
GOD BLESS SIR, VERY HARD WORK DONE REALLY APPRECIATABLE. THANKS
अच्छा राह दिखाने के लिये धन्यवाद
Thanks a lot for providing such an useful sheet🙏🙏🙏
Very informative very well explined
please explain how to create google sheet whether online realitime rates are getting updated automatically and how can we use in the excel sheet provided by you
You don't have to create a new Google sheet, just make a copy of my sheet as shown in the video and start using it online. The sheet is updated automatically
Excellent efforts you made. My question is that Whether this strategy can be used on regular basis irrespective of any market trend ie uptrend or downtrend ? Please reply at the earliest. Thanks.
Yes, it can be used in all market conditions
Sir if a person don't want to whitdraw the money in that case can he keep invested with buy on every dip? Will it beat the mutual fund return in long term. I am investing in ETF's to beat mutual funds profits. Please suggest
Very good work for sharing this sheet. Thank you
Sir,
Thanks for making such an informative video.
However, Please explain, how to open NSE, SELECT ETFs, copy the NSE ETF SHEET & EXPORT IT TO GOOGLE FINANCE SHEET, WHICH WE CAN SAVE AND EFIT.
* TO START WITH, IS IT NECESSARY TO DOWNLOAD GOOGLE FINANCE SHEET IN OUR MOBILE/IPAD/PC ?
THANKS.
good morning sir, i have gone through the video, which is well narrated. I have makeup mind to go for etf shop in gradual manner. your well teaching has encouraged me, in first phase I am thinking for dummy investment for first one month so that I can well know the whole procedure/system. Let us hope for best, is there any more upgraded sheet ? I am thankful to you, regards, RK Chandel
That's a good plan to gain confidence and experience.
The upgraded sheet is available in this video
ruclips.net/video/QLdTgLcFMvY/видео.html
Sir apka shit use kar raha hu
Jisme copy ho raha hai par pest ka option nahi aa raha hai
Thank you Krishan ji.
God bless you 🙏🙏
Many thanks to you!.. i have fully automated this as part of my algo and its doing pretty well so far!
That's great 👍
lot of thanks to u sir...wish u good luck . for this social work for us .
Please clarify that l am not so computer shabby so will use my android mobile to see the daily position of etf shopping and not to use for posting of any buy and sale. So, I think the first page of your Google sheet will fulfill my requirements ? Please reply at the earliest. Thanks.
Yes it will
Hello sir!! Ek query h jo investment amount h wo bich me kbi b change kr skte h kya?? N one more thing if i want to invest a particular amount let’s say 10000/- per month then in that case investment amount value kitna amount enter krna pdega??
Apne Bht hi achi and executable strategy with minimal efforts share ki h.. hope so profitable b ho in future.. I’ll execute this strategy from 1st of may 2023. And update you with the results.
Wonderful enhancements done. Thanks
Very good explanation appprecited
Fantabulous work. You rightly said that the work involved was back-breaking. one thought emerged-having bought the ETF, will it be useful to place a sell GTD order.
As per the strategy, we fix a time to sell and buy ETFs. If you can follow that, it will be more fruitful than fixed 6% profit booking using GTT like features. Backtesting and my real trades are using the fixed time method
Excellent sir thanks for sharing with us
sir g namaskar and a big thank you, sir aapne jo google sheet banaya hai usme aapke bika hua maal me jo entry aapne banaya hua hai and usme jo formula lagake rakhkha hai usme thora sa modification chahiye, jaise ki aapne bataya ki column A4 se L9 ko delete kar do, lekin jab hum data ko delete kar dete hai tab total qty, total invested, avg price, sell price sell date isme automatically data fill nehi hota. delete k baad woh formulas v gayab ho rahe hai, Jab ki ab woh waqt abhi aaya nehi, ab toh shop ki taiyari chal raha hai saman bechne v hai. Aapka guidence ki jarurat hai. kripaya marg darshan kare. Even agar dubara etf add karne ki naubat aaye toh wah automatically add v nehi ho raha hai.
Can we buy/sell before 10 AM? Will this strategy work? I know it is not backtested. But, just a question as I am outside India and difficult for me to trade around 2:50 PM IST. Request you to suggest. Thanks in advance
Yes you can trade at 10 am as well
Thanks a lot for you prompt reply@@FIREinIndia
Great Sir . Thank you Krishanji
Yah Sare kam Bina computer laptop ke mobile per ho sakta hai kya
Awesome work Krishan Ji
Thank you Krishan ji for your kind efforts
After creating a portfolio of 5 ETF Can we repeat as per ranking indicated in excel sheet Or we need to wait until new ETF is reflecting in excel sheet Ranking.
You can upgrade the ETF shop provide in this video: ruclips.net/video/QLdTgLcFMvY/видео.html
This is a good piece of work! Keep it up !
Hi Sir, Really appreciate the efforts you have put to make the sheet. Very great learnings from your video. But in the sheet "Kharida Huya Maal" & "Bika Huya Maal", I am not able to find any formulas in the sheet. Can you please look into the matter? Please help us. 😊
Plz sir reply.....Sir agar hum sell hi nahi krna chahe long term tk like 1,2,3 etc years tk .tb ye etf k dukan ka formula thek rahega ??
Ya long term k investment k liye jo main ETF 4-5 unko hi buy krte jaye bar bar .??
Thanks a lot
Excellent efforts and nicely explained
Thanks for sharing your efforts.
Very useful information for all ETF traders provided with. I tried to use the Google sheet but that at most of places formulae are not being copied. Will you please help me in this issue.