Feature request: Canadian currency conversion

isonium / CloudAtCost-Wallet

Python code to export CloudAtCost Wallet Transactions to a .CSV file

MIT License

1 stars 1 forks source link

Feature request: Canadian currency conversion #5

Closed glaverty closed 2 years ago

glaverty commented 2 years ago

I'm trying to use this to do my taxes - much better than the copy paste I was trying to do!. It would be convenience if the google doc it also handled the USD->CAD currency conversion, and displayed CAD as another column anywhere we display USD.

mrd0n commented 2 years ago

Hi - One option is to add this formula to Column M, Row 3 in the google sheet (and copy down): =index(GOOGLEFINANCE("Currency:USDCAD", "price",J3,1),2,2)

This will use the google finance api to lookup the Current Conversion on each day from USD to CAD

mrd0n commented 2 years ago

I updated the Google Sheet Template to include CAD prices

glaverty commented 2 years ago

Nice! That's perfect, thank you very much!!!