FIFO Inventory problem

[srodriguezv]

Hey guys,
This is my first post in this forum.
First of all I would like to be excused for my english, im from Chile so my native language is spanish. Ill try to do my best to explain my problem.
So I have this excel file with a macro to introduce the products, in my case shares, with the amount, price, date and type of movement (buy or sell).
The thing is that when i sell i want to do it by the FIFO method but im not achieving that.
I can upload my file with an example of what is doing wrong.

For example first ill buy 100 shares of Apple with the price of $15 per share,
then ill buy 50 shares more with a price of $20 per share,
to finally sell 120 shares for a price of $25 per share.

if i do the mental math my gain of capital with FIFO method should be:
100*(25-15) + 20*(25-20) = 1100
But im not getting that.
Please if you could help me ill be very happy.

Thanks

I've done the same post in another forum but got no answer
https://www.excelforum.com/excel-programming-vba-macros/1186919-fifo-inventory-problem.html#post4663079

 

[srodriguezv]

sorry im not able to attach my excel
but you can see it in this link
https://www.excelforum.com/excel-programming-<acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">vba</acronym>-macros/1186919-fifo-inventory-problem.html#post4663079

 

[cerfani]

Excel Forum requires login to download files or view pictures so I don't think everyone can see your file. Can you take a screen shot? And upload the image to a website like Imgur.com and put the image here

 

[srodriguezv]

Imgur: The most awesome images on the Internet

Imgur: The most awesome images on the Internet

Imgur: The most awesome images on the Internet

Imgur: The most awesome images on the Internet

Imgur: The most awesome images on the Internet

Imgur: The most awesome images on the Internet

Imgur: The most awesome images on the Internet

 

[srodriguezv]

thanks for your quick answer cerfani,
i've tried that but the administrators have to review my post first

 

[srodriguezv]

Do you know when im gonna be able to post with attachments??

 

[Joe4]

No one can upload files to this site. But there are tools you can use to post screen images. They are listed in Section B of this link here: http://www.mrexcel.com/forum/board-a...forum-use.html.

Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.

 

[srodriguezv]

Imgur: The most awesome images on the Internet
in this image is my main sheet in which you type the information, i mean kind of transaction( buy or sell), amount of stocks, price per unit, date

Imgur: The most awesome images on the Internet
in this image you can see where the info goes to, the macro generates a sheet per stock entered in the program


the rest of the images are form my vba code.
Imgur: The most awesome images on the Internet

Imgur: The most awesome images on the Internet

Imgur: The most awesome images on the Internet

Imgur: The most awesome images on the Internet

Imgur: The most awesome images on the Internet

thanks.

 

[srodriguezv]

thaks for clear me that out.