Hello,
When I export my security account details to CSV, all the sell transactions have a negative price and a positive quantity, where I think it makes more sense to have it the other way around, ie a negative quantity and a positive price.
This would also make it a lot easier for me to run my pivot tables on the data and get the correct results.
Is there a reason its this way or can it be changed to properly export the quantity
?
The export works like WYSWYG.
What you see is what you get.
Your example indicates you closed a trade witj a loss, isn’t that correct?
I did not sell at a loss. I sold 100 shares at $47.11 each. So the value in my securities account does decrease by $4711 as that goes into the related cash account, but I feel it should show quantity-
“-100” and price “$47.11”
Unfortunately, you’re showing your Excel but not your booking.
When I look at all bookings, filtered to sell transactions, I never see negative values, independent of a gain or loss.
Thanks for your responses. The problem was between brain and keyboard, I figured out what I was doing wrong this morning.DOH!
Inbound delivery and sell instead of outbound delivery?
No, even dumber! The exported CSV file contains the total value (which is negative and correct) and the quantity of shares. I needed the per share price, so I added a column and calculated it, but I should have used the absolute result, which gets rid of the negative price per share.