HomeОбразованиеRelated VideosMore From: Intraday Trading Strategies India

How to import NSE data in to Google sheets (Excel) and How to make your own strategy step by step

947 ratings | 60934 views
How to import NSE data in to Google sheets (Excel) and How to make your own strategy step by step How to import NSE data in to excel. https://support.google.com/docs/answer/3093281?hl=en&pageId=116289528119519991666 thenexttrade.com https://www.facebook.com/Intradaytradingstrategiesindia/?ref=bookmarks Futures and options hedging strategy for intraday trading (Risk Free) https://www.thenexttrade.com/options-strategy Options Trading Videos https://www.youtube.com/playlist?list=PL0ITu5YXje8ksPtWzxAnGkE6TuwONVc_q Subscribe to Channel https://goo.gl/UXIAQP -~-~~-~~~-~~-~- Please watch: "Goodwill commodities trading account " https://www.youtube.com/watch?v=65m25J69h5Y -~-~~-~~~-~~-~-
Html code for embedding videos on your blog
Text Comments (256)
Futures and options hedging strategy for intraday trading (Risk Free)https://www.thenexttrade.com/options-strategy
Saaty Revive (9 days ago)
Unable to continue my work. As I am getting an error in OPEN , HIGH, LOW, PREV CLOSING coloumn. error message : Function GOOGLEFINANCE parameter 2 value is invalid for the symbol specified. please reply
SHIV SANGADE (11 days ago)
Really helpful video,Thank you
Aman Sharma (17 days ago)
Nice video sir
GODHANI NIKHIL (1 month ago)
sir what is a refresh rate and in my sheet data refreshing at an interval of 15 to 30 min can I increase the refresh rate
Tony John (1 month ago)
Thank you sir. Great work
Dipankar Biswas (1 month ago)
Hiii. Your tutorial is awesome actually great..a very little bit query about this thing .. how to make code for .. last month, last week, and last day opening and closing market price.. can you please help me out..
Dipankar Biswas (1 month ago)
awesome
surinder matharu (1 month ago)
how can i get EMA's imported in google spreadsheets. like 21DEMA, 50DEMA, 100DEMA. Any help would be really appreciated
HowToExcel (1 month ago)
Just what I'm looking for. Great explanation.
milan kakkad (1 month ago)
how to find settlement price instead of close price. because as we write "price" it shows LTP not Settlement price at end of day. so, please try to help it.
Utpalendu Deb (1 month ago)
Great to know this feature. Thanks a lot.
Akshay Shirke (1 month ago)
CREAT CODE FOR LAST DAY OPEN CLOSE HIGH LOW VOL AND SAME FOR DAY BEFORE YESTERDAY AND GO ONE
Shashank H (1 month ago)
Thanks and God bless you brother
Kireet Butail (2 months ago)
Thanks!
Celebrity Kids (2 months ago)
Great work sir...Thanks for sharing knowledge.
Ajit Prasad (2 months ago)
It is not working in excel 2016.tell me how to use
Aarya Devarla (2 months ago)
Well explained. May god bless you. How can we do the same with MS EXCEL?
vishu1r (2 months ago)
Pls tell me how to update the option chain data in Excel sheet with Volume, OI & IV
Nilesh Bhoir (2 months ago)
Excellent sir Many Many Thanks to You
Dv Abhi (2 months ago)
Already subscibed bro...thanks thanks ton of thanks brother
Why sad (3 months ago)
20 minutes diley kyu rahta hai?
Amit kumar (3 months ago)
thank you sir for valuable support for us
rahul bhatnagar (3 months ago)
Thanks for sharing useful information. But some how any of "return" attribute is not working....can you suggest please.
Ks Kannan (3 months ago)
For Amibroker free live data feed settings call 9633623203
Manju Shimpi (3 months ago)
Thank you, how to add nifty IT. auto etc index?
Flotery Extadives (3 months ago)
Thanks sir, Do these data update daily?
yanejay (3 months ago)
How to add daily volatility in Google Sheets? I could not find attribute.
Vishwanath SiddAanNavar (3 months ago)
THANK YOU SIR WHERE IS NEXT VIDEO
Artatran Biswal (4 months ago)
How to import graph from nse
mohanasundaram marimuthu (4 months ago)
REALLY SUPER, YOU ARE REALLY GREAT MASTER
Saurabh Mahajan (4 months ago)
WE CAN DO SIMPLE EXCEL SHEET OR IN SOMETHING ELSE LIKE GOOGLE SHEET?
Jai Sankar (4 months ago)
I tried but it is showing delayed value. How can I bring real-time value? If I am looking sheet at 10am it is showing 9.50 only
Sreenu Vasan (4 months ago)
FOR WEEKLY HIGH AND WEEKLY LOW PRICE VALUE?
Jitendra Bapna (4 months ago)
Thanks a lot for this wonderful training video.. what should we write in ticker name for derivatives future & options..
alugunoori (4 months ago)
GREAT TO SEE VIDEO, THANK YOU. PRASANNA, WARANGAL, TELANGANA STATE
DIPIN C (4 months ago)
Sir can u please upload the support resistance strategy in excel sheet? Thank u great work
bala subrahmanyam (5 months ago)
this is not from NSE, it is from google finance
Shiva Putra (5 months ago)
Sir live data is not updating
Premlata Rajesh (5 months ago)
Thanks for this great and informative video. I think the google data is delayed up to 20 mins. How can we get the live quotes directly from NSE website using similar approach? Is there any google or excel function for this?
Swarup Sen (5 months ago)
Hi, my question is can we do something so that price will get refreshed automatically? Thank you.
Shivu Barbare (5 months ago)
it is not getting data from NSE even i made same formula
Shivu Barbare (5 months ago)
Very useful video .. sir thanks
Gopala Krishna (5 months ago)
Very good explanation
kkrao Rao (6 months ago)
How to do AMFIINDIA NAVs download of a particular date?
Jit Sahu (6 months ago)
great work sir.
Alisagar Jiruwala (6 months ago)
Hello sir Thank for making Video..now How can I fetch future and option data from NSE to Google sheet ?
Alisagar Jiruwala (6 months ago)
No future data like sep expiry data of cipla or any stock
https://youtu.be/zNfdCBiPfAQ
Naveen Pasem (6 months ago)
Very Nice and useful information , could you please let me know how to add Volume Jump and Open Interest Increase/Decrease
uttiya banerjee (6 months ago)
Excellent Sir.One small problem, I am not being able to fetch the tickers(i.e. names of stocks)from NSE to Google Sheets in separate rows.All are coming in a single row. Pls suggest,to overcome the problem.
Debjit625 (7 months ago)
Thank man
Kuldeep Kumar (7 months ago)
sir i am unable to load it
Decorex Jpr (7 months ago)
Thank you so much sir for sharing the video and spreading knowledge... Could you pls share how to get nifty and bank nifty index data?
Deepak Korgaonkar (7 months ago)
How to add alerts ..?
Manohar Mahato (7 months ago)
Volume average and Beta are not working. Could you help
Gokul Prasad (7 months ago)
Great Video 👍👍👍
Nikhil Joshi (7 months ago)
THANKS FOR THE VERY INFORMATIVE VIDEO SIR WHAT IS THE SCRIPT FOR YESTEDAY LOW?
YESTERDAY HIGH          "high",TODAY()-1,TODAY())  YESTERDAY LOW             "low",TODAY()-1,TODAY())
Harsimran Singh (7 months ago)
very useful information, thank you sir.
Ssunnel (7 months ago)
SIR , HOW CAN I CREATE ""OPTION CALLS - CE AND PE " LTP" PRICE IN EXCEL SHEET WHAT IS THE FORMULA FOR EXAMPLE:(NIFTY18AUG9100CE)
yogesh sonthalia (7 months ago)
SIR HAM APNA MUTUALFUND PORTFOLIO BHI KYA EXCEL PR AISE HI CREAT KAR SAKTE HAI
Hasmukh Prajapati (7 months ago)
pls share your number i am having some doubt
dinesh kumar (7 months ago)
Marvelous job... Thank you
Piyush Kumar (7 months ago)
SIR CAN WE GET STOCK DATA IN GOOGLE SHEET WITH TIME STAMP?
subramaniam konar (7 months ago)
Very Good Video Sir..keep it up
Thank you.
shankaar parray (7 months ago)
too good.... looking for something like this ...for long time..can we auto refresh or how to referesh the data... thanks for sharing this wonderful tool..
RAMAMURTHI RAGHU (7 months ago)
nice video. how to import previous 10 day data of a particular symbol in google data sir.
Pradeep Kumar (7 months ago)
Hi Nice video, Please let me know how I can get the values from google finance for all the indices like NIFTY SENSEX NIFTY BANK NIFTY INFRA NIFTY IT NIFTY PHARMA
NIFTY BANK "BANKNIFTY" NIFTY INFRA "CNXINFRA" NIFTY IT "CNXIT" NIFTY PHARMA "CNXPHARMA"
For BSE watch this video https://www.youtube.com/watch?v=Uc5kFH7AJ9c&t=449s
suresh prabhu (7 months ago)
Kindly let us know how to copy nifty option data in excel sheet. Reagrds.
LIVE INTRADAY TRADING (8 months ago)
SIR HOW TO GET NIFTY 20 DAY HISTORICAL DATA IN EXCEL USING POWER QUERY
LIVE INTRADAY TRADING (8 months ago)
Because there are no www link
LIVE INTRADAY TRADING (8 months ago)
How to use it
GOOGLEFINANCE("Nifty", "price", DATE(2018,07,1), DATE(2018,07,20), "DAILY")
LIVE INTRADAY TRADING (8 months ago)
HOW TO CONTACT YOU
LIVE INTRADAY TRADING (8 months ago)
Sir contact me
LIVE INTRADAY TRADING (8 months ago)
What u charge if i want last 30 day automatic historical data
https://www.thenexttrade.com/contact
Akshay Soneji (8 months ago)
Does the data get updated on a minute to minute basis ?
YES
Sunil Kumar (8 months ago)
How to add previous day's volume Pls
Naveen Kumar (8 months ago)
how to use this in excel 2007??? Thanks
Ravi kant (8 months ago)
WILL DATA UPDATE EVERY MINUT AUTOMATICALY?
yes
sachin bendale (8 months ago)
please make video on option chain link to google sheet
Jeet Mishra (8 months ago)
for cash market
Jeet Mishra (8 months ago)
Hi Can you help me to how to extract the open interest data from NSE to spread sheet
Tangella raju (8 months ago)
Thank you very much for quite useful knowledge bro.really appreaciable.
Rahul279 Gadakar (8 months ago)
Great
hiten jotaniya (8 months ago)
hi sir any formula for previous day high,, low??
hiten jotaniya (8 months ago)
#N/A show what i do??
=GOOGLEFINNANCE("NSE:" &A2, "high",TODAY()-1,TODAY())
hiten jotaniya (8 months ago)
error not work formula
=GOOGLEFINNANCE (nse:, "high",TODAY()-1,TODAY())
hiten jotaniya (8 months ago)
thank you so much for reply sir you r great but sir please write all details i mean =GOOGLEFINNANCE (nse:, "high") this type thank you
vara prasad (8 months ago)
SIR WHAT IS THE FORMULA I CANT UNDERSTAND PROPERLY PLZ RELAY ME SIR
kamal Sapkota (8 months ago)
Hi bro, what is the keyword for yesterday high like yestclose for previous close price. Or sintex for date
Bir Singh Singhal (8 months ago)
Great sir, bahut achi information di h apne
Rushikesh Tarlekar (8 months ago)
What is the code for previous day's high & low?
"high",TODAY()-1,TODAY()) "low",TODAY()-1,TODAY())
Chetan Meghani (8 months ago)
Excellent sir, my dream come true after long time...
Saurabh Mahajan (4 months ago)
HOW U OPEN OPEN GOOGLE EXCEL SHEET?
EQUITY TRADING (8 months ago)
how can add previous day high and low price in google sheet
HEMANT DOIFODEY (8 months ago)
Nice,only one column be added i.e.oi data too,thks
Utpal Vatsa (8 months ago)
NOT ABLE TO FETCH DATA USING THE SYNTEX MENTIONED..
hiten jotaniya (9 months ago)
hi sir how to add sector any stock in Google spreadsheet?? thank you very useful video
sumit chandra (9 months ago)
GOOD MORNING SIR , SIR THIS VIDEO IS VERY HELPFUL PLS TELL HOW TO CALCULATE PIVOT POINT IN LIVE GOOGLE SHEET
kundan kumawat (9 months ago)
How to Live data of BSE in Google sheets, I have tried but failed to do that please share
https://youtu.be/Uc5kFH7AJ9c
Dhiren Vara (9 months ago)
Nice info.. Please make a video on Excel sheet with support and resistance with live alert, s1, s2, s3 and r1, r2, r3.
srikanta saha (9 months ago)
good explained... plz tell us how to find 15 min break out script
Muddineni Sampath (9 months ago)
Is this stil working ?? i getting error saying '#Name?' plz suggest
pawan kumar (9 months ago)
U made my life easy .. thanks for the awesome video.. can u share the video with strategies as continuation of this
pawan kumar (9 months ago)
Sir what is the continuation to this video
aj rawat (9 months ago)
how to get 5 day average volume .. plz reply
anurag singh (9 months ago)
Disclaimer says this data may be hoti 20 min late... Can you confirm latency and refresh rate of these data..
Manish Bhatnager (9 months ago)
I am highly thankful to you. I was searching for this kind of solution for past few weeks. Now my excel is active. Thanks again Could you be kind enough to give the syntax for adding sparkleline too
DHONGI BABA (9 months ago)
Sir, super work and one requst is how to get the yesterday high and low of the script
Kunal Gajjal (9 months ago)
How to do this for "Mutual funds" importing the AMFI data

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.