Stock splits cause incorrect tallying

anthonyk1225 / robinhood-to-xlsx

Python package that grabs your robinhood data and exports it to excel

MIT License

14 stars 3 forks source link

Stock splits cause incorrect tallying #21

Open anthonyk1225 opened 4 years ago

anthonyk1225 commented 4 years ago

If holding options or shares of a company when a stock split or reverse stock split happens, the profit/loss on sheet 2 for options.xlsx or orders.xlsx won't be accurate for those companies.

kfchou commented 4 years ago

Was just about to submit an issue on this. Glad you're already working on it!

anthonyk1225 commented 4 years ago

Yep! Doing a bit of recon on it so may take a little bit longer. I'll have a solution eventually :D

kfchou commented 4 years ago

fyi, another scenario in addition to splits or reverse splits is when a company itself splits into two separate companies, or participate in mergers. For example, $SIR split into $OPI and $ILPT in 2018.