Accounting/multiple currencies/Cryptocurencies here are 2 questions in the shared Google Sheet file For Q1, you can provide the answer directly in the file. For Q2, please feel free to use VBA/Python/Excel/Google Sheet to solveit. If you use VBA/Python, please send us the script.