Hi, Just bought the Sheet. Its quite amazing. Wonderful work done by you. Huge respect. Please update the list with the MTF column as well.

Dear Krishanji, Great Video & thank you for making it, it was one of my concern that you have resolved.

Mere savaal yah hai ki pichhale kuchh maheenon paheale maine Gold etf main jo nivesh kiya tha,vah mainne pahale hee book kar liya tha 3-4% profit ke saath,but now gold ka price 20 DMA se 6-7% up hai,and Gold jewellery shop ka scaneer main ah raha hai for buying ,kya mai new gold etf khareed sakta hu,or wait karna hai 20DMA and price thora nikatatam a jay... Thank you sirji.

महेश कौशिक सर को अनदेखा ना करके अपने जो कार्य किया उसके लिए खुप शूप धन्यवाद।

Hello sir, is Google sheet me manual backtesting kar sakte hai ?

Sir ji master etf sheet क्या सबको मिल सकती है विदाउट any चार्ज

How much should we remit to get the sheet 3.0

Hi I recently purchased your "FIRE SHOP WITH JEWELS". I want to ask that only maximum 12 months are allowed in Profit Percentage Table (CAGR Table) in SOLD Sheet because after 12 months the Profit Percentage Table does not do the autosum

Hi. Thank yoi very much for the sheet. Very helpful. Just one question. It seems the sheet is recommending a sell even if i averaged the purchase. It asks me to sell the part puchased later and not the full lot of 2x the invested amount. The method was different earlier. Or am i missing something?

Is it possible to have interview or discussion video with Mr. Rohan on SST? I am following your blog and it's results are amazing.

Hi. While adding a Second Lot (as previously Bought ETF was down by 4% and it was eligible to add 1 more lot to averaging), then the previously bought ETF % does not change and its still highligted in red. Please explain this as may i am doing something wrong sir

Hi Krishan, Amazing video as usual. any new updates expected for Fire Shop with jewellery?

Annual return kitni calculate hue shop se?

pl. suggest about nifty bees and bank bees swing trading buy on 2% fall and sell on 2% up . will it work?

Namaste Sir, sheets show absolute returns. Can you please explain the STCG and its impact on net returns? Thank you

Hi, I have started recently with the ETF shop. And so I have multiple ETF with the same underlying. Now the new sheet where there are no multiple underlying , how to deal with it ?

I have already purchased the ETF sheet in aug 2023, but ETF 3.0 has not been sent to me pl let me know do I have to buy that again?? As ETF 3.0 is not showing in my fire shop with jewels ETF sheet

Sir jinke pass purani etf shop ki Excel hai unko bhi new purchase krni pdegi kya ?

In the 'Kharida Hua Mall' sheet, one column is "Fall% of averaging". What is it and what is the significance of the number shown against it.

Great job sir, thanks a lot

Any update in mck Version of etf shop

Hello sir, I want to understand how your subscribers to a particular sheet get the updated sheet whenever you make changes or updates to it. From time to time, you upgrade existing sheets and add new features/formula to them. Are those new features available to clients who purchased the sheets in the past, and if so, how do they get the updated sheets? Waiting for your reply.

If i have done average in one etf, how i will know which one to sell...i mean how do i know which etf is last in

if i had brought 2.0 ver then do i have to buy new 3.0 ver again ...pls help with the awnser

Hello as mahesh sir said In this list Can we add nifty top 10 stocks by market cap also?

Thanks a lot sir for this great sheet..

hi, im trading as per ur sheet, going good till now, if i have funds can i BUY/SELL 2 or more ETF on same day ? will sheet manage data accordingly or does sheet have a limitation of 1 Buy/ SEll only ? Thanks

ETF Shop 3.0 sheet not showing averaging stocks

sir agr top 5 etf buy kiya hu or whi same etf aa rhe hai toh ab konse etf buy krna chahiye average kb karein or kb avoid kare please reply

Hello Krishan, I've seen your Videos for Lifo and fifo, I am still unable to understand which one books faster? Lifo or Fifo and which one is more profitable way to book lifo or fifo? Sorry it might be a repeat question to you. I am just unable to understand. But if there is a way to know and if you've mentioned some where in the blog then do let me know. Thanks

Sir, highly appreciate your work and THANKS. Seeking your advice...if the whole capital is invested in NIFTY BEES, it fetches an annual average return of 15%. In that case by trading with etf shop, we end up making around 20%. Is it better just to invest only in ETFS one time (lumpsump) which gives annualised return of around 15-20%. Please advice

Good Job done. Requested to please provide Master ETF List in other excel Sheets also. Thanks

Hi, i am using FIRE shop with Jewels - BID Investment - 24 MAR 2024 GSheet now. Is BID feature in this new Sheet? Not demonstrated. Can i get discount?

Sir y stretegy m agar corona jaisa fall aaya to what we have to do stop investing or continue to follow stretegy??

Please let us know best strategy of mukesh ji according to you and which strategy does your most funds goes

sir,how much to pay not mentioned in razor pay site..?

Sir Aapka ETF SHOP ka Google sheet buy kiye hai.. But kuch ETF ka CMP galat hai.. 1. FMCGIETF 2. MIDSELIETF 3. ALPL30IETF

Chief it seems like the diversification module added i.e. etf from each sector included without repetition is the single most effective factor towards profitibility can you please share back testing of these select new etfs even before asking your earlier subscribers to purchase again. ? Much appreciated

Bought the sheet today...thank u sir

I alreday have old version of ETF shop. How can I upgrade into V3. 0. d Do we need to buy new one

Sir muje ATH ka formula nhi mil rha

I have one question, in original strategy by Mahesh Sir, we use to buy when ETF falls by 2%, in the 3.0 strategy should we buy the top recommended ETF even if it is not down by -2%, lets sat the top ETF is showing "% Change 20 DMA Vs CMP" 1% or above?

20 DMA strategy and Fire Shop 3.0 look similar....In your suggestion What is a Good Strategy for a beginner to Start ? Are doing both advisable with separate capital and brokers as both strategy looks similar?

Sir after payment sheet ka link mail s milega ?? Bcs mene mobile s payment kiya h nd mobile m sheet open hui excel so i cant copy from mobile to my drive please guide me

You have been phenomenal in teaching these strategies in such a easy to understand way. I am currently based in USA. I want to know if i can apply these strategies in USA NYSE. 1- dar box theory 2- consolidated break out strategy 3- BOH theory. If yes can i use same 6% profit rule and 20% averaging rule and 2.5% dips in USA stock market also or it needs adjustment. Your advice in this regard is highly appreciated.

In MTF video by Mahesh Sir, he told that don't make ( or hold) more than 14 position in one time, can this criteria in any form can be applied to ETF 3.0 ? thanks

Sir please suggest ideal amount to start this with. Minimum and ideal both please.

what is to be done if the price of ETF is higher than the 20 DMA (% change is positive) and there is no ETF with price less than the 20 DMA. Do we still buy or wait for market to come down.

If I am starting today...Do I need to buy only this current sheet or the current sheet + Previous sheets also ?

We will be highly obliged

Hello Sir, Can you make same for stock. Take one stock from sector wise or underlying asset.

Hello Sir. The sheet is very good and I have been using it for quite some time now. But today I ran into some problem. 3 ETFs, namely MIDSELIETF, FMCGIETF and ALPL30IETF have changed their face values. So their CMP has reduced drastically by 10 times. As a result, they are showing on top of the buying list by fall of -89%. So, how to tackle that? Please suggest.

THANKS KRISHAN JI again ROCKS......💯

Nifty 100 ESG security leaders is not getting updated ? What to do

Superb sheet sir thank you very much, sir I have a query if supposed we want to average in particular ETF then how to do entry please explain. In the same way as we were doing by pressing control D and entering new data ??

Hi Sir, Thanks for your efforts to enlighten us. please make same sheet for stocks too

Sir mene apki google seat buy ki lekin woh edit nhi ho rhi hai

Hi .thanks for the video. Did you find any better averaging mechanism or you find 2.5% is working fine? Returns are really good as shown in your video

Sir good enhancements , appreciate your efforts. FIFO sheet kab launch karo ge?

Hey krishan ji....since i am a user of your previous lifo sheet.....inwanted to know before purchasing.....in 3.0 we have limited etf ....i have previously bought etfs. So if i paste in new sheet will things gonna update...or not

Payment done. But didn't receive master sheet link.

Agr atomTice sheet mai apni aap kaam na kra toh kya kra

Annual roi kitna h sir isme if its 18-24% h to ye best strategy h ye

Thank you sir 🙏 me Nov23 se Fire shop with jewelry use kar raha ho abhi tk 12.45% ka gain hua hi to me isi me bana rahu ya ETF shop 3.0 LIFO me shift ho jow.

Hello Krishan! As per the Strategy Rules in the first sheet, Rank 1 to 5 ETFs have to be considered for new purchase. However in the ETF's List sheet, ranking has been done for 20 ETFs. Could you please clarify the purpose of considering 20 rankings?

Sir i have 1 doubt. When u start the etf shop 1st time (like 1st day of buying) then how do we decide to buy etf? If your list is showing X etf as No 1 in buying list but in actual that etf is in profit (not fallen from its 20 DMP) then also we should but it? Or we shuld wait for any etf to fall below 2.5% or 3% and then start my journey of etf buying? Plz clarify

Pl guide. For MTF strategy of Mahesh Sir, which broker is best?

Thanks for sharing this valuable information with us. You mentioned somewhere in the comment that you start monthly SIP whenever any etf average price starts falling down more than 10%. So, what is that SIP amount or percentage which turns out our losses into profits?

Hi Krishan. I am a bit confused. What is the key difference between Fire shop and ETF Shop? Is is just that we buy 3 ETFs per day iin Fire Shop and 1 in ETF Shop? Also the profit booking % is different in both? It will be great if you can reply to this message with 2-3 key pointers which differentiate the both. Thanks!

Thank you !

Super Job! Now that we have a sheet, I don't think it will be too hard to automate the process of scraping excel data and buy/sell using broker APIs. What are your thoughts on this Krishan ji? PS: I am pretty good at coding but relatively new to trading.

Sir I am using an MTF shop with cash plz make a video on that.

Dear Sir, Aaj (Day close hone ke baad) aapki "ETF Shop 3.0 LIFO" ki "Kharida Hua Maal" Sheet me NSE:HEALTHY, CMP 12.1 dikha raha hai jabki NSE ki site me Close Price 11.85 aa raha hai. Kya ye theek hai ? Regards

I want to begin ETF shop journey . Can you pls make a video on how to trade ETF on broker. How one can withdraw dividend and profit out fro the broker.

Dear "Mr. FIRE in India" will receipt/invoice be generated if payment is made ? You are liable to pay taxes on the profit you make. It will attract attention of IT department if rules are violated.

Bahut bahut dhnyawaad sir😂

Do we need delete eft from kharida hua maal once sold? Bcoz even after selling the etf still showing in summary of investment.

Thank you so much sir ji

Sir LIFO 3.0 with Jwell and stock wala kab tak milega

Sir, i bought LIFO sheet for the 2nd time but facing problem in doing make a copy. please help in resolving my problem

Dear Krisha, thanks for your wonderful work. Is this sheet considering the compounding? If it is, then the profit 6% should be different for different rows. Please correct me if I am wrong.

Just paid for the sheet today... However, when I fill the data, the column "Invested amt on this date" is not getting updated... What could be the problem?

Thanks a lot ❤

sir ji master ef list view only hai to usme copy option disable kiya hua hai to kaise copy hoga

The Existing ETF Buy Option is not working if the ETF falls below 3%.

Sir bank data kese update kre monthly base per

Sir mene apki ETF shop wali sheet but karni hai to konsi sheet Theek rahegi?? Version 1 ya 2 ya 3 Please answer

sir maine aapki etf sheet kharidi hai jo ki last update hai 24th march.. kya mujhe etf shop lifo 3.0 fir se kharidni padegi?

Sir, I had purchased your ETF Shop with LIFO sheet in August 2023. Now for your new improved sheet with the same strategy I request you [if possible] to charge the differential amount - not the full amount.

Sir Aap apna ETF trading experience video ke madhyam se bataye Example:- 1. Monthly kitna ETF sell ho jata hai.. 2. Kiya aapka sabhi ETF 6% pe profit book hota hai. 3. Agar koi ETF 6% jada ho jata hai to aap Kiya karte hai. 4. Earning increase karne ke liye kiya karte hai. 5. Aapna trading psychology bataye.. Etc.

Superb Sir Nicely Explain and nicely create Excel sheet most usefull Capital Management Part thank you😇 Sir pls update capital management in consolidated breakout strategy.

Karida Hua Mal Avg LIFO is not highlighting the resent Purchase price.

Hi, i have added 4 ETF from Master ETF sheet like Mafang, bharat 22, hangsang, nasdaq 100 in eTF list page that increased no. Of ETF from 38 to 42, will this work, Thanks

thank you sir, i purchased your latest version LIFO3.0, i wish that in KHM the suggested buying quantity may be included for easy buying for the day.

Sir ji kuch dino se same etf aa rhe h first 3rank main naye etf kab aayenge buy k liye

Just purchased your sst sheet sir how can i add another 200 stocks in your sheet

New sheet me avrej wala kolam purane sheet se mech nahi ho rahi

Why Google sheet shows wrong data of TITAN STOCK

Thanks for preparing the excel with automation which will help in reducing time required to execute. Today I bought your gSheet and excited to start the journey. 😊 I have few questions, please suggest. [1] Apart from capital I want to invest, I have a FD booked for 10 yrs which will give 1lac on 1lac ie 2 lac,should I break that and invest here and its not part of emergency fund? [2] Should i exit from all weather small case and invest here as it has given 20 percent in 1 year? [3] With investment of 10lac, Can this LIFO way of etf shop used for long term wealth generation like my target is to accumulate 1cr I know it gives regular income but my aim is long term Target.. [4] In future if I want to increase investment amount to let say 20-25LAC, will this strategy still worth that time due to high volume trading or it will be risky with this much capital ? Your response is highly appreciated. TIA.

Is sheet for lifetime after buying? Or it has any subscription?