An Excel Sheet to Track Your Crypto Portfolio and Calculators for Stop-Loss, Weighted Average, More..

in #portfolio • 8 years ago (edited)

Hello Everyone,

The objective of this excel sheet is to track your short term and long term crypto investments with real time price data obtained from www.coinmarketcap.com.

The other goal is to perform following basic calculations easily by inputting purchase price and sell price.

  1. Profit-loss calculator from the purchase price and current price
  2. Stop-loss calculator from the purchase price
  3. Risk reward ratio based on target price and stop loss price
  4. Weighted average price calculator
  5. Short sell profit calculator
    I hope this excel sheet helps the community. If you have any suggestions and feedback please leave a comment.

Click the link below to download the Excel sheet. The instructions are embedded in the Excel sheet (cell L38)
https://1drv.ms/x/s!AhIqMXcUWPcejOEkRORkLFmCthQx8A

Old versions of Excel need Power Query plugin (link given in the instructions)

Thanks! bdr90 for the following post (How to import coinmarketcap data into excel)
https://steemit.com/cryptocurrency/@bdr90/import-coinmarketcap-data-into-excel-with-automatically-update-in-few-steps

#crypto #calculator #excel #howto
8 years ago in #portfolio by
$0.00
    1 vote
    Reply 4
    Sort:  
  • Trending
    • [-]
     8 years ago 

    You should check out Cointracking Portfolio Manager.

    It has

    1. Automatic import of trades through APIs.
    2. Average purchase and sale price reports.
    3. Booked and unbooked profits.
    4. Ability to calculate your taxes.
    5. Set up price notifications.

    For details of how to use these features checkout this post.

    $0.00
      Reply
      [-]
       8 years ago 

      Anything that is free or closed is always risky. It is highly risky if it is both. And blockfolio falls in this category.

      You should check out Cointracking Portfolio Manager.

      It has

      1. Automatic import of trades through APIs.
      2. Average purchase and sale price reports.
      3. Booked and unbooked profits.
      4. Ability to calculate your taxes.
      5. Set up price notifications.

      For details of how to use these features checkout this post.

      It is both paid and open-sourced(may be not full). As in if you pay the full amount you will get the full source code as well.

      $0.00
        Reply
        [-]
         7 years ago 

        Congratulations @sriharsha88! You have received a personal award!

        1 Year on Steemit
        Click on the badge to view your Board of Honor.

        Do not miss the last post from @steemitboard:

        Trick or Treat - Publish your scariest halloweeen story and win a new badge
        SteemitBoard notifications improved

        Support SteemitBoard's project! Vote for its witness and get one more award!

        $0.00
          Reply
          [-]
           6 years ago 

          Congratulations @sriharsha88! You received a personal award!

          Happy Birthday! - You are on the Steem blockchain for 2 years!

          You can view your badges on your Steem Board and compare to others on the Steem Ranking

          Vote for @Steemitboard as a witness to get one more award and increased upvotes!
          $0.00
            Reply

            Coin Marketplace

            STEEM 0.13
            TRX 0.34
            JST 0.034
            BTC 110663.51
            ETH 4371.64
            SBD 0.84