Can I update Only current stock prices, non-manually?
Options
John16
Member ✭✭
I want to track stock prices on a week to week basis, so that a portfolio shows the week-to-week change in Price Day Change and Day Gain/Loss columns. The Update Quotes selection retrieves the daily prices since the last update. I want only a snapshot of the current price, not the history since last update.
I have over 50 stocks in the portfolio so manually updating them weekly is not a valid solution.
Thanks in advance for the help.
John
I have over 50 stocks in the portfolio so manually updating them weekly is not a valid solution.
Thanks in advance for the help.
John
0
Best Answer
-
Instead of using Quicken to download the quotes, I suggest you import a CSV file generated using a Google sheet. For example:
When we download the Google sheet as a CSV file, the file is formatted appropriately for import into Quicken:
To learn more about Google sheets, I suggest you review: https://www.google.com/sheets/about/
5
Answers
-
PS. This is for Quicken 2020, R26.23.0
-
Instead of using Quicken to download the quotes, I suggest you import a CSV file generated using a Google sheet. For example:
When we download the Google sheet as a CSV file, the file is formatted appropriately for import into Quicken:
To learn more about Google sheets, I suggest you review: https://www.google.com/sheets/about/
5 -
Absolutely brilliant. I sort of figured that there was no option to set, so this will do what I want. I've never used Google sheets so this is an opportunity to learn. Thanks!0
This discussion has been closed.