Skip to main content

How to create an OHL scanner in google drive

1. Go to Gmail account >> Click on google apps icon besides setting icon >> Click on Drive icon app


2. Click on New button >> Google Sheets >> Blank Spreadsheet



3. Fill out the first row as shown below:-

Scrip NameLTPOPENHIGHLOWPREV CLOSECHANGECHANGE PCTOHL

4. Get the scrip name list from the NSE website >> Click on the below link and download the latest date excel sheet


5. Copy the symbols from the excel sheet and past them to the newly created excel sheet.

6. Put down the formulas as per column name below:-

LTP : =GOOGLEFINANCE("NSE:" & A3,"PRICE")
OPEN : =GOOGLEFINANCE("NSE:" & A3,"priceopen")
HIGH : =GOOGLEFINANCE("NSE:" & A3,"High")
LOW : =GOOGLEFINANCE("NSE:" & A3,"Low")
PREV CLOSE : =GOOGLEFINANCE("NSE:" & A3,"closeyest")
CHANGE : =GOOGLEFINANCE("NSE:" & A3,"change")
CHANGE % : =GOOGLEFINANCE("NSE:" & A3,"changepct")
OHL Scanner : =if(C3=E3,"BUY",IF(C3=D3,"SELL"))

7. Select all the cells and drag them down so that data gets populated for all the scrips.

This is how you'll create a google sheet in your Gmail drive and it gets automatically updated as per after few times and you can trade as per your preference.













Labels:

Comments

  1. mba1979March 27, 2022 at 2:39 AM

    Hello,
    In A2,A3,A4.... Column I have Script Name Which i have taken from NSE Bhavcopy file when i am typing below commment to fetch Open Price
    =GOOGLEFINANCE("NSE:" & A3,"priceopen") but I get Error #Name? , can you please let me know how to resolve it Miteshbhai??

    ReplyDelete

Post a Comment

Popular posts from this blog

My Intraday Trading Setup for Stocks!

This setup I have taken from the internet means I have not paid anyone for this and I tested and then modified it according to my personality and preferences related to timeframes and different indicators from which I get good results. And also risk management and position sizing is an important aspect too. You can test and modify according to your personality that is why the time frame and indicator selections are up to since I will not enforce anything on you by saying that this will work or not work or it is a very profitable set-up.  My Intraday Trading Setup:- For Long:- Above VWAP, Range breakout(S&R)-Previous day High & Low, EMA Cross(9/10,18/20) & Supertrend. Previous candle high should be broken then Enter. For Short:- Below VWAP, Range breakout (S&R)-Previous day High & Low , EMA Cross(9/10,18/20 ) & Supertrend. Previous candle low should be broken then Enter. For Entry:- Look for 1/3/5 min TF and for TSL look for 3/10/15 min TF.{In multiples of...
Post a Comment
Read more

Mitesh Bhai Gyan

For intraday 3 min charts For positional at least 30/75 min charts First look at daily charts and find direction. Then look at 60 min chart and find support and resistance and then find the intraday trend and then Thoko.(Daily>60min>3min>Execute) The biggest mistake of every trader is that they are predicting target and taking trades based on target and that's view is preventing  them to change as per market direction. Manage position w.r.t market movement, Deploy capital in phase manner 25-50-75-100%. Play straddle only when VIX is low, Intraday is different. I do for positional. For Intraday you have fixed SL, you can use capital as per your risk. Identify last week range if in current week BN trading near low range sell only calls. If trading near high sell only put. If trading in between range sell both call and put. Strike to sell - select at least 1-2% away strike from high/low range if BN trading in middle If near high sell put at last week low strike. If at low sel...
Post a Comment
Read more

Mitesh Patel: The angry young man of options trading tips & tricks

 Mitesh Patel: The angry young man of options trading tips & tricks -The main lesson that I learned from the book was not to sell short when the market is in an uptrend or  to buy when the market is in a downtrend. -In a rising market, the stop loss was kept below the previous low while in a falling market it was above the previous high. -My next step was to mix technical analysis with options selling. I used the support and resistance points to initiate a trade.  -If the market moved higher after testing the support levels, I would sell the puts,  and if it fell after testing the resistance levels, I sold calls. -Only if it lingered between the support and resistance line would I create a short strangle trade. -Suppose the Bank Nifty reverses from a support level at 26,500, I will sell a 26,200 Put.  The strike on which I trade has to be 1 percent away from the support or resistance level.  If the Bank Nifty is breaking the previous trend, I will cut m...
1 comment
Read more