Big thank you for the clear explanation, sir. I'm an accountant and I was embarrassed to be struggling to devise an easy way to track cost basis of my crypto investments in Excel. This lead me down the right path. Thanks again!
You say that is not professional. Yes it is. But you show us the logic of this FİFO. So I can use this method on my Portfolio Table. I am very glad for that.
Thank you. You provided a perfect solution to a problem I have had for a couple of years. I could not adequately track my crypto trades with FIFO applied on any SS I could find on RUclips or the internet. I took you "pens" demo and adapted it to the crypto world and it seems to fit very well. We'll see if Big Brother (IRS) will accept the calculations. Again, thank you.
Hold on... You didn't calculate the individual profit of each sale you had at the start, which is what you need to report. How would you automate the splitting of a sale between the two (or more) respective purchases? I'm not sure it can be done without VB, as it involves creating new lines. Or you do it manually like you did in the beginning, maybe with the aid of some cross-check columns.
Thanks for such a clear explanation Magic Monk! Much appreciate it I would love to see how earnings per sale may be displayed so easily as what you have tought so far!
Good learning with clear explanation. Like to see the calculation of the profit against each sell transaction and anual % return against each sell transaction. Also love to see the weighted average purchase price and value of the closing stock with current sell cost.
How can you calculate the individual selling batch costs? For example, you sold 89 Pens on 20 March & if you would like to calculate the cost of selling these 89 pens how do I do that?
Insted of using total unit...try to use Cumilative total quantity sold column in next column (L column in this video) by putting =sum($K$6:k7) then you can also drag it down
![How to keep Inventory using an Excel Spreadsheet - [create your own Template]](http://i.ytimg.com/vi/msQoTuCsKJ4/mqdefault.jpg)
Big thank you for the clear explanation, sir. I'm an accountant and I was embarrassed to be struggling to devise an easy way to track cost basis of my crypto investments in Excel. This lead me down the right path. Thanks again!
You say that is not professional. Yes it is. But you show us the logic of this FİFO. So I can use this method on my Portfolio Table. I am very glad for that.
Thank you. You provided a perfect solution to a problem I have had for a couple of years. I could not adequately track my crypto trades with FIFO applied on any SS I could find on RUclips or the internet. I took you "pens" demo and adapted it to the crypto world and it seems to fit very well. We'll see if Big Brother (IRS) will accept the calculations. Again, thank you.
This was a great video. It took a bit of work for me unraveling two years of activity in the cryptocurrency market, but your layout made it a breeze.
Hold on... You didn't calculate the individual profit of each sale you had at the start, which is what you need to report. How would you automate the splitting of a sale between the two (or more) respective purchases? I'm not sure it can be done without VB, as it involves creating new lines. Or you do it manually like you did in the beginning, maybe with the aid of some cross-check columns.
Ya, only piece missing, fuck
Is there a way to itemize the cost to see each individual profit margin? Or is it only as a whole?
Thanks for such a clear explanation Magic Monk! Much appreciate it
I would love to see how earnings per sale may be displayed so easily as what you have tought so far!
Good learning with clear explanation. Like to see the calculation of the profit against each sell transaction and anual % return against each sell transaction. Also love to see the weighted average purchase price and value of the closing stock with current sell cost.
that's a good idea, thanks buddy
Many Thanks! It is exactly what I was looking for.
Deep thanks for your detail explaination
You saved my Career,thank you so much
🤣🤣🤣
Thanks u increase my skill on top
Thank you sooo much! It helped me a lot!
How to deal with purchase return if any?...what formula to use or adjust here? Please help..
How can you calculate the individual selling batch costs? For example, you sold 89 Pens on 20 March & if you would like to calculate the cost of selling these 89 pens how do I do that?
Insted of using total unit...try to use Cumilative total quantity sold column in next column (L column in this video) by putting =sum($K$6:k7) then you can also drag it down
sir, make vedio if there are many items it will be greatfull to you, thanks
Thank you sir
Thank you sir. I got my answer
nice
You are not good presenter