FYERS EXCEL | Live Option Chain tick by tick data NIFTY Banknifty OI
HTML-код
- Опубликовано: 2 авг 2024
- Welcome to FYERS EXCEL, the ultimate tool for traders looking to analyze live option chain data for NIFTY and Banknifty. In this video, we will show you how to access and interpret real-time option chain tick by tick data using FYERS EXCEL.
The option chain is an indispensable tool for options traders as it provides valuable insights into the overall market sentiment and pricing patterns. With FYERS EXCEL, you can now access this crucial information and make informed trading decisions.
Our platform provides live option chain data for both NIFTY and Banknifty, allowing you to closely monitor open interest (OI) levels, implied volatility, and volume for different strike prices and expiry dates.
Using the option chain, you can identify potential support and resistance levels, understand the prevailing market trends, and spot lucrative trading opportunities. Whether you are a seasoned trader or a beginner, this tool will prove to be invaluable in your trading journey.
With FYERS EXCEL, you can customize and filter the option chain data according to your specific requirements. You can analyze and compare different strike prices, track changes in OI, and even visualize the data using charts and graphs.
Don't miss out on this opportunity to enhance your trading strategies and increase your chances of success in the options market. Join us as we dive deep into the world of live option chain data with FYERS EXCEL.
Make sure to subscribe to our channel for more informative videos on option chain analysis and other trading strategies. Remember to hit the like button and share this video with other traders who might benefit from this valuable information.
#nifty #optionchain #fyersexcel #exceloptionchain #bankniftyoptionchain #liveoptionchaindata #liveniftydata #optionchainbanknifty #optionchainanalysis
Download TEMPLATE From Telegram: t.me/empirewealthtrade
Time Staps:
0:30 Introduction
1:15 - Downloading Fyers One
2:20 - Settings for excel
5:40 - Nifty tick by tick option chain Data into excel
7:20 - NIFTY Spot, Future and VWAP into excel sheet
8:00 - Template Sheet
#optionchainnifty
#optionchainfyers
#optionchaintickbytickdata
![[BLACKSWAN] ‘Roll Up’ Official Music Video](http://i.ytimg.com/vi/ulvCwyKrwqw/mqdefault.jpg)
![Jordan Adetunji - KEHLANI REMIX (feat. Kehlani) [Official Video]](http://i.ytimg.com/vi/EeJ8n5PxFGE/mqdefault.jpg)
Dear Bro, We proud of YOU. BIG THANKS
Great Video Brother... Keep Growing and Happy Trading
Thank you
Very useful 👌
Glad to hear that
Thanks sir
So nice of you
cute, even those who are not tech savvy can easily learn from this video.
thank you :)
Hello sir can you please tell me this change in oi for ce pe is refreshed after how many minutes like it is delayed on nse by 3 mins and how much time does it take on fyers ?
Hi Paurik, thank you for your tutorials. Are you planning to post a video on complete Fyers based template anytime soon? I checked your telegram channel but could not locate which template is based on fyers data. Could you please help. Thanks again
Yes. i will post as soon as i get free time.
Sir,please add customisable multiple oi strike open interest change (trending oi) nifty banknifty with open and high in sheet
Sir please can you also make a follow up video for making a dynamic spread sheet for data taken from fyres as well.
Yes, soon
Sir thanks sharing this video, ur helping retailers..
Sir can I operate zerodha and flyers account both simultaneously. As I have one account on zerodha.
Yes you can.
Fyers give very good platform
Thank you sir
Can we plot graph of changing value continuesly of particular cell only
Value changes in its own cell
Plz guide sir
Yes You can. explain me what you want to do in detail
Hello Sir, Thank you for sharing this video, its really a great video. Did u share the template in telegram with data linked to fyers account or we have to create a new one with it
i will share is soon .
@@Paurik Thank you very much
Thanks for the update sir, it will be very helpful, but one thing i wanted to know there is no data of banknifty.
follow the same process instead nifty select bank nifty . it will work same
Hi Sir ! Currently Fyers supports only 250 scripts in one watchlist. Could u suggest a way of more scripts in an excel via Fyers or any other platform ? Let’s say around 7000 scripts which includes stocks options
Sorry No idea. Try kotak terminal or i guess NEST
I activated the fno segment in fyers one on Wednesday night, it's showing active in my account now but I'm unable to see fno data on fyers one, the price oi vol everything is blank in fno segment on fyers one
run fyers as administrator
SIR I HAVE 2016 EXCEL AND IN EXCEL PROPERTIES THERE IS NO OPTION OF COMPATIBILITY SO I CANT CHANGE IT AND GO FOR FURTHER PROCESS PLZ SIR SUGGEST ME WHAT TO DO . THANK YOU SIR.
Hello sir Nice Video, I would like to add the Nifty & BankNifty Option Chain in the sheet simultaneously with realtime updates can it will be possible??
Yes its possible.
@@Paurik can you tell me how??
very informative video.
sir ek request hai future ka data excel me pull nahi ho raha, 1 chhota video bana dijiye,
thank u
With flyers ? Or NSE ?
Sir nse
Make video complete create excel sheet using Live data fyresone
Nice video , i saw excel in you telegram channel , you posted 24 nov excel sheet , it will work for monday only or it will work for next week ??
It will work till 24th Nov.
dear pratik ticks stop updating after some time while pulling data from fyres one, any solution? thnx in advance for your effort , it will be very helpful if u upload the excel in telegram for fyres , as many of us are not skillful like u ,your interface is so eye soothing , and please put in comparison in 15 min tf , if u can pls , thnx again
i would prefer NSE data over fyers, as sometimes fyers do not update realtime. these days i got busy with work as soon as i get time i will try to fix it and will update. thanks
Sir please make dedicated video on how to plot this data in oi sheet and buy sell signal
You can refer nifty NSE oi data video . It's will be same
Hello sir! Can we save these live tick by tick data anywhere in excel or some other software...
Yes, you can
Sir, I have windows11 and I am unable to see the excel compatibility setting there..I tried to google but cant find it
what is the error. ping me on telegram i will try help you
Sir...can we link crude oil option data in exel from fyers ?
Yes
Can we view option Chart in fyers one
No
Sir ye sheet pe study k liye fyers ka account hona jaruri hai kya
Mai account open kar lu kya is pe
yes you require fyers account. once in a year fyers has been offering lifetime free a.m.c account. keep an eye on fyers portal.
is it possible to get futures nifty/banknifty/stocks from nse websites with 3mins intervel ?
Possible... From moneycontrol
yes
Sir 2016 office free hai ya paid kya ye sirf window 10 me hi run karta hai aur hamare city me ye available nahi hai to kya 2013 office work karega same pls reply de
it is available online download it. u will require 2019+ to use VBA and micro.
sir, i have downloaded the sheet from Telegram channel. it shows data for Dec 1. How can i update the same everyday?
I have shared video on changing data date . Please find in videos
Did they stop providing these option chain data? From yesterday, option chain data is blank in fyres one app.
There must be error with flyers
@@Paurik I got it. My fno segment was not activated. Now its working after activation. Thank you so much for the reply. Appreciate it.
I got data in excel,but after that not updating ,Same old data remains
Hi sir, can you please share banknifty excel if possible, this would be very useful.
Sure will do it soon
sir downloading data from fyers ,data is not showing tick by tick, how to solve this problem, regarding ram only 50% of ram and 60%of cpu is used
Is it working or showing data in fyres app?
Good evening sir, plz provide nifty and banknifty option chain in one sheet
As soon as possible
hi, im not able to copy the link to excel contents to excel , its shows error sir ..
ping me on telegram i will share
Sir, I'm using excel 2016. But my problem data refresh very slowly (5- 10 mins) delayed. RAM speed 4GB. What's My problem?. And how to slove this... please tell me sir....!!
not only your side sometimes fyersone also become slow.
Thank you Sir 🙏
Sir mai bahot din se try kar raha hu NSE OPTION CHAIN DATA ko Google Sheet me pull karne k liye but nahi ho pa raha . Sir ek video bana dijiye kaise banana hai.
Please sir reply 🙏
Google sheet do not support VBA and Micro. U will have to use Desktop Excel 2019 + only
@@Paurik Thank you sir
Add banknifty also pls
now you can have it online on web
Kya ham fyers se one time two index ka deta le sakte hain
Yes
@@Paurik sir mera bus 1 hi index live data upload karta hain second nahi
@@maheshborate68 it should . Ur net or ram must be slow
Mac M1 hain sir
Sir plz help me
Hi the NSE Excel Sheet is great, it helped me to understand the Market move, I tried as per your instruction but it is giving error in VLOOKUP as #NA used this formula =VLOOKUP(B3,Nifty50,1,0), can you please suggest how to go about it
copy strike price column and paste in 1st front cell. it will help vlookup to identify row data
Sir, particular strike price ka
1. ce pe open interest, 2.change in oi, 3.PCR,4. ce pe difference kaise dekhe
Every 3/5 minute
Ek hi page/sheet par?
Hi have added in sheet somewhat same what ur looking for
Take example from template . Its Simple process
@@Paurik video link please for that template
Hello sir ,
Fyers option chain data is completely wrong, much more difference in actual data and live data ,
Yes definately data after divide by 50 for nifty and 25 for banknifty
I would prefer NSE website data. Sometimes fyers data do not update realtime .
Sir fyers se wali Excel sheet plz share kar do na
Sure will do it soon.
Sir fyers dimet account kase opan kar
go to their website
This looks too technical. Can you help bit slow/ step by step.
Help please 🙏
sure
Bank nifty sheet pls
I will make and share.
High, low price tik by tik nhi aata isme ?
No
@@Paurik fir kisme milega sir
@@alndr4u NSE website update data every 3 minutes. to get high low close you require tick by tick data. which is paid by NSE.. you can search on google for realtime tick by tick nse data provider you will find many you can take their service.
Bro your sheer not work window 10
what is the error ur facing ?
where is sheet
t.me/empirewealthtrade
sir do not auto update future data
please download new sheet
@@Paurik SIR include nifty future data auto record evry 5 mint exampel evry 5 mint future open price, close price , cheng in oi, cheng in no of tred , requst❤❤❤
excel shit refresh nhi ho rhi he sir,,, dartcrts.exe mang rha he
share screenshot on telegram