search

rlan / convert-csv-schwab2pp

Converts a Charles Schwab transaction CSV file to a ready-to-import CSV file for Portfolio Performance.
MIT License
9 stars 1 forks source link

Support sell transaction of securities #3

Open rlan opened 2 years ago

rlan commented 2 years ago

"Sell" is supported as an educated guess. I don't have an actual transaction to verify.

ipaulo commented 4 months ago

"06/11/2024","Sell","FAK","FAKE ETF","17","$27.00","$0.25","$98.75"

rlan commented 4 months ago

@ipaulo Thank you again for sharing transaction data. Will update.

rlan commented 1 month ago

@ipaulo I still have no actual sell transactions on my Schwab account. I am update the code to include the sell data you shared. I observe the following inconsistency. Number of shares sold is 17 at $27.00 per share. Fee is $0.25. So the proceeds should be 17*27 - 0.25 = 458.75. In the data you shared, amount is 98.75. This amount is very different from the math I just did. If you feel comfortable, would you mind sharing another data point? Perhaps filling the Symbol and Description columns as fake as you have done. Thank you.