Sunday, October 10, 2021

Bottom Out Hunting Method with Automated Google Finance Sheets

 The first method of bottom-out hunting:- In the first method of bottom-out hunting we buy a stock that recently make his year low and recover 20% from year low. Watch this video for a deep understanding of the first method of bottom-out hunting.

Video link:- https://www.youtube.com/watch?v=XzsihlnyW4o

The target of 1st method stocks:- 5% to 10% from buying price.

Google Sheet Link for 1st method:- Here is the link of automated google finance automated sheet which suggests starting GTT in stock when stock recover 10% from a recent year low and suggests buying when stock cross 20% upside from his recent year low (GTT price 20% up from recent year low):-

Fast Loading Web Page View:-

https://docs.google.com/spreadsheets/d/e/2PACX-1vSkeHarbDMIVIevDepW7bRLCyJXDsjDyPNg6n3txF6s3_vvgliV7MzZKqItb7EtlXjC2VKufk8r0zHH/pubhtml

Raw Sheet With Formulas Slow Loading:-

https://docs.google.com/spreadsheets/d/1_h-cUfV_qBuxVaiQWPkgQiXSM35844KGDw9aKdQkdRo/edit?usp=sharing

Stop-loss in 1st method stocks:- I do not recommend investing a huge amount in a single stock and also not suggested any stop loss. In my method invest, 1/3 part of your total investment amount for a single stock and if your stock fall then instead of using stop loss wait for 20% or more fall, after 20% or more fall from average price use bottom out hunting method again and average out that stock with the same amount. (wait for 20% fall, Average out with the same method means to wait for 20% recovery from the year low, average out with the same amount which you invest in first buying. this time target is 5% to 10% from average price).


If you invest only in Nifty 50 stocks, Bank Nifty stocks, Nifty 100 stocks, PSU Stocks then no need to use stop loss, and in maximum 3 average out you may get a profitable exit in any condition but if you trade in small caps and invest huge amounts then the super stop loss is best for you. watch this video for super stop loss:- https://www.youtube.com/watch?v=uE6ZUds_9SQ

The second method of bottom-out hunting:- In the second method of bottom-out hunting we buy a stock that recently make his year low and recover 40% from year low. Watch this video for a deep understanding of the second method of bottom-out hunting.

Video link:- https://www.youtube.com/watch?v=XzsihlnyW4o



The target of 2nd method stocks:-  15% to 20% from buying price.

Google Sheet Link for 2nd method:- Here is the link of automated google finance automated sheet which suggests starting GTT in stock when stock recover 20% from a recent year low and suggests buying when stock cross 40% upside from his recent year low (GTT price 40% up from recent year low):-

Fast Loading Web Page View:-

https://docs.google.com/spreadsheets/d/e/2PACX-1vRAcvR8mBqPHC9CUQba3SZG6WhT0R9NV1bo4G5thxrOJDmWrbyFxLkG-pKcKrQ9NHMhn1u-c1OLgPnJ/pubhtml

Raw Sheet With Formulas Slow Loading:-

https://docs.google.com/spreadsheets/d/1crdmT53dH7xh4-Yx-Pi3EYbZoFeCNqTe3YXow_hL4hw/edit?usp=sharing

Stop-loss in 2nd method stocks:- I do not recommend investing a huge amount in a single stock and also not suggested any stop loss. In my method invest, 1/3 part of your total investment amount for a single stock and if your stock fall then instead of using stop loss wait for 20% or more fall, after 20% or more fall from average price use bottom out hunting method again and average out that stock with the same amount. (wait for 20% fall, Average out with the same method means to wait for 20% recovery from the year low, average out with the same amount which you invest in first buying. this time target is 5% to 10% from average price).

If you invest only in Nifty 50 stocks, Bank Nifty stocks, Nifty 100 stocks, PSU Stocks then no need to use stop loss, and in maximum 3 average out you may get a profitable exit in any condition but if you trade in small caps and invest huge amounts then the super stop loss is best for you. watch this video for super stop loss:- https://www.youtube.com/watch?v=uE6ZUds_9SQ

(Stocks automatic generated in the above sheets not considered as my research report or recommendation)

Discloser:-

I Mahesh Chander Kaushik, owner of this automated sheet am an existing research analyst and passed NISM certification for research analysts. I have also registered under SEBI(RESEARCH ANALYSTS) REGULATIONS, 2014 ( SEBI Registration Number INH 100000908 ) hereby disclose my financial interest in the subject companies and the nature of such financial interest:- 1 These are automated sheets which chose stocks by formulas so these are not considered as my recommendations and me and my associates or relatives also using this sheet for selection of short term trading stocks, so my personal interest is included in all of these automated chosen stocks. 2. Me and my associates or relatives have not any actual/beneficial ownership of one percent or more securities of any companies recommended in this sheet. 3. Me and my associates or relatives have not any other material conflict of interest at the time of publication of the automated sheet. 4. Me and my associates or relatives have not received any type of compensation from the subject companies in the past twelve months. 5. I am not served as an officer, director, or employee of the subject companies. 6. I have been not engaged in the market-making activity for the subject companies.

Saturday, March 6, 2021

Sharegenius Swing Trading Method of Mahesh Kaushik With Automated Google Finance Sheet.

Sharegenius swing trading method rule:- 
1. Plan to buy a stock when it is traded on 20 days low. 
2. Our google finance sheet automatically detects stocks which 20 days low=today low 
3. When today's low is equal to 20 days low then we do not immediately buy that stock, instead of immediately buying we start a GTT order at 20 days high of that stock. 

4. Once the GTT order is started then we need to update the trigger price regularly with 20 Days High. 
5. Do not worry my google finance sheet automatically shows 20 Days high as GTT trigger price so no need to calculate 20 days high manually. 
6. When your stock starts an upward movement and makes a fresh 20 Days high then your order is triggered and you buy that stock at the best price. 
7. Now our target is 20% 
8. in 70 % of cases we got this target within 2 to 20 days. 
9. if stock fall again then instead of stop-loss we again follow this method, when stock again reaches on 20 days low we start the GTT system. 
10. if we average out stock then reduce our target as below:- 
 1. First buy=20% 
 2. after 1 time average=15% 
 3. after 2 average=10% 
 4. after 3 average=5% 
If we follow this system only in the blue-chip like Nifty 50 stocks, ETF's, Nifty 100 Stocks, Nifty 200 Stocks then I am not found any stocks which need more than 3 average. 
11. Automated google finance sheet for this system:- Fast Loading web page view:- 
12. Watch this video for more understanding:-

Update:- If we mix this system with Bottom out hunting filter then it is safer in any big market fall watch this video for making advanced google sheets for this system:-


Matched Content

My Youtube Channel

Blog Archive

हिन्दी वेबपेज आफ महेश कौशिक डाट कोम