How to Use Google Sheet for Intraday Trading with Live NSE Data?
HTML-код
- Опубликовано: 30 окт 2020
- This video is titled as - ‘How to Use Google Sheet for Intraday Trading with Live NSE Data?’ As the name suggests, the video explains the ways to Use Google Sheet for intraday trading with NSE live data. As traders know, doing intraday trading with NSE live data is very hard unless you have proper tools to do that. Google Sheets can draw live NSE data from Google Finance. Therefore automatically the question arises, how to use Google Sheet for intraday trading with live NSE data?
This video will take you step by step to create own intraday trading calls using simple open-high-low-close data. The trading system will help you create your own Google Sheet for intraday trading with live NSE data. You will know which stocks have opening price=high and opening price=low. If open=high not breached after some time, the stock will probably come down intraday. Similarly, open=low means the stock price will move up during the day, if the day low is not breached. Your Google Sheet will help trade intraday giving valuable inputs. You can set the system to fetch NSE live data into Google sheet live every minute. The data will get refreshed every minute. So trade and enjoy it.
----
Google Finance Doc Editor's Help: support.google.com/docs/answe...
----
Join Zerodha under me: www.stockmaniacs.net/recommen...
----
Join Alice Blue under me: www.stockmaniacs.net/recommen...
----
Join Angel Broking under me: www.stockmaniacs.net/recommen...
----
Join 5Paisa under me: www.stockmaniacs.net/recommen...
----
Join StoxKart under me: www.stockmaniacs.net/recommen...
----
Join Upstox under me and avail the offer: www.stockmaniacs.net/recommen...
----
Join Fyers under me: www.stockmaniacs.net/recommen...
----
Join my trading team and get my special guidance: www.stockmaniacs.net/join-us-...
----
Download my Hot Tips App from here: play.google.com/store/apps/de...
----
And Follow Us At:
----
Website: www.stockmaniacs.net/
Twitter: / stockmaniacs
Facebook: / stockmaniacs
After a long time i found to update the 1 minute update on my sheets , thank you. and you got my subscription
Awesome, thank you!
@@IndrajitMukherjee , THE ONLY CHALLENGE I AM STILL FINDING OUT IS TO FIND THE RIGHT STOCK TO TRADE ON DAY TRADING.
It was explained in a nice & simple way, thanks
Glad you liked it
Salute to you Dada...Well explained and made it so simple...Thanks
Welcome.
Thanks for this wonderful video.
Glad you enjoyed it!
you are a true genius, many thanks, may god bless you and may all your dreams come true!!!
You're welcome!
Fantastic sir. Long long waited requirement for me. Thank you very much. Nice video and great step by step explanation. Kudos to you. Banknifty is not displaying. Changed nifty index as nifty_50 and it works. Please advice for banknifty.
Nifty_Bank
too much clever thanku so much....it's really helpfull
Welcome
NICE WORK,THANKS
No problem 👍
Great information 👍
Glad it was helpful!
Thank you. managed to setup the sheet after viewing a few times. a request, if you can do away with the "yellow cursor" in your video. would help.
Sorry about that
Very good Demo.
I have done this.
Good
a perfect tutorial
Thanks
Very very nice work
God bless you
Thank you! Cheers!
good video sir, thanks
So nice of you
Thank you for sharing knowledge.. I am facing issue to pull Nifty and Bank Nifty data.. Rest data is appearing fine. Please help me to fix this or suggest some alternative if data is no longer available using this method
INDEXNSE:NIFTY_50 & INDEXNSE:NIFTY_BANK
I am facing problem in opening your app..We have to open a dmat account in the link, then only we can operate the app?
Yes you are right, whatsapp your name, mobile number and email to 9674321856
How to get the IntraDay stock high-low, open-close and volume for every 5 min for a given date ?
Need to use Python
Earlier we use to pull option chain as well thru Google Sheets. But now it's not possible. Do you know any method to pull option chain in Google sheets without coding or python?
Thanks
Tricky process
Hi, How can I pull all the NSE stocks data instead of selecting Nifty 50 and other indices. Thank you.
NSE:RELIANCE or NSE:ACC etc
Sir pls help in highlighting the LTP colour if it is 52 wks high, similarly for 52 wks low
Ok next time.
How to get open high low close data of say 5 minute data to google sheet for a single scrip? Also can we get the data for futures?
Hmm need to check.
Dada: Why dont you have this sheet uploaded on your website for free download for your youtube family members. Also if option chain of Nifty & BN can be automated, it will be great. Thanks for the video.
Well I tried to teach how to catch a fish.
Checked the live nse now. The data is not getting updated live. There is a delay of min 2 minutes for some shares and more than 10 mins for many shares. Please suggest to get the live data. As you said, for nse the data will be instantaneous.
Google claims there NSE data is live.
good video
Thanks for the visit
Sir i want to how to make file which has all intraday price for one particular security ... i know we can have live data but how to store that live data for each instant ( as it is require to do statistical analysis )
I feel you need some macros for that.
I compared price with google & broker's site. I find that the data is delayed. Is that so ?
NSE real time.
@@IndrajitMukherjee
This is very very useful & very simple.
Many thanks sir. 👌👍👍👍
How can i import commodity data such as Silverm futures data in google sheet
Try your broker's API and Python
Unable to fetch 6month high and low data. Would be helpful if you can help me with the formula
Next time will show you how to do it.
Sir how to add moving average nearby ? Like near 50 EMA or 200 EMA or 50,200,100 SMA?
Easy. Will show you soon.
hi, i want all NSE stock data into my gsheet, how do i do? please let know that too. thanks
You need to repeat same for each stock
Google finance can't fetch Some stock data like UPL and GLAND. Can anyone tell why?
Try NSE: UPL and NSE: GLAND
@@IndrajitMukherjee Tried that already... no luck..😒
Need a help. How do i see LIVE chart in Google Sheet similar to how we see in any brokerage terminals Can you pls. show that?
You need to run a macro. Its not easy for common people
Excellent sir. Can you plz make a video on "how to extract live data in Excel from Alice blue platform".
Will check.
how to get pre open market data for nifty 50 stocks at daily 9.10 am?
Need to check. But you can get it in your broker's terminal.
But Live data is not pulled in google sheet...it takes more than 10 minutes to update close value🤔...how to pull close price each 1 minute??
In that case you need Python
i only want 11200 ,11300 call and put option contract so which code ia requrd can you please help me with this ..????
Options data from google finance is not possible. For that other trick is there.
Respected Sir please help i have two problem
1) how to bring all 1680 NSE listed companies in single Excel file?
2)how to set cookie permanently to solve recurring connection problem ?
1) You will get list on NSE site.
2) In google sheet there is no cookie issue. Coz data comes from google finance.
WHAT I SHOULD TYPE FOR BTC/USDT, ETH/USD THIS??anyone suggest
Will check
i have been doing it, but the data is END OF THE DATA, and that is also delayed. how can you get real-time data
End of day data is delayed? How come? Means you are getting the data next day?
@@IndrajitMukherjee Yess. EOD data upadted after 12 PM. I am making a system for character analysis. Is there another way.
Please sir make a video on Banknifty weightage calculation on Excel sheet ?? For e.g - Hdfc bank 1 point move korle banknifty koto point barbe...
Lets see
Sir not able to fetch the data with nsenifty please help with google symbol..
Check older comments
How to get intra day data? Can we also get options and futures data? Please make a series of videos on this
You are getting intraday data only. Futures data from google finance is not possible. For that other options are there
NIFTY AND BANK NIFTY ARE NOT SHOWING THEIR VALUES ON MY SHEET??? IT'S COMING N/A. ANY KIND SUGGESTIONS????/
Go through the previous replies. Solved.
SIR AS WE SAW HERE HOW TO GET DATA OF PRICE, CAN U EXPLAIN HOW TO GET DATA OF VOLUMES ON GOOGLE EXCEL IN LIVE MARKET, THAT IS TOTAL BUY QUANTITY AND TOTAL SELL QUANTITY. KINDLY WAITING FOR YOUR REPLY.
Volume you can see, but buy and sell volume differently is not possible.
Sir for Stocks we are using NSE:RELIANCE. For indices what we can use to see live data in excel: example NSE:BANKNIFTY, NSE:NIFTY50, it is not working
INDEXNSE:Nifty_50 and INDEXNSE:Nifty_Bank
@@IndrajitMukherjee I think its better to add this disclaimer in the video description itself. I was also stuck on this for some time and I see there are many questions around this. BTW this was a nice and informative video. Keep them coming.
Sir, Please make video how to pull Nifty Option Chain Data in Google Sheet.
Ok later and this technique is tricky now.
good one What is the formula to get 5 minute data real time of nifty
From google it is tough
Thanks Dada...can you share how to add indicator value in this file..
Will upload soon
How to get for nifty 50 or nifty bank....i tried with nifty_50 its not working
Check older comments
sir you show how to create google sheet, but not show how to trade with open high low stocks with help of google sheet
For that I have seperate videos and blog posts. Read www.stockmaniacs.net/open-high-low-same-trading-strategy/
NOT SHOWING OPEN/HIGH/LOW/CLOSE NIFTY/BANKNIFTY BUT OTHER STOCKS OK PLEASE HELP ME
Read earlier comments. Solution given there. INDEXNSE:NIFTY_50 and INDEXNSE:NIFTY_BANK
how can we pull out option data in google sheet
Tough now.
Dear Sir,
how can we get "Symbol" from any share company full name? e.g.- if name is "Punjab National Bank" than how can we convert into "PNB" symbol , plese clarify...
NSE:PNB
No...no...no...
I want google finance formula
To convert company name into symbol
how to do for fno stocks???
Add all FNO stocks in the same way.
It s not fetching live data.... How much delayed it will be
Not much gap in NSE
Pls Make a video to get data for many days of a particular stock.
Ok you mean historical.
HOW TO GET CLOSE PRICE?? BECAUSE IF I CHOOSE PRICE THEN I AM GETTING LTP, BUT I WANT CLOSE PRICE, HOW TO DO THAT?
What is the difference between LTP and close price? If you want close price of last day then use CLOSEYEST
How can i buy and sell from within google sheet. any chance?
Need to check
Please highlight open = low & open=high formula
Ye android main kaam karega kya?
Yes hope so.
How to get live option chain for nifty
Tough in GSheet
What is the use of delayed data in intraday ??
Why delayed. Google to NSE is live.
Sir can i see live volatility in google sheet?
I feel you can check India VIX
Can we import option chain
Yes but no easy method.
SIR, I DIDN'T GET DATA FOR NIFTY &BANKNIFTY INDEX
INDEXNSE:NIFTY_50 and INDEXNSE:NIFTY_BANK
Please load the ticke for any days low of nse syock
Same way, use symbol GOOG, MSFT etc.
Waiting for part 2
Sure
@@IndrajitMukherjee Part 2 is created? if yes, please share link
SIR,
WILL YOU PLEASE SHARE HOW TO GET OPTIONS CHAIN DATA IN GOOGLE SHEET.
Cumbersome process. Not easy anymore
Good morning,
=GLEFINANCE("INDEXNSE:" & "NIFTY","PRICEOPEN") not working since last 1month, kly correct my function formula
Entire formula is wrong. Watch my video carefully. Try replacing NIFTY to NIFTY_50.
@@IndrajitMukherjee Thanks, using NIFTY_50, I am able to pull the data.
Banknifty formula is still not working
But sir this data are delay 20 min According to market time , so there is anthor way to get exact time data in google sheet
NSE data almost live. BSE data can be delayed.
Nice work !! But still I donot trust Google data. It says Nifty_50 52weeks high is 30,892.40 :)
Ok
Google sheets not working carrent time
Yes it works.
Sir ...
Data are stable..
Infect i chang location india and resfresh time 1 min..
But it dosent work
😑
Data is coming at my end. Not heard any issue with google.
how to pull out option chain in google sheet
Tough now.
We have to refresh every time or data will change automatically
Will change auto as per your sheet settings.
@@IndrajitMukherjee sir i am also indian and i changed spreadsheet setting as you done in video... i am watching my google sheet since morning but no any auto change in data...
SIR HOW TO get VWAP data from NSE ?
Let me check.
sir if i want 11200call value so which code required....
Options data from google finance is not possible. For that other trick is there.
@@IndrajitMukherjee ok so can u please make a video that how to pull option data atm strike prive call and put value ...because i trust on u and your skill is also amazing
Do you say Google 'shits' on purpose? If Google shits, I am sure it will do so on a sheet.😉😉
In any case, very nice video...learned a lot. Thank you for your efforts.
Sheet is singular sheets is plural. At this moment cant remember where I told an extra s. But definitely no connection with shit :)
sir how to open option chain in G sheets
Ok that is tough now. Needs Python knowledge.
Sir delivery dekhne ke liye Kya likhenge?
Doosra video banayenge.
Sir 20 day high low & 50 day high low kaise show kare isame
I will check
HELLO PLEASE CAN YOU SHARE THE GOOGLE SHEET LINK
Its no special google sheet, just shown how to create it.
How to fetch data of pre open market
I have a video for that. But in google sheet tough
@@IndrajitMukherjee can u share the link of that viddo
Sir, how to create LIVE total Open Interest OI data GRAPH (BAR CHART) in excel sheet or any other?? please guide
Complex process now after NSE new website.
SIR GOOGLE EXCELNSHEET ME STOCK ME FORMULA LAG RAHA PER NIFTY/BANK NIFTY FORMULA NAHI LAG PAA RAHA HAI
INDEXNSE:NIFTY_50 and INDEXNSE:NIFTY_BANK.
Thanks sir 🙏
Make video on Option chain in google spreadshert
NSE blocked that now.
Sirf EOD kelia hi hai ye??
Ha kar sakte hain
Nice tutorial, but this data is delayed up to 20-minutes and is not real-time data.
For Indian market it is real time.
Wow wonderful. U r revolution in youtube stockmarket education like how zerodha is revolution in broking industry. Awesome sir.
Is there any furtherway we can trade directly from this sheets using kite connect? If yes plz make one video on that one.
I feel no way. Let me check.
Nifty , bank nifty price Google formula please
INDEXNSE:NIFTY_50 & INDEXNSE_NIFTY_BANK
@@IndrajitMukherjee sir thank you
If nifty future formula available please send me sir. If formula not available, leave sir .. thank you sir
Data get very low speed..intraday not poosible with this
I will show you more hacks to get the data fast
Arey dada it takes 2 minutes to make this screener in chartink.com
🙄🙄🤦♂️🤦♂️
Yes I know, but its delayed data. Anyways G-Sheet has its own applications.
@@IndrajitMukherjee only 5 minutes for free account and 1 minute data if you have paid account. not a bad deal dada.
@@IndrajitMukherjee Google sheet also delayed data from NSE.
The data is not LIVE. There is a 15 - 20 minutes delay even with the calculations set to refresh every minute.
India its live
google spred seet GOOGL EFINANCE LOADING LONG TIME ?
Check your formula
BUT SINCE WE ARE PULLING THE DATA FROM GOOGLE FINANCE, IT IS UPDATED EVERY 20 MINUTES ONLY, SEE BOTTOM OF GOOGLE SHEET.
Indian markets its live
Not working
Working brother
@@IndrajitMukherjee Iit shown error that exchange is not allowed to Google sheets to extract data
Mobile me ?
Yes in mobile too. But best in PC
मेरे पास मोबाईल है
मेरे दोस्त ने मुझे उसके लिए आपको आप मे Google Financiase sheets dikhaya उसे शेअर मार्केट रिसर्च करणे मे और डिसीजन लेना मे बहुत आसान हो रहा है लेकिन मेरे पास लॅपटॉप कॅम्पुटर नही है लेकिन मेरेको उसको फॉर्म्युला मोबाईल का युज करना है तो नही कर रहा हु
मैने आपके चैनल को सब्सक्राइब किया है कृपया आप मोबाइल के अंदर कैसे युज करते है इस बारे में व्हिडिओ बनाये लॅपटॉप मौत से ऐसे लोगों के पास लॅपटॉप नाही आप मोबाइल के अंदर कैसे युज बताईये
Please make a video using Excel.
I believe there is a delay in Google sheets
G Sheet for NSE is live. Also excel video is there, search in my channel.
@@IndrajitMukherjee THANK YOU but in my sheet the NSE feeds are updating the next day it is not happening automatically . can you please help
Work smart,not hard,OHL is available online on daily basis 😉
Well all is not so smart like you and all has own application. This is a building block, for leaners. Smart can excuse me.
OHL is available where? And any easy way of doing it without much effort? Any screener which you can recommend - Rashid ji?
This is not live data , this may lag upto 20 minutes 😔
NSE is live
@@IndrajitMukherjee NSE data is live but the data we get in Google sheets are not live
Kuch bhi video bana diya.....
Samajh me ana bhi chahiye Das Babu.