Security View: Update Price for a Specific Date , i.e., dd/mm/yyyy

Options
DonL_TX
DonL_TX Member
edited September 2022 in Investing (Windows)
Opening one investment record, going to the Security View and then clicking on Update, will update ALL investment prices with the price on all Friday dates through the current date.

I want to automatically update a specific date, i.e., May 31, 2022, which is a Wednesday, for all investments.

Is there such a process without having to access each investment and then use the Price History method?
:s :*

Best Answers

  • Jim_Harman
    Jim_Harman SuperUser ✭✭✭✭✭
    Answer ✓
    Options
    There is no automatic way to update prices for a specific date, but a reasonably quick manual way is:

    Go to Investing > Portfolio and next to Show: pick Quotes or any view that includes the securities you want to update and the Quote/Price column.

    Next to Group by: pick Security

    Next to As of: enter the date you want.

    Now you can go to the Quote/Price for each security you want to update and enter the price. 


    QWin Premier subscription
  • Boatnmaniac
    Boatnmaniac SuperUser ✭✭✭✭✭
    edited July 2022 Answer ✓
    Options
    DonL_TX said:
    Opening one investment record, going to the Security View and then clicking on Update, will update ALL investment prices with the price on all Friday dates through the current date.
    If you go to Security Detail View, do not click on UpdateInstead, click on More and then click on Download Historical Prices.  Then you can select the time period you want downloaded (5 days, month, year, 2 years, 5 years).  You can also select specific securities or all securities for pricing history to be downloaded.  Then click on Update Now and Quicken will download end of day prices for every trading day in the time period you select.
    DonL_TX said:
    I want to automatically update a specific date, i.e., May 31, 2022, which is a Wednesday, for all investments.

    Is there such a process without having to access each investment and then use the Price History method?
    I know of no way to select downloads for only 1 specific day.  But by using the process I mentioned above you will get all the daily prices, including Wednesdays.
    You can also set up One Step Update (OSU) to include downloading of securities prices for the last 5 days.: 
    • Tools > Security List > check the Download Quotes box for each security you want prices downloaded...or click on the Select All button > Done.
    • One Step Update > Update Settings > check the box for "Download quotes and investment information" > click on the following link for "select quotes" > Apply > either Update Now or Close.
    You can also set up OSU to run automatically.:  
    • From the Update Settings popup > Schedule Updates.
    • Alternately, Tools > Schedule Updates.
    • Select when you want Quicken to automatically run OSU.
    • As long as your PC is running and Quicken is kept open, Quicken will automatically run OSU on the selected schedule.
    Does this help you get want you want?

    Quicken Classic Premier (US) Subscription: R55.26 on Windows 11

  • Jim_Harman
    Jim_Harman SuperUser ✭✭✭✭✭
    Answer ✓
    Options
    Downloading historical prices as @Boatnmaniac recommends will get daily prices for the last 30 days, Friday prices for the previous 11 months, and month-end prices before then.

    It would certainly to reconcile with brokerage statements if Quicken also downloaded month-end prices for dates 1 - 12 months ago.  
    QWin Premier subscription

Answers

  • Jim_Harman
    Jim_Harman SuperUser ✭✭✭✭✭
    Answer ✓
    Options
    There is no automatic way to update prices for a specific date, but a reasonably quick manual way is:

    Go to Investing > Portfolio and next to Show: pick Quotes or any view that includes the securities you want to update and the Quote/Price column.

    Next to Group by: pick Security

    Next to As of: enter the date you want.

    Now you can go to the Quote/Price for each security you want to update and enter the price. 


    QWin Premier subscription
  • Boatnmaniac
    Boatnmaniac SuperUser ✭✭✭✭✭
    edited July 2022 Answer ✓
    Options
    DonL_TX said:
    Opening one investment record, going to the Security View and then clicking on Update, will update ALL investment prices with the price on all Friday dates through the current date.
    If you go to Security Detail View, do not click on UpdateInstead, click on More and then click on Download Historical Prices.  Then you can select the time period you want downloaded (5 days, month, year, 2 years, 5 years).  You can also select specific securities or all securities for pricing history to be downloaded.  Then click on Update Now and Quicken will download end of day prices for every trading day in the time period you select.
    DonL_TX said:
    I want to automatically update a specific date, i.e., May 31, 2022, which is a Wednesday, for all investments.

    Is there such a process without having to access each investment and then use the Price History method?
    I know of no way to select downloads for only 1 specific day.  But by using the process I mentioned above you will get all the daily prices, including Wednesdays.
    You can also set up One Step Update (OSU) to include downloading of securities prices for the last 5 days.: 
    • Tools > Security List > check the Download Quotes box for each security you want prices downloaded...or click on the Select All button > Done.
    • One Step Update > Update Settings > check the box for "Download quotes and investment information" > click on the following link for "select quotes" > Apply > either Update Now or Close.
    You can also set up OSU to run automatically.:  
    • From the Update Settings popup > Schedule Updates.
    • Alternately, Tools > Schedule Updates.
    • Select when you want Quicken to automatically run OSU.
    • As long as your PC is running and Quicken is kept open, Quicken will automatically run OSU on the selected schedule.
    Does this help you get want you want?

    Quicken Classic Premier (US) Subscription: R55.26 on Windows 11

  • Jim_Harman
    Jim_Harman SuperUser ✭✭✭✭✭
    Answer ✓
    Options
    Downloading historical prices as @Boatnmaniac recommends will get daily prices for the last 30 days, Friday prices for the previous 11 months, and month-end prices before then.

    It would certainly to reconcile with brokerage statements if Quicken also downloaded month-end prices for dates 1 - 12 months ago.  
    QWin Premier subscription
  • Boatnmaniac
    Boatnmaniac SuperUser ✭✭✭✭✭
    edited July 2022
    Options
    Downloading historical prices as @Boatnmaniac recommends will get daily prices for the last 30 days, Friday prices for the previous 11 months, and month-end prices before then.

    It would certainly to reconcile with brokerage statements if Quicken also downloaded month-end prices for dates 1 - 12 months ago.  
    Oops!  Thank for reminding me.  Since I download prices every time I run OSU (which is just about every day) my historical record has daily prices going back years so I forgot about the weekly and monthly intervals for dates beyond 30 days.
    @DonL_TX - An option you might want to consider to get those Wednesday prices for dates more than 30 days ago is to manually download the securities prices from your brokerage in CSV format (assuming they have daily prices that go back further than 30 days).  Then you can import the prices in that CSV file into Quicken.  You can read up on this process at https://www.quicken.com/support/how-do-i-import-data-quicken-windows.

    Quicken Classic Premier (US) Subscription: R55.26 on Windows 11

This discussion has been closed.