Forum Discussion

rejean2300's avatar
rejean2300
Copper Contributor
Dec 09, 2023

How to add the APY on a profit/loss crypto spreadsheet?

I have the essentials only need to include the income (APY)  (10% Cosmos) before profit and loss results.

2 Replies

  • mathetes's avatar
    mathetes
    Gold Contributor

    rejean2300 

     

    You see you have well over 75 views and no responses. Do you suppose it's because you're not asking a clear question; in fact, you're not giving much info at all.

     

    At the very least, an image of all those "essentials" and how you've arrayed them would help. But also a bit more explanation of the terminology. Words like "income" are widely known. Less so is the parenthetical "10% Cosmos" yet you add it as if it explains it all!

    • rejean2300's avatar
      rejean2300
      Copper Contributor
      how to delete my post i think i resolve it
      Atom
      DATE TOTAL qty price value fees
      18-Feb-21 107 3.254729 31.61 102.88 4.11

      18-Nov-21 0.000497 38.97 0.01936809 0

      end of year
      Total 107 3.255226 0 4.11
      current value 3.255226 40.3 131.1856078
      gain/loss 24.1856078
      % 22.60%
      I could not post this .

Resources