I am currently using Quicken for Windows 2017 version. Can I download or upload stock prices?
Options
dfc551
Member ✭
If I have history for a stock symbol for daily end results for last 30 days in an Excel file, can I upload them into Quicken 2017?
0
Answers
-
You may export the appropriately formatted data from the Excel file to an CSV file that may be imported into Quicken. I suggest you review the built-in documentation in the topic: press F1
2 -
Thank you for your response!! That is what I was thinking but didn't know the format of the file or command in Quicken to use to upload. I will check it out and let you know how it works! Thank you again for responding!0
-
I was able to download the ending price quote for each day with the following format in a CSV file: HON 153 6/10/20
This gave me the ending quote price for 6/10/20 for Honeywell stock for any number of days specified.
I was not able to find an acceptable format for including High, Low, and volume by day for Honeywell Stock. This was a big help but ideally I'd like to include the High, Low, and volume for the day. However, all in all very helpful!! Thank you!0 -
FYI - as was mentioned in another thread - you might use Google Sheets,and the =GoogleFinance function - to get all the info
QWin - R54.16 - Win10
0 -
If you haven't already, you may want to review: https://community.quicken.com/discussion/7542737/faq-importing-security-prices-including-hi-lo-vol/p1dfc551 said:I was able to download the ending price quote for each day with the following format in a CSV file: HON 153 6/10/20
This gave me the ending quote price for 6/10/20 for Honeywell stock for any number of days specified.
I was not able to find an acceptable format for including High, Low, and volume by day for Honeywell Stock. This was a big help but ideally I'd like to include the High, Low, and volume for the day. However, all in all very helpful!! Thank you!1
