How to get NSE Live Data in excel with AutoRefresh | NIFTY50 Stocks | Cookie Permanently Resolved

This video explains how to pull NSE NIFTY50 stocks live data in excel with auto refresh feature using cookie. Please hit subscribe and press like button for more such videos
@salujafintech Saluja Fintech
#nifty50 #stockmarket #nifty

Important update:
To avoid timed out issue, please also include below 4 headers in power query (Nifty50) and in Function CookieN(URL) code just before .send

.setRequestHeader "Accept", "text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5"
.setRequestHeader "Accept-Language", "en-us,en;q=0.9"
.setRequestHeader "Accept-Encoding", "gzip, deflate"
.setRequestHeader "Content-type", "application/json; charset=utf-8"

Note: Do not include '.setRequestHeader' part in power query

Your Query:

nse data in excel, nse live data in excel, nse live data feed for excel, nse data to excel, nse to excel, how to import nse data to excel, how to get nse live data to excel sheet, nse live data, how to import nse live data into microsoft excel sheet, how to pull option chain data in excel, live option chain data in excel, how to get stock market live data to excel, ms excel - import live data from web, how to fetch nse live data in excel, how to import nse data in to excel

[salujafintech]

The solution for timed out error has been given in the video description under heading 'Important Update'. Email me to get this file for free.

[jameskhad]

Really thank you so much sir for your work and today I learned lot of knowledge about live Datta in Excell

[mbedmutha]

Very very important and usefull knowledge, salute you brother and really very very thanks from heart.

[VinodYadav-nnlj]

Thanks for the video. Learned a lot from it.

[ads]

Thanks a lot sir.
Very Nice.
Need to learn more. I am novice.

[dhawalbdesai]

which video should we refer to us the developer function

[harpreetsinghwalia]

Mr Saluja how to connect with you facing issues in connectivity

[hoticesteve]

Thanks a lot . Many are selling the Cookie sheet for 2K

[rijumehta]

Will it work in ms- excel 2013 ?if yes, then how ? Bcoz in 2013 version there is no advance option ?

[webytrade]

Sir please help me, sir stock ka live spot price ko excel mein kaise import karen

[AtulBorse-sjzv]

Hi when I type "stockin: in the filter section I did not those 2 filters of equity.

[Jabuarvo]

Hey man, when i tried to enter the ''stockin'' in the filter, the two names havent come. Please Help

[ShivamSharma-bbyn]

Can we keep records of stocks day to day high low opening and closing. If you can explain this will be very helpful

[AmruthaSRISAIDURGA]

Great Job sir, How to download NSE & BSE IPO Historical data with stock code, Listing price, OHLC, Listing Date. Thank you

[vishnujaiswal]

can you post entire corrected vba code once again, debugger stopping at .send line always

[ganeshsukale]

asking credentials for connecting to request URL at very first step.

[sanatsafty]

Dear, Please help to solve this, Compile error "User defined type not defined" pop up coming

[sanjayshiva]

Is it possible to pull live price of a particular option contract?

[kunalscholar]

Hi, thanks for such informative video. I am unable to connect to NSE website in excel to download data and getting error “We couldn't authenticate with the credentials provided. Please try again.” I have reset the connection setting multiple times but it’s not working.

While trying here and there it started working to fetch the cookie when setting were changed to “Basic” from “anonymous” under authentication however now data headers are getting error -: "The 'user-agent' header is only supported when connecting anonymously. These headers can be used with all authentication types: Accept, Accept-Charset, Accept-Encoding, Accept-Language, Cache-Control, Content-Type, If-Modified-Since, Prefer, Range, Referer". Thanks in advance.

[raajeshpradhan]

above xls file can run in MSoffice 13??