IMPORTING LIVE OPTION CHAIN DATA IN GOOGLE SHEET - Automated Google Sheet Option Chain Analysis 1
In this video, we're going to show you how to import live option chain data into a Google Sheet using Automated Google Sheet Option Chain Analysis. This is a useful technique for tracking and analyzing the performance of your options investments.
If you're interested in learning how to use Automated Google Sheet Option Chain Analysis, then this video is for you! We'll show you step by step how to import live option chain data into a Google Sheet, and then use Automated Google Sheet Option Chain Analysis to analyse the data. After watching this video, you'll be able to use Automated Google Sheet Option Chain Analysis to track the performance of your options investments.
Using live option chain data can give you a real-time view of how your options are performing and help you make informed trading decisions. This video will show you how to import the data in Google Sheet and use automated option chain analysis to make important trading decisions.
#optionanalysis #livedata #automatedtrading #liveoptionchain #nifty50 #livedatarde
➤ Telegram: t.me/RomanceWithMarket
You Can Open a Trading account from the below links:-
➤ Zerodha:- zerodha.com/?c=XS6330&s=CONSOLE
➤ Fyers:- open-account.fyers.in/?id=XB1...
➤ Dhan:- invite.dhan.co/?invite=SGXQC3...
Learning Videos For Beginners:-
➤Bull Put Spread Strategy | Zero Loss Strategy Option | Option Trading For Beginners
• Bull Put Spread Strate...
➤🔥🔥Stock Screener for Day Trading | How to Select Stock for Intraday Trading | Break Out Stock Screener🔥🔥
• Stock Screener for Day...
➤Option Trading Course Hindi | Option Trading For Beginners | CE PE Kya Hota Hai | Part 1
• Option Trading Course ...
➤Option Trading For Beginners in Hindi | Intrinsic Value Explained | ATM, ITM & OTM In Hindi | Part 2
• Option Trading For Beg...
➤Open Interest Analysis For Intraday Trading (Hindi)
• Open Interest Analysis...
➤🔥Open Interest Analysis kaise kare | Option Trading se Daily Profit kamaye | oi change strategy🔥
• 🔥Open Interest Analysi...
➤VWAP Indicator | Intraday Trading With VWAP | 5 min VWAP strategy | Stock Market Beginners
• VWAP Indicator | Intra...
Пікірлер: 190
For Part 2 Like, Comment & Subscribe❤
Nice work, thank you for sharing
@RomanceWithMarket
Жыл бұрын
Thanks for watching!
Good Explanation.👍 Thank you for sharing your hard work, Very few people share their knowledge for free, waiting for your next video
@RomanceWithMarket
Жыл бұрын
Welcome sir total 5 parts have been uploaded you can watch and prepare
@kathiravanm9917
11 ай бұрын
pls share contact number sir we want option chain sheet @@RomanceWithMarket
Excellent 👌
Really great video, keep it up, awesome content bro.
@RomanceWithMarket
Жыл бұрын
Thanks for watching
Good knowledge
Nice video and explaination sir
@RomanceWithMarket
Жыл бұрын
Thanks and welcome
It's Awesome video, Excellent Bro👌🏻👌🏻
@RomanceWithMarket
Жыл бұрын
Thanks
Thank u sir
Wow Great Skill
@RomanceWithMarket
Жыл бұрын
Thanks❤️
Thanks a lot
@RomanceWithMarket
Жыл бұрын
Most welcome
Super video sir
@RomanceWithMarket
7 ай бұрын
Thanks
Thank you
@RomanceWithMarket
8 ай бұрын
You're welcome
Good one sir, please share the next part.
@RomanceWithMarket
Жыл бұрын
Parts are already uploaded
@naveendn2888
Жыл бұрын
@@RomanceWithMarket checked all videos sir,thanks a lot
Good afternoon sirji
The import formula has stopped working. Can you please help?
❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤धन्यवाद, पहले तो मुझे लगा कि फॉर्मूला गलत दिया है लेकिन मैं गलत था
@RomanceWithMarket
3 ай бұрын
❤️
Good work, salute you..
@RomanceWithMarket
3 ай бұрын
Thanks
@ravirohilla2189
3 күн бұрын
Please share sheet
❤ Excel Master sir
@trade_like_pk
Жыл бұрын
1st wala formula ache se nhi dikh raha h yaha type kro na yrr
Good work,sir data refresh even after 15min also not refreshing
@RomanceWithMarket
Жыл бұрын
Thanks
@RomanceWithMarket
Жыл бұрын
New Video Has been Uploaded with solution of Data refreshing Problem plz visit and Comment
Bhaii volume kaa formulaa diya hee nahee aapna video maa orr open interest orr change in open internet kaa too hamm aagaa kaisa badaa????????
Please advise how this can be used for US market. Thanks.
@RomanceWithMarket
2 ай бұрын
This sheet is Not for US market
I landed on this video searching for ways to fetch live F&O data on Google Sheets. It was very helpful and I thank you for sharing this. However, sometimes it is not working and the results showing NA but other times it is working. Is there a way out of the problem. Also, is there a way for automatic refresh of the data?
@RomanceWithMarket
11 ай бұрын
No it is sheet app problem
@amitayudas1411
11 ай бұрын
I have used the auto refresh feature suggested by you through the App Script. Thanks for providing the solution in Vol 4. It is working fine. @@RomanceWithMarket
Good work sir, sir abhi currant expiry data liya but expiry date khatam hone ke baad agli expiry date data kaise lena hoga...plz guide
@RomanceWithMarket
Жыл бұрын
Jha pr apne Money control wali site table 6 paste kiya wha pr formula bar me jake edit kro new date
request have you tried with getting data from nse,issue with moneycontrol,
@RomanceWithMarket
Жыл бұрын
Nse is possible in excel sheet in google sheet money control
Sir aapne excel sheet jaisi jahaj to de diya hai Usko chalana kaise hai, use use karna kaise hai free hoke 1 vdo bna dijiye plz Aapke sahare hamara bhi life ka beda par ho jayega Thankyou ❤️
Sir trading mei kya upyog hai iska? Kya ye buy sell ka perfect signal dega ya nai?
@RomanceWithMarket
Жыл бұрын
Perfect kuch nhi hota but ham direction ka anuman lga skte hai jo bhut help krta hai trade me Or Jnakari ke liye Telgram kare t.me/Romance_With_Market
iisse achha excel bhi upload kar deta bhai
Pls guide on this issue
Sir after some time of fetching data from money control....data automatically shows an error. Please try to resolve my query sir
@RomanceWithMarket
Жыл бұрын
Plz send screenshot of error on my telegram
hello i am getting following error message ---Error Imported content is empty. pls suggest what to do
@RomanceWithMarket
10 ай бұрын
It will auto repair
Hello sir Can we make the same sheet for USDINR option also
@RomanceWithMarket
6 ай бұрын
Yes
ImportHTML function is not working nowadays in Google Sheets, any method to fix it?
@RomanceWithMarket
Жыл бұрын
I think it is working because this video i uploaded recorded same day of upload 29 Dec 22
@kdsbhatia
11 ай бұрын
@@RomanceWithMarket imported data empty error aa raha
I am not able to download as suggested. Message coming is #N/A Imported content is empty. How to fix this problem???? Please help
@RomanceWithMarket
11 ай бұрын
You can try again this error is occurring due to google sheet proble
Since you are sharing the technique to create this sheet you must share the codes clearly, make a Google sheet and provide your viewers a link to it. Not doing so, gives the impression you are commercializing your technique, nothing wrong in that, but be transparent
Sir can u upload the Google sheet here in the description ???
@RomanceWithMarket
Жыл бұрын
t.me/Romance_With_Market Msg Here
@trading.pathsala
9 ай бұрын
Sir aap ne google sheet kharidi hai
Sir can you help on MCX option chain excel sheet
@RomanceWithMarket
Жыл бұрын
Will try my best
How to Get SENSEX OPTION CHAIN PLEASE HELP ME
@RomanceWithMarket
4 ай бұрын
Thanks
hello sir, jbb main expiry change ker raha huun uss time toh change hoo rahe hai...but thodi der ke baad woh wapis old expiry main chala jata hai. what to do sir please guide
@RomanceWithMarket
3 ай бұрын
Expiry ko macro me bhi change kro jha macro me link hai
@loveislife6656
3 ай бұрын
Table 5 main update hoo jaa rahe hai..but table 6 update nahin hoo raha...
while changing the number from "5" to"6" it says the imported data is empty
@RomanceWithMarket
5 ай бұрын
Some times it happens so try again after some time
Please complete how to sheet part 2
@RomanceWithMarket
Жыл бұрын
Yes working it will upload soon
how to get sheet sir the one you have explained
@RomanceWithMarket
7 ай бұрын
Check description
Aage ki sheet taiyar krne ke liye or kon kon se formule lgaga ??
@RomanceWithMarket
Жыл бұрын
Their are total 6 parts on channel for this sheet
Sir abhi data nahi aa rha hai using that importHTML query I guess kch issue hai pls check
@RomanceWithMarket
8 ай бұрын
Google Sheet app errror
Is it possible to track historical EPS data in google sheets
@RomanceWithMarket
2 ай бұрын
Ok i will try
@abhinaysreeram1
2 ай бұрын
@@RomanceWithMarket thankq
error coming while deploying IMPORTHTML code says "import content is empty"
@navneetgupta7323
Жыл бұрын
I am also getting same error
@Maxcis
11 ай бұрын
mee too, same error.
Formula is not working for beginning only
@RomanceWithMarket
11 ай бұрын
Sheet app error
Can i use this automated sheet in mobile
@RomanceWithMarket
9 ай бұрын
Yes you can prepare it by watching all parts of video and use it🙂
Hello Sir, can we fetch option chain in google sheet nse website?
@RomanceWithMarket
Жыл бұрын
No money control
@RomanceWithMarket
Жыл бұрын
In excel you can
Sir banknifty data kaise add kare aur konsa formula use kare
@RomanceWithMarket
Жыл бұрын
Nifty 50 symbol jis jagh use kiya wha pr banknifty ka ticker lgao
data featch karne may problem ho raha hai
@RomanceWithMarket
6 ай бұрын
what Problem Please describe
Pl. Share Google sheet
error Imported Content is empty ... what to do please help
@RomanceWithMarket
6 ай бұрын
Change expiry date and try again
Yeah...importhtml has stopped working...kindly suggest some other way out...
@RomanceWithMarket
Жыл бұрын
Yes some sheets are not working but same in new sheet is working so you have to do little hard work create another sheet, moneycontrol site is working this problem is sheet problem
BHAI MERE NAHI CHAL RAHA LTP PE AAKE VALUE DIKHANE LAGTA HAE , KINDY SHARE YOUR CONTACT DETAILS TO BUY IT
@RomanceWithMarket
7 ай бұрын
t.me/Romance_With_Market Telegram
Live market me data fetch nahi hota sahi se. Money control ki jagah kisi aur website ko choose kare?
@RomanceWithMarket
Жыл бұрын
Yes bro uska bhi solution ayega jald hi
@anand86139
Жыл бұрын
@@RomanceWithMarket Thank you Bhai for all your efforts 🙏🙏🙏
This is Received error--->. Star_Star = VALUE Error (So can you suggest formula in LTP(Rs) *_*
@RomanceWithMarket
Жыл бұрын
Sir Formula is there in video plz copy same
Can I get this spreadsheet
@RomanceWithMarket
Ай бұрын
Yes but in readymade condition it is paid
Or value raa rha h
Can you please share the format...
@RomanceWithMarket
Жыл бұрын
Inbox me on telegram
Sir getting error when entered =IF(CELL=*_*,0,CELL) #ERROR.
@RomanceWithMarket
Жыл бұрын
*_* check this
its not working now
@RomanceWithMarket
8 ай бұрын
Working sometimes Google sheet having update issue
Brother ye 1st formula me hi error btata hai ... imported content is empty show krta hai
@RomanceWithMarket
Жыл бұрын
Google sheet glitch
Option chain live update nahi ho rahi Kya setting Karni padegi
@RomanceWithMarket
Жыл бұрын
Next parts dekho sb kuch milega
Error is showing - imported content is empty
@RomanceWithMarket
8 ай бұрын
Google sheet is facing errors it corrects automatically
ye data live update hota h kya ?
@RomanceWithMarket
Жыл бұрын
Yes same as moneycontrol site
Error aa rha h
@RomanceWithMarket
4 ай бұрын
Check it in PC
can you share this sheet
@RomanceWithMarket
11 ай бұрын
You can prepare it by watching this
Current expiry is not showing
@RomanceWithMarket
Жыл бұрын
Check Part 3
Data import nahi ho Raha imported data empty error aata hai
@RomanceWithMarket
11 ай бұрын
Ho rha bt kabhi kabhi google sheet refresh nhi ho rha
Sir .Sheet kaise milegi aur kiya charge he iska
@RomanceWithMarket
Жыл бұрын
Telegram pr msg kro
@PMUYinfo
Жыл бұрын
Sir .telegram join nahi ho para ha he an error occurred bata raha he
@RomanceWithMarket
Жыл бұрын
Insta Here instagram.com/_romance_with_market_?igshid=NTA5ZTk1NTc=
@PMUYinfo
Жыл бұрын
Follow to karliya he Google sheet kaise milegi ye to bataye sir
Ab to importHTML me hi issue aa raha he
@RomanceWithMarket
10 ай бұрын
Google sheet shi kaam nhi kr rha
Please sir formula 1 Google sheet link share
@RomanceWithMarket
Жыл бұрын
Msg me on Telegram
@pradeepaithal1810
Жыл бұрын
I am message sir please check reply
this is good excercise but live data fatching is not happening. If you can put some light on, will be good. 😌
@RomanceWithMarket
Жыл бұрын
Plz check and enter formulas correctly it is working
File chahiye please
@RomanceWithMarket
5 ай бұрын
Telegram link in description
Table no 6 dale tho nhi aara
@RomanceWithMarket
Жыл бұрын
Formula shi se likho ho jayega
Import content empty errors
Sir only N/A sawing.
@RomanceWithMarket
9 ай бұрын
Google sheet app error
@sushantdas343
9 ай бұрын
I just created a new Google sheet, when I imported it sawing #N/A.
How to connect with you
@RomanceWithMarket
Жыл бұрын
Telegram link in description
@vikramsingh-oy5mt
Жыл бұрын
How to get this sheet access
Not working
@RomanceWithMarket
9 ай бұрын
Working i am using
Not working your formula
@RomanceWithMarket
9 ай бұрын
Working
SHARE 255 DAY CHART GOOGLE FORMULA
@RomanceWithMarket
3 ай бұрын
Change 255 in formula
Sir mil hi nhi rha h Grp me hai fir bhi
@RomanceWithMarket
Жыл бұрын
Aj Evening me mil jayegi
@nirav2505
Жыл бұрын
@@RomanceWithMarket thankyou in advance
Ye formula kahi pe dona. Error hi aa raha he
@RomanceWithMarket
Жыл бұрын
Which One Import?
@anand86139
Жыл бұрын
@@RomanceWithMarket Woh jo ***** hata ne ke liye nahi likha tha Aap ne
@anand86139
Жыл бұрын
@@RomanceWithMarket =if(MID(CELL, FIND(***, CELL) +1, 1) *.*, 0,(MID(CELL, FIND(***, F4) +1, (LEN(CELL) -2)))) +0
@anand86139
Жыл бұрын
@@RomanceWithMarket Upar jo comment kiya usme kya galti he? Formula me?
@RomanceWithMarket
Жыл бұрын
double inverted Commas “*” and “-“
Bhai, apna mobile no.dena.
@RomanceWithMarket
Ай бұрын
Telegram link description me hai
Don't give him single rupee. He is froad
Zhol jhaal hai. Ise Paisa mat do
Too much confusing.. not easy for beginner.. also incomplete process
@RomanceWithMarket
Жыл бұрын
If you follow all videos properly than easy only and total 5 part to complete process
Ye froad hai. Ise Paisa mat do
@RomanceWithMarket
8 ай бұрын
Video dekh kr sheet bnao Paisa na do
Hi sir g, Great work, but while i am doing error is coming. Now i think i need u r help. I need to contact you, can u tell m how many telegram subscribes u r having, bcoz when i am searching u r telegram link 3 - 4 telegram channel r coming
@RomanceWithMarket
7 ай бұрын
It have 870
❤ Excel Master sir
@RomanceWithMarket
Жыл бұрын
🙏🏻🙏🏻