search

anthonyk1225 / robinhood-to-xlsx

Python package that grabs your robinhood data and exports it to excel
MIT License
14 stars 3 forks source link

Tallying P/L for expired option contracts #24

Open kfchou opened 3 years ago

kfchou commented 3 years ago

Hello! Hope all is well!

Right now, expired call options still shows up as "unrealized premium" in the P/L table. Instead, expired call options should show up in the P/L column. I haven't experimented with puts, so don't have data points for those.

Cheers!

anthonyk1225 commented 3 years ago

Hey! I'm gonna get to this soon, I promise!

anthonyk1225 commented 3 years ago

In addition to stock splitting, #21 there's a problem when strike prices for contracts change before expiration. I'm not sure if this is the problem but it's probably a strong possibility it's one of the two issues.

Not sure how to fix this since RH doesn't have endpoints to map strike prices as far as I can tell. Same thing for splits and the best I can come up with for now is statically keeping split history and mapping it under the hood. I'll keep this open and hopefully it can be solved soon.