How can I currently track my cryptocurrency wallet in Quicken.

Safi

How can I currently track my cryptocurrency wallet in Quicken. Assume I have a wallet with more than five crypto. If quicken does not have this feature, what is the most current practical way in the current quicken version

Tom Young

I've set up a separate "Coinbase" Account for my crypto with a separate "security" for each coin.  I record my buys to the 6 digits of precision and use the correct "per share" amount for the full 8 digit purchase.  That typically gets me some fairly small dollar rounding error which I record as a cash adjustment + or - and I'll also note the correct 8 decimal place number in the memo.  The few sells I've done  I've recorded in a similar fashion.  Then each day I update the prices of each security.

I have very few transactions in any given year and this works fine to give me an indication of the total holdings in dollars.  It certainly wouldn't work as well if you were very active and actually using the crypto as "currency", making many small purchases in various cryptos.  In that case it would make more sense to use one of the hardware or software wallets that are available. 

Frankx

Hi @Safi,

Currently, Quicken does not support crypto currency, however it is one of a number of planned improvements that they are currently working on.  Here's a link to an Idea Post tht has additional information but unfortunately no specific date - LINK.

Obviously, for now, you can track the investment manually and there are a number of websites from which you could download prices as part of your manual tracking.

Frankx

Safi

Many thanks @Frankx
If I am going to go manually, what will be the best practice to record in Quicken, assume I will be treating the all wallet of different crypto as one (ex: open one account). Do I just create an asset account and recorded the increase and decrease, or is there other way

splasher

One of the issues currently with trying to track crypto-currencies is that Quicken does not retain enough precision (number of decimal places) to track it accurately.

Safi

@splasher what will be the practical way to record cryptocurrencies in Quicken manually. Assume that I will treat multiple crypto in the wallet as one and just going to update my stand manually.

splasher

You could treat it like a cash account and just update the current balance by adding a deposit or a debit of recent changes.
I'm not aware of any "great" way to track it in Quicken.

Tom Young

I've set up a separate "Coinbase" Account for my crypto with a separate "security" for each coin.  I record my buys to the 6 digits of precision and use the correct "per share" amount for the full 8 digit purchase.  That typically gets me some fairly small dollar rounding error which I record as a cash adjustment + or - and I'll also note the correct 8 decimal place number in the memo.  The few sells I've done  I've recorded in a similar fashion.  Then each day I update the prices of each security.

I have very few transactions in any given year and this works fine to give me an indication of the total holdings in dollars.  It certainly wouldn't work as well if you were very active and actually using the crypto as "currency", making many small purchases in various cryptos.  In that case it would make more sense to use one of the hardware or software wallets that are available. 

Safi

@Tom Young thanks for the info

LocoMoco10

[removed - no soliciting]

JeremyGNJ

I have created a way to effectively track crypto prices in quicken, and it's mostly automated once you get it it set up:
https://github.com/JeremyGNJ/quicken

BillOKeefe

Hi @JeremyGNJ. I tried your approach, but when I try to import the generated CSV file into Windows Quicken Deluxe (v40.21) it says "no valid prices found to import". I checked the file, and it looks to me like it aligns with the expected format according to Quicken Help, except the Help example shows just 2-digit dates (which suggests this was written a long-long time ago . So I tried that as well, but I get the same error. Any idea what the problem might be?

JeremyGNJ

> @BillOKeefe said:
> Hi @JeremyGNJ. I tried your approach, but when I try to import the generated CSV file into Windows Quicken Deluxe (v40.21) it says "no valid prices found to import". I checked the file, and it looks to me like it aligns with the expected format according to Quicken Help, except the Help example shows just 2-digit dates (which suggests this was written a long-long time ago . So I tried that as well, but I get the same error. Any idea what the problem might be?

Sorry I didnt see this til now.
Not sure what to tell you. I JUST ran this and it worked for me. My CSV output look like this...do you see the same?

zzzBTC,29864.04000000,6/4/2022
zzzBTC,29700.21000000,6/3/2022
zzzBTC,30452.62000000,6/2/2022


Only thing I can think to suggest is that I've only run this particular script in powershell 7.x