Live Advanced Option Chain in Excel with Analysis | BankNifty Option Chain | Nifty Option Chain

[@dronraj1703]

प्यास लगी थी गजब की मगर पानी में जहर था पीते तो मर जाते और ना पीते तो भी मर जाते बस यही वो मसले थे अभी तक हल नही हुए आप की नःस्वार्थ भाव को सलाम और हमेशा ही पुजनिये रहेगे अगर आप एक और उपकार कर दे इसका सेटअप मेल पर भेज तेगे किया

[@dranujnutrition]

trully Amazing work

[@sanjabl555]

सर, आप ऐसाही f&o स्टॉक का नीट बनाऐगे क्या ?

[@123mallik]

Please share the contents of the notepad specially those related to the code for p1,02,03,04

[@GaddamidiLatha]

Sir, If you don't mind , can you share me the link of this sheet, I pay for it. . thank you

[@akashagrawal7621]

url for cookies is not valid

[@abhijeetpatil3735]

सर मुझे मिल सकती है

[@abhijeetpatil3735]

सर हमे मिल सकती है excel sheet

[@RaviPatel-vb3sf]

note pad hai vo coding to do, hu sundar pichai thodi hai jo khud se samaj lenge

[@patelmur1501]

Get data refresh button kahase aya .... zero se chalu kiya hota new excel me... 1st step hi. Nai pata 99 step samjake kya fayda

[@RajeshGyupt]

shi bat hai bro 👌

[@patelmur1501]

Code dalke dekha run Kiya to .send pe yellow hoke. Error aa raha haii

[@patelmur1501]

Code dalke dekha run Kiya to .send pe yellow hoke. Error aa raha haii

[@anupr9584]

A great teacher with great knowledge And the best thing is will of sharing the knowledge In a really remarkable understandable language

[@ramindrakumarchauhan9132]

LOGO KO CHUTIYA KYO BANATE HO ? AGAR SACH ME HELP KARNA CHATE HO TO LINK AND COOKIE KO NOTEPAD ME UPLOAD KARO . OTHER WISE CHUTIYA BANANA CHOD DO.

[@dniliminaw]

Excellent video, working fine, just facing one problem, not getting autoupdated, i have to do it manually, any solution for this.

[@SreedeviSemes]

can u share excel file I have mailed

[@emarajan1]

HOW TO GET API ID FOR NSE SIR

[@emarajan1]

SIR CAN I GET CODE FOR AUTO COOKIE UPDATE VBA?

[@akkshaysinghi3302]

Hi, Thank you! But I have a few queries I have written the code as you mentioned. But I am unable to get the 'Get Data' link on the Cookie sheet. Please help

[@parthpatil5492]

How can we get this excel shown in video sir? Is it uploaded somewhere?

[@justlife8806]

Such a fine and selfless explanation, you deserve to be bestest teacher of stock market, profit ho ya na ho, your hardwork deserves a salute sir🎉🎉

[@medasbabu]

Agree with you, I'm a VBA developer, and this process needs a lot of time and effort and he is explaining everything here for all of us, Thank You.

[@CCD522]

sir not understand about any data collection, and also resistance formula ?

[@CCD522]

where to get cookie data and so many data you get from where or send me the exact link....pls....

[@CCD522]

sir LARGE formula nahi work kar raha hai ?

[@bhaveshgajera7361]

Great.....Can you send the code if possible?

[@sureshnchavhan]

sir u r great make video on nifty and banknifty future option chain

[@stumblegameryt.7842]

send me function cookie code....

[@stumblegameryt.7842]

your information page send me....

[@mustakshaikh3509]

Great work by you dear. kindly make collum of pcr in this excel

[@vinayakdiwate637]

Hellooo!!! Can you please reply. 🙏🙏🙏

[@vishantmane3663]

Getting note that ( ⚠️This won’t work because it would move cells in a table on your worksheet) Have Solution please reply back Thank You

[@gopinathv9707]

Hello sir, yeh code ka link send karna please

[@santhoshnayar7257]

Can you please send the Excel Sheet .Thank yiu

[@NileshNahajan]

Please send code link please

[@vinayakdiwate637]

Excellent Work and Great efforts put up by You!! Can I get the excel sheet and the notepad sheet with the code provided, please?

[@JanmabhumiMedia]

Is it legal for using cookies in excel from nse website

[@rupendergangji]

Excellent Video!!! Sir, I am working on creating the Excel file. I am receiving an error while I am trying to fetch the data from the NSE Site step (Video @ 21 mins). Error - We couldn't authenticate with the Credential provided. Please Try Again. Could you please help me resolve this issue

[@shubhamgadekar7247]

Please tell me some one how to get cookies

[@iamkora]

Hi, Please share the contents of the notepad specially those related to the code for p1,02,03,04 . I'm getting some error when I tried to type it out by looking at the video . Very useful video though.

[@dhananjaynaidu7761]

how can i get this sheet

[@bharatsinhmori4298]

Sir You Created Function CookieN, so how to use it?

[@gauravj7474]

Brilliant...Simple and Useful...thanks for the wonderful content. very much needed for a newbie like us. was searching for such a content for past few months...

[@EYEREPLY]

Sir ye Greeks calculation me Future expiry ka farak padta hai kya

[@daverohitb]

VBA codes where are they?

[@daverohitb]

VBA Codes plz

[@rajuj8876]

Sir Links and VBA code can you please share I tried it but error showing

[@hagarwal6464]

Throws an error for No. Of Strikes - P4 says the column No. of Strikes not found. Seems a connection needs to be established first. Please clarify how to resolve the issue

[@rajeshrao867]

sirji can you please share the Excel file aap ka mail id share karogay

[@ravindradandge1311]

Sir Above Not Work Proper Why Don't No Please Recolve

[@backtonature9529]

Bhai aapse contact kaise hoga

[@mohdkamran-g9z]

how to get this exel sheet bcz i am not able to do?

[@ajaykumardwivedi8504]

Sir aapko mail Kiya hai

[@asishmuk]

Excellent sir the best free video of option chain, keep posting such wonderful videos

[@salujafintech]

Thanks

[@geeteshkumbhare6928]

I watch so many videos regarding fetching nse option chain data but this video is unique and very useful. Thank you sir ❤ for your help.

[@salujafintech]

Thanks for appreciating!

[@geeteshkumbhare6928]

@@salujafintech SIR CAN I GET CODE FOR AUTO COOKIE UPDATE VBA?

[@salujafintech]

File has been sent.

[@vipinjakhmola7678]

@@salujafintech i need it too if possible

[@chetanbharadi1066]

Amazing Video❤❤❤❤, I am still finding difficulties to make the file work, any help would be appreciated sir

[@devamru103]

👏👏Brilliant work and an equally amazing explanatory video! Keep up the good work! Was wondering if Option Greeks could also be added to the existing Excel sheet to corroborate the OI and Price change interpretations?🙏

[@babulalmistry8057]

👍Excellent and concise approach, but lagging in NSE data is the prob, Pls help with addition of Max Pain row, there should be an extra row say for 10 strikes(10+10+1).

[@JyothiPrakash-g5u]

Excellent video ,seen so many videos on fetching data but this one is the best so far, thanks for upgrading knowledge , looking forward for your upcoming videos.Thank you........Can you share the codes

[@pravinhirani7962]

Excellent sir

[@d.s.patilvidya2428]

lxent Sir Keep guiding us, Thanks

[@salujafintech]

Always welcome

[@mohsintaqvi6004]

Excellent works. Can I buy this program.

[@anuragtripathi5201]

Excellent work sir, pls share the notepad file and supporting files so that we could make this excel ourself.

[@toorsukhwinder]

Excellent video, very useful for learner

[@salujafintech]

Thank you for appreciating.

[@JaiPrakash-ec6kf]

super se bhi upper

[@salujafintech]

Thanks for appreciating.

[@rajkalangutkar]

Absolutely amazing work sir. How can we add a column next to " Change in OI" column which would show up or down arrows if the "change" is positive or negative?

[@pramodpatil5478]

SUPER SIR THANKS

[@shahronak1881]

Hello Sir I am Stuck with below problem. Can you just help me ? Can you just brief explain step by step sheet 1 i.e Cookie under Get Data, Refresh, Stop Refresh button how to create and link to VBA Coad

[@patelmur1501]

Sahi diktat haai keto bataya nai or sita kon thi

[@BhaveshkumarPrajapati-fg4bk]

Hi... Your work is excellent But im facing promblem in P2 Why i dont know it shows that your table doesn't match Why? Pls help me

[@RRahi-sq4fb]

Great work, I am eagerly waiting for the real time data bot with trading terminal Fyers web API/Fyers one

[@salujafintech]

Noted

[@sanjaypandey2985]

Very good, sir please add PCR, OI total call n put line chart and please share this Excel sheet sir.

[@salujafintech]

Noted, will post a video.

[@shahidalikhan011]

question: There might be an issue in this sheet. Wanted to clarify. We have taken Change in OI > or < 0 as our criteria. However what if Call OI Change reduces from 100K to 80K and call prices increase.. In this case short covering is taking place. However since 80K>0, the formula will show call buying...Can this issue be rectified? Great job on the excel otherwise. Thanks.

[@buntyalbuquerque1234]

Well done sir 👍

[@salujafintech]

Thanks

[@ashitraja2247]

Unable to generate cookie, can you help?

[@nilanjanmukherjee1209]

Sir iss mein aisa kuch kar satke hain kya jisse auto refresh hota rahe 1min baad

[@venkateshdhayal1888]

Excellent video, very useful for learner ,, can i get link exl file

[@sahebbeshra7659]

Make Video for currency options chain in excel

[@salujafintech]

The topic will be covered in the upcoming videos.

[@ashoksinha9653]

Sir Iske liye software developer ka pahle course sikhna padega, Jo utna padha likha nahi hai wo kaya kar sakta hai, margdarshan karne ki kripa kijiye 🙏🙏

[@st-xm6kw]

Aapko Excel code bhi dalna tha

[@ananddixit9061]

Hello, Great work. But I am not able to make the excel. Can you please share the excel🙏🏻

[@AgrianDashrath]

Kya kisi bhi trading software se every 5 minutes data record kar sakte he?

[@MokshKiTaraf]

Amazing.

[@salujafintech]

Thanks!

[@curious6353]

Just Loved it.. truly amazed by your honest of sharing knowledge.. _/\_

[@vasanthkumarbavi]

Nice Bro.. Can I get this Excel sheet pls..

[@tejsingh7035]

sir can we get sensex option chain in excel too

[@mayurdhumal2330]

Can you send code power query and vba i follow all stap on video but cookies not genret and Bankoc power query error show

[@tusharpotdar77]

दोस्त, Office 2010 or any other office version run on windows 8.1 में option chain data pull करने का कोई trick बताओ ना

[@salujafintech]

It works in excel 2016 and later

[@raajeshpradhan]

will this file working on MSoffice 2013??

[@technicalpappuda5133]

Thank you sir

[@salujafintech]

Welcome

[@vikimishra5420]

Plz share how to download all fno stocks option chain data with single click in excel from nseindia

[@salujafintech]

Will create a video on that soon.

[@mohsintaqvi6004]

I need this program. Can tell me the price

[@mohammadimam5445]

Data update timing kya hai sir

[@sujitroy7821]

Thank you sir Jee...Grt job....pls code share kar dejeya......

[@salujafintech]

File sent

[@punitpillin]

Hi Sir, thanks for your contribution. The p2, p3, p4 value doesn't update and throws error as "Expression Error = The field content of the record wasn't found. Details, content[Table], Name=BNPrice Please help me asap. Thanks.

[@pramodpatil5478]

same problem

[@anupbaraskar]

same issue, did you get the solution finally?

[@polysahiar5716]

Sir can u show how to make this option chain in googlr sheets if it is possible for u

[@salujafintech]

This code works with MS excel only. May be I will cover the google sheets automation in future as well.

[@lovegreen2774]

Sir, can you share the excel sheet please

[@anantadesai6388]

Can you show how to do the same in data pulled from fyersone software and plotting graph of oi vs time every 5 min

[@salujafintech]

For now, my focus is on getting data through APIs without any special software. However, at later stage will look into these topics as well. Your point has been noted.

[@shankarbishwas3611]

sir mujhe ye kaise milega..notepad data

[@niteshnike002]

hello sir, file is working fine thanks, i am getting error when iam in advance Editor (time in above video 35:47 to 40:20 while doing this steps) could u please help me to solve this problem....!

[@salujafintech]

Email me the screenshot of the error. Will help you

[@you.179]

sirji code copy paste kar sakte hai aisa ek sheet share kariye

[@salujafintech]

Send me an email, will share the file.

[@TDS9030]

Excellent bro can you share this sheet?

[@salujafintech]

Send me an email

[@JaiPrakash-ec6kf]

Pl mention vba reference file name, because str variable not defined, error find.