Hello, I have developed a FIFO stock profit sheet for both longs and shorts. The Long transactions seem to be working fine but the short transactions not so much.
I am attaching the worksheet. If you play around with the quantities bought and sold you can see the short FIFO is wrong. Any ideas?
Thanks
Dan
Bookmarks