Analyzing Options Trading Data, What should I look for?
Hello,
I have access to daily excel spreadsheets going back ~3 years which include:
Daily Trade data (majority is options, some equity) ~30-100 trades per day
Daily cash balance
Daily account balance
Daily price data
It's extremely messy, I've been spending the past week trying to clean it up.
Because they are options, I am not entirely sure if I am analyzing it in the best way. What would be the best way to look at this data? Most efficient way to analyze it?
I want to focus on reducing risk and determining better exit points. For example, one way I've analyzed it is to calculate the return of a single options trade after it's been closed and compare it to the historical values from prior days. So if I had a 12% return, I look to see if while I was holding the option there was a day that would have given me a higher return, like 15%. Since these options are a bit volatile, there is often these large fluctuations. I want to see if it would have been more beneficial to free up that capital. and save on opportunity cost by closing it sooner.
I want to get as much information from this data as I can, I am just overwhelmed. I need some guidance!
Thank you very much.
Rerum natus reiciendis quisquam qui est. Qui saepe sint dolores repellendus suscipit vel sed. Sint ut iste voluptatem amet quia.
Molestias non porro qui nihil enim. Molestias eos esse ad temporibus natus. Non ut sit et omnis amet.
Similique laboriosam numquam dolor et ipsa. Consequatur vel officia sit illum eum rerum. Suscipit sit voluptates fuga temporibus distinctio. Sint impedit dolore error consequatur aperiam fuga provident. Ullam id error atque dignissimos ut quisquam dignissimos.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...