How to record Option Chain OI data in Excel using Macros & VBA
HTML-код
- Опубликовано: 8 сен 2024
- In this video, I have shown how to automate option chain data recording process. Automating recording of option chain data helps you to analyse market with altogether different perspective.
In this video, we have used macros & VBA programming to record the data.
Video Sponsor: makemyitr.com/
Promo Code: “KHIMSARIYA”
If you want to get our excel sheet which gives BUY & SELL signals based on price movements + OI change of Nifty & BankNifty with logic & unhidden formulas, you may email us at below given email id.
If you want to contact me, you can get connected on LinkedIn
LinkedIn Profile Link - / keval-khimsariya-296b4...
Email me at cakevalkhimsariya@gmail.com
If you want to know what trades I am doing, you can join my telegram channel
Telegram Channel Link - t.me/optionsig...
Thank you for watching this video.
Option Chain In Excel, Option Chain Analysis, How To Pull Option Chain Data In Excel, Excel Option Chain, Option Chain Data Recording, Record Option Chain Oi Data In Excel, How To Record Oi Data In Excel, How To Record Data In Excel, Record Option Chain Data Using Macro, Record Option Chain Data, Auto Recording, Option Chain VBA, CA Keval Khimsariya
Nice work
Thanks🙏 Nice info, I've recently done this with help of excel formulas, without scripting..
Thank you Keval, you brought it all together here from the first video on. One Love Brother.
Sir agar apka ye poora process complete ho Gaya ha toh pls help and guide for data updation pls reply
Thanks for the detailed explanation.
Sir apne complete chart bna liya h kya or agar bna liya ha to pls help me sir I have some issues pls
Thanks for your values information sir
Thanks a lot!!! God bless you
Badhiya sir!
very well explained!
Very good Info, thank you...
Awesome and detailed one, thanks a lot for Ji for this information. Very helpful !!!
Very good work for begginers.
Hi Keval, Thanks for your hard affords. I have tried your steps, things goes well except the data doesn't AUTO RECORD. Please help me to guide in this regard asap. Thanks bro.
Thank you very much sir for this video.
🙏😇
@@CAKevalKhimsariya Sir kya runtimer macro me 2macro run hosakta he?
Like nifty and reliance.
keval bhai aap guinius ho aap ne to badi baat samja di but usse pehle ke video ke bare me bhi thoda bata dete to sabhi naye log ko samjne me jyada aasani hoti
& dhanyvaad aapka jai hind
Thanks for giving good information👍
Thank you very much...
Hello sir
I have used this method and it works. But after some run time.. I get error code 1004. Something Object defined error.. Can you please suggest any solution for it?
nice sir....
Thanks
Thanks bro
🙏😇
Thank you
Is this work while excel are not in use ? Like if make automatic macro and shut down laptop. Then open after 3:30 , will this able to record all data ?
2:20 But how the time is coming there, just left side of Total Call change in oi. The time it is automatically updating how is it happening.
Love it, thanks
Hi Keval. I am getting expression error - we cannot convert a value of type record to type number
Getting error...."can not run the macro...(location of the file).... The macro may not be available in this workbook or all macros may be disabled."
Though macros are not disabled...
Data is not getting auto recorded and throws the above error. But when I click on the macro button data gets recorded in single row
sir yai only one strike price k liyai hi hoga agar hum ek sath jayda strike price analysis karna chaihai to uskai iya kya hoga
?
How to run an Excel macro on a specific sheet?
please support
Mine is not working, how you add time column there , may be that one is affecting me ?! 🤔
I HAVE A LIVE RUNNING EXCEL SHEET WHICH PROVIDE OPEN INTEREST OF OPTIONS. I WANT TO CONVERT IT INTO GRAPH CHART IN EVERY 15MINS.PLS HELP ME...
❤️❤️❤️❤️
Any way to contact you . Would like your help to develop one Marcro sheet . Would pay
How can you record and view addition in ms excel
how to record data in top row after shifting old data down i mean incert row above...
While recording macro just insert new row , so when you run macro then it will automatically fet h data and insert a new row also
bhai i am getting run time error nine subscript out of range error what to do
sry got it
If in case your Macro isnt working properly, SKIP the CRTL+DOWN step.
Ryte sir but how to solve this error is we don't take step ctrl +down button how the VBA select next coloum
@@nitinjain00 Dim lRow as integer
Dim lCol as integer
lRow = Range("A1048576").End(xlUp).Row
lCol = Range("XFD1").End(xlToLeft).Column
New data top me or previous data niche recording kaise kare
How to contact you?
Will you make one excel sheet as per my condition?
Sir I need criteria regarding excel that what ur following. How do i know? I need to know about interpretation, trend, buy & call signals by using live dumping data. Please do let me know how to do? If I have to pay any money regarding this I will pay sir
One suggestion, add one button to stop the recording.
yes
SIR
Plz make video Aouto Refresh FII,DI ,Prop, Long,short formula Exle shit
Do you share this sheet ?
Bhai auto refresh ke baad isko macro sheet auto open karne se kese roke
How to get out of recording mode in between Mr. KK, recording keeps on going
Sir can u please share this Excel file , I am trying hard to make but unfortunately not able to make it,
Please make a code in Excel VBA.
1 .Copy any data from sheets 1 A1 to sheets 2 A1 in every 5 minute automatically,
2. Data copy start at 0900 am and auto stop at 1535 pm,
3. Data copy stop when NSE holiday and Saturday and Sunday,
4. Data copy start on set time.
I need to get data to my excel sheet , I am ready to pay , please help .
Aapne jo dikhaya hain, new data bottom me record ho raha hain or old data top me hain
How to make the total change in oi and oi summation in live?
use DAX function for calculation in power query. its simple as pivot table calculated fields
sir data is updating but lines donot get change... it overlap on same data....request to help...give some tips.
I think you have problem with relative cell referencing
please watch video again carefully (may be on 0.75X speed)
How to contact you?
how to use this function in VBA
With ThisWorkbook.Worksheets("name of your sheet goes here")
.Range("C2:L37").Copy
.Range("D2").PasteSpecial Format:=3, Link:=1, DisplayAsIcon:=False, IconFileName:=False
End With
Call test
End Sub
SIR , AUTOMATED MACRO ME APKA SCRIPT KAM NAHI KARTA SOLUTION DIJIYENA PLS
KEVAL AAPKA VIDEO DEKH KAR MAINE EXCEL SHEET BANAYA WO KAM BHI KAR RAHA H BUT BACKGROUND MAY KUCH AUR KAM JAB KAR RAHA HU TO EXCEL SHEET PAR DATA COPY NAI HORAHA JAB EXCEL KHOL KAR SCREEN PAR RAKH RAHA HU TANHI DATA AUTOCOPY HORAHA OTHERWISE NAI HORAHA H ISKA KYA SOLUTION HAI???????
Recording ke time dusara excel use karoge toh issue aayega
Solution: recording dusara laptop / desktop me chalu karke rakh do
@@CAKevalKhimsariya ok bro
Computer kee RAM badhao.
Sir kya runtimer macro me 2macro run hosakta he?
Like nifty and reliance.
Dono ke liye alag alag runtimer lagana padega
@@CAKevalKhimsariya thank you sir
Sir note pad ka cod nhi dikh rha h pleas help me sir
Agar 2 baar click ho jata h buttons tab macro double run hota h uske liye koi solution hai kya sir
but the oi values is same on every record why
Sir, Mera 1004 error ara hai isme. Kese fix kree use?
I am. Also getting this error
Can you please tell us how can we stop recording too.. with macro/vba code
Sir ye office kaun si hai 2016 ya aur koi
Sir,
Please provide "script" for auto record of OI data in Google sheets.
CA HAI PAISA MAANGEGA...😄
vba code mila to aasan ho jayega sirji... yaha error aa rahi hai
Hello sir can u share this excel
Aree save hota he lekin daily macro banana pad rha auto remove ho ja rha he
Bhai mujhe nuclear bom bana ne ka seacret batawo naa plees plees
Getting error debugger
Excel file share kariye na
please provide this Excel
Sir ye data mil sakta hain
Share the file plz
Loss hi hota hai
Kya Matlab yar paisa kama nahi sakte
Paisa Kamane ka tarika batao
Bhai automatic record ho ja rahi one sheet to other but..... Use sheet pe baar baar courser chala jaa raha
Apka help chahiye please number dijye