Respected Readers,
Here are the new google sheets with BOH ( Bottom out hunting) filter.
It means these sheets also check 52 weeks high and the 52-weeks low dates and ignore triggers if the 52-weeks high date is earlier than 52 Weeks low date.
1. Sharegenius Method:-
sheet with formulas:- https://docs.google.com/spreadsheets/d/1UDRDD1hTLAeTABFK3Tqbl7CohnaNDc2MoBqaGW0UbCk/edit?usp=sharing
2. Turtle Trading Method:-
sheet with formulas:- https://docs.google.com/spreadsheets/d/1vJ8xcjgJYTSTobSUub2_w_uZ5P0SMwfjztEl4EuRjeM/edit?usp=sharing
3. Buy Low Sell High:-
sheet with formulas:- https://docs.google.com/spreadsheets/d/1LHLwcJVjct6rufOf5k6r-mvjiDI5N2Juvkh8Po2HvX4/edit?usp=sharing
4. Automatic Stock Screener 100 SMA:-
sheet with formulas:- https://docs.google.com/spreadsheets/d/1251LUwp1qj7xcXvw6c66c8qDRrVuRqwVvHDe64TP6E0/edit?usp=sharing
Watch this video for more details:-
Thank you Sir!
ReplyDeleteWelcome Mutee Shivraj Patil Ji
DeleteClosing price par buy karna hai ya 100 Dma se upar me
DeleteSir namaste, aapka ek vdo dekha tha jisme xcel sheet par aapne futures ke starting date se month ke last thursday tak ka calculation xcel par dikhaya aur kuch formulations se gtt set karna and profit book karna bataya tha, vo vdo dubara dekhna hai mujhe but main uska topic name bhul gaya hu..aap uski link ya us strategy ka naam bata sakte hai...
DeleteSir, Sheet me jo stock nifty50 and nifty 200 ke letest stock add karne ki kripa kare
DeleteSUPERB MAHESH JI.. YOU ARE EXTRA ORDINARY SIR. PLEASE UPDATE OUR 4000 COMPANY LATEST FULL DATA. AND ALSO GUIDE US HOW WE READY THIS DATA ON QUARTERLY BASED.
ReplyDeleteRohit Kukadia ji sir data base aap individually update nahi kar sakate, me latest data base 1 May 2022 tak de sakunga Regards
DeleteGood evening sir , top 10 cheapest nifty shares sheet not working,
DeleteSir, I am Vijay Singh and I wish you all the best in your advised in stock selling strategy for short-term and long-term investors. I do both types of trading: swing trading and investing for a period of 2-3 years. Pl share with us tech strategy.
DeleteDouble Top and Double Bottom sheet
ReplyDeleteSir I will try
Delete@mahesh ji , request to confirm one thing . etf ki dukaan ( etf , jewellery & equity ) me koi ceiling bhi hai kya ?
DeleteThank you very much, very few people like you in this market who have not hidden the knowledge but have whole heartedly shared it, although I have one request the people who have won zerodha challenge, if you could interview them, how their journey started so far, and which strategy of yours they have applied, would be great.
ReplyDeleteThanks and keep up the good work
My name is naresh, my email id is nareshpoland@yahoo.com
DeleteYes, indded it helps the new entrants and to get confidence in implementing the said strategies. Thank you.
DeleteGreat work sirji
ReplyDeleteThank you sir ji
DeleteThank you sir 🙏
DeleteHalo Mahesh Sir, Your selfless attitude to help all the people who wants to invest in Share Market shows your sincere and helpful nature, you are a true teacher, lakhs of people blessings are with you and your family for all your advises and strategies....Thank you Sir
DeleteThank you Sir
ReplyDeletewelcome sir
DeleteThank you so much Sir
ReplyDeleteThank you Jayesh ji
DeleteHello sir, thank you for your great work.
ReplyDeleteI am beginner in stock market and my capital is 2L. Can you pls suggest one best method to start.
use REIT and INVIT through darvas box method , divided your capital in 33 to 50 parts and invest each part in every week through darvas box
DeleteGreat work guru ji
ReplyDeletethank you sir ji
DeleteRespected Sir,
ReplyDeleteThere is no update in swning trading system google sheet at morning
Ankit ji because no any share pass the filter.. when any share pass the all filters it will show in sheet
Deletesir plz provide swing trade or positional trade sheet
ReplyDeleteJayesh ji All sheets are usefull for swing trade
DeleteThank u sir ji for sharing such an amazing filtering mechanism which most of times return profit without thinking or any effort or taking analyst view. You are the best. Tks
ReplyDeleteThank you sir
DeleteSir you are genius 🙏
ReplyDeleteThank you sir
Deletehello Mahesh sir, How will excel sheet update in my pc?
ReplyDeleteaap hindi me likhiye, video dekhkar samajh nahi aata.
ReplyDeleteIt is really a helpful blog to find some different source to add my knowledge. Best Cfd Trading Platform
ReplyDeletesir, list of stock are updated?
ReplyDeleteHi Mahesh Ji,
ReplyDeleteReally you are doing great job to share your knowledge ,i have read your books , wonderful .
Hi Gurujeee, bahut bahut dhanyawad apka, pls aap yeh smart averaging vidhi bhi update kijeeye sir
ReplyDeleteSir fast web page are not opening please guide
ReplyDeleteSir, Turtle trading sheet is not showing data correctly, please update it.
ReplyDeleteGreat sir... thank you
ReplyDeleteits awesome sir ji regards
ReplyDeleteMahesh ji share market ki knowledge aur strategies share karne ke liye bahot shukriya. Hum surprised ke aap ka channel itna purana aur popular hair fir bhi hame aaj tak iske bare me pata nahi chala. Humne kuch 2 months pehle hi zerodha me account banaya hai lekin long term ko dhyaan rakhkar lekin apke videos dekhkar lagta hai ke short term me bhi thoda effort aur apki knowledge ka use karke kuch kara ja sakta. Sirf choti si problem ye hai ke apke videos itne salo se aa rahe hain aur itne zyada aur ache hain ke lagta hai sab dekhein fir start kare. Kya aisa possible ho sakta ke ap h jaise beginners ke liye YouTube me kych kuch playlist banakar apne videos ko ek logical order me organize kar dein, aise hi advanced aur fir expert ke bhi kara ja sakta hai aur maybe ek jisme apke Sare screeners ho. I know ap bahot busy honge lekin isse hum jaise beginners ko bahot help mil gayi. Fir se apke effort ke liye bahot shukriya.
ReplyDeleteOk 🙏🏻 thank you sir I will try
DeleteSir,aap Mean Reversal stretegy by Jim Simon samjaye Jo share market me jisne treding se bahut successful vyakti he, mene YouTube me bahut videos dekhe par iski koi Google finance sheet bhi ban sakti he. Aur wo stretegy me aap ka kya sujav he wo bhi bataiyega
ReplyDeleteSIR JAN 2024 ME KUCH BATAYE SARE STOCK PRICE UPPAR HAI
ReplyDeleteOk
DeleteSir namaste, aapka ek vdo dekha tha jisme xcel sheet par aapne futures ke starting date se month ke last thursday tak ka calculation xcel par dikhaya aur kuch formulations se gtt set karna and profit book karna bataya tha, vo vdo dubara dekhna hai mujhe but main uska topic name bhul gaya hu..aap uski link ya us strategy ka naam bata sakte hai...
ReplyDeleteSir namaste, aapka ek vdo dekha tha jisme xcel sheet par aapne futures ke starting date se month ke last thursday tak ka calculation xcel par dikhaya aur kuch formulations se gtt set karna and profit book karna bataya tha, vo vdo dubara dekhna hai mujhe but main uska topic name bhul gaya hu..aap uski link ya us strategy ka naam bata sakte hai...
ReplyDeleteBahut Bahut Dhanyavad aapka 🙏🙏
ReplyDeleteTHANKS A LOT, SIR. BULL MARKET ME BARTE HUE SHARE ME NEBES, OUR STOP LOSS KA BIDE KYA HO SAKTA HAI SIR, PRONAM.
ReplyDeleteSir please share link for fast loading sheet
ReplyDeleteIncredible work sir ji 🙏
ReplyDeleteExcellent way of understanding market nuances. Also a handholding guidance for retired persons like me, who interested to safe guard inflation erosion of income.
ReplyDeleteSir, Darvax box sheet with BOH hai kya?
ReplyDeleteSir aapki share genius automatic sheets mein koi nahin aa raha hai kya sheet corrupt ho gai hai kya?
ReplyDeleteSir Thank you for your good work
ReplyDeleteSir MTF Sharegenious Google finance sheet Jewellery shop is not showing latest data please guide.
Sir Google finance sheet top 500 stock update krne par automatic price nahi a rahe new stock ka vo sikha dijiye naye stock kaide add kare make a copy kr liya tab bhi nahi ho rha hai
ReplyDeleteDear sir you are Extrodinary Teacher & Transparent person & good patience in stock market. Thank you for your Genuous knowledge
ReplyDeleteaapki vidhi sharegenious swing trading me 1st time 20%, 2nd 15%, 3rd 10%, 4th 5% target lete hai.. kya usi prakar sharegenious swing trading with BOH me target le sakte hai kya sir.. ye sawal isliye pucha sir kyuki aapne tata motors ka example samjane ke liye shregenious swing trading with BOH me 1st target 5% ka hi target rakha tha..
ReplyDeletesir aapki vidhi sharegenious swing trading me first time 20%, 2nd 15%, 3rd 10%, 4th 5% is prakar target rehta hai.. kya isi prakar sharegenious swing trading with BOH me kr sakte hai kya... ye sawal isliye pucha kyuki aapne tata motors ka example smajane ke liye sirf 5% ka target rakha hai
ReplyDeletesir aapki vidhi sharegenious swing trading me first time 20%, 2nd 15%, 3rd 10%, 4th 5% is prakar target rehta hai.. kya isi prakar sharegenious swing trading with BOH me kr sakte hai kya... ye sawal isliye pucha kyuki aapne tata motors ka example smajane ke liye sirf 5% ka target rakha hai
ReplyDeletesir aapki vidhi sharegenious swing trading me first time 20%, 2nd 15%, 3rd 10%, 4th 5% is prakar target rehta hai.. kya isi prakar sharegenious swing trading with BOH me kr sakte hai kya... ye sawal isliye pucha kyuki aapne tata motors ka example smajane ke liye sirf 5% ka target rakha hai
ReplyDeleteI Maheshji, lot of love from Melbourne, i hope you would like to answer my query for many of your followers, my query is on diversification and allocation of funds, sir please make video on how one should diversify and use your strategy if they have 10lac to 50lac, i am earning good and liked your simple systems, i want to allocate funds to your strategies example - ETF ki dukaan , Darvas Box, SIP in value stocks, and other more, do you think i should use all of your strategies to be diversified or it will become over diversification and also how much funds i should allocate for each strategy, as i am 32 years old and me and my wife both are earning good and saving up to 4-5lacs a month.
ReplyDeleteIf possible, kindly make video where you can tell percentage wise funds allocation to different strategies of yours.
Thank you for reading :)
Also please let me know any help you need in back testing.
Sir thank u for knowledge sharing all with Google Sheets, Technics.. I am a new invester pls guide ETFs for long term (5 to 10 years) investments
ReplyDeleteplz sheet ko check kijiye updated 4 number wali Updated Automatic sheet. Bahut sare naam ki price N/A dikha raha hai NETFIT, Adanitrans, etc. shayad wo naam hat gae ETF aur Nifty se.
ReplyDeletesir, aapke video dekhkar invest karne ka vishwas bahut badha hai , shareginius boh filter vidhi se share kharedi kiya hai ,par muze kaise bechana hai ye samaz me nahi aa raha krupya kaise beche , kin bato ka khayal rakhe iska aapka koi video ho to bataye ya magadarshan kare
ReplyDeleteHi Sir , 100 SMA sheet par GTT order lagane ke baad agar market gap-up khulta hai toh zada tar time order trigger nehi hota hai. Toh GTT order cancel kar du ya 2-3 days wait Karu order trigger hone ke liye.
ReplyDeleteI really appreciate the depth of information here. This will help a lot of readers better understand the topic.
ReplyDeleteiepf recovery
Mahesh sir main google sheet me previous week Low ke liye kya formula lagaye kripya bataiye main ETF ke liye apni google sheet banana chahata hu
ReplyDelete