सर इस सीरीज को आगे बढ़ाने की कृपा करें इस सीरीज को एसएमसी के ऑटोट्रेंडर को ध्यान में रखकर डिजाइन करें धन्यवाद आपका कि आपने इतनी ज्यादा महत्वपूर्ण सीरीज की शुरुआत की 🙏
Lots of respect to you sir for your great effort in learning us. If you sir teach us about data recording every 5 or 15 minutes, we will very much be benefitted. God bless you.
It is my humble request to create a google sheets for paper trading in F n O to practice strategies virtually Please include difficulty expiry and auto refreshing sheet This sheet will be a game changer for small investors
Thank you very much for your great efforts and learning to us. I see that spot Nifty value is not appearing while importing . Kindly tell us how to import that spot levels which shall be helpful to know the instant situation.
amazing video, just a small question...does this data at updated Realtime in the sheet?.. and secondly if i am working on option chain on weekly basis the do i have to copy fresh link? or the system will auto consider the fresh expiry?.
Google sheet not allowed refresh macro with third party website so ... you need to refresh manually If you use excel then you can create refresh based on your requirements
Sir ji jo bhi apne batay h vo pura data work kar raha h thank you so much ❤️🙏❣️🏹🏹 Pr Mera data one hour ke bad refresh ho raha h Apne ji settings batai hain settings calculation - on change and every minute - save settings, ye sab Kiya to bhi nhi ho Raha h Plz help 🙏🥺
सर इस सीरीज को आगे बढ़ाने की कृपा करें इस सीरीज को एसएमसी के ऑटोट्रेंडर को ध्यान में रखकर डिजाइन करें धन्यवाद आपका कि आपने इतनी ज्यादा महत्वपूर्ण सीरीज की शुरुआत की 🙏
Is series ko jitna jaldi pura karenge utna accha hoga sir thanku
SMC k autotrender ko dhyan me rakh k design krna sir
Esse hr kisi ko accha lagega
Lots of respect to you sir for your great effort in learning us. If you sir teach us about data recording every 5 or 15 minutes, we will very much be benefitted. God bless you.
You can use macro to record
Sir aap google sheet ki class de do
It is my humble request to create a google sheets for paper trading in F n O to practice strategies virtually
Please include difficulty expiry and auto refreshing sheet
This sheet will be a game changer for small investors
Thank you very much for this........
Great Job sir, How to download NSE & BSE IPO Historical data with stock code, Listing price, OHLC, Listing Date. Thank you
Great video. I was searching for exact this thing everywhere. THANKS A LOT.
Nicely explain thanks
LEARN VERY GOOD THINGS.
सर आप ग्रेट हो 🙏
Thank You so much sir
🙏🙏🙏Great sir g very nice g good thanks so much sir g 💜💜💜💕💕💕💐🌷🌹
i am getting an error while importing data. "Formula Parse"
sir split command samaj mai nahi aaya thoda elobarate kar sakhte hai kya spilt command ke baad alt ctrl kaise hota hai
can we do the same from NSE/ZERODHA website,plz clear
How can we pull data of different expiry by introducing drop down for expiry date and also by choosingcunderlying
thanks for the informative video, data however is not getting refreshed automatically evenif every minute setting is on
Google chrome not getting refresh with moneycontrol ....
If anybupdate ..Will let everyone know 😊✌️
Thank you very much for your great efforts and learning to us. I see that spot Nifty value is not appearing while importing . Kindly tell us how to import that spot levels which shall be helpful to know the instant situation.
Link with money control spot price .... or link with yahoo finance nifty spot
Thanks a lot sir. one thing sir how can we get the spot price on the sheet? actually I want highlight ITM and OTM.
You can get from nse website and connect that link
genious ho bhai aap
Thnku sir
How can this google sheet be used for paper trading .Please make a video on that aslo so that users can try different FnO startegies virtually
amazing video,
just a small question...does this data at updated Realtime in the sheet?.. and secondly if i am working on option chain on weekly basis the do i have to copy fresh link? or the system will auto consider the fresh expiry?.
If its created function with date then ..just change date then it will take auto
Sir all stock option data plz ek video bana do
THANK YOU SIR! GOLD BLESS U!
🙏🙏🙏Sir g commodity pr yese vdo bnao na g plz???? 🙏🙏🙏
sir, I couldn't use for split formula...Alt+cntrl for change%. please let me know how to do it.
Alt + Entr
Great sir, helped me alot
In split part,
What is meaning of command "alter control"....??
Press alt + Ctr in keyboard
Sir . stocks ka option chain google sheet par kaise bana ye.
Please is topic par v. Ek video banaye
i tried to import it gives me error in delimeter value
HELLO SIR I AM NOT ABLE TO SPLIT THE "CHANGE'" COLUMN HOW I CAN DO
Not getting data now kya ek sal baad band ho gya ?
sir i put data from money control, but it show error. how we can put data , please share google sheet
How frequently this data is updated in moneycontrol?
moneycontrol refresh 3-5 min but googlesheet not auto link for refresh
@@SilentTrader24 then how google sheet will refresh
because moneycontrol is also refreshed manually
that is the reason that sheet is not updating
सर डेल्टा एक्सचेंज में बिटकॉइन करेंसी का ऑप्शन चेंज डाटा गूगल सेट में कैसे इनपुट करें वह वीडियो बनाई ,
do they provide data without login ?
Sir muje previous close ka column chahiye
Nice video bro
hum kaise daily 9.17 am & 10.15am ka option chain data google sheet me automatically import kar sakte hain ?
Google sheet not allowed refresh macro with third party website so ... you need to refresh manually
If you use excel then you can create refresh based on your requirements
Sir ji jo bhi apne batay h vo pura data work kar raha h thank you so much ❤️🙏❣️🏹🏹
Pr
Mera data one hour ke bad refresh ho raha h
Apne ji settings batai hain settings calculation - on change and every minute - save settings, ye sab Kiya to bhi nhi ho Raha h
Plz help 🙏🥺
Boss any reply 🙏🏹
Will inform everyone if I find alternate way for refresh
@@SilentTrader24 ok boss .. We are waiting please let me know soon ❤️🏹❣️🙏🥳💓😍😍😍
Boss any update plz 🏹🎈🙏
@@SilentTrader24 boss any update plz 🏹🎉🙏
DATA SPLIT COMMAND ME SPLIT(DATA!D3," KE BAAD KYA KYA KARTE HAI MEANS KOUN KOUN SI KEY KA USE KARTE HAI KYONKI MERE SE TO HO NAHI RAHA HAI,PLS HELP ME
Alt + Enter
Sir pls teach us how to record oi change every 15 mins.
But data not refresh automatic
Moneycontrol me option chain nahi aa rahi, shayad band ho gayi
www.moneycontrol.com/indices/fno/view-option-chain/NIFTY/2023-10-26
Ye money control pe nse se alag data aata h
THANKS
VERY USEFUL VEDEO.
SPLIT IS NOT WORKING.
Alt + Ent
Split formula not able to use... Make & explain plz
ruclips.net/video/M7k_oYyOeY0/видео.html
Not work... pls help...
Live data not updating automatically
Ab import nahi hota, imported data empty error aa raha
how to get closing of nifty in google data sheet ?
Through Google finance , use index formula and get nifty close prise
Abhi **16000**aata he. Star ko kaise remove karenge
ruclips.net/video/MpQSgcWNgqU/видео.html
imported content is empty error
Sir,
alt + Ctr in keyboard not working
Only alt + enter
Data update nahi ho raha hai sir
Sirji, Google Sheet Update nahi ho raha hai...Please guide
automated playlist me video dekh lena .... all sheets working fine
dekha harshil ? , video me bataya hai ...ki agar koi error hai toh kese dur kare
@@SilentTrader24 sir can you please share link? Sir aaj to data bhi load nahi ho raha hai
Yeh sheet mil sakta hai kya??
tumne try kiya banane ka ? kya muskil aa rahi ye batao pehle
Historical option chain data kaise milega?
3rd party website se
@@SilentTrader24 any free web site or sheet provides data?
As per my knowledge, I have not seen any such data
That's why I use 3rd party Web
Sir jaldi banao na dosri option chain sheet
Bana diya hai ... check playlist automated excel
Bhai pcr data kese nikale excel par
Total PE oi / CE OI
imported content is empty
HOW WE GET SPOT PRICE?
there are two option to get data for spot , 1- google finance 2- moneycontrol
@@SilentTrader24 formula
Sir, Split command nahi chal rahi.
Bhai video banaya hai latest dekhlo.... automated excel playlist me
Phir tum nai kahoge... command nai chal raha
❤️
Jisko excel bilkul nahi ata woh kaise
Free website se data dekhe
Mene ek video bana ya hai ... free website for data ..option chain
SPLIT code please send me
Alt + enter
@@SilentTrader24 sir not working
ruclips.net/video/M7k_oYyOeY0/видео.html
Error aara
ruclips.net/video/MpQSgcWNgqU/видео.html
Split change oi me aara sir
Bahut achhe se samjaye aap
SEEMS LIKE YOU ARE GUJJU... DASH WORD MAKES ME SURE :))))