Tejasvita SoniTejasvita Soni
Student at Lachoo Memorial College of Science & Tech Follow 82
Tejasvita Soni, Student at Lachoo Memorial College of Science & Tech
  • views 19k
  • users 297
  • reviews 25
  • Downloadable Best Practices 9
  •  
  • views 19k
  • users 297
  • reviews 25
  • Downloadable Best Practices 9

Publish your own Best Practice

keyboard_arrow_leftkeyboard_arrow_right

Discuss with Tejasvita Soni

Ask Tejasvita Soni questions about their Best Practices. Go ahead!

Post Comment

  • Tejasvita Soni
    2 years ago
    Authorstar
    * comment deleted *
    arrow_drop_uparrow_drop_downReply reply
    • fro3en
      2 years ago
      Eloquens Member
      Hello! I bought your table and am very pleased with it, but there is one problem!
      I have a screenshot that would show everything at once, but I cannot send you a screenshot, so I will try to describe it.
      Let's say that 1.1.11 I bought 1 Bitcoin for 1000$(BTC_USD). 5.11.11 I bought one more! I have 2 bitcoins now(2000$)! Next, on 5.11.11, I bought 10 more lightcoins for 1000USD, which is equivalent to one Bitcoin! Now I have 2BTC and 10LTC (1BTC)! Now on 10.11.11 I buy 1BTC for 10LTC (BTC_LTC). And now 15.11.11 when I want to sell all 3BTC(BTC_USD) I have a problem in your table, since she does not know that I bought 1ВТС for 10LTC, an error occurs in the calculation.
      "CUM Cost of BTC Sold" and "FIFO Gain (USD)" stop showing data. How to solve it!? I need the table to go into the minus when needed, but it creates a link to the wrong parameter in "Total BTC Purchased".
      Help me please! Thank you in advance!
      1arrow_drop_uparrow_drop_downReply reply
      • Tejasvita Soni
        2 years ago
        Authorstar
        Hi Fro3en,

        Thanks for the purchase. Profit/loss for different currency pairs should be calculated in separate sheets. Please put the transactions for BTC/USD pair in one sheet and LTC/USD in another sheet. In case you did any trade for BTC/LTC pair, and want it to include it in the calculations, then you will need to convert LTC quantity into equivalent BTC (separately) and then put that numbers in the sheet. I hope it makes sense.

        Regards
        Soni
        arrow_drop_uparrow_drop_downReply reply
      • turboblast
        9 months ago
        Eloquens Member
        Hi; I am on the most recent version and am having a problem with the quantity in hand calculation in on of the wooksheets. It seems to miss the quantity from the first purchase for some reason.
        arrow_drop_uparrow_drop_downReply reply
        • Tejasvita Soni
          8 months ago
          Authorstar
          Thanks for giving an honest review. I hope you are happy with the solution.
          arrow_drop_uparrow_drop_downReply reply
        • Tejasvita Soni
          2 years ago
          Authorstar
          * comment deleted *
          1arrow_drop_uparrow_drop_downReply reply
          • Syed Gardezi
            2 years ago
            Eloquens Member
            Hi Soni,

            hope you are doing great. I must say making BTC FIFO template is a great effort. I just need to ask a couple of things.
            1. What is the point of making Sale cost part 1& 2 column.
            2. There is no such column of commission? you should have added commission with BTC buy price (i.e. fee charged by exchanges) and then subtract from the sold price to get FIFO capital gain as end of the day we need to have capital gain/loss as a record. just wondering if it is possible for you to do that?
            2arrow_drop_uparrow_drop_downReply reply
            • Tejasvita Soni
              2 years ago
              Authorstar
              Hi Syed,

              Thanks for your kind review and comment.

              1. Columns M:P contain formulas for calculating costs of coins sold in split/parts. These formulas are complex and doing the calculation on FIFO method. These contains intermediate results. You may show/hide them as per your preference.

              2. In next version, I will include Commission field also and will let you know when it is uploaded.

              Regards
              Soni
              2arrow_drop_uparrow_drop_downReply reply
            please wait...