Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

Can I use excel to keep track of my capital gains using LIFO?


  • Please log in to reply
1 reply to this topic

#1 aj777

aj777

  • Members
  • 22 posts
  • OFFLINE
  •  
  • Local time:05:09 PM

Posted 13 January 2018 - 07:07 PM

Hi, I want to use excel to track my capital gains from my cryptocurrencies. If you don't know what cryptocurrencies are, just assume they're stocks, as it's the same thing for all intents and purposes.

 

Basically whenever I buy or sell a crypto, I want to enter the trading symbol (e.g. BTC), how much I bought or sold, the price per coin, and the fees.

 

I then want the spreadsheet to automatically calculate my capital gains whenever I sell, using LIFO accounting.

 

Is this possible?



BC AdBot (Login to Remove)

 


#2 britechguy

britechguy

    Been there, done that, got the T-shirt


  • Moderator
  • 7,534 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:Staunton, VA
  • Local time:06:09 PM

Posted 15 January 2018 - 07:59 PM

Yes.

 

There are scads of LIFO spreadsheet templates out there.  See these search results:  https://duckduckgo.com/?q=excel+%22lifo%22+spreadsheet+template&norw=1&t=hg&atb=v91-1&ia=web 

 

Specifically:  http://exceltemplate.net/finance/cost-of-goods-sold-calculator/

                     http://www.exceltemplates.org/cogs-calculator.html

 

or dig around until you find one that has a presentation format you prefer.


Brian AKA Bri the Tech Guy (website in my user profile) - Windows 10 Home, 64-Bit, Version 1803, Build 17134 

 

     In a modern society where everyone thinks their opinion deserves to be heard nothing annoys me more than individuals who mistake their personal preferences for fact.

         ~ Commenter TheCruyffGurn on the The Guardian website, 8/13/2014

 

              

 





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users