Select intraday best stock before one day excel formula

Best Intraday Stocks Selection Before One Day Excel Formula. The formula that how to PIVOT point, Support1 (S1) and Resistance1 (R1) by excel formula.

Download CSV Zip File: https://www.nseindia.com/products/content/equities/equities/archieve_eq.htm

----------------------------------------------------------------
Excel Formula to Select Best Intraday Stocks Before One Day:-
-----------------------------------------------------------------

HI ALL TODAY I WILL TELL YOU HOW TO SELECT STOCKS BEFORE ONE DAY FOR NEXT DAY INTRADAY TRADING
1. FIRST OPEN NSEINDIA WEBSITE.
2. THEN FOLLOW THE PROCESS TO DOWNLOAD THE TODAY WHOLE DAY STOCKS COMBINED EXCELSHEET.
3. CLICK ON HISTORICAL DATA
4. DOWNLOAD THE BHAVCOPY FILE AT 6:30 PM IN THE EVENING FOR THE WHOLE DAY.
5. EXTRACT THE DOWNLOADED FILE.
6. THEN OPEN THE EXTRACTED FILE.
7. DELETE THE UNWANTED DATA FROM EXCELSHEET.
8. NOW FOLLOW THE FORMULA PROCESS.
SEE HOW TO PIVOT S1 (SUPPORT1) AND R1 (RESISTANCE1) FROM FORMULA IN EXCELSHEET.
A. PIVOT =(HIGH+LOW+CLOSE)/3 THEN ENTER
B. S1 =(PIVOT*2)-HIGH THE ENTER
C. R1 =(PIVOT*2)-LOW THE ENTER
9. NOW WE WILL COPY FORMULA AND PASTE FOR THE ALL STOCKS PIVOT, S1 AND R1.
10. SELECT THE ALL PASTED FORMULA ROW AND CONVERT IT INTO LIKE TWO DIGITS AFTER POINT LIKE .00
11. COLOUR THE PIVOT AND CLOSE IN YELLOW COLOUR FOR KNOWLEDGE
AND R1 AND S1 IN GREEN COLOUR.
SHORT THE SHEET ACCORDING TO TRDVAL LARGEST TO LOWEST
AFTER ONE BLANK ROW JUST TYPE =CLOSE-PIVOT
PAST FOR TOP 100 STOCK ONLY
AND CHECK THE MAXIMUM DIFFERENCE STOCK
WI WILL TAKE ONLY THE MAXIMUM DIFFERENCE STOCK FOR NEXT DAY.
TRY TO CHOOSE FOUR OR FIVE STOCKS ONLY, BECAUSE IT WILL DIFFICULT TO YOU FOR THE NEXT DAY TRADING TO EYES ON MAXIMUM STOCKS.
NOW USE FILTER ACCORDING OUR BUY CATEGORIES STOCKS WHICH IS (Y)
I HAVE CHOOSEN NINE STOCKS FOR NEXT DAY INTRADAY TRADING

NOW THE MOST IMPORTANT TASK THAT HOW WE WILL DECIDE TO BUY AND SELL AND WHAT WILL THE STOPLOSS AND TARGET.
WHEN WE WILL BUY

WHEN THE MAXIMUM VALUE BETWEEN PIVOT AND CLOSE BREAK THEN WE WILL BUY STOCK LIKE THE RELCAPITAL MAXIMUM VALUE IS 161.35 THEN WE WILL BUY WHEN BREAK 161.31 AND OUR STOPLOSS WILL BE S1 AND OUR TARGET WILL BE R1

WHEN WE WILL SELL STOCK

WHEN THE MINIMUM VALUE BETWEEN PIVOT AND CLOSE BREAK THEN WE WILL SELL AND THEN OUR STOPLOSS WILL BE THE MAXIMUM VALUE BETWEEN PIVOT AND CLOSE AND OUR TARGET WILL BE S1

REMBER THE MINIMUM VALUE BETWEEN PIVOT AND CLOSE BREAK, THEN WE WILL USE FOR SELL.

FOR EXAMPLE RELCAPITAL STOCK THE MINIMUM VALUE 155.32. WHEN IT WILL BREAK WE WILL TAKE SELL POSITION AND OUR TARGET WILL BE 146.63 AND OUR STOPLOSS WILL BE 162.00 (TAKE 50 PAISE OR 1 RUPEES MORE THAN THE VALUE FOR STOPLOSS O 161.32 WAS I HAVE TAKEN 162 FOR STOPLOSS.

SO THIS IS THE FORMULA FOR SELECTING STOCKS BEFORE ONE DAY.

I WILL GIVE THE FORMULA IN DESCRIPTION FOR PIVOT, S1 AND R1.

THANKS FOR WATCHING MY VIDEO PLEASE SUBSCRIBE AND LIKE MY VIDEO.