| View previous topic :: View next topic |
| Author |
Message |
Gary
Guest
|
 Posted: Sun Jul 13, 2008 12:33 am Post subject: Can I run a report of one investment in one account showing |
 |
|
I've been needing this over and over on many occasions in which I am
trying to understand where something went wrong.
That would be a report of the register of a single investment in a
single account (which might have other investments in it), showing all
transactions and a running total of shares balance and investment
value.
Actually a cash balance isn't as critical, but if included would
probably be ACCOUNT cash balance...not cash balance due to that
particular investment.
Does anyone know how I can generate such a report in Quicken? If you
do, and you share it, I'd really appreciate it! |
|
| Back to top |
|
 |
| |
Ads |
Advertising
Sponsor
|
|
John Pollard
Guest
|
| Posted: Sun Jul 13, 2008 9:42 pm Post subject: Re: Can I run a report of one investment in one account sho |
|
|
Gary wrote:
| Quote: |
I've been needing this over and over on many occasions in
which I am
trying to understand where something went wrong.
That would be a report of the register of a single investment
in a
single account (which might have other investments in it),
showing all
transactions and a running total of shares balance and
investment
value.
Actually a cash balance isn't as critical, but if included
would
probably be ACCOUNT cash balance...not cash balance due to
that
particular investment.
Does anyone know how I can generate such a report in Quicken?
If you
do, and you share it, I'd really appreciate it!
|
I know of no report in Quicken that would report running share
totals or running market value or running cash balance.
I think your only hope is to export to Excel and compute the
totals in Excel, and I don't think it will necessarily be a
trivial exercise.
To start, you can export a Quicken Investment Transaction report
to Excel, and add an Excel column with a formula to compute the
running share totals from the number-of-shares in each
transaction. [This alone may be enough to solve many problems,
and is the easiest part of the exercise.]
If the security is a mutual fund, you could use the price/share
from the Investment Transaction report to have Excel compute the
running market value.
If the security is a stock, the Quicken price/share for a
transaction is not likely to be the closing price for that day,
so you would probably need a separate source of closing quotes
to import to Excel, then an Excel procedure to get the imported
quotes assigned to the correct Excel rows for the date of the
transaction.
You can export prices from Quicken to a tab delimited file which
can be input to Excel. [To export: Investing > Security Detail
View > (select security) > Update > Edit Price History > Print]
You can get a comma delimited file of all Quicken security
prices (or the prices for a given security, plus several other
options) using the free program QPH File Processor (Google for
it).
I'm guessing someone with Excel expertise could get the tab
delimited or comma delimited files into Excel and get the prices
for each date assigned to the row that contained the transaction
for that date. Then Excel could compute the market value for
that date. [There's a newsgroup for Excel which I believe would
have the expertise, if no one here does.]
The Investment Transaction report has the cash amount of each
transaction, so its running total could also be computed in
Excel. But it would be the cash amount related only to the
single security whose transactions you exported.
--
John Pollard
First initial underscore Last name at mchsi dot com
Please reply to newsgroup |
|
| Back to top |
|
|
| |
Ads |
Advertising
Sponsor
|
|
Jerry Boyle
Guest
|
| Posted: Sun Jul 13, 2008 11:25 pm Post subject: Re: Can I run a report of one investment in one account sho |
|
|
"Gary" <gary_w1@hotmail.com> wrote in message
news:pr0i745d8va85q72a99olistl7rd1a7t9k@4ax.com...
| Quote: |
I've been needing this over and over on many occasions in which I am
trying to understand where something went wrong.
That would be a report of the register of a single investment in a
single account (which might have other investments in it), showing all
transactions and a running total of shares balance and investment
value.
Actually a cash balance isn't as critical, but if included would
probably be ACCOUNT cash balance...not cash balance due to that
particular investment.
Does anyone know how I can generate such a report in Quicken? If you
do, and you share it, I'd really appreciate it!
|
No such report that I know of. But you may be able to use Portfolio
(Investing -> Portfolio or Ctrl-U) to find when your share balance went
wrong.
The following method (known as binary convergence) works quite well if you
have brokerage statements that go back to the date or dates where the
error(s) occurred.
Set Show:Holdings and Group by:Accounts and As of:<date of interest> to see
your share balance, cost basis, etc. on that date. You can customize this
report to add or remove columns.
Then find a date G where the balance was good, a date B where it is bad and
a date M about midway between G and B.
If the balance on M is bad the error is between G and M, so divide that
interval in half and repeat the process. If the balance on M is good divide
the interval between M and B. Keep dividing until you find the date where
the error occurred. |
|
| Back to top |
|
|
| |
Ads |
Advertising
Sponsor
|
|
Jerry Boyle
Guest
|
| Posted: Sun Jul 13, 2008 11:35 pm Post subject: Re: Can I run a report of one investment in one account sho |
|
|
I forgot to mention that if you have Group by:Accounts in Portfolio you can
click the "+" to the left of the security name to see the lots of the
security that you held on the As of: date. This may provide a further clue
as to what's wrong.
Jerry |
|
| Back to top |
|
|
| |
Ads |
Advertising
Sponsor
|
|
Gary
Guest
|
| Posted: Mon Jul 14, 2008 5:57 pm Post subject: Re: Can I run a report of one investment in one account sho |
|
|
On Sun, 13 Jul 2008 16:42:23 GMT, "John Pollard" <invalid@invalid.com>
wrote:
| Quote: |
Gary wrote:
I've been needing this over and over on many occasions in
which I am
trying to understand where something went wrong.
That would be a report of the register of a single investment
in a
single account (which might have other investments in it),
showing all
transactions and a running total of shares balance and
investment
value.
Actually a cash balance isn't as critical, but if included
would
probably be ACCOUNT cash balance...not cash balance due to
that
particular investment.
Does anyone know how I can generate such a report in Quicken?
If you
do, and you share it, I'd really appreciate it!
I know of no report in Quicken that would report running share
totals or running market value or running cash balance.
I think your only hope is to export to Excel and compute the
totals in Excel, and I don't think it will necessarily be a
trivial exercise.
To start, you can export a Quicken Investment Transaction report
to Excel, and add an Excel column with a formula to compute the
running share totals from the number-of-shares in each
transaction. [This alone may be enough to solve many problems,
and is the easiest part of the exercise.]
If the security is a mutual fund, you could use the price/share
from the Investment Transaction report to have Excel compute the
running market value.
If the security is a stock, the Quicken price/share for a
transaction is not likely to be the closing price for that day,
so you would probably need a separate source of closing quotes
to import to Excel, then an Excel procedure to get the imported
quotes assigned to the correct Excel rows for the date of the
transaction.
You can export prices from Quicken to a tab delimited file which
can be input to Excel. [To export: Investing > Security Detail
View > (select security) > Update > Edit Price History > Print]
You can get a comma delimited file of all Quicken security
prices (or the prices for a given security, plus several other
options) using the free program QPH File Processor (Google for
it).
I'm guessing someone with Excel expertise could get the tab
delimited or comma delimited files into Excel and get the prices
for each date assigned to the row that contained the transaction
for that date. Then Excel could compute the market value for
that date. [There's a newsgroup for Excel which I believe would
have the expertise, if no one here does.]
The Investment Transaction report has the cash amount of each
transaction, so its running total could also be computed in
Excel. But it would be the cash amount related only to the
single security whose transactions you exported.
|
Thanks, John, for this idea. This way of looking at data, using
running totals, etc., is so fundamental to my thinking about
investments, checking and savings, that I would probably want to
generate a separate report for each type of holding in each account.
The amount of work it would take is prohibitive. Not having the
ability to get this in Quicken is a major shortcoming of the product.
When you go to, for example, the Vanguard site, you always see
transaction reports with running totals in shares owned. Same thing
for other investment sites and for bank sites.
I seem to remember that certain kinds of accounts in Quicken show
running totals in the register, and I'll look for them. If there's a
way I can re-design my entire portfolio to give accounts to look like
this, I will do it. |
|
| Back to top |
|
|
| |
Ads |
Advertising
Sponsor
|
|
John Pollard
Guest
|
| Posted: Mon Jul 14, 2008 6:26 pm Post subject: Re: Can I run a report of one investment in one account sho |
|
|
Gary wrote:
| Quote: |
On Sun, 13 Jul 2008 16:42:23 GMT, "John Pollard"
invalid@invalid.com
wrote:
Gary wrote:
I've been needing this over and over on many occasions in
which I am
trying to understand where something went wrong.
That would be a report of the register of a single
investment
in a
single account (which might have other investments in it),
showing all
transactions and a running total of shares balance and
investment
value.
Actually a cash balance isn't as critical, but if included
would
probably be ACCOUNT cash balance...not cash balance due to
that
particular investment.
Does anyone know how I can generate such a report in
Quicken?
If you
do, and you share it, I'd really appreciate it!
I know of no report in Quicken that would report running
share
totals or running market value or running cash balance.
I think your only hope is to export to Excel and compute the
totals in Excel, and I don't think it will necessarily be a
trivial exercise.
To start, you can export a Quicken Investment Transaction
report
to Excel, and add an Excel column with a formula to compute
the
running share totals from the number-of-shares in each
transaction. [This alone may be enough to solve many
problems,
and is the easiest part of the exercise.]
If the security is a mutual fund, you could use the
price/share
from the Investment Transaction report to have Excel compute
the
running market value.
If the security is a stock, the Quicken price/share for a
transaction is not likely to be the closing price for that
day,
so you would probably need a separate source of closing
quotes
to import to Excel, then an Excel procedure to get the
imported
quotes assigned to the correct Excel rows for the date of the
transaction.
You can export prices from Quicken to a tab delimited file
which
can be input to Excel. [To export: Investing > Security
Detail
View > (select security) > Update > Edit Price History
Print]
You can get a comma delimited file of all Quicken security
prices (or the prices for a given security, plus several
other
options) using the free program QPH File Processor (Google
for
it).
I'm guessing someone with Excel expertise could get the tab
delimited or comma delimited files into Excel and get the
prices
for each date assigned to the row that contained the
transaction
for that date. Then Excel could compute the market value for
that date. [There's a newsgroup for Excel which I believe
would
have the expertise, if no one here does.]
The Investment Transaction report has the cash amount of each
transaction, so its running total could also be computed in
Excel. But it would be the cash amount related only to the
single security whose transactions you exported.
Thanks, John, for this idea.
This way of looking at data, using
running totals, etc., is so fundamental to my thinking about
investments,
|
I - and I believe others - have suggested to Intuit that they
modify the Investment transaction report to optionally allow the
display of running share totals. You could add your voice to
the list by going to the Intuit Support web site and making a
"suggestion".
| Quote: |
checking and savings, that
I would probably want to
generate a separate report for each type of holding in each
account.
|
You include all desired investment accounts in the Investment
Transaction report, sub-total it by account, and export/import
that to Excel.
| Quote: |
The amount of work it would take is prohibitive.
|
Getting the running share balance in Excel would not be that
much work.
| Quote: |
Not having the
ability to get this in Quicken is a major shortcoming of the
product.
When you go to, for example, the Vanguard site, you always see
transaction reports with running totals in shares owned. Same
thing
for other investment sites and for bank sites.
I seem to remember that certain kinds of accounts in Quicken
show
running totals in the register, and I'll look for them.
|
Your original question only asked about investment accounts, I
figured you already knew that non-investment account "registers"
displayed a running balance. And that you can print a "check
register" report for non-investment accounts which shows a
running balance.
Also, I mis-spoke in my previous post: you can also print a
"register" report for an investment account which shows a
running cash balance ... but there is no option to control the
contents except for a date range.
The only investment accounts that I know that provide a running
share balance are Quicken Single Mutual Fund accounts ... and I
personally suggest not using Single Mutual Fund accounts, they
are two restrictive (and you won't be able to use them if you
download and your fi doesn't allow each security to be
downloaded to a separate Quicken account).
| Quote: |
If there's a
way I can re-design my entire portfolio to give accounts to
look like
this, I will do it.
|
--
John Pollard
First initial underscore Last name at mchsi dot com
Please reply to newsgroup |
|
| Back to top |
|
|
| |
Ads |
Advertising
Sponsor
|
|
Gary
Guest
|
| Posted: Mon Jul 14, 2008 9:18 pm Post subject: Re: Can I run a report of one investment in one account sho |
|
|
On Mon, 14 Jul 2008 08:26:27 -0500, "John Pollard"
<invalid@invalid.com> wrote:
| Quote: |
Gary wrote:
On Sun, 13 Jul 2008 16:42:23 GMT, "John Pollard"
invalid@invalid.com
wrote:
Gary wrote:
I've been needing this over and over on many occasions in
which I am
trying to understand where something went wrong.
That would be a report of the register of a single
investment
in a
single account (which might have other investments in it),
showing all
transactions and a running total of shares balance and
investment
value.
Actually a cash balance isn't as critical, but if included
would
probably be ACCOUNT cash balance...not cash balance due to
that
particular investment.
Does anyone know how I can generate such a report in
Quicken?
If you
do, and you share it, I'd really appreciate it!
I know of no report in Quicken that would report running
share
totals or running market value or running cash balance.
I think your only hope is to export to Excel and compute the
totals in Excel, and I don't think it will necessarily be a
trivial exercise.
To start, you can export a Quicken Investment Transaction
report
to Excel, and add an Excel column with a formula to compute
the
running share totals from the number-of-shares in each
transaction. [This alone may be enough to solve many
problems,
and is the easiest part of the exercise.]
If the security is a mutual fund, you could use the
price/share
from the Investment Transaction report to have Excel compute
the
running market value.
If the security is a stock, the Quicken price/share for a
transaction is not likely to be the closing price for that
day,
so you would probably need a separate source of closing
quotes
to import to Excel, then an Excel procedure to get the
imported
quotes assigned to the correct Excel rows for the date of the
transaction.
You can export prices from Quicken to a tab delimited file
which
can be input to Excel. [To export: Investing > Security
Detail
View > (select security) > Update > Edit Price History
Print]
You can get a comma delimited file of all Quicken security
prices (or the prices for a given security, plus several
other
options) using the free program QPH File Processor (Google
for
it).
I'm guessing someone with Excel expertise could get the tab
delimited or comma delimited files into Excel and get the
prices
for each date assigned to the row that contained the
transaction
for that date. Then Excel could compute the market value for
that date. [There's a newsgroup for Excel which I believe
would
have the expertise, if no one here does.]
The Investment Transaction report has the cash amount of each
transaction, so its running total could also be computed in
Excel. But it would be the cash amount related only to the
single security whose transactions you exported.
Thanks, John, for this idea.
This way of looking at data, using
running totals, etc., is so fundamental to my thinking about
investments,
I - and I believe others - have suggested to Intuit that they
modify the Investment transaction report to optionally allow the
display of running share totals. You could add your voice to
the list by going to the Intuit Support web site and making a
"suggestion".
checking and savings, that
I would probably want to
generate a separate report for each type of holding in each
account.
You include all desired investment accounts in the Investment
Transaction report, sub-total it by account, and export/import
that to Excel.
The amount of work it would take is prohibitive.
Getting the running share balance in Excel would not be that
much work.
Not having the
ability to get this in Quicken is a major shortcoming of the
product.
When you go to, for example, the Vanguard site, you always see
transaction reports with running totals in shares owned. Same
thing
for other investment sites and for bank sites.
I seem to remember that certain kinds of accounts in Quicken
show
running totals in the register, and I'll look for them.
Your original question only asked about investment accounts, I
figured you already knew that non-investment account "registers"
displayed a running balance. And that you can print a "check
register" report for non-investment accounts which shows a
running balance.
Also, I mis-spoke in my previous post: you can also print a
"register" report for an investment account which shows a
running cash balance ... but there is no option to control the
contents except for a date range.
The only investment accounts that I know that provide a running
share balance are Quicken Single Mutual Fund accounts ... and I
personally suggest not using Single Mutual Fund accounts, they
are two restrictive (and you won't be able to use them if you
download and your fi doesn't allow each security to be
downloaded to a separate Quicken account).
If there's a
way I can re-design my entire portfolio to give accounts to
look like
this, I will do it.
|
I have also submitted the suggestion. |
|
| Back to top |
|
|
| |
Ads |
Advertising
Sponsor
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
67 Attacks blocked
Powered by phpBB © 2001, 2005 phpBB Group
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
