Can I update Only current stock prices, non-manually?

John16

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

Sherlock

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/

John16

PS. This is for Quicken 2020, R26.23.

Sherlock

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/

John16

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!