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)
Import of security prices from Comma Delimited file - prices are not being updated
chall3809
I'm trying to update prices for a list of cryptocurrencies using a Comma Delimited ASCII file and the prices are just not being updated. I've created each crypto with a Symbol and Name as type "Other" and have each one selected to Not Download Quotes. I've tried editing the file with both Excel and Notepad as either a comma delimited or just spaces between, ie:
BTC, 6935.25, 4/20/2020
or
BTC 6935.25 4/20/2020
Neither one works.
Any ideas?
Find more posts tagged with
Accepted answers
Dan Glynhampton
I've just tested it and it seems to be working OK for me. Some things to check:
Make sure that the ticker symbol you are using matches exactly with the ticker symbol in Quicken (BTC in your example).
Make sure that there isn't already a price for the date you are using in the CSV file that you have manually entered in Quicken - Quicken uses a hierarchy to determine which prices take priority if there is more than one for a given date:
Manually entered Price
Current Price from Update Quotes
Historical Price from Price History
Price from the OFX response of Update Broker
Imported Price (CSV)
Transaction Price (manually entered OR OFX update from Broker)
Imported prices are well down that list at number 5, so any price from sources 1-4 will override the ones you are trying to import.
If none of that helps post more details of the Quicken version you are using and exactly what steps you are taking to try and import the prices.
All comments
Dan Glynhampton
I've just tested it and it seems to be working OK for me. Some things to check:
Make sure that the ticker symbol you are using matches exactly with the ticker symbol in Quicken (BTC in your example).
Make sure that there isn't already a price for the date you are using in the CSV file that you have manually entered in Quicken - Quicken uses a hierarchy to determine which prices take priority if there is more than one for a given date:
Manually entered Price
Current Price from Update Quotes
Historical Price from Price History
Price from the OFX response of Update Broker
Imported Price (CSV)
Transaction Price (manually entered OR OFX update from Broker)
Imported prices are well down that list at number 5, so any price from sources 1-4 will override the ones you are trying to import.
If none of that helps post more details of the Quicken version you are using and exactly what steps you are taking to try and import the prices.
chall3809
Thanks Dan! For whatever reason after doing exactly the same things as I did yesterday - it worked today. Go figure...
Quick Links
All Categories
Recent Posts
Activity
Unanswered
Help
Best Of