Community Homepage
Discussions
Categories
Quicken for Mac
Quicken Lifehub
Quicken Mobile
Quicken on the Web
Quicken for Windows
Support
Quicken Classic
Quicken Simplifi
Getting Started
Community Training FAQs
Using and Improving the Community
Connect and Engage
Announcements & Alerts
Announcements
Alerts, Online Banking & Known Product Issues
Product Ideas
Beta
Home
Quicken Classic for Windows
Investing (Windows)
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
Find more posts tagged with
Accepted answers
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.
All comments
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
Quick Links
All Categories
Recent Posts
Activity
Unanswered
Best Of