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

John16 · May 2020

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 · May 2020

Instead of using Quicken to download the quotes, I suggest you import a CSV file generated using a Google sheet. For example:

Image: https://us.v-cdn.net/6031128/uploads/editor/ng/h1k0yvgjevdd.png

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 · May 2020

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

Sherlock · May 2020

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 · May 2020

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!

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

Welcome!

Best Answer

Answers

Welcome!

Quick Links

Categories