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.