nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Investing tab return % data shows NA

tkstaple

The return % data in the investing tab columns on several data sets either shows NA or the percentage seems overstated. This has been a problem with Quicken for as long as I've been using which is many years. Why does it seem to work for some investment lines and many others are just showing "NA". There are no complicated transfers in these transactions. Mainly buy/sell transactions. Is there a fix in the works? Can Quicken just add data that pulls annualized return data from a website such as Morningstar as alternative?

Find more posts tagged with

Accepted answers

q_lurker

The help file description for Return%-YTD includes the following:

Note that this performance measure is based on downloaded data and will not be affected by changes in the Portfolio's As of date option.

With respect to Return % YTD, it does not matter how long you have owned the security of if you owned it at the beginning of the year.

The data-supplier often does not provide that data for ETFs and may miss it for a variety of stocks; I don't know of a specific pattern. For my current universe of roughly 150 securities, I am showing about 15 with blank and 30 with N/A for Return%-YTD. Those counts exclude bonds and MM for which the data would not be downloaded anyway.

Jim_Harman

Average Annual Return in Quicken is based on the timing of your Buys and Sells so unless you did no Buys and Sells during the analysis period and reinvested all your distributions, your performance will not match published figures for the security.

Also for periods of less than one year such as YTD, the number is annualized, so for YTD it assumes the performance so far this year will continue for the rest of the year. For short periods, the ROI (%), which is not annualized, is a better measure of your performance.

All comments

NotACPA

What Q product are you running? What Build/Release? (Do HELP, About Quicken for this info).

What particular securities are you seeing this for?

tkstaple

I have latest Quicken Windows subscription. Securities involve basic mutual fund or ETF investments. Transactions are basic buy/sell nothing complex. As an example the investment tab column "Return % YTD" should be displayed for all since I've at least owned all investments since the beginning of the year. The majority of the fields for this column are blank for these investments but there are entries in some others. I don't see any particular pattern in the transactions that would explain it. The other columns of data I like to use are Average Annual Return % - YTD, 1,3,5 year. Many of these numbers are not accurate according to what is listed online for these investments. Don't really understand where Quicken gets these numbers.

q_lurker

The help file description for Return%-YTD includes the following:

Note that this performance measure is based on downloaded data and will not be affected by changes in the Portfolio's As of date option.

Jim_Harman

tkstaple

Jim_Harman said:

Average Annual Return in Quicken is based on the timing of your Buys and Sells so unless you did no Buys and Sells during the analysis period and reinvested all your distributions, your performance will not match published figures for the security.

Also for periods of less than one year such as YTD, the number is annualized, so for YTD it assumes the performance so far this year will continue for the rest of the year. For short periods, the ROI (%), which is not annualized, is a better measure of your performance.

Thank you!

tkstaple

q_lurker said:

The help file description for Return%-YTD includes the following:
Note that this performance measure is based on downloaded data and will not be affected by changes in the Portfolio's As of date option.
With respect to Return % YTD, it does not matter how long you have owned the security of if you owned it at the beginning of the year.

The data-supplier often does not provide that data for ETFs and may miss it for a variety of stocks; I don't know of a specific pattern. For my current universe of roughly 150 securities, I am showing about 15 with blank and 30 with N/A for Return%-YTD. Those counts exclude bonds and MM for which the data would not be downloaded anyway.

Thank you! They probably need a new data supplier for this info. This info is readily available on most financial sites that I use. I appreciate your answer.